Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: 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 Name Column 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 Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type UCM_CMVERSNCHGLOG NOUN+OBJECT_ID+STOREENT_ID+WORKSPACE Unique Index SQL101215095936940 CMVERSNCHGLOG_ID Primary Key _vcc_freeselect_bottom_