WebSphere Commerce database table: TRDTYPEDSC

This table stores a description for TradingAgreement types in multiple languages.

Column Descriptions
Column Name Column Type Description
TRDTYPE_ID INTEGER NOT NULL An identifier for the TradingAgreement type.
LANGUAGE_ID INTEGER NOT NULL Identifies the language of the TradingAgreement type description. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(4000) A description of the TradingAgreement type.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235304490 TRDTYPE_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_883 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_884 TRDTYPE_ID TRDTYPE TRDTYPE_ID Cascade