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