Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: CMFTASKDSC

Holds the task description information for tasks in workspaces.

Column Name Column Type Description
CMFTASK_ID BIGINT NOT NULL Foreign key to the CMFTASK table. Associates the task description to a task. Forms a primary key together with LANGUAGE_ID.
LANGUAGE_ID INTEGER NOT NULL Foreign key to the LANGUAGE table. The identifier of the language. For a list of language components, see the LANGUAGE table. Forms a primary key along with CMFTASK_ID.
NAME VARCHAR(254) The name of the task.
DESCRIPTION VARCHAR(4000) The description of the task.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030316300 CMFTASK_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1131 CMFTASK_ID CMFTASK CMFTASK_ID Cascade
F_1132 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search