Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: COLLATERAL
This table contains data describing the advertisements used by marketing campaigns.
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 SQL100520030318610 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
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_251 COLLATERAL_ID COLLDESC COLLATERAL_ID Cascade
Related reference
_vcc_freeselect_bottom_