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 Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
SQL050212031318410 TERMCOND_ID+TYPE+SEQUENCE Primary Key
I0000807 TRADING_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_923 TERMCOND_ID TERMCOND TERMCOND_ID Cascade
F_924 TRADING_ID TRADING TRADING_ID Cascade

Feedback