Holds the task information for workspaces
Column Description(s):
Column Name | Column Type | Description |
CMFTASK_ID |
BIGINT NOT NULL |
Primary key |
IDENTIFIER |
VARCHAR(254) |
Unique external name that is used to identify the Task. |
USAGE |
INTEGER |
Reserved for IBM internal use. |
DUEDATE |
TIMESTAMP |
Indicates the due date for the task. |
COMPLETEDATE |
TIMESTAMP |
Indicates the date the task was marked complete. |
STATUS |
INTEGER NOT NULL DEFAULT 0 |
Indicates the status of the task; 0=Inactive 1=Working 2=Complete |
TEMPLATETYPE |
INTEGER NOT NULL DEFAULT 0 |
Indicates if this is a template task; 1=Template 0=Instance |
TYPE |
INTEGER NOT NULL DEFAULT 1 |
Indicates the type of task; 1=Content Contributor; 2=Approver |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000885 |
IDENTIFIER |
Unique Index |
SQL050212031213170 |
CMFTASK_ID |
Primary Key |
I0000886 |
STATUS |
Non-Unique Index |
I0000887 |
TYPE |
Non-Unique Index |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1131 |
CMFTASK_ID |
CMFTASKDSC |
CMFTASK_ID |
Cascade |
F_1137 |
CMFTASK_ID |
CMFTGTSKREL |
CMFTASK_ID |
Cascade |
F_1133 |
CMFTASK_ID |
CMFTSKMBREL |
CMFTASK_ID |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.