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. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| lockdb_exp2_ix | Performance | Asc | expires |
| lockdb_own2_ix | Performance | Asc | owner |
| lockdb_res2_uix | Must be unique | Asc | resourcekey |
Relationships
Close relationships within degrees of separation
