CMFWSTGREL

Holds the relationshop between the Workspace and the Task Group

Column Descriptions:

NameTypeDescription
CMFWKSPC_IDBIGINT NOT NULLForeign key to the CMFWKSPC table. Forms the primary key along with CMFTASKGRP_ID
CMFTASKGRP_IDBIGINT NOT NULLForeign key to CMFTASKGRP table. Forms the primary key together with CMFWKSPC_ID.
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>CMFWKSPC_ID+CMFTASKGRP_IDPrimary Key
I0001442CMFTASKGRP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1127CMFWKSPC_IDCMFWKSPCCMFWKSPC_IDCascade
F_1135CMFTASKGRP_IDCMFTASKGRPCMFTASKGRP_IDCascade