WebSphere Commerce database table: TCSUBTYPDS

Each row in this table contains a description for a sub-type of terms and conditions.


Column Description(s):
Column NameColumn TypeDescription
TCSUBTYPE_ID CHAR(64) NOT NULL This column contains an identifier for the terms and conditions sub-type.
LANGUAGE_ID INTEGER NOT NULL This column contains an identifier indicating the language of the description. For a list of language components, see the LANGUAGE table.
DESCRIPTION VARCHAR(4000) A description of the terms and conditions sub-type.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031318860 TCSUBTYPE_ID+LANGUAGE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_829 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_830 TCSUBTYPE_ID TCSUBTYPE TCSUBTYPE_ID Cascade

Feedback