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 | Description |
---|---|---|
TERMCOND_ID | BIGINT NOT NULL | The TermsAndConditions ID. |
TYPE | INTEGER NOT NULL | The type of attribute for the terms and conditions as follows: 0 = TermCondition 1 = Policy |
TRADING_ID | BIGINT NOT NULL | The trading agreement identifier. |
SEQUENCE | INTEGER NOT NULL DEFAULT 0 | The sequence of the data. |
XMLDEFINITION | CLOB NOT NULL | The XML definition of the term and condition. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031318410 | TERMCOND_ID+TYPE+SEQUENCE | Primary Key |
I0000807 | TRADING_ID | Non-Unique Index |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_923 | TERMCOND_ID | TERMCOND | TERMCOND_ID | Cascade |
F_924 | TRADING_ID | TRADING | TRADING_ID | Cascade |