> ## Documentation Index
> Fetch the complete documentation index at: https://superofficeas-bugfix-ty-screen-designer-paradox.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# locking table

> Generic locking and error messages

## locking Table (380)

Generic locking and error messages

## Fields

| Name            | Description                                             | Type     | Nullable |
| --------------- | ------------------------------------------------------- | -------- | :------: |
| id              | Primary key                                             | PK       |    No    |
| status          | Current status                                          | status   |    Yes   |
| stop            | Signal to stop schedule                                 | Bool     |    No    |
| last\_execution | Last execution                                          | DateTime |    Yes   |
| execution\_time | Amount of time in seconds used by last execution        | Int      |    Yes   |
| lock\_expire    | Lock preventing the same schedule to run simultaniously | DateTime |    Yes   |
| lock\_pid       | PID preventing the same schedule to run simultaniously  | Int      |    Yes   |
| lock\_ttl       | Lock time to live                                       | Int      |    Yes   |
| error\_message  | Last error message                                      | Clob     |    Yes   |
| last\_error     | Time of last error                                      | DateTime |    Yes   |
| retries         | Number of retries since last successfull execution      | Int      |    No    |

<img src="https://mintcdn.com/superofficeas-bugfix-ty-screen-designer-paradox/bBv7ep-d5A4oaYwj/media/loc/en/database/tables/locking.png?fit=max&auto=format&n=bBv7ep-d5A4oaYwj&q=85&s=ad058f2fa54db0bacda7ef799742b362" alt="locking table relationship diagram" width="335" height="59" data-path="media/loc/en/database/tables/locking.png" />

## Indexes

| Fields | Types | Description |
| ------ | ----- | ----------- |

## Relationships

| Table            | Description                           |
| ---------------- | ------------------------------------- |
| [inbox](./inbox) | Info and status for safe email import |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.