WebSphere Commerce database table: CMFWKSPCDSC

WebSphere Commerce database table: CMFWKSPCDSC

Holds workspace description-specific information.
Column Descriptions
Column Name Column Type Description
CMFWKSPC_ID BIGINT NOT NULL Associates the description to a workspace. Foreign key to CMFWKSPC. Forms the primary key together with LANGUAGE_ID.
LANGUAGE_ID INTEGER NOT NULL Associates the description to a language. Foreign key to the LANGUAGE table. Forms the primary key together with CMFWKSPC_ID.
NAME VARCHAR(254) The name of the workspace.
DESCRIPTION VARCHAR(4000) The description of the workspace.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235143720 CMFWKSPC_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1128 CMFWKSPC_ID CMFWKSPC CMFWKSPC_ID Cascade
F_1124 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Column Name	Column Type	Description
CMFWKSPC_ID	BIGINT NOT NULL	Associates the description to a workspace. Foreign key to CMFWKSPC. Forms the primary key together with LANGUAGE_ID.
LANGUAGE_ID	INTEGER NOT NULL	Associates the description to a language. Foreign key to the LANGUAGE table. Forms the primary key together with CMFWKSPC_ID.
NAME	VARCHAR(254)	The name of the workspace.
DESCRIPTION	VARCHAR(4000)	The description of the workspace.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1128	CMFWKSPC_ID	CMFWKSPC	CMFWKSPC_ID	Cascade
F_1124	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade