| 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 |
|
|
|
