This table contains registered e-Marketing Spots.
Column Name | Column Type | Column Description |
---|---|---|
DEFAULTRULE | VARCHAR (4000) NULL |
Reserved for IBM internal use. |
DESCRIPTION | VARCHAR (254) NULL |
Description of the e-Marketing Spot. |
EMSPOT_ID | INTEGER NOT NULL |
Primary key. |
LASTUPDATE | TIMESTAMP NULL |
Timestamp of the last update to the e-Marketing Spot. |
LASTUPDATEDBY | VARCHAR (254) NULL |
Logon ID of the last user to update the e-Marketing Spot. |
NAME | VARCHAR (64) NOT NULL |
Name of the e-Marketing Spot. |
STOREENT_ID | INTEGER NOT NULL |
Store to which this e-Marketing Spot belongs. |
SUPPORTEDTYPES | VARCHAR (20) NULL |
The types of things that this e-Marketing Spot can display: A = Awareness ad, P = Product, C = Category, or S = Cross-sell/Up-sell on product. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000100 | NAME, STOREENT_ID | Unique Index |
SQL030416034926820 | EMSPOT_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_313 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_387 | EMSPOT_ID | INTVSCHED | EMSPOT_ID | Cascade |