Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: CMACTVERSN
This table is part of the Content Version schema, and alias in the Commerce base schema. This table contains all content active version.
Column Name Column Type Description CMVERSNINFO_ID BIGINT NOT NULL Foreign key to CMVERSINFO table CONTAINER_ID INTEGER NOT NULL -1 for catalog component UI_OBJECT_NAME VARCHAR(128) NOT NULL The UI object name defined in the content version configuration file OBJECT_ID BIGINT NOT NULL The object ID STOREENT_ID INTEGER NOT NULL The store entity ID MEMBER_ID BIGINT The user who last updates the active version VERSION_IDENTIFIER VARCHAR(128) NOT NULL The version identifier NAME VARCHAR(254) The name of the version LASTUPDATE TIMESTAMP The last updated timestamp OBJECT_DELETED INTEGER NOT NULL DEFAULT 0 0 not deleted, 1 deleted MODIFIED INTEGER NOT NULL DEFAULT 0 Reserved IBM Internal Use WORKSPACE VARCHAR(25) NOT NULL Workspace identifier. For base schema, it is IBM_WC_BASE, for real workspace, it is W_10001, etc. CONTENT_TASKGRP VARCHAR(25) Content task group of the workspace CONTENT_TASK VARCHAR(25) No CONTENT_TASK external description assigned yet OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type UCM_CMACTVERSN_0 OBJECT_ID+UI_OBJECT_NAME+WORKSPACE+STOREENT_ID+CONTAINER_ID Unique Index SQL101215095935330 CMVERSNINFO_ID+WORKSPACE Primary Key ICM_CMACTVERSN_0 WORKSPACE+CONTENT_TASKGRP+CONTENT_TASK Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type FCM_CMACTVERSN_0 CMVERSNINFO_ID CMVERSNINFO CMVERSNINFO_ID Cascade _vcc_freeselect_bottom_