Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: CMFWSTGREL

Holds the relationship between a workspace and a task group.

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
SQL100520030317600 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

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search