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 Related reference
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