mailingrecipients

Module: mailinglists

Recipients for mailing list campaigns.

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Mailing recipient 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		EXTRACT(epoch FROM now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
message messages.ID	integer			Message ID (**dependency**)
participant participants.ID	bigint			Participant ID
email	text			E-mail address

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_mailingrecipients_message					btree	message
pk_mailingrecipients					btree	ID
u_mailingrecipients_participant_message					btree	participant, message

Name	Type
dc_mailingrecipients_email	check
fk_mailingrecipients_message	foreign_key
fk_mailingrecipients_participant	foreign_key
pk_mailingrecipients	primary_key

Loading...