WebSphere Commerce database table: CMFTASKDSC

WebSphere Commerce database table: CMFTASKDSC

Holds the task description information for tasks in workspaces.
Column Descriptions
Column Name Column Type Description
CMFTASK_ID BIGINT NOT NULL Foreign key to the CMFTASK table. Associates the task description to a task. Forms a primary key together with LANGUAGE_ID.
LANGUAGE_ID INTEGER NOT NULL Foreign key to the LANGUAGE table. The identifier of the language. For a list of language components, see the LANGUAGE table. Forms a primary key along with CMFTASK_ID.
NAME VARCHAR(254) The name of the task.
DESCRIPTION VARCHAR(4000) The description of the task.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235142660 CMFTASK_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1131 CMFTASK_ID CMFTASK CMFTASK_ID Cascade
F_1132 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Column Name	Column Type	Description
CMFTASK_ID	BIGINT NOT NULL	Foreign key to the CMFTASK table. Associates the task description to a task. Forms a primary key together with LANGUAGE_ID.
LANGUAGE_ID	INTEGER NOT NULL	Foreign key to the LANGUAGE table. The identifier of the language. For a list of language components, see the LANGUAGE table. Forms a primary key along with CMFTASK_ID.
NAME	VARCHAR(254)	The name of the task.
DESCRIPTION	VARCHAR(4000)	The description of the task.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1131	CMFTASK_ID	CMFTASK	CMFTASK_ID	Cascade
F_1132	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade