Holds the Task Group information for
Workspaces.
Column Descriptions:
Name | Type | Description |
CMFTASKGRP_ID | BIGINT NOT NULL | The unique ID of this task group. |
IDENTIFIER | VARCHAR (254) | Unique, language-independent name used to
identify the task group. |
STATUS | INTEGER NOT NULL DEFAULT 0 | Indicates the status of the Task Group. The
possible values are:
- 0=inactive.
- 1=working.
- 2=ready for approval.
- 3=approved.
- 4=ready to commit.
- 5=complete.
- 6=canceled.
- 7=commit failed.
- 8=commit in progress.
- 9=committed.
- 10=ready to publish.
- 11=publish in progress.
- 12=published.
- 13=publish failed.
|
APPROVEDATE | TIMESTAMP | Indicates the date the task group was approved
for promotion. |
DUEDATE | TIMESTAMP | Due date of the task group. |
PROMOTIONDATE | TIMESTAMP | Date on which the task group promotion is
scheduled. |
PERSISTENTYPE | INTEGER NOT NULL DEFAULT 0 | Indicates whether or not this is a persistent
task group.
- 1=persistent
- 0=not persistent
|
TEMPLATETYPE | INTEGER NOT NULL DEFAULT 0 | Indicates whether or not this is a template task
group.
|
QUICKPUBLISHTYPE | INTEGER NOT NULL DEFAULT 0 | Indicates whether or not this is a quick publish
task group.
|
COMMITDATE | TIMESTAMP | Indicates the date that the task group content
was committed to the base content. |
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 | Primary Key |
I0000882 | IDENTIFIER | Unique Index |
I0000883 | STATUS | Non-Unique Index |
I0000884 | TEMPLATETYPE | Non-Unique Index |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_1125 | CMFTASKGRP_ID | CMFTGDSC | CMFTASKGRP_ID | Cascade |
F_1129 | CMFTASKGRP_ID | CMFTGCMT | CMFTASKGRP_ID | Cascade |
F_1135 | CMFTASKGRP_ID | CMFWSTGREL | CMFTASKGRP_ID | Cascade |
F_1136 | CMFTASKGRP_ID | CMFTGTSKREL | CMFTASKGRP_ID | Cascade |