This table stores information about the terms and conditions attributes specified within a contract. This table stores the XML data required by a term and condition.
Column Name | Column Type | Column Description |
---|---|---|
SEQUENCE | INTEGER NOT NULL, DEFAULT 0 |
The sequence of the data. |
TERMCOND_ID | BIGINT NOT NULL |
The TermsAndConditions ID. |
TRADING_ID | BIGINT NOT NULL |
The trading agreement identifier. |
TYPE | INTEGER NOT NULL |
The type of attribute for the terms and conditions as follows: 0 = TermCondition 1 = Policy |
XMLDEFINITION | CLOB (1000000) NOT NULL |
The XML definition of the term and condition. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035126830 | TERMCOND_ID, TYPE, SEQUENCE | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_923 | TERMCOND_ID | TERMCOND | TERMCOND_ID | Cascade |
F_924 | TRADING_ID | TRADING | TRADING_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|