CMFTGTSKREL

Holds the relationship between a task group and a task.

Column Descriptions:

NameTypeDescription
CMFTASK_IDBIGINT NOT NULLForms the primary key together with CMFTASKGRP_ID. Foreign key to the CMFTASK table.
CMFTASKGRP_IDBIGINT NOT NULLForms the primary key together with CMFTASK_ID. Foreign key to the CMFTASKGRP 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+CMFTASKGRP_IDPrimary Key
I0001441CMFTASKGRP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1136CMFTASKGRP_IDCMFTASKGRPCMFTASKGRP_IDCascade
F_1137CMFTASK_IDCMFTASKCMFTASK_IDCascade