WebSphere Commerce database table: EMSPOT

This table contains registered e-Marketing Spots.


Column Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
I0000100 NAME+STOREENT_ID+USAGETYPE Unique Index
SQL050212031226180 EMSPOT_ID Primary Key
I0000568 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_313 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_387 EMSPOT_ID INTVSCHED EMSPOT_ID Cascade
F_1158 ESPOT_ID SHDCACRM EMSPOT_ID Cascade

Feedback