appointments


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('"appointments_ID_seq"'::regclass)
davids.appointment FK_davids_appointment N
invitations.appointment FK_invitations_appointment C
owneruser int4 10 null
users.ID FK_appointments_owneruser C

The owner user

ownergroup int4 10 null
groups.ID FK_appointments_ownergroup C

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

creator int4 10 null
users.ID FK_appointments_creator N

The object creator

assigneduser int4 10 null
users.ID FK_appointments_assigneduser N

The assigned user

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)

visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

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

Unix timestamp in seconds

dateto int8 19 null

Unix timestamp in seconds

recurrence int2 5 null

Number

interval int2 5 1

The interval in which a recurring event should take place

daterecurrence int8 19 null

The maximum date

description text 2147483647 ''::text

The general description field

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_appointments_ID Primary key Asc ID

Relationships