DMEMSPOTPAGE

This table is currently not used. Can be used to relate e-Marketing Spots to store pages.

Column Descriptions:

NameTypeDescription
EMSPOT_IDINTEGER NOT NULLThe identifier of the e-Marketing Spot.
DMPAGE_IDINTEGER NOT NULLThe identifier of the store page.
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>EMSPOT_ID+DMPAGE_IDPrimary Key
I0001158DMPAGE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3533DMPAGE_IDDMPAGEDMPAGE_IDCascade
F_3534EMSPOT_IDEMSPOTEMSPOT_IDCascade