CMVERSNINFO

This table is part of the Content Version schema, and alias in the Commerce base schema. This table contains the content version meta information.

Column Descriptions:

Name	Type	Description
CMVERSNINFO_ID	BIGINT NOT NULL	Generated primary key
CONTAINER_ID	INTEGER NOT NULL	-1 for catalog component
CONFIG_GROUP_ID	INTEGER NOT NULL	The config group ID
OBJECT_ID	BIGINT NOT NULL	The primary key of the object.
STOREENT_ID	INTEGER NOT NULL	The store entity ID
MEMBER_ID	BIGINT	The user who creates the version
USEDINPRODUCTION	INTEGER NOT NULL DEFAULT 0	0 not used in production database, 1 used in production database
VERSION_IDENTIFIER	VARCHAR (128) NOT NULL	The version identifier
UI_OBJECT_NAME	VARCHAR (128) NOT NULL	The UI object name defined in the content version configuration file
NAME	VARCHAR (254)	The name of the version
COMMENTS	VARCHAR (4000)	Description of the content version information.
CREATETIME	TIMESTAMP	The time when the version is created
FIELD1	BIGINT	Custom field 1
FIELD2	BIGINT	Custom field 2
FIELD3	VARCHAR (254)	Custom field 3
FIELD4	VARCHAR (254)	Custom field 4
FIELD5	VARCHAR (254)	Custom field 5
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	Primary Key
UCM_CMVERSNINFO_0	OBJECT_ID+UI_OBJECT_NAME+VERSION_IDENTIFIER+STOREENT_ID+CONTAINER_ID	Unique Index
ICM_CMVERSNINFO_0	OBJECT_ID+UI_OBJECT_NAME+CREATETIME	Non-Unique Index

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
FCM_CMACTVERSN_0	CMVERSNINFO_ID	CMACTVERSN	CMVERSNINFO_ID	Cascade
FCM_CMVERSNCOLLREL_0	CMVERSNINFO_ID	CMVERSNCOLLREL	CMVERSNINFO_ID	Cascade