participants

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	bigint	plain			Particpants 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)
mailinglist	integer	plain		mailinglists.ID	Mailing list ID (**dependency**); is mutually exclusive to `campaign` (either one is required)
campaign	integer	plain		campaigns.ID	Campaign ID (**dependency**); is mutually exclusive to `mailinglist` (either one is required)
contact	integer	plain		contacts.ID	Contact ID
name	text	main			Name
phone	text	extended			Default: ''Phone number
email	text	main			Default: ''E-mail address

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_participants_campaign					gin	campaign
fk_participants_contact					btree	contact
fk_participants_mailinglist					gin	mailinglist
pk_participants					btree	ID
s_participants_email					gin	email
s_participants_name					gin	name

Name	Type
c_participants_association	check
dc_participants_email	check
dc_participants_name	check
dc_participants_phone	check
fk_participants_campaign	foreign_key
fk_participants_contact	foreign_key
fk_participants_creator	foreign_key
fk_participants_mailinglist	foreign_key
pk_participants	primary_key

Loading...