This table records the relevant data of a recommendation event. It captures which campaign was run, which initiative was run, the e-Marketing Spot, which customer profiles were involved, and what was recommended to the customer.
Column Name | Column Type | Column Description |
---|---|---|
CAMPAIGNNAME | VARCHAR (64) NULL |
The name of a campaign as described in the NAME column of the CAMPAIGN table. |
CAMPAIGN_ID | INTEGER NULL |
The campaign identifier as described in the CAMPAIGN_ID column of the CAMPAIGN table. |
INITIATIVENAME | VARCHAR (64) NULL |
The name of the initiative as described in the NAME column of the INITIATIVE table. |
INITIATIVE_ID | INTEGER NOT NULL |
The initiative identifier as described in the INITIATIVE_ID column of the INITIATIVE table. |
MPENAME | VARCHAR (64) NULL |
The name of the e-Marketing Spot as described in the NAME column of the EMSPOT table. |
MPETYPENAME | VARCHAR (64) NULL |
The name of the e-Marketing Spot type as described in the NAME column of the MPETYPE table. |
MPETYPE_ID | INTEGER NULL |
Reserved for IBM internal use. |
MPE_ID | INTEGER NOT NULL |
The e-Marketing Spot identifier as described in the EMSPOT_ID column of the EMSPOT table. |
RESULTS | VARCHAR (254) NULL |
A comma-delimited list of category entry identifiers (for suggestive selling) or ad copy identifiers (for awareness advertisements). This column stores what was recommended to the customer. |
SHOPSEGMENTS | VARCHAR (254) NULL |
A comma-delimited list of customer profile names in which the customer fell into when a recommendation was run. |
STOREENT_ID | INTEGER NOT NULL |
The store entity identifier as described in the STOREENT_ID column of the STOREENT table. |
USRTRAFFIC_ID | BIGINT NOT NULL |
The user traffic identifier as described in the USRTRAFFIC_ID column of the USRTRAFFIC table. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034914040 | USRTRAFFIC_ID, MPE_ID, INITIATIVE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|