Database Table: EMSPOT

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000100 NAME, STOREENT_ID Unique Index
SQL030416034926820 EMSPOT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_313 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_387 EMSPOT_ID INTVSCHED EMSPOT_ID Cascade