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 Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
I0000834 WORKSPACE+ALLOCATED Unique Index
SQL050212031215110 CMWSSCHEMA_ID Primary Key

Feedback