WebSphere Commerce database table: COLLDESC

This table holds language-dependent information related to a Collateral.

Column Descriptions
Column Name Column Type Description
COLLATERAL_ID INTEGER NOT NULL The internal reference number that indicates the Collateral that this language specific information relates to.
LANGUAGE_ID INTEGER NOT NULL The Identifier of the language. For a list of language components, see the LANGUAGE table.
LOCATION VARCHAR(254) The full image path of the Collateral in the Web application.
MARKETINGTEXT VARCHAR(4000) The marketing text of the Collateral. It describes the marketing objective intended by the marketing campaign.
FIELD1 VARCHAR(254) Customizable.
FIELD2 VARCHAR(254) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235145110 LANGUAGE_ID+COLLATERAL_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_251 COLLATERAL_ID COLLATERAL COLLATERAL_ID Cascade
F_250 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference