Holds the Task information for Workspaces
Column Descriptions:
| Name | 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:
|
| TYPE | INTEGER NOT NULL DEFAULT 1 | Indicates the type of task:
- 1=Content Contributor
- 2=Approver
|
| OPTCOUNTER | SMALLINT | 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> | CMFTASK_ID | Primary Key |
| I0000885 | IDENTIFIER | Unique Index |
| I0000886 | STATUS | Non-Unique Index |
| I0000887 | TYPE | Non-Unique Index |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_1131 | CMFTASK_ID | CMFTASKDSC | CMFTASK_ID | Cascade |
| F_1133 | CMFTASK_ID | CMFTSKMBREL | CMFTASK_ID | Cascade |
| F_1137 | CMFTASK_ID | CMFTGTSKREL | CMFTASK_ID | Cascade |