WebSphere Commerce database table: CMWSSCHEMA

WebSphere Commerce database table: 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
Column Name Column 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.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
SYNCREQUIRED SMALLINT NOT NULL DEFAULT 0 No SYNCREQUIRED external description assigned yet

Indexes
Index Name Indexed Column Names Index Type
I0000834 WORKSPACE+ALLOCATED Unique Index
SQL060903235144150 CMWSSCHEMA_ID Primary Key

Column Name	Column 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.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.
SYNCREQUIRED	SMALLINT NOT NULL DEFAULT 0	No SYNCREQUIRED external description assigned yet

Index Name	Indexed Column Names	Index Type
I0000834	WORKSPACE+ALLOCATED	Unique Index
SQL060903235144150	CMWSSCHEMA_ID	Primary Key