This table is part of the Content Version schema,
and alias in the Commerce base schema. It holds a list of objects
to be versioned.
Column Descriptions:
Name | Type | Description |
CMVERSNCHGLOG_ID | BIGINT NOT NULL | The primary key of the table. |
NOUN | VARCHAR (128) NOT NULL | The name of the noun. |
OBJECT_ID | BIGINT NOT NULL | The object ID |
STOREENT_ID | INTEGER NOT NULL | The store entity ID |
WORKSPACE | VARCHAR (25) NOT NULL | The workspace for that the object is in for
versioning. For base schema, it is IBM_WC_BASE, for real workspace,
it is W_10001, etc. |
CONTENT_TASKGRP | VARCHAR (25) | The task group identifier |
STATUS | SMALLINT NOT NULL DEFAULT 0 | The status of versioning this object. 0=This
object is pending for process -1=This object is ready to be
processed -2=This object is processed -3=The process on this object
has failed. Retryable -4=The process on this object has fauled.
Non-retryable. |
FILTER | INTEGER | The filter value |
LASTUPDATE | TIMESTAMP | The last update time |
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> | CMVERSNCHGLOG_ID | Primary Key |
UCM_CMVERSNCHGLOG_0 | NOUN+OBJECT_ID+STOREENT_ID+WORKSPACE | Unique Index |