Reference > Database > WebSphere Commerce database tables > T

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 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... 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
SQL100520030437770	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

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search