Database Table: COLLATERAL

This table contains data describing the advertisements used by marketing campaigns.

Column Name Column Type Column Description
COLLATERAL_ID INTEGER
NOT NULL
The internal reference number of the Collateral.
COLLTYPE_ID INTEGER
NOT NULL
Identifies the type of Collateral. Foreign key to the COLLTYPE table. The supported default types are Image and Flash.
FIELD1 VARCHAR (254)
NULL
Customizable.
FIELD2 VARCHAR (254)
NULL
Customizable.
NAME VARCHAR (30)
NULL
The name of the Collateral.
STOREENT_ID INTEGER
NOT NULL
The ID of the store to which the Collateral belongs.
URL VARCHAR (254)
NULL
The click action to be invoked when the Collateral on the page is clicked.
Indexes:
Index Name Indexed Column Names Index Type
I0000077 NAME, STOREENT_ID Unique Index
I0000312 STOREENT_ID Non-Unique Index
SQL030625034931780 COLLATERAL_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_248 COLLTYPE_ID COLLTYPE COLLTYPE_ID Cascade
F_249 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_251 COLLATERAL_ID COLLDESC COLLATERAL_ID Cascade