CMFTGDSC

Holds the Task Group description information for Workspaces


Column Descriptions:

Name Type Description
CMFTASKGRP_ID BIGINT NOT NULL Foreign key to the CMFTASKGRP table. Associates the description to the task group. Forms the primary key together with LANGUAGE_ID.
LANGUAGE_ID INTEGER NOT NULL Foreign key to the LANGUAGE table. Indicates the language of the description. Primary key along with CMFTASKGRP_ID.
NAME VARCHAR (254) The name of the task group.
DESCRIPTION VARCHAR (4000) The description of the task group.
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> CMFTASKGRP_ID+LANGUAGE_ID Primary Key


Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_1125 CMFTASKGRP_ID CMFTASKGRP CMFTASKGRP_ID Cascade
F_1126 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade