The association of the underlying database schemas
that makes up the workspace along with the assigning the workspace
to a workspace identifier.
Column Descriptions:
| Name | Type | Description |
| CMWSSCHEMA_ID | INTEGER NOT NULL | A unique reference to the read, write and base
schema combination. |
| BASESCHEMA | CHAR (30) NOT NULL | The name of the schema that contains the base
content. |
| WRITESCHEMA | CHAR (30) NOT NULL | The name of the schema that will contain the
content changes. |
| READSCHEMA | CHAR (30) NOT NULL | The name of the schema that will represent how
the content changes will appear. |
| WORKSPACE | CHAR (25) | 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. |
| SYNCREQUIRED | SMALLINT NOT NULL DEFAULT 0 | The flag indicates whether this workspace needs
to be synchronized. Default is '00'. There are four possible values
'00', '01' , '10' and '11'. '00' means no synchronization is
required. '01' means this synchronization request is triggered by
the changes in the current workspace. '10' means this
synchronization request is triggered by the changes in the base (a
broadcast synchronization). '11' means this synchronization request
is triggered by the changes in both the base ( a broadcast
synchronization) and the current workspace. |
| 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> | CMWSSCHEMA_ID | Primary Key |
| I0000834 | WORKSPACE+ALLOCATED | Unique Index |