The association of the underlying database schemas that makes up the workspace along with the assigning the workspace to a workspace identifier.
Column Description(s):
Column Name | Column Type | Description |
CMWSSCHEMA_ID |
INTEGER NOT NULL |
A unique reference to the read, write and base schema combination. |
BASESCHEMA |
CHAR(10) NOT NULL |
The name of the schema that contains the base content. |
WRITESCHEMA |
CHAR(10) NOT NULL |
The name of the schema that will contain the content changes. |
READSCHEMA |
CHAR(10) NOT NULL |
The name of the schema that will represent how the content changes will appear. |
WORKSPACE |
CHAR(25) NOT NULL |
The workspace assigned to the schema pool. |
ALLOCATED |
INTEGER NOT NULL |
Flag used to ensure that no workspace identifier will be assigned to another available schema pool. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000834 |
WORKSPACE+ALLOCATED |
Unique Index |
SQL050212031215110 |
CMWSSCHEMA_ID |
Primary Key |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.