WebSphere Commerce database table: CMFTGTSKREL

WebSphere Commerce database table: CMFTGTSKREL

Holds the relationship between a task group and a task.

Column Descriptions
Column Name Column Type Description

CMFTASK_ID BIGINT NOT NULL Forms the primary key together with CMFTASKGRP_ID. Foreign key to the CMFTASK table.

CMFTASKGRP_ID BIGINT NOT NULL Forms the primary key together with CMFTASK_ID. Foreign key to the CMFTASKGRP table.

OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type

SQL060903235143280 CMFTASK_ID+CMFTASKGRP_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type

F_1137 CMFTASK_ID CMFTASK CMFTASK_ID Cascade

F_1136 CMFTASKGRP_ID CMFTASKGRP CMFTASKGRP_ID Cascade

Column Name	Column Type	Description
CMFTASK_ID	BIGINT NOT NULL	Forms the primary key together with CMFTASKGRP_ID. Foreign key to the CMFTASK table.
CMFTASKGRP_ID	BIGINT NOT NULL	Forms the primary key together with CMFTASK_ID. Foreign key to the CMFTASKGRP table.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1137	CMFTASK_ID	CMFTASK	CMFTASK_ID	Cascade
F_1136	CMFTASKGRP_ID	CMFTASKGRP	CMFTASKGRP_ID	Cascade