Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CMFTGCMT
Holds the task group comments for workspaces
Column Name Column Type Description CMFTGCMT_ID BIGINT NOT NULL Primary Key. Uniquely identifies a task group comment. CMFTASKGRP_ID BIGINT NOT NULL Foreign key to the CMFTASKGRP table. Associates task group comments to a task group. POSTEDDATE TIMESTAMP The date the comment was posted. MEMBER_ID BIGINT NOT NULL Foreign key to the MEMBER table. Indicates which member posted the comment. COMMENTS VARCHAR(4000) The comments for the task group. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030316610 CMFTGCMT_ID Primary Key I0000890 CMFTASKGRP_ID Non-Unique Index I0000891 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1129 CMFTASKGRP_ID CMFTASKGRP CMFTASKGRP_ID Cascade F_1130 MEMBER_ID MEMBER MEMBER_ID Cascade _vcc_freeselect_bottom_