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.
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>CMFTASK_ID+MEMBER_IDPrimary Key
I0000888MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1133CMFTASK_IDCMFTASKCMFTASK_IDCascade
F_1134MEMBER_IDMEMBERMEMBER_IDCascade