CMMETADATA

Records the business objects that have changed and the associated workspaces, task groups, and tasks that have made that change. This table will be used for resource locking and for determining the business objects that will be committed and published to production.

Column Descriptions:

Name	Type	Description
CMCONTAINER_ID	INTEGER NOT NULL	The container associated with the business object.
CMRESMGR_ID	INTEGER NOT NULL	The resource manager associated with the business object.
BOKEY1	BIGINT NOT NULL	The 4 columns together make up the primary key value for the business object. These 4 values with the container and manager id will uniquely identify the business object.
BOKEY2	BIGINT NOT NULL	The 4 columns together make up the primary key value for the business object. These 4 values with the container and manager id will uniquely identify the business object.
BOKEY3	BIGINT NOT NULL	The 4 columns together make up the primary key value for the business object. These 4 values with the container and manager id will uniquely identify the business object.
BOKEY4	BIGINT NOT NULL	The 4 columns together make up the primary key value for the business object. These 4 values with the container and manager id will uniquely identify the business object.
ACTION	CHAR (1) NOT NULL	The action performed on the business object (new, update, delete).
CMTIMESTAMP	TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP	When the update was performed.
WORKSPACE	CHAR (25)	The workspace identifier associated with the change.
TASKGRP	CHAR (25)	The task group associated with the change.
TASK	CHAR (25)	The task associated with the change.
MEMBER_ID	BIGINT	The user who has modified the resource.
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
I0000835	CMCONTAINER_ID+CMRESMGR_ID+BOKEY1+BOKEY2+BOKEY3+BOKEY4	Non-Unique Index