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 HCL internal use. |
| PROMOTIONPOLICY | INTEGER NOT NULL DEFAULT 0 | Reserved for HCL 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 |