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:

Name	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 for HCL 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)	Content task of the workspace
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>	CMVERSNINFO_ID+WORKSPACE	Primary Key
UCM_CMACTVERSN_0	OBJECT_ID+UI_OBJECT_NAME+WORKSPACE+STOREENT_ID+CONTAINER_ID	Unique Index
ICM_CMACTVERSN_0	WORKSPACE+CONTENT_TASKGRP+CONTENT_TASK	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
FCM_CMACTVERSN_0	CMVERSNINFO_ID	CMVERSNINFO	CMVERSNINFO_ID	Cascade