Database Table: TCATTR

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035126830 TERMCOND_ID, TYPE, SEQUENCE Primary Key
Constraints:
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

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