ICMSTCheckedOut (Checked Out Table)
The ICMSTCHECKEDOUT table maintains a list of all items that have been checked out. When a user checks in a locked item, the row is deleted from this table. The content manager tracks rows that reflect currently active checkout locks.
| Column Name | Data Type | Attribute |
|---|---|---|
| ItemID | CHAR(26) | NOT Null |
| UserID | CHAR(32) | NOT Null |
| GroupID | CHAR(16) | NOT Null |
| Created | TIMESTAMP | NOT Null |
- Primary Key
- None
- Indexes
-
Unique Index = (UserID ascending, ItemID ascending) Unique Index = (ItemID ascending) Index = (Created ascending) - Referential Constraints
- None
Column Definitions
- 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.
- UserID
- The ID of the user who has checked out the item.
- GroupID
- The ID to distinguish between multiple resource managers of
the same UserID (for check out), in the form of:
RM : SourceRMcode : Replicator (1) or Migrator (0) : last 6 digits of ItemID : TargetRMcode
For example,RM:1:1:123456:1. - Created
- The timestamp when the entry was created. Your application cannot update this field.