DMEMSPOTCOLLDEF

This is a relationship table between an e-Marketing Spot and a Collateral, which stores the e-Marketing Spot label.

Column Descriptions:

Name	Type	Description
DMEMSPOTCOLLDEF_ID	INTEGER NOT NULL	The primary key of the table
EMSPOT_ID	INTEGER NOT NULL	The identifier of the e-MarketingSpot in which to set the default label.
STOREENT_ID	INTEGER NOT NULL	The identifier of the store in which to set the e-MarketingSpot default label.
COLLATERAL_ID	INTEGER NOT NULL	The internal reference number that indicates the Collateral that will be used as label.
SEQUENCE	DOUBLE NOT NULL DEFAULT 0	The sequence number that determines the display order of the labels
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
P_0015	DMEMSPOTCOLLDEF_ID	Primary Key
I0001483	EMSPOT_ID+STOREENT_ID+COLLATERAL_ID	Unique Index
I0001484	COLLATERAL_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3740	EMSPOT_ID	EMSPOT	EMSPOT_ID	Cascade
F_3741	COLLATERAL_ID	COLLATERAL	COLLATERAL_ID	Cascade