CMVERSNCHGLOG

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:

NameTypeDescription
CMVERSNCHGLOG_IDBIGINT NOT NULLThe primary key of the table.
NOUNVARCHAR (128) NOT NULLThe name of the noun.
OBJECT_IDBIGINT NOT NULLThe object ID
STOREENT_IDINTEGER NOT NULLThe store entity ID
WORKSPACEVARCHAR (25) NOT NULLThe 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_TASKGRPVARCHAR (25)The task group identifier
STATUSSMALLINT NOT NULL DEFAULT 0The 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. Retriable
-4=The process on this object has failed. Not retriable.

FILTERINTEGERThe filter value
LASTUPDATETIMESTAMPThe last update time
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>CMVERSNCHGLOG_IDPrimary Key
UCM_CMVERSNCHGLOG_0NOUN+OBJECT_ID+STOREENT_ID+WORKSPACEUnique Index