mailingrecipients

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	bigint	plain			Mailing recipient 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: EXTRACT(epoch FROM now())Last modification date and time as a Unix timestamp (auto-reset on modification)
message	integer	plain		messages.ID	Message ID (**dependency**)
participant	bigint	plain		participants.ID	Participant ID
email	text	main			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_creator	foreign_key
fk_mailingrecipients_message	foreign_key
fk_mailingrecipients_participant	foreign_key
pk_mailingrecipients	primary_key

Loading...