Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CMFTGTSKREL
Holds the relationship between a task group and a task.
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 SQL100520030316950 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 _vcc_freeselect_bottom_