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 serial 10 nextval('"events_ID_seq"'::regclass)
owneruser int4 10 null
users.ID FK_events_owneruser C

The owner user

ownergroup int4 10 null
groups.ID FK_events_ownergroup C

The owner group (if owneruser and ownergroup are NULL, the element is public)

creator int4 10 null
users.ID FK_events_creator N

The object creator

creationdate int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

lastmodified int8 19 (date_part('epoch'::text, now()))::bigint

Last modification date/time (Unix timestamp in seconds)

entity TP_entity 2147483647 null

The referenced entity name (e.g. "contacts")

index int4 10 null

The ID of the referenced entity

name text 2147483647 null
color varchar 6 ''::character varying
datefrom int8 19 null

Unix timestamp in seconds

dateto int8 19 null

Unix timestamp in seconds

meta json 2147483647 null

Optional meta data on the event

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_events_ID Primary key Asc ID
IDX_events_entity_index Performance Asc/Asc entity + index

Relationships