IBM Content Manager, Version 8.5.0.3

ICMSTItemEvents (Item Events Table)

The ICMSTITEMEVENTS table contains records of item Create, Retrieve, Update, Delete (CRUD) events logged by server depends on the ItemEventFlag in the Item Type Definition Table (ICMSTITEMTYPEDEFS). Events may relate to actions of library users when working on items. After data for an event is created, it cannot be updated. The system administration client can turn the event logging on or off.

Column Name	Data Type	Attribute
EventCode	INTEGER	NOT Null
Created	TIMESTAMP	NOT Null
ItemID	CHAR(26)	NOT Null
UserID	CHAR(32)	NOT Null
EventData1	VARCHAR(254)	nullable
EventData2	VARCHAR(254)	nullable
EventData3	VARCHAR(254)	nullable
EventData4	VARCHAR(254)	nullable
EventData5	VARCHAR(254)	nullable

Primary Key

None

Indexes

Index = (ItemID ascending, Created descending, EventCode ascending)
Index = (UserID ascending, EventCode ascending, Created descending)
Index = (EventCode ascending, Created descending)

Referential Constraints

None

Column Definitions

EventCode

Classification of events with similar purposes into groups. Only positive values are allowed. Your application cannot update this field.

Created

The timestamp when the entry was created. Your application cannot update this field.

ItemID

Item identifier.

The value for ItemID is generated in content manager the application requests to create an item.

This column cannot be updated by your application. For details, see Table 2.

UserID

The ID of the user who inserted this row.

EventData1