WebSphere Commerce database table: CMFTGCMT

Holds the task group comments for workspaces

Column Descriptions
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
SQL060903235142990 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