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 |