Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: COLLDESC
This table holds language-dependent information related to a Collateral.
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. LONGMKTGTEXT CLOB Reserved for IBM internal use. FIELD1 VARCHAR(254) Customizable. FIELD2 VARCHAR(254) Customizable. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030318770 LANGUAGE_ID+COLLATERAL_ID Primary Key I0001249 COLLATERAL_ID Non-Unique Index
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
_vcc_freeselect_bottom_