Footprints Data Model

Table
Name item_lock
Comment
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.

Column
Name Datatype Comment Is PK Is FK
item_lock_id bigint The automatically generated primary key of the item_lock table. Yes No
item_defn_id bigint Identifies the Item Definition for the item being locked. No Yes
item_id bigint Identifies the Item being locked. No Yes
session_token varchar(255)
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.
No Yes
locked_by varchar(255)
a string description suitable for display of a session user or component that
owns a lock.
No No
create_date datetime The date that the Item Lock was created. No No