CMVERSNCOLL

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

Column Descriptions:

NameTypeDescription
CMVERSNCOLL_IDBIGINT NOT NULLGenerated primary key
COLLECT_TYPE_IDINTEGER NOT NULL-1 for StagingProp, -2 for TaskGroupApproval
STOREENT_IDINTEGER NOT NULLThe store entity ID
COLLECT_IDENTIFIERVARCHAR (128)The collection identifier
MEMBER_IDBIGINTThe user who creates the version
CREATETIMETIMESTAMPThe time when the collection is created
NAMEVARCHAR (254)The name of the collection
COMMENTSVARCHAR (4000)Comments
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>CMVERSNCOLL_IDPrimary Key
UCM_CMVERSNCOLL_0 COLLECT_TYPE_ID+STOREENT_ID+COLLECT_IDENTIFIERUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
FCM_CMVERSNCOLLREL_1CMVERSNCOLL_IDCMVERSNCOLLRELCMVERSNCOLL_IDCascade