WebSphere Commerce database table: CMFTGCMT

Holds the task group comments for workspaces


Column Description(s):
Column NameColumn TypeDescription
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 a task group comment 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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031213630 CMFTGCMT_ID Primary Key
I0000890 CMFTASKGRP_ID Non-Unique Index
I0000891 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1129 CMFTASKGRP_ID CMFTASKGRP CMFTASKGRP_ID Cascade
F_1130 MEMBER_ID MEMBER MEMBER_ID Cascade

Feedback