The default content to display in an e-Marketing
Spot.
Column Descriptions:
| Name | 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. When
used by store functions, valid values include: FeatureEnabled, URL,
Locales. |
| CONTENT | VARCHAR (254) | The unique identifier of the content. For content
of type MarketingContent, this is the COLLATERAL.COLLATERAL_ID. For
content of type CatalogGroup, this is the CATGROUP.CATGROUP_ID. For
content of type CatalogEntry, this is the
CATENTRY.CATENTRY_ID. |
| SEQUENCE | DOUBLE NOT NULL DEFAULT 0 | The sequence of the default content. |
| 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> | DMEMSPOTDEF_ID | Primary Key |
| I0001163 | EMSPOT_ID+STOREENT_ID+CONTENTTYPE+CONTENT | Unique Index |
| I0001164 | STOREENT_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3537 | EMSPOT_ID | EMSPOT | EMSPOT_ID | Cascade |