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_


+

Search Tips   |   Advanced Search