CMFTSKMBREL

Holds the task member-specific information. This relationship defines the tasks assigned to members. For example, workspaces contributor tasks, approval tasks will be stored in this table.

Column Descriptions:

NameTypeDescription
CMFTASK_IDBIGINT NOT NULLForms the primary key along with MEMBER_ID. Foreign key to the CMFTASK table.
MEMBER_IDBIGINT NOT NULLForms the primary key together with CMFTASK_ID. Foreign key to the MEMBER table.
OPTCOUNTERSMALLINTThe 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>CMFTASK_ID+MEMBER_IDPrimary Key
I0000888MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1133CMFTASK_IDCMFTASKCMFTASK_IDCascade
F_1134MEMBER_IDMEMBERMEMBER_IDCascade