DMEMSPOTCMD

The ordering scheme set up for stores and individual e-MarketingSpots.

Column Descriptions:

NameTypeDescription
DMEMSPOTCMD_IDINTEGER NOT NULLThe primary key.
CONTENTTYPEVARCHAR (254) NOT NULLThe type of content to be ordered. Valid values include: CatalogGroup, CatalogEntry, MarketingContent.
STOREENT_IDINTEGER NOT NULLThe 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_IDINTEGERThe identifier of the e-MarketingSpot in which to run the ordering scheme.
DMEMSPOTORD_IDINTEGERThe identifier of the e-MarketingSpot ordering scheme.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>DMEMSPOTCMD_IDPrimary Key
I0001160CONTENTTYPE+STOREENT_ID+EMSPOT_IDUnique Index
I0001161EMSPOT_IDNon-Unique Index
I0001162DMEMSPOTORD_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3535DMEMSPOTORD_IDDMEMSPOTORDDMEMSPOTORD_IDCascade
F_3536EMSPOT_IDEMSPOTEMSPOT_IDCascade