> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# inbox table

> Info and status for safe email import

## inbox Table (352)

Info and status for safe email import

## Fields

| Name             | Description                                                                                                | Type                                        | Nullable |
| ---------------- | ---------------------------------------------------------------------------------------------------------- | ------------------------------------------- | :------: |
| id               | Primary key                                                                                                | PK                                          |    No    |
| mail\_in\_filter | A reference to the id of the mail box                                                                      | FK [mail\_in\_filter](./mail-in-filter.mdx) |    No    |
| locking\_id      | A reference to the id of lock                                                                              | FK [locking](./locking.mdx)                 |    No    |
| uidl             | The uidl of the message. Stored before the retrieval starts to prevent double import. For locking purposes | String(2047)                                |    Yes   |
| created          | When the mail was created                                                                                  | DateTime                                    |    Yes   |
| imported         | When the mail was imported                                                                                 | DateTime                                    |    No    |
| status           | Status enum                                                                                                | Int                                         |    No    |
| mail\_size       | The size of the mail in bytes                                                                              | Int                                         |    No    |
| next\_retry      | When is the next time we should try again?                                                                 | DateTime                                    |    Yes   |
| plugin           | Name of plugin that created this inbox entry                                                               | String(255)                                 |    No    |
| format           | Format of the inbox entry                                                                                  | String(255)                                 |    No    |

<img src="https://mintcdn.com/superofficeas/6OcOTPa_ISkjXJg4/media/loc/en/database/tables/inbox.png?fit=max&auto=format&n=6OcOTPa_ISkjXJg4&q=85&s=260a9dce1f424743df9bc070ef8435b6" alt="inbox table relationship diagram" width="658" height="625" data-path="media/loc/en/database/tables/inbox.png" />

## Indexes

| Fields           | Types    | Description |
| ---------------- | -------- | ----------- |
| mail\_in\_filter | FK       | Index       |
| locking\_id      | FK       | Index       |
| imported         | DateTime | Index       |
| status           | Int      | Index       |

## Relationships

| Table                                | Description                                                                                             |
| ------------------------------------ | ------------------------------------------------------------------------------------------------------- |
| [ej\_message](./ej-message)          | This table contains the messages listed under tickets.                                                  |
| [locking](./locking)                 | Generic locking and error messages                                                                      |
| [mail\_in\_filter](./mail-in-filter) | This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP). |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [Inbox](/en/automation/crmscript/reference/CRMScript.Native.Inbox.md)
- [locking table](/en/database/tables/locking.md)
- [extra_tables table](/en/database/tables/extra-tables.md)
- [BinaryObject table](/en/database/tables/binaryobject.md)
- [SuperOffice Inbox](/en/email/inbox/learn/index.md)
- [ej_message table](/en/database/tables/ej-message.md)