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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035127380 | TERMCOND_ID, LANGUAGE_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|