Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMCAMPAIGN
A group of activities to meet specific marketing objectives.
Column Name Column Type Description DMCAMPAIGN_ID INTEGER NOT NULL The unique identifier of a marketing campaign. STOREENT_ID INTEGER NOT NULL The identifier of the store in which the campaign was created. NAME VARCHAR(64) NOT NULL The name of the marketing campaign. DESCRIPTION VARCHAR(254) The description of the marketing campaign. STATE SMALLINT NOT NULL DEFAULT 0 This column is not currently used. SEASON VARCHAR(254) The season of the year in which the campaign should be run. TYPE INTEGER This column is not currently used. STARTDATE TIMESTAMP This column is not currently used. ENDDATE TIMESTAMP This column is not currently used. CREATED TIMESTAMP The time when the marketing campaign was created. LASTUPDATE TIMESTAMP The time when the marketing campaign was last updated. LASTUPDATEDBY VARCHAR(254) The information about the individual who last updated the marketing campaign. OWNER VARCHAR(64) The name of the business owner of the camapign. OBJECTIVE VARCHAR(254) The objectives and goals that the marketing campaign intends to reach. FIELD1 INTEGER Customizable field. FIELD2 BIGINT Customizable field. FIELD3 DECIMAL (20,5) Customizable field. FIELD4 VARCHAR(254) Customizable field. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001139 NAME+STOREENT_ID Unique Index SQL100520030326330 DMCAMPAIGN_ID Primary Key I0001140 STOREENT_ID Non-Unique Index
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3523 DMCAMPAIGN_ID DMACTIVITY DMCAMPAIGN_ID Cascade _vcc_freeselect_bottom_