Database Table: TCDESC

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

Column Name Column Type Column Description
DESCRIPTION VARCHAR (254)
NULL
A brief description of the term or condition.
LANGUAGE_ID INTEGER
NOT NULL
The language ID. For a list of language components, see the LANGUAGE table.
LONGDESCRIPTION VARCHAR (4000)
NULL
A detailed description of the term or condition.
TERMCOND_ID BIGINT
NOT NULL
A unique identifier for the term or condition.
TIMECREATED TIMESTAMP
NULL
Time created.
TIMEUPDATED TIMESTAMP
NULL
Time updated.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035127380 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable