WebSphere Commerce database table: TCSUBTYPE

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

Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235259250 TCSUBTYPE_ID Primary Key
I0000808 TCTYPE_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_831 TCTYPE_ID TCTYPE TCTYPE_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_830 TCSUBTYPE_ID TCSUBTYPDS TCSUBTYPE_ID Cascade
F_835 TCSUBTYPE_ID TERMCOND TCSUBTYPE_ID Cascade
Related reference