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.
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+CMFTASKGRP_IDPrimary Key
I0001441CMFTASKGRP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1136CMFTASKGRP_IDCMFTASKGRPCMFTASKGRP_IDCascade
F_1137CMFTASK_IDCMFTASKCMFTASK_IDCascade