WebSphere Commerce database table: TCSUBTYPDS

TCSUBTYPDS

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

Column Descriptions:

Name Type Description
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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> TCSUBTYPE_ID+LANGUAGE_ID Primary Key

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_829 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_830 TCSUBTYPE_ID TCSUBTYPE TCSUBTYPE_ID Cascade

Related reference
Contract data model

Name	Type	Description
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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Constraint	Columns	Parent Table	Parent Columns	Type
F_829	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade
F_830	TCSUBTYPE_ID	TCSUBTYPE	TCSUBTYPE_ID	Cascade