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 |