WebSphere Commerce database table: CMFTGDSC

WebSphere Commerce database table: CMFTGDSC

Holds the task group description information for workspaces.
Column Descriptions
Column Name Column Type Description
CMFTASKGRP_ID BIGINT NOT NULL Foreign key to the CMFTASKGRP table. Associates the description to the task group. Forms the primary key together with LANGUAGE_ID.
LANGUAGE_ID INTEGER NOT NULL Foreign key to the LANGUAGE table. Indicates the language of the description. Primary key along with CMFTASKGRP_ID.
NAME VARCHAR(254) The name of the task group.
DESCRIPTION VARCHAR(4000) The description of the task group.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235143140 CMFTASKGRP_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1125 CMFTASKGRP_ID CMFTASKGRP CMFTASKGRP_ID Cascade
F_1126 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Column Name	Column Type	Description
CMFTASKGRP_ID	BIGINT NOT NULL	Foreign key to the CMFTASKGRP table. Associates the description to the task group. Forms the primary key together with LANGUAGE_ID.
LANGUAGE_ID	INTEGER NOT NULL	Foreign key to the LANGUAGE table. Indicates the language of the description. Primary key along with CMFTASKGRP_ID.
NAME	VARCHAR(254)	The name of the task group.
DESCRIPTION	VARCHAR(4000)	The description of the task group.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1125	CMFTASKGRP_ID	CMFTASKGRP	CMFTASKGRP_ID	Cascade
F_1126	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade