Base object attributes

Owned by Lite Farm
Dec 12, 2022
1 min read

All objects in the system should have a few base attributes:

Attribute

Data Type

Default Value

Notes

CreatedDateTime

DateTime

 

Only set once upon record creation, immutable

CreatedByUserId

Ref: user

 

Only set once upon record creation, immutable

lastModifiedDateTime

DateTime

 

Updated any time an update is performed on a record

lastModifiedUserId

Ref: user

 

Updated any time an update is performed on a record

deleted

Boolean

false

Deleted records shouldn’t be displayed on the front-end

For objects that implement tasks, they should also have the following attributes:

Attribute

Data Type

Default Value

Notes

OwnerUserId

Ref: User

null

The user that created the task

AssigneeUserId

Ref: User

null

The user that is assigned to the task

When creating new tables, they should have the above attributes. For migrating existing tables to this new format the initial CreatedDateTime and lastModifiedDateTime should be set to 1/1/2000. CreatedByUserId and lastModifiedUserId should be set to a default System user.

Most controllers can be updated via baseController, but some controllers do not extend it and would need special attention. Some upserts using graphs (Sale) may update several tables at a time which could introduce some complexity.