WebSphere Commerce database table: TCDESC

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031318580 TERMCOND_ID+LANGUAGE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_825 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_826 TERMCOND_ID TERMCOND TERMCOND_ID Cascade

Feedback