This table is part of the Content Version schema,
and alias in the Commerce base schema. This table contains all
content active version.
Column Descriptions:
Name | Type | Description |
CMVERSNINFO_ID | BIGINT NOT NULL | Foreign key to CMVERSINFO table |
CONTAINER_ID | INTEGER NOT NULL | -1 for catalog component |
UI_OBJECT_NAME | VARCHAR (128) NOT NULL | The UI object name defined in the content version
configuration file |
OBJECT_ID | BIGINT NOT NULL | The object ID |
STOREENT_ID | INTEGER NOT NULL | The store entity ID |
MEMBER_ID | BIGINT | The user who last updates the active version |
VERSION_IDENTIFIER | VARCHAR (128) NOT NULL | The version identifier |
NAME | VARCHAR (254) | The name of the version |
LASTUPDATE | TIMESTAMP | The last updated timestamp |
OBJECT_DELETED | INTEGER NOT NULL DEFAULT 0 | 0 not deleted, 1 deleted |
MODIFIED | INTEGER NOT NULL DEFAULT 0 | Reserved for HCL internal use |
WORKSPACE | VARCHAR (25) NOT NULL | Workspace identifier. For base schema, it is
IBM_WC_BASE, for real workspace, it is W_10001, etc. |
CONTENT_TASKGRP | VARCHAR (25) | Content task group of the workspace |
CONTENT_TASK | VARCHAR (25) | Content task of the workspace |
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+WORKSPACE | Primary Key |
UCM_CMACTVERSN_0 |
OBJECT_ID+UI_OBJECT_NAME+WORKSPACE+STOREENT_ID+CONTAINER_ID | Unique Index |
ICM_CMACTVERSN_0 | WORKSPACE+CONTENT_TASKGRP+CONTENT_TASK | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
FCM_CMACTVERSN_0 | CMVERSNINFO_ID | CMVERSNINFO | CMVERSNINFO_ID | Cascade |