WebSphere Commerce database table: TCSUBTYPE

Each row in this table contains information about the implementation of a terms and conditions sub-type.


Column Description(s):
Column NameColumn TypeDescription
TCSUBTYPE_ID CHAR(64) NOT NULL Primary key. This column contains an identifier for the terms and conditions sub-type.
TCTYPE_ID CHAR(64) NOT NULL Foreign key to the TCTYPE table. This column indicates the term type.
ACCESSBEANNAME VARCHAR(254) This column contains the enterprise access bean name for the term.
DEPLOYCOMMAND VARCHAR(254) This column contains the deploy command interface name for the term.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031319040 TCSUBTYPE_ID Primary Key
I0000808 TCTYPE_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_831 TCTYPE_ID TCTYPE TCTYPE_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_830 TCSUBTYPE_ID TCSUBTYPDS TCSUBTYPE_ID Cascade
F_835 TCSUBTYPE_ID TERMCOND TCSUBTYPE_ID Cascade

Feedback