temp_db_lock table - SuperOffice

temp_db_lock Table (535)

Represents a temporary lock on a resource identified by table_id and key

Fields

Name	Description	Type	Nullable
temp_db_lock_id	Primary key	PK	No
table_number	The table number (or domain) of the locked resource	TableNumber	Yes
key	The key/id of the locked resource	RecordId	Yes
timeout_at	When this lock times out. Refreshing this while working is a good idea.	UtcDateTime	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

Indexes

Fields	Types	Description
table_number	TableNumber	Index
key	RecordId	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons

Replication Flags

None

Security Flags

No access control via user’s Role.