CMFTGCMT

Holds the Task Group Comments for Workspaces

Column Descriptions:

NameTypeDescription
CMFTGCMT_IDBIGINT NOT NULLPrimary Key. Uniquely identifies a task group comment.
CMFTASKGRP_IDBIGINT NOT NULLForeign key to the CMFTASKGRP table. Associates task group comments to a task group.
POSTEDDATETIMESTAMPThe date the comment was posted.
MEMBER_IDBIGINT NOT NULLForeign key to the MEMBER table. Indicates which member posted the comment.
COMMENTSVARCHAR (4000)The comments for the task group.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CMFTGCMT_IDPrimary Key
I0000890CMFTASKGRP_IDNon-Unique Index
I0000891MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1129CMFTASKGRP_IDCMFTASKGRPCMFTASKGRP_IDCascade
F_1130MEMBER_IDMEMBERMEMBER_IDCascade