Database Table: INITIATIVE

This table contains the data describing an initiative.

Column Name Column Type Column Description
CAMPAIGN_ID INTEGER
NULL
The ID of the campaign to which this initiative belongs.
DESCRIPTION VARCHAR (254)
NULL
This field contains the description of the initiative.
FIELD1 VARCHAR (254)
NULL
Customizable.
INITIATIVE_ID INTEGER
NOT NULL
Primary key.
LASTUPDATE TIMESTAMP
NOT NULL
This field contains a timestamp of the last update date for the initiative.
LASTUPDATEDBY VARCHAR (254)
NOT NULL
This field contains the logon ID of the individual who last updated the initiative.
NAME VARCHAR (64)
NOT NULL
This field contains the name of the initiative.
RESULTTYPE CHARACTER (1)
NULL
The type of output produced by the initiative:
A = Awareness ad, P = Product, C = Category, or S = Cross-sell/Up-sell on product.
RULE LONG VARCHAR
NULL
An XML document describing the rule for the initiative.
SELLTYPE INTEGER
NULL
Initiative classification:
1 = General, 2 = Up sell, 3 = Cross sell, 4 = Discount, or 5 = Coupon.
STATUS CHARACTER (1)
NULL
Initiative status. Valid values include:
null - enabled/resumed
D - disabled/suspended
STOREENT_ID INTEGER
NOT NULL
The ID of the store to which the initiative belongs.
TYPE INTEGER
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000134 NAME, STOREENT_ID Unique Index
SQL030416034945540 INITIATIVE_ID Primary Key
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
F_386 INITIATIVE_ID INTVSCHED INITIATIVE_ID Cascade