Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CMFWKSPC
Holds workspace-specific information.
Column Name Column Type Description CMFWKSPC_ID BIGINT NOT NULL Primary key. IDENTIFIER VARCHAR(254) Unique, language-independent name for the workspace. STATUS INTEGER NOT NULL DEFAULT 1 Indicates the status of a workspace. 1=active, 2=complete, 3=cancelled, 4=cancel in progress. MEMBER_ID BIGINT NOT NULL Foreign key to the MEMBER table. Identifies the Workspace Manager. PERSISTENTYPE INTEGER NOT NULL DEFAULT 0 Indicates whether or not this is a persistent workspace. 1=persistent, 0=not persistent LOCKINGPOLICY INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use. PROMOTIONPOLICY INTEGER NOT NULL DEFAULT 0 Reserved for IBM internal use. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000880 IDENTIFIER Unique Index SQL100520030317260 CMFWKSPC_ID Primary Key I0000881 STATUS Non-Unique Index I0000889 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1123 MEMBER_ID MEMBER MEMBER_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_1128 CMFWKSPC_ID CMFWKSPCDSC CMFWKSPC_ID Cascade F_1127 CMFWKSPC_ID CMFWSTGREL CMFWKSPC_ID Cascade _vcc_freeselect_bottom_