Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: 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 Name Column 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 Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type UCM_CMVERSNINFO_0 OBJECT_ID+UI_OBJECT_NAME+VERSION_IDENTIFIER+STOREENT_ID+CONTAINER_ID Unique Index SQL101215095934760 CMVERSNINFO_ID Primary Key ICM_CMVERSNINFO_0 OBJECT_ID+UI_OBJECT_NAME+CREATETIME Non-Unique Index
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type FCM_CMACTVERSN_0 CMVERSNINFO_ID CMACTVERSN CMVERSNINFO_ID Cascade FCMCMVERSNCOLLREL0 CMVERSNINFO_ID CMVERSNCOLLREL CMVERSNINFO_ID Cascade _vcc_freeselect_bottom_