mailinglists


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 null
messages.mailinglist fk_messages_mailinglist N
participants.mailinglist fk_participants_mailinglist C

Mailing list ID

owneruser int4 10 null
users.ID fk_mailinglists_owneruser C

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

ownergroup int4 10 null
groups.ID fk_mailinglists_ownergroup C

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

creator int4 10 null
users.ID fk_mailinglists_creator N

Creator user ID (defaults to authenticated user on creation)

assigneduser int4 10 null
users.ID fk_mailinglists_assigneduser N

Assigned user ID

creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)

campaign int4 10 null
campaigns.ID fk_mailinglists_campaign N

Campaign ID

visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)

name text 2147483647 null

Name

sender text 2147483647 ''::text

Sender name and e-mail address

description text 2147483647 ''::text

Detailed general description

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_mailinglists Primary key Asc ID
fk_mailinglists_campaign Performance Asc campaign
i_mailinglists_noowner Performance Asc ownergroup
i_mailinglists_owner Performance Asc/Asc/Asc owneruser + ownergroup + assigneduser
s_mailinglists Performance Asc/Asc name + sender

Relationships