System Fields

System Fields

Every record in Brinkee is automatically provided with several system fields.

NameDescriptionType
uidUnique ID of the recordUID
created_atDate & time the record was createdDate Time
created_byReference to the user that created the recordReference to the user table
updated_atDate & time the record was createdDate Time
updated_byReference to the user that updated the recordReference to the user table

Optional Fields

Depending on the table definition, the number field is added.

NameDescriptionType
numberAuto incrementing ID for the recordNumber