CMWSSCHEMA

The association of the underlying database schemas that makes up the workspace along with the assigning the workspace to a workspace identifier.

Column Descriptions:

NameTypeDescription
CMWSSCHEMA_IDINTEGER NOT NULLA unique reference to the read, write and base schema combination.
BASESCHEMACHAR (30) NOT NULLThe name of the schema that contains the base content.
WRITESCHEMACHAR (30) NOT NULLThe name of the schema that will contain the content changes.
READSCHEMACHAR (30) NOT NULLThe name of the schema that will represent how the content changes will appear.
WORKSPACECHAR (25)The workspace assigned to the schema pool.
ALLOCATEDINTEGER NOT NULLFlag used to ensure that no workspace identifier will be assigned to another available schema pool.
SYNCREQUIREDSMALLINT NOT NULL DEFAULT 0The 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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CMWSSCHEMA_IDPrimary Key
I0000834WORKSPACE+ALLOCATEDUnique Index