This table contains registered e-Marketing Spots.
Column Name | Column Type | Description |
---|---|---|
EMSPOT_ID | INTEGER NOT NULL | Primary key. |
STOREENT_ID | INTEGER NOT NULL | Store to which this e-Marketing Spot belongs. |
NAME | VARCHAR(64) NOT NULL | Name of the e-Marketing Spot. |
DESCRIPTION | VARCHAR(254) | Description of the e-Marketing Spot. |
SUPPORTEDTYPES | VARCHAR(20) | The types of things that this e-Marketing Spot can display: A = Awareness ad P = Product C = Category S = Cross-sell or Up-sell on product. |
LASTUPDATE | TIMESTAMP | Timestamp of the last update to the e-Marketing Spot. |
LASTUPDATEDBY | VARCHAR(254) | Logon ID of the last user to update the e-Marketing Spot. |
DEFAULTRULE | VARCHAR(4000) | Reserved for IBM internal use. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
USAGETYPE | VARCHAR(20) NOT NULL DEFAULT 'MARKETING' | Defines the usagetype of EMSPOT. EMSPOT can be used to deliver marketing message or store contents. Following are the valid usagetype: MARKETING - Delivers marketing message CONTENT - Delivers store content. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000100 | NAME+STOREENT_ID+USAGETYPE | Unique Index |
SQL050212031226180 | EMSPOT_ID | Primary Key |
I0000568 | STOREENT_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_313 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_387 | EMSPOT_ID | INTVSCHED | EMSPOT_ID | Cascade |
F_1158 | ESPOT_ID | SHDCACRM | EMSPOT_ID | Cascade |