CMFTASK
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 HCL 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:
|
TEMPLATETYPE | INTEGER NOT NULL DEFAULT 0 | Indicates if this is a template task:
|
TYPE | INTEGER NOT NULL DEFAULT 1 | Indicates the type of task:
|
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> | 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 |