Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CAMPAIGN
This table contains the meta-information for a campaign. This table is used by the Marketing subsystem.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type I0000060 NAME+STOREENT_ID Unique Index SQL100520030309390 CAMPAIGN_ID Primary Key I0000511 STOREENT_ID Non-Unique Index
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_1041 CAMPAIGN_ID EMLCAMPREL CAMPAIGN_ID Cascade F_384 CAMPAIGN_ID INITIATIVE CAMPAIGN_ID Cascade F_1047 CAMPAIGN_ID PX_PROMOTION CAMPAIGN_ID Cascade
Related reference
_vcc_freeselect_bottom_