A list of ordering schemes in which to order
marketing content displayed in an e-MarketingSpot.
Column Descriptions:
| Name | 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 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | DMEMSPOTORD_ID | Primary Key |
| I0001159 | CONTENTTYPE+ORDERINGNAME | Unique Index |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_3535 | DMEMSPOTORD_ID | DMEMSPOTCMD | DMEMSPOTORD_ID | Cascade |