Database Table: COLLDESC

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

Column Name Column Type Column Description
COLLATERAL_ID INTEGER
NOT NULL
The internal reference number that indicates the Collateral that this language specific information relates to.
FIELD1 VARCHAR (254)
NULL
Customizable.
FIELD2 VARCHAR (254)
NULL
Customizable.
LANGUAGE_ID INTEGER
NOT NULL
The Identifier of the language. For a list of language components, see the LANGUAGE table.
LOCATION VARCHAR (254)
NULL
The full image path of the Collateral in the Web application.
MARKETINGTEXT VARCHAR (4000)
NULL
The marketing text of the Collateral. It describes the marketing objective intended by the marketing campaign.
Indexes:
Index Name Indexed Column Names Index Type
SQL030625034932190 LANGUAGE_ID, COLLATERAL_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_250 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_251 COLLATERAL_ID COLLATERAL COLLATERAL_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable