participants


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int8 19 √ null

Particpants ID
creator int4 10 √ null
users.ID fk_participants_creator N

Creator user ID (defaults to authenticated user on creation)
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)
mailinglist int4 10 √ null
mailinglists.ID fk_participants_mailinglist C

Mailing list ID (**dependency**); is mutually exclusive to campaign (either one is required)
campaign int4 10 √ null
campaigns.ID fk_participants_campaign C

Campaign ID (**dependency**); is mutually exclusive to mailinglist (either one is required)
contact int4 10 √ null
contacts.ID fk_participants_contact N

Contact ID
name text 2147483647 null

Name
phone text 2147483647 ''::text

Phone number
email text 2147483647 ''::text

E-mail address

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_participants Primary key Asc ID
fk_participants_campaign Performance Asc campaign
fk_participants_contact Performance Asc contact
fk_participants_mailinglist Performance Asc mailinglist
s_participants Performance Asc/Asc name + email

Relationships

Close relationships within degrees of separation