participants


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID bigserial 19 nextval('"participants_ID_seq"'::regclass)
creator int4 10 null
users.ID FK_participants_creator N

The object creator

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

Last modification date/time (Unix timestamp in seconds)

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

Last modification date/time (Unix timestamp in seconds)

mailinglist int4 10 null
mailinglists.ID FK_participants_mailinglist C
campaign int4 10 null
campaigns.ID FK_participants_campaign C
contact int4 10 null
contacts.ID FK_participants_contact N

Reference to the associated contact

name text 2147483647 null
phone text 2147483647 ''::text
email text 2147483647 ''::text

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_participants_ID Primary key Asc ID

Relationships