CMFTGDSC

Holds the Task Group description information for Workspaces

Column Descriptions:

NameTypeDescription
CMFTASKGRP_IDBIGINT NOT NULLForeign key to the CMFTASKGRP table. Associates the description to the task group. Forms the primary key together with LANGUAGE_ID.
LANGUAGE_IDINTEGER NOT NULLForeign key to the LANGUAGE table. Indicates the language of the description. Primary key along with CMFTASKGRP_ID.
NAMEVARCHAR (254)The name of the task group.
DESCRIPTIONVARCHAR (4000)The description of the task group.
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>CMFTASKGRP_ID+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1125CMFTASKGRP_IDCMFTASKGRPCMFTASKGRP_IDCascade
F_1126LANGUAGE_IDLANGUAGELANGUAGE_IDCascade