mailinglists

Module: mailinglists

Email mailing lists with sender and campaign associations.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Mailing list ID
fork forks.ID	integer			Fork ID (`null` for base module)
owneruser users.ID	integer			Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
ownergroup groups.ID	integer			Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
creator	integer			Creator user ID (defaults to authenticated user on creation)
assigneduser users.ID	integer			Assigned user ID
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)
campaign campaigns.ID	integer			Campaign ID
visibility	smallint		0	Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
name	text			Name
sender	text		''	Sender name and e-mail address
description	text		''	Detailed general description

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_mailinglists_assigneduser					gin	assigneduser
fk_mailinglists_campaign					btree	campaign
fk_mailinglists_fork					gin	fork
fk_mailinglists_ownergroup					gin	ownergroup
fk_mailinglists_owneruser					gin	owneruser
i_mailinglists_nofork					gin	fork
i_mailinglists_noowner					gin	ownergroup
pk_mailinglists					btree	ID
s_mailinglists_name					gin	name
s_mailinglists_sender					gin	sender

Name	Type
c_mailinglists_owner	check
dc_mailinglists_description	check
dc_mailinglists_name	check
dc_mailinglists_sender	check
dc_mailinglists_visibility	check
fk_mailinglists_assigneduser	foreign_key
fk_mailinglists_campaign	foreign_key
fk_mailinglists_fork	foreign_key
fk_mailinglists_ownergroup	foreign_key
fk_mailinglists_owneruser	foreign_key
pk_mailinglists	primary_key

Loading...