Lock Db Table Schema (lock_db)


Description

Stores active and inactive lock types for db locking method.

lock_db table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
resourcekey varchar 255

String identifying the resource to be locked. Should use frankenstyle format.

expires bigint 10 null

Expiry time for an active lock.

owner varchar 36 null

uuid indicating the owner of the lock.

Table contained -1 rows

lock_db table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
lockdb_exp_ix Performance Asc expires
lockdb_own_ix Performance Asc owner
lockdb_res_uix Must be unique Asc resourcekey