Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMEMSPOTDEF
The default content to display in an e-Marketing Spot.
Column Name Column Type Description DMEMSPOTDEF_ID INTEGER NOT NULL The primary key. EMSPOT_ID INTEGER NOT NULL The identifier of the e-MarketingSpot in which to set the default content. STOREENT_ID INTEGER NOT NULL The identifier of the store in which to set the e-MarketingSpot default content. CONTENTTYPE VARCHAR(254) NOT NULL The type of content which can be ordered. Valid values include: CatalogGroup, CatalogEntry, MarketingContent. CONTENT VARCHAR(254) The identifier of the content. This is the primary key to the table containing the content. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001163 EMSPOT_ID+STOREENT_ID+CONTENTTYPE+CONTENT Unique Index SQL100520030327360 DMEMSPOTDEF_ID Primary Key I0001164 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3537 EMSPOT_ID EMSPOT EMSPOT_ID Cascade _vcc_freeselect_bottom_