Database Table: CAMPAIGN

This table contains the meta-information for a campaign. This table is used by the Marketing subsystem.

Column Name Column Type Column Description
CAMPAIGN_ID INTEGER
NOT NULL
Primary key.
DESCRIPTION VARCHAR (254)
NULL
This field provides a description of the campaign.
FIELD1 VARCHAR (254)
NULL
Customizable.
LASTUPDATE TIMESTAMP
NOT NULL
This field contains the timestamp for the last updates made to the campaign.
LASTUPDATEDBY VARCHAR (254)
NOT NULL
This field contains the logon ID of the individual who last updated the campaign.
NAME VARCHAR (64)
NOT NULL
This field contains the name of the campaign.
OBJECTIVE VARCHAR (254)
NULL
This field contains the objectives and goals that the campaign intend to reach.
OWNER VARCHAR (64)
NULL
This field contains the name of the owner of the campaign.
STATUS CHARACTER (1)
NULL
Reserved for IBM internal use.
STOREENT_ID INTEGER
NOT NULL
This field contains the store ID to which the campaign belongs.
TYPE INTEGER
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000060 NAME, STOREENT_ID Unique Index
SQL030416034854560 CAMPAIGN_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_182 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_384 CAMPAIGN_ID INITIATIVE CAMPAIGN_ID Cascade