| ID |
int4 |
10 |
|
√ |
null |
|
davids.appointment
|
fk_davids_appointment N
|
|
invitations.appointment
|
fk_invitations_appointment C
|
|
|
Appointment ID |
| owneruser |
int4 |
10 |
√ |
|
null |
|
|
users.ID
|
fk_appointments_owneruser C
|
|
Owner user ID (PUBLIC if owneruser=null and ownergroup=null) |
| ownergroup |
int4 |
10 |
√ |
|
null |
|
|
groups.ID
|
fk_appointments_ownergroup C
|
|
Owner group ID (PUBLIC if owneruser=null and ownergroup=null) |
| creator |
int4 |
10 |
√ |
|
null |
|
|
users.ID
|
fk_appointments_creator N
|
|
Creator user ID (defaults to authenticated user on creation) |
| assigneduser |
int4 |
10 |
√ |
|
null |
|
|
users.ID
|
fk_appointments_assigneduser N
|
|
Assigned user ID |
| 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) |
| visibility |
int2 |
5 |
|
|
0 |
|
|
Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED) |
| name |
text |
2147483647 |
|
|
null |
|
|
Name |
| location |
text |
2147483647 |
|
|
''::text |
|
|
Location |
| 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 |
| recurrence |
int2 |
5 |
√ |
|
null |
|
|
Recurrence (0=DAY, 1=WORKDAY, 2=WEEK, 3=MONTH, 4=YEAR) |
| interval |
int2 |
5 |
|
|
1 |
|
|
Recurrence interval in minutes |
| daterecurrence |
int8 |
19 |
√ |
|
null |
|
|
Recurrence end date as a Unix time stamp |
| description |
text |
2147483647 |
|
|
''::text |
|
|
Detailed general description |
