mailinglists

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

Loading...