Reference > Database > WebSphere Commerce database tables > D
WebSphere Commerce database table: DMEMSPOTORD
A list of ordering schemes in which to order marketing content displayed in an e-MarketingSpot.
Column Name Column Type Description DMEMSPOTORD_ID INTEGER NOT NULL The unique identifier of the e-MarketingSpot ordering scheme. CONTENTTYPE VARCHAR(254) NOT NULL The type of content which can be ordered. Valid values include: CatalogGroup, CatalogEntry, MarketingContent. ORDERINGNAME VARCHAR(254) NOT NULL The name of the ordering scheme. INTERFACENAME VARCHAR(254) NOT NULL The command interface name. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001159 CONTENTTYPE+ORDERINGNAME Unique Index SQL100520030327500 DMEMSPOTORD_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3535 DMEMSPOTORD_ID DMEMSPOTCMD DMEMSPOTORD_ID Cascade _vcc_freeselect_bottom_