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 19 √ null
resourcekey VARCHAR 255

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

expires BIGINT 19 √ 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