Skip to main content

events

NameTypeStorageNullableForeign KeysDefault Value & Notes
PKIDintegerplainEvent ID
forkintegerplainforks.IDFork ID (`null` for base module); inherited from entity
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)
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)
entityt_entityplainCanonical entity
indexintegerplainEntity ID
nametextmainName
colorcharacter varying(6)extendedDefault: ''Color code (CSS-style hexadecimal without `#`)
datefrombigintplainStart date and time as a Unix timestamp; must be less than or equal to `dateto`
datetobigintplainEnd date and time as a Unix timestamp; must be greater than or equal to `datefrom`
metajsonextendedJSON-encoded metadata (object)
NameUniqueNulls DistinctPrimaryPartialMethodKeys
fk_events_forkginfork
fk_events_ownergroupginownergroup
fk_events_owneruserginowneruser
i_events_datefrom_datetobtreedatefrom, dateto
i_events_entity_indexbtreeentity, index
i_events_noownerginownergroup
pk_eventsbtreeID
NameType
c_events_datecheck
c_events_entitycheck
c_events_ownercheck
dc_events_colorcheck
dc_events_metacheck
dc_events_namecheck
fk_events_creatorforeign_key
fk_events_forkforeign_key
fk_events_ownergroupforeign_key
fk_events_owneruserforeign_key
pk_eventsprimary_key
Loading...