WebSphere Commerce database table: CMFTASKGRP

Holds the task group information for workspaces.


Column Description(s):
Column NameColumn TypeDescription
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 - 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
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000882 IDENTIFIER Unique Index
SQL050212031213480 CMFTASKGRP_ID Primary Key
I0000883 STATUS Non-Unique Index
I0000884 TEMPLATETYPE Non-Unique Index

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

Feedback