participants

Module: campaigns

Campaign and mailing list participants with contact info.

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Particpants 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)
mailinglist mailinglists.ID	integer			Mailing list ID (**dependency**); is mutually exclusive to `campaign` (either one is required)
campaign campaigns.ID	integer			Campaign ID (**dependency**); is mutually exclusive to `mailinglist` (either one is required)
contact contacts.ID	integer			Contact ID
name	text			Name
phone	text		''	Phone number
email	text		''	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_mailinglist	foreign_key
pk_participants	primary_key

Loading...