WebSphere Commerce database table: CMFWSTGREL

WebSphere Commerce database table: CMFWSTGREL

Holds the relationship between a workspace and a task group.
Column Descriptions
Column Name Column Type Description
CMFWKSPC_ID BIGINT NOT NULL Foreign key to the CMFWKSPC table. Forms the primary key along with CMFTASKGRP_ID
CMFTASKGRP_ID BIGINT NOT NULL Foreign key to CMFTASKGRP table. Forms the primary key together with CMFWKSPC_ID.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235143870 CMFWKSPC_ID+CMFTASKGRP_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1135 CMFTASKGRP_ID CMFTASKGRP CMFTASKGRP_ID Cascade
F_1127 CMFWKSPC_ID CMFWKSPC CMFWKSPC_ID Cascade

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

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1135	CMFTASKGRP_ID	CMFTASKGRP	CMFTASKGRP_ID	Cascade
F_1127	CMFWKSPC_ID	CMFWKSPC	CMFWKSPC_ID	Cascade