Skip to main content

objects

NameTypeStorageNullableForeign KeysDefault Value & Notes
PKIDintegerplainObject ID
forkintegerplainforks.IDFork ID (`null` for base module)
owneruserintegerplainusers.IDOwner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
ownergroupintegerplaingroups.IDOwner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
creatorintegerplainusers.IDCreator user ID (defaults to authenticated user on creation)
assigneduserintegerplainusers.IDAssigned user ID
creationdatebigintplainDefault: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodifiedbigintplainDefault: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification)
visibilitysmallintplainDefault: 0Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
nametextmainName
entitytextmainCustom entity
datebigintplainDefault: EXTRACT(epoch FROM now())Designated date and time as a Unix timestamp (defaults to current date and time on creation)
descriptiontextextendedDefault: ''Detailed general description
datajsonextendedJSON-encoded object data (array or object)
binfileintegerplainbinfiles.IDBinary file ID; is read-only (not for `PUT` or `PATCH`)
NameUniqueNulls DistinctPrimaryPartialMethodKeys
fk_objects_assigneduserginassigneduser
fk_objects_binfilebtreebinfile
fk_objects_forkginfork
fk_objects_ownergroupginownergroup
fk_objects_owneruserginowneruser
i_objects_datebtreedate
i_objects_entityginentity
i_objects_noforkginfork
i_objects_noownerginownergroup
pk_objectsbtreeID
s_objects_nameginname
NameType
c_objects_ownercheck
dc_objects_datacheck
dc_objects_descriptioncheck
dc_objects_entitycheck
dc_objects_namecheck
dc_objects_visibilitycheck
fk_objects_assigneduserforeign_key
fk_objects_binfileforeign_key
fk_objects_creatorforeign_key
fk_objects_forkforeign_key
fk_objects_ownergroupforeign_key
fk_objects_owneruserforeign_key
pk_objectsprimary_key
Loading...