WebSphere Commerce database table: TCDESC

TCDESC

This table stores descriptions for terms and conditions for a contract.

Column Descriptions:

Name Type Description
TERMCOND_ID BIGINT NOT NULL A unique identifier for the term or condition.
LANGUAGE_ID INTEGER NOT NULL The language ID. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR (254) A brief description of the term or condition.
LONGDESCRIPTION VARCHAR (4000) A detailed description of the term or condition.
TIMECREATED TIMESTAMP Time that this term and condition was created.
TIMEUPDATED TIMESTAMP Time that this term and condition was last 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> TERMCOND_ID+LANGUAGE_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_825 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_826 TERMCOND_ID TERMCOND TERMCOND_ID Cascade

Related reference
Contract data model

Name	Type	Description
TERMCOND_ID	BIGINT NOT NULL	A unique identifier for the term or condition.
LANGUAGE_ID	INTEGER NOT NULL	The language ID. For a list of language components, see the LANGUAGE table.
DESCRIPTION	VARCHAR (254)	A brief description of the term or condition.
LONGDESCRIPTION	VARCHAR (4000)	A detailed description of the term or condition.
TIMECREATED	TIMESTAMP	Time that this term and condition was created.
TIMEUPDATED	TIMESTAMP	Time that this term and condition was last 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_825	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_826	TERMCOND_ID	TERMCOND	TERMCOND_ID	Cascade