appointments
Calendar appointments with recurrence, location, and color coding.
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 | Appointment ID | ||
fork forks.ID | integer | Fork ID (`null` for base module) | ||
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) | ||
assigneduser users.ID | integer | Assigned user ID | ||
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) | |
davserver davservers.ID | integer | DAV server ID | ||
visibility | smallint | 0 | Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED) | |
name | text | Name | ||
location | text | '' | Location | |
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` | ||
recurrence | smallint | Recurrence (`0`=DAY, `1`=WORKDAY, `2`=WEEK, `3`=MONTH, `4`=YEAR) | ||
interval | smallint | 1 | Recurrence interval in minutes | |
maxoccurrences | integer | 0 | Maximum number of occurrences including the start date (`0`=unlimited) | |
daterecurrence | bigint | Recurrence end date as a Unix timestamp | ||
description | text | '' | Detailed general description |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| fk_appointments_assigneduser | gin | assigneduser | ||||
| fk_appointments_davserver | gin | davserver | ||||
| fk_appointments_fork | gin | fork | ||||
| fk_appointments_ownergroup | gin | ownergroup | ||||
| fk_appointments_owneruser | gin | owneruser | ||||
| i_appointments_datefrom_dateto | btree | datefrom, dateto | ||||
| i_appointments_nofork | gin | fork | ||||
| i_appointments_noowner | gin | ownergroup | ||||
| pk_appointments | btree | ID | ||||
| s_appointments_location | gin | location | ||||
| s_appointments_name | gin | name |
| Name | Type |
|---|---|
| c_appointments_date | check |
| c_appointments_owner | check |
| dc_appointments_color | check |
| dc_appointments_description | check |
| dc_appointments_interval | check |
| dc_appointments_location | check |
| dc_appointments_maxoccurrences | check |
| dc_appointments_name | check |
| dc_appointments_recurrence | check |
| dc_appointments_visibility | check |
| fk_appointments_assigneduser | foreign_key |
| fk_appointments_davserver | foreign_key |
| fk_appointments_fork | foreign_key |
| fk_appointments_ownergroup | foreign_key |
| fk_appointments_owneruser | foreign_key |
| pk_appointments | primary_key |
Loading...