WebSphere Commerce database table: TCATTR

WebSphere Commerce 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 Descriptions
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235258610 TERMCOND_ID+TYPE+SEQUENCE Primary Key
I0000807 TRADING_ID Non-Unique Index

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
Related reference

Contract data model

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
SQL060903235258610	TERMCOND_ID+TYPE+SEQUENCE	Primary Key
I0000807	TRADING_ID	Non-Unique Index

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