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 suspended |
FIELD1 | 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 product |
SELLTYPE | INTEGER | Campaign Web activity classification: 1 = General 2 = Up sell 3 = Cross sell 4 = Discount 5 = Coupon |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000134 | NAME+STOREENT_ID | Unique Index |
SQL050212031233320 | INITIATIVE_ID | Primary Key |
I0000588 | STOREENT_ID | Non-Unique Index |
I0000589 | CAMPAIGN_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_384 | CAMPAIGN_ID | CAMPAIGN | CAMPAIGN_ID | Cascade |
F_385 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_266 | INITIATIVE_ID | CPPMN | INITIATIVE_ID | Cascade |