Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EMSPOT
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.
G = General content, which corresponds to a content spot. This value should only be used by the system.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 SQL100520030333370 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
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3536 EMSPOT_ID DMEMSPOTCMD EMSPOT_ID Cascade F_3537 EMSPOT_ID DMEMSPOTDEF EMSPOT_ID Cascade F_3534 EMSPOT_ID DMEMSPOTPAGE EMSPOT_ID Cascade F_387 EMSPOT_ID INTVSCHED EMSPOT_ID Cascade F_1158 ESPOT_ID SHDCACRM EMSPOT_ID Cascade
Related reference
_vcc_freeselect_bottom_