Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CMFTASKGRP
Holds the task group information for workspaces.
Column Name Column Type Description CMFTASKGRP_ID BIGINT NOT NULL The unique ID of this task group. IDENTIFIER VARCHAR(254) Unique, language-independent name used to identify the task group. STATUS INTEGER NOT NULL DEFAULT 0 Indicates the status of the Task Group. The possible values are: 0=inactive. 1=working. 2=ready for approval. 3=approved. 4=ready to commit. 5=complete. 6=cancelled. 7=commit failed. 8=commit in progress. 9=committed. 10=ready to publish. 11=publish. 12=publish in progress. 13=publish failed. APPROVEDATE TIMESTAMP Indicates the date the task group was approved for promotion. DUEDATE TIMESTAMP Due date of the task group. PROMOTIONDATE TIMESTAMP Date on which the task group promotion is scheduled. PERSISTENTYPE INTEGER NOT NULL DEFAULT 0 Indicates whether or not this is a persistent task group. 1=persistent, 0=not persistent TEMPLATETYPE INTEGER NOT NULL DEFAULT 0 Indicates whether or not this is a template task group. 1=Template 0=Instance QUICKPUBLISHTYPE INTEGER NOT NULL DEFAULT 0 Indicates whether or not this is a quick publish task group. 1=Yes 0=No OPTCOUNTER SMALLINT Reserved for IBM internal use. COMMITDATE TIMESTAMP Indicates the date that the task group content was committed to the base content.
Indexes Index Name Indexed Column Names Index Type I0000882 IDENTIFIER Unique Index SQL100520030316460 CMFTASKGRP_ID Primary Key I0000883 STATUS Non-Unique Index I0000884 TEMPLATETYPE Non-Unique Index
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1129 CMFTASKGRP_ID CMFTGCMT CMFTASKGRP_ID Cascade F_1125 CMFTASKGRP_ID CMFTGDSC CMFTASKGRP_ID Cascade F_1136 CMFTASKGRP_ID CMFTGTSKREL CMFTASKGRP_ID Cascade F_1135 CMFTASKGRP_ID CMFWSTGREL CMFTASKGRP_ID Cascade _vcc_freeselect_bottom_