Holds the task group information for workspaces.
Column Description(s):
Column Name | Column 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 - 0=inactive, 1=working, 2=ready for approval, 3=approved 4=ready to commit, 5=complete, 6=cancelled, 7=commit failed, 8=commit in progress, 9=committed, 10=ready to publish, 11=publish, 12=publish in progress |
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. 1=Template 0=Instance |
QUICKPUBLISHTYPE |
INTEGER NOT NULL DEFAULT 0 |
Indicates whether or not this is a quick publish task group. 1=Yes 0=No |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
COMMITDATE |
TIMESTAMP |
Indicates the date that the task group content was committed to the base content. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000882 |
IDENTIFIER |
Unique Index |
SQL050212031213480 |
CMFTASKGRP_ID |
Primary Key |
I0000883 |
STATUS |
Non-Unique Index |
I0000884 |
TEMPLATETYPE |
Non-Unique Index |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1129 |
CMFTASKGRP_ID |
CMFTGCMT |
CMFTASKGRP_ID |
Cascade |
F_1125 |
CMFTASKGRP_ID |
CMFTGDSC |
CMFTASKGRP_ID |
Cascade |
F_1136 |
CMFTASKGRP_ID |
CMFTGTSKREL |
CMFTASKGRP_ID |
Cascade |
F_1135 |
CMFTASKGRP_ID |
CMFWSTGREL |
CMFTASKGRP_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.