WebSphere Commerce database table: COLLATERAL

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

Column Descriptions
Column Name Column Type Description
COLLATERAL_ID INTEGER NOT NULL The internal reference number of the Collateral.
STOREENT_ID INTEGER NOT NULL The ID of the store to which the Collateral belongs.
COLLTYPE_ID INTEGER NOT NULL Foreign key to the COLLTYPE table. Identifies the type of Collateral. The supported default types are Image, Flash, and Text.
NAME VARCHAR(30) The name of the Collateral.
URL VARCHAR(254) The click action to be invoked when the Collateral on the page is clicked.
FIELD1 VARCHAR(254) Customizable.
FIELD2 VARCHAR(254) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000077 NAME+STOREENT_ID Unique Index
SQL060903235144950 COLLATERAL_ID Primary Key
I0000312 STOREENT_ID Non-Unique Index

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

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_251 COLLATERAL_ID COLLDESC COLLATERAL_ID Cascade
Related reference