invitations

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	bigint	plain			Invitation ID
creator	integer	plain		users.ID	Creator user ID (defaults to authenticated user on creation)
creationdate	bigint	plain			Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint	plain			Default: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification)
appointment	integer	plain		appointments.ID	Appointment ID (**dependency**)
contact	integer	plain		contacts.ID	Contact ID
name	text	main			Name
email	text	main			Default: ''E-mail address
flag	smallint	plain			Default: 0Flag (`0`=UNANSWERED, `1`=CONFIRMED, `2`=REJECTED)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_invitations_appointment					btree	appointment
fk_invitations_contact					btree	contact
pk_invitations					btree	ID

Name	Type
dc_invitations_email	check
dc_invitations_flag	check
dc_invitations_name	check
fk_invitations_appointment	foreign_key
fk_invitations_contact	foreign_key
fk_invitations_creator	foreign_key
pk_invitations	primary_key

Loading...