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 Descriptions:

NameTypeDescription
CMVERSNINFO_IDBIGINT NOT NULLForeign key to CMVERSINFO table
CONTAINER_IDINTEGER NOT NULL-1 for catalog component
UI_OBJECT_NAMEVARCHAR (128) NOT NULLThe UI object name defined in the content version configuration file
OBJECT_IDBIGINT NOT NULLThe object ID
STOREENT_IDINTEGER NOT NULLThe store entity ID
MEMBER_IDBIGINTThe user who last updates the active version
VERSION_IDENTIFIERVARCHAR (128) NOT NULLThe version identifier
NAMEVARCHAR (254)The name of the version
LASTUPDATETIMESTAMPThe last updated timestamp
OBJECT_DELETEDINTEGER NOT NULL DEFAULT 00 not deleted, 1 deleted
MODIFIEDINTEGER NOT NULL DEFAULT 0Reserved for HCL internal use
WORKSPACEVARCHAR (25) NOT NULLWorkspace identifier. For base schema, it is IBM_WC_BASE, for real workspace, it is W_10001, etc.
CONTENT_TASKGRPVARCHAR (25)Content task group of the workspace
CONTENT_TASKVARCHAR (25)Content task of the workspace
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>CMVERSNINFO_ID+WORKSPACEPrimary Key
UCM_CMACTVERSN_0 OBJECT_ID+UI_OBJECT_NAME+WORKSPACE+STOREENT_ID+CONTAINER_IDUnique Index
ICM_CMACTVERSN_0WORKSPACE+CONTENT_TASKGRP+CONTENT_TASKNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
FCM_CMACTVERSN_0CMVERSNINFO_IDCMVERSNINFOCMVERSNINFO_IDCascade