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


phone text 2147483647 ''::text

Phone number

email text 2147483647 ''::text

E-mail address

Table contained 0 rows


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