WebSphere Commerce database table: TCDESC

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

Column Descriptions
Column Name Column 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 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235258800 TERMCOND_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_825 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_826 TERMCOND_ID TERMCOND TERMCOND_ID Cascade
Related reference