events

Module: calendar

Timeline events linked to entities with date ranges and metadata.

Colors Codes

Color Code	Color
FCC	Red
CCF	Blue
CFC	Green
FFC	Yellow
FCF	Pink
CFF	Cyan

Name	Type	Nullable	Default Value	Notes
PKID	integer			Event ID
fork forks.ID	integer			Fork ID (`null` for base module); inherited from entity
owneruser users.ID	integer			Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
ownergroup groups.ID	integer			Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
creator	integer			Creator user ID (defaults to authenticated user on creation)
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		date_part('epoch', now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
entity	t_entity			Canonical entity
index	integer			Entity ID
name	text			Name
color	character varying(6)		''	Color code (CSS-style hexadecimal without `#`)
datefrom	bigint			Start date and time as a Unix timestamp; must be less than or equal to `dateto`
dateto	bigint			End date and time as a Unix timestamp; must be greater than or equal to `datefrom`
meta	json			JSON-encoded metadata (object)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_events_fork					gin	fork
fk_events_ownergroup					gin	ownergroup
fk_events_owneruser					gin	owneruser
i_events_datefrom_dateto					btree	datefrom, dateto
i_events_entity_index					btree	entity, index
i_events_noowner					gin	ownergroup
pk_events					btree	ID

Name	Type
c_events_date	check
c_events_entity	check
c_events_owner	check
dc_events_color	check
dc_events_meta	check
dc_events_name	check
fk_events_fork	foreign_key
fk_events_ownergroup	foreign_key
fk_events_owneruser	foreign_key
pk_events	primary_key

Loading...