Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: 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 Name Column Type Description CMVERSNCOLL_ID BIGINT NOT NULL Generated primary key COLLECT_TYPE_ID INTEGER NOT NULL -1 for StagingProp, -2 for TaskGroupApproval STOREENT_ID INTEGER NOT NULL The store entity ID COLLECT_IDENTIFIER VARCHAR(128) The collection identifier MEMBER_ID BIGINT The user who creates the version CREATETIME TIMESTAMP The time when the collection is created NAME VARCHAR(254) The name of the collection COMMENTS VARCHAR(4000) Comments 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 Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type UCM_CMVERSNCOLL_0 COLLECT_TYPE_ID+STOREENT_ID+COLLECT_IDENTIFIER Unique Index SQL101215095935880 CMVERSNCOLL_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type FCMCMVERSNCOLLREL1 CMVERSNCOLL_ID CMVERSNCOLLREL CMVERSNCOLL_ID Cascade _vcc_freeselect_bottom_