events


Details

Colors Codes

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null

Event ID
owneruser int4 10 √ null
users.ID fk_events_owneruser C

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)
ownergroup int4 10 √ null
groups.ID fk_events_ownergroup C

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)
creator int4 10 √ null
users.ID fk_events_creator N

Creator user ID (defaults to authenticated user on creation)
creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)
lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
entity text 2147483647 √ null

Canonical entity
index int4 10 √ null

Entity ID; is required if entity is not null, otherwise must be null
name text 2147483647 null

Name
color varchar 6 ''::character varying

Color code (CSS-style hexadecimal without #) (Pattern: ^([A-F\d]{3}){0,2}$)
datefrom int8 19 null

Start date and time as a Unix time stamp; must be less than or equal to dateto
dateto int8 19 null

End date and time as a Unix time stamp; must be greater than or equal to datefrom
meta json 2147483647 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_events Primary key Asc ID
i_events_datefrom_dateto Performance Asc/Asc datefrom + dateto
i_events_entity_index Performance Asc/Asc entity + index
i_events_noowner Performance Asc ownergroup
i_events_owner Performance Asc/Asc owneruser + ownergroup

Relationships

Close relationships within degrees of separation