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:
| Name | 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 | 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> | CMVERSNCOLL_ID | Primary Key |
| UCM_CMVERSNCOLL_0 |
COLLECT_TYPE_ID+STOREENT_ID+COLLECT_IDENTIFIER | Unique Index |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| FCM_CMVERSNCOLLREL_1 | CMVERSNCOLL_ID | CMVERSNCOLLREL | CMVERSNCOLL_ID | Cascade |