Reference > Database > WebSphere Commerce database tables > T
WebSphere Commerce database table: TCSUBTYPE
Each row in this table contains information about the implementation of a terms and conditions sub-type.
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 SQL100520030438400 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
Referenced By 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
_vcc_freeselect_bottom_