campaigns

Module: campaigns

Marketing campaigns with status tracking and date ranges.

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

Name	Type	Nullable	Default Value	Notes
PKID	integer			Campaign ID
fork forks.ID	integer			Fork ID (`null` for base module)
ownergroup groups.ID	integer			Owner group ID (`null`=PUBLIC)
creator	integer			Creator user ID (defaults to authenticated user on creation)
assigneduser users.ID	integer			Assigned user ID
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		date_part('epoch', now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
visibility	smallint		0	Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
name	text			Name
datefrom	bigint			Start date as a Unix timestamp; must be less than or equal to `dateto`
dateto	bigint			End date as a Unix timestamp; must be greater than or equal to `datefrom`
status	smallint		0	Status (`0`=DRAFT, `1`=NOTSTARTED, `2`=AWAITINGAPPROVAL, `3`=APPROVED, `4`=DISMISSED, `5`=ACTIVE, `6`=INACTIVE, `7`=INEVALUATION, `8`=CANCELLED, `9`=CLOSED)
description	text		''	Detailed general description

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_campaigns_assigneduser					gin	assigneduser
fk_campaigns_fork					gin	fork
fk_campaigns_ownergroup					gin	ownergroup
i_campaigns_nofork					gin	fork
i_campaigns_noowner					gin	ownergroup
pk_campaigns					btree	ID
s_campaigns_name					gin	name

Name	Type
c_campaigns_date	check
dc_campaigns_description	check
dc_campaigns_name	check
dc_campaigns_status	check
dc_campaigns_visibility	check
fk_campaigns_assigneduser	foreign_key
fk_campaigns_fork	foreign_key
fk_campaigns_ownergroup	foreign_key
pk_campaigns	primary_key

Loading...