WebSphere Commerce database table: TRDDESC

TRDDESC

The trading agreement description table.

Column Descriptions:

Name 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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> TRADING_ID+LANGUAGE_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_873 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_874 TRADING_ID TRADING TRADING_ID Cascade

Related reference
Contract data model

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Constraint	Columns	Parent Table	Parent Columns	Type
F_873	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_874	TRADING_ID	TRADING	TRADING_ID	Cascade