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:

Name	Type	Description
CMFTASK_ID	BIGINT NOT NULL	Forms the primary key along with MEMBER_ID. Foreign key to the CMFTASK table.
MEMBER_ID	BIGINT NOT NULL	Forms the primary key together with CMFTASK_ID. Foreign key to the MEMBER table.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CMFTASK_ID+MEMBER_ID	Primary Key
I0000888	MEMBER_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_1133	CMFTASK_ID	CMFTASK	CMFTASK_ID	Cascade
F_1134	MEMBER_ID	MEMBER	MEMBER_ID	Cascade