CMFTASKDSC

Holds the task description information for tasks in workspaces.

Column Descriptions:

NameTypeDescription
CMFTASK_IDBIGINT NOT NULLForeign key to the CMFTASK table. Associates the task description to a task. Forms a primary key together with LANGUAGE_ID.
LANGUAGE_IDINTEGER NOT NULLForeign key to the LANGUAGE table. The identifier of the language. For a list of language components, see the LANGUAGE table. Forms a primary key along with CMFTASK_ID.
NAMEVARCHAR (254)The name of the task.
DESCRIPTIONVARCHAR (4000)The description of the task.
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+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1131CMFTASK_IDCMFTASKCMFTASK_IDCascade
F_1132LANGUAGE_IDLANGUAGELANGUAGE_IDCascade