WebSphere Commerce database table: CAMPAIGN

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


Column Description(s):
Column NameColumn TypeDescription
CAMPAIGN_ID INTEGER NOT NULL Primary key.
STOREENT_ID INTEGER NOT NULL This field contains the store ID to which the campaign belongs.
NAME VARCHAR(64) NOT NULL This field contains the name of the campaign.
DESCRIPTION VARCHAR(254) This field provides a description of the campaign.
TYPE INTEGER Reserved for IBM internal use.
STATUS CHAR(1) Reserved for IBM internal use.
FIELD1 VARCHAR(254) 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.
OWNER VARCHAR(64) This field contains the name of the owner of the campaign.
OBJECTIVE VARCHAR(254) This field contains the objectives and goals that the campaign intend to reach.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000060 NAME+STOREENT_ID Unique Index
SQL050212031207480 CAMPAIGN_ID Primary Key
I0000511 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_182 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1041 CAMPAIGN_ID EMLCAMPREL CAMPAIGN_ID Cascade
F_384 CAMPAIGN_ID INITIATIVE CAMPAIGN_ID Cascade
F_1047 CAMPAIGN_ID PX_PROMOTION CAMPAIGN_ID Cascade

Feedback