Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMEMSPOTCMD
The ordering scheme set up for stores and individual e-MarketingSpots.
Column Name Column Type Description DMEMSPOTCMD_ID INTEGER NOT NULL The primary key. CONTENTTYPE VARCHAR(254) NOT NULL The type of content to be ordered. Valid values include: CatalogGroup, CatalogEntry, MarketingContent. STOREENT_ID INTEGER NOT NULL The identifier of the store in which to run the e-MarketingSpot ordering scheme. If the value of emspot_id is null, then this is the default ordering scheme for all the e-MarketingSpots in the store. EMSPOT_ID INTEGER The identifier of the e-MarketingSpot in which to run the ordering scheme. DMEMSPOTORD_ID INTEGER The identifier of the e-MarketingSpot ordering scheme. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001160 CONTENTTYPE+STOREENT_ID+EMSPOT_ID Unique Index SQL100520030327190 DMEMSPOTCMD_ID Primary Key I0001161 EMSPOT_ID Non-Unique Index I0001162 DMEMSPOTORD_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3535 DMEMSPOTORD_ID DMEMSPOTORD DMEMSPOTORD_ID Cascade F_3536 EMSPOT_ID EMSPOT EMSPOT_ID Cascade _vcc_freeselect_bottom_