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:

NameTypeDescription
CMCONTAINER_IDINTEGER NOT NULLThe container associated with the business object.
CMRESMGR_IDINTEGER NOT NULLThe resource manager associated with the business object.
BOKEY1BIGINT NOT NULLThe 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.
BOKEY2BIGINT NOT NULLThe 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.
BOKEY3BIGINT NOT NULLThe 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.
BOKEY4BIGINT NOT NULLThe 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.
ACTIONCHAR (1) NOT NULLThe action performed on the business object (new, update, delete).
CMTIMESTAMPTIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMPWhen the update was performed.
WORKSPACECHAR (25)The workspace identifier associated with the change.
TASKGRPCHAR (25)The task group associated with the change.
TASKCHAR (25)The task associated with the change.
MEMBER_IDBIGINTThe user who has modified the resource.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
I0000835 CMCONTAINER_ID+CMRESMGR_ID+BOKEY1+BOKEY2+BOKEY3+BOKEY4Non-Unique Index