WebSphere Commerce database table: COLLATERAL

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000077 NAME+STOREENT_ID Unique Index
SQL050212031215670 COLLATERAL_ID Primary Key
I0000312 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_248 COLLTYPE_ID COLLTYPE COLLTYPE_ID Cascade
F_249 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_251 COLLATERAL_ID COLLDESC COLLATERAL_ID Cascade

Feedback