Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CMFTASK
Holds the task information for workspaces
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.
Indexes Index Name Indexed Column Names Index Type I0000885 IDENTIFIER Unique Index SQL100520030316130 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 Names 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 _vcc_freeselect_bottom_