WebSphere Commerce database table: CMFTASK

Holds the task information for workspaces


Column Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
I0000885 IDENTIFIER Unique Index
SQL050212031213170 CMFTASK_ID Primary Key
I0000886 STATUS Non-Unique Index
I0000887 TYPE Non-Unique Index

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign 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

Feedback