CMFWKSPC
Holds workspace-specific information.
Column Descriptions:
Name 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=canceled
- 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 NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
Indexes:
Name Column Names Type <SYSTEM-GENERATED> CMFWKSPC_ID Primary Key I0000880 IDENTIFIER Unique Index I0000881 STATUS Non-Unique Index I0000889 MEMBER_ID Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_1123 MEMBER_ID MEMBER MEMBER_ID Cascade
Referenced By Child Tables:
Constraint Columns Child Table Child Columns Type F_1127 CMFWKSPC_ID CMFWSTGREL CMFWKSPC_ID Cascade F_1128 CMFWKSPC_ID CMFWKSPCDSC CMFWKSPC_ID Cascade