invitations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID bigserial 19 nextval('"invitations_ID_seq"'::regclass)
creator int4 10 null
users.ID FK_invitations_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)

appointment int4 10 null
appointments.ID FK_invitations_appointment C
contact int4 10 null
contacts.ID FK_invitations_contact C

Reference to the associated contact

flag int2 5 0

0: Unanswered, 1: Confirmed, 2: Rejected

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_invitations_ID Primary key Asc ID
UNQ_invitations_appointment_contact Must be unique Asc/Asc appointment + contact

Relationships