Reference > Database > WebSphere Commerce database tables > T


WebSphere Commerce database table: TRDDESC

The trading agreement description table.

Column Name Column Type Description
TRADING_ID BIGINT NOT NULL Trading ID.
LANGUAGE_ID INTEGER NOT NULL The language ID. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(254) Trading agreement short description.
LONGDESCRIPTION VARCHAR(4000) Trading agreement long description.
TIMECREATED TIMESTAMP Time created.
TIMEUPDATED TIMESTAMP Time updated.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030443090 TRADING_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_873 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_874 TRADING_ID TRADING TRADING_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search