invitations

Module: calendar

Appointment invitations with contact and response status.

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Invitation ID
creator	integer			Creator user ID (defaults to authenticated user on creation)
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)
appointment appointments.ID	integer			Appointment ID (**dependency**)
contact contacts.ID	integer			Contact ID
name	text			Name
email	text		''	E-mail address
flag	smallint		0	Flag (`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
pk_invitations	primary_key

Loading...