campaigns


Details

Status codes

Status Activity ID Color
Draft DRAFT 0 green
Not started DRAFT 1 orange
Awaiting approval DRAFT 2 orange
Approved OPEN 3 green
Dismissed CANCELLED 4 red
Active OPEN 5 green
Inactive OPEN 6 orange
In Evaluation OPEN 7 green
Cancelled CANCELLED 8 red
Closed CLOSED 9 black

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null
mailinglists.campaign fk_mailinglists_campaign N
opportunities.campaign fk_opportunities_campaign N
participants.campaign fk_participants_campaign C

Campaign ID
ownergroup int4 10 √ null
groups.ID fk_campaigns_ownergroup C

Owner group ID (null=PUBLIC)
creator int4 10 √ null
users.ID fk_campaigns_creator N

Creator user ID (defaults to authenticated user on creation)
assigneduser int4 10 √ null
users.ID fk_campaigns_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)
visibility int2 5 0

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
name text 2147483647 null

Name
datefrom int8 19 null

Start date as a Unix time stamp; must be less than or equal to dateto
dateto int8 19 √ null

End date as a Unix time stamp; must be greater than or equal to datefrom
status int2 5 0

Status (0=DRAFT, 1=NOTSTARTED, 2=AWAITINGAPPROVAL, 3=APPROVED, 4=DISMISSED, 5=ACTIVE, 6=INACTIVE, 7=INEVALUATION, 8=CANCELLED, 9=CLOSED)
description text 2147483647 ''::text

Detailed general description

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_campaigns Primary key Asc ID
i_campaigns_noowner Performance Asc ownergroup
i_campaigns_owner Performance Asc/Asc ownergroup + assigneduser
s_campaigns Performance Asc name

Relationships

Close relationships within degrees of separation