Reference > Database > WebSphere Commerce database tables > C


WebSphere Commerce database table: 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 Name Column 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 eternal 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 eternal 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 eternal 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 eternal 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, udpate, 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 assoicated with the change.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
MEMBER_ID BIGINT The user who has modified the resource.

Indexes
Index Name Indexed Column Names Index Type
I0000835 CMCONTAINER_ID+CMRESMGR_ID+BOKEY1+BOKEY2+BOKEY3+BOKEY4 Non-Unique Index

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search