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 |