Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: INITIATIVE
This table contains the data describing a campaign Web activity.
Column Name Column Type Description INITIATIVE_ID INTEGER NOT NULL Primary key. NAME VARCHAR(64) NOT NULL This field contains the name of the campaign Web activity. DESCRIPTION VARCHAR(254) This field contains the description of the campaign Web activity. CAMPAIGN_ID INTEGER The ID of the campaign to which this Web activity belongs. TYPE INTEGER Reserved for IBM internal use. STATUS CHAR(1) Campaign Web activity status. Valid values include:
null - enabled or resumed
D - disabled or suspendedFIELD1 VARCHAR(254) Customizable. LASTUPDATE TIMESTAMP NOT NULL This field contains a timestamp of the last update date for the campaign Web activity. LASTUPDATEDBY VARCHAR(254) NOT NULL This field contains the logon ID of the individual who last updated the campaign Web activity. STOREENT_ID INTEGER NOT NULL The ID of the store to which the campaign Web activity belongs. RULE CLOB An XML document describing the rule for the campaign Web activity. RESULTTYPE CHAR(1) The type of output produced by the campaign Web activity:
A = Awareness ad
P = Product
C = Category
S = Cross-sell or Up-sell on productSELLTYPE INTEGER Campaign Web activity classification:
1 = General
2 = Up sell
3 = Cross sell
4 = Discount
5 = CouponOPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000134 NAME+STOREENT_ID Unique Index SQL100520030344870 INITIATIVE_ID Primary Key I0000588 STOREENT_ID Non-Unique Index I0000589 CAMPAIGN_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_384 CAMPAIGN_ID CAMPAIGN CAMPAIGN_ID Cascade F_385 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_266 INITIATIVE_ID CPPMN INITIATIVE_ID Cascade
Related reference
_vcc_freeselect_bottom_