WebSphere Commerce database table: EMSPOT

This table contains registered e-Marketing Spots.

Column Descriptions
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.

Indexes
Index Name Indexed Column Names Index Type
I0000100 NAME+STOREENT_ID+USAGETYPE Unique Index
SQL060903235156290 EMSPOT_ID Primary Key
I0000568 STOREENT_ID Non-Unique Index

Constraints
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
F_1158 ESPOT_ID SHDCACRM EMSPOT_ID Cascade