Footprints Data Model

Table
Table Name Item Lock
Table Definition A pessimitic lock of a dynamic item instance. The lock helps implement single session editing of an ticket item , cmdb item, solution item, or any other item in the system.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Item Lock Id The automatically generated primary key of the item_lock table. LONG Yes
Item Definition Id Identifies the Item Definition for the item being locked. LONG Yes
Item Id Identifies the Item being locked. LONG Yes
Session Token A Global Unique IDentifier search key for the System Session, composed of letters and numbers. The session table is not persisted to the database for performance and integrity reasons. Locks will be cleared by the application in normal use, and may be cleared if they are orphaned. VARCHAR(255) Yes
Create Date The date that the Item Lock was created. DATE Yes
Locked By a string description suitable for display of a session user or component that owns a lock. VARCHAR(255) Yes