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:

NameTypeDescription
CMVERSNINFO_IDBIGINT NOT NULLGenerated primary key
CONTAINER_IDINTEGER NOT NULL-1 for catalog component
CONFIG_GROUP_IDINTEGER NOT NULLThe config group ID
OBJECT_IDBIGINT NOT NULLThe primary key of the object.
STOREENT_IDINTEGER NOT NULLThe store entity ID
MEMBER_IDBIGINTThe user who creates the version
USEDINPRODUCTIONINTEGER NOT NULL DEFAULT 00 not used in production database, 1 used in production database
VERSION_IDENTIFIERVARCHAR (128) NOT NULLThe version identifier
UI_OBJECT_NAMEVARCHAR (128) NOT NULLThe UI object name defined in the content version configuration file
NAMEVARCHAR (254)The name of the version
COMMENTSVARCHAR (4000)Description of the content version information.
CREATETIMETIMESTAMPThe time when the version is created
FIELD1BIGINTCustom field 1
FIELD2BIGINTCustom field 2
FIELD3VARCHAR (254)Custom field 3
FIELD4VARCHAR (254)Custom field 4
FIELD5VARCHAR (254)Custom field 5
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_IDPrimary Key
UCM_CMVERSNINFO_0 OBJECT_ID+UI_OBJECT_NAME+VERSION_IDENTIFIER+STOREENT_ID+CONTAINER_IDUnique Index
ICM_CMVERSNINFO_0OBJECT_ID+UI_OBJECT_NAME+CREATETIMENon-Unique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
FCM_CMACTVERSN_0CMVERSNINFO_IDCMACTVERSNCMVERSNINFO_IDCascade
FCM_CMVERSNCOLLREL_0CMVERSNINFO_IDCMVERSNCOLLRELCMVERSNINFO_IDCascade