> ## 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.

# email_account table

> Email account information

## email\_account Table (491)

Email account information

## Fields

| Name                      | Description                                                               | Type                                                      | Nullable |
| ------------------------- | ------------------------------------------------------------------------- | --------------------------------------------------------- | :------: |
| email\_account\_id        | Primary key                                                               | PK                                                        |    No    |
| email\_address            | The From-address                                                          | String(255)                                               |    Yes   |
| associate\_id             | Associate who owns this email account                                     | FK [associate](./associate.mdx)                           |    Yes   |
| incoming\_auth            | Incoming server (imap) authentication                                     | FK [service\_auth](./service-auth.mdx)                    |    Yes   |
| outgoing\_auth            | Outgoing server (smtp) authentication                                     | FK [service\_auth](./service-auth.mdx)                    |    Yes   |
| registered                | Registered when                                                           | UtcDateTime                                               |    No    |
| registered\_associate\_id | Registered by whom                                                        | FK [associate](./associate.mdx)                           |    No    |
| updated                   | Last updated when                                                         | UtcDateTime                                               |    No    |
| updated\_associate\_id    | Last updated by whom                                                      | FK [associate](./associate.mdx)                           |    No    |
| updatedCount              | Number of updates made to this record                                     | UShort                                                    |    No    |
| default                   | True if this account is the default account for the associate who owns it | Bool                                                      |    Yes   |
| account\_status           | The status of this email account                                          | Enum [EmailAccountStatus](./enums/emailaccountstatus.mdx) |    Yes   |
| encryptedCheck            | Encrypted hash checksum                                                   | String(254)                                               |    No    |
| error\_count              | How many failures since reset                                             | Int                                                       |    Yes   |
| error\_reason             | Reason for last failure if available                                      | String(254)                                               |    No    |
| last\_fetch               | When we last fetched email.                                               | UtcDateTime                                               |    Yes   |
| use\_graph\_api           | Use the GraphApi for this account                                         | Bool                                                      |    No    |

<img src="https://mintcdn.com/superofficeas/i6M2qZmvMNH7UTeu/media/loc/en/database/tables/email_account.png?fit=max&auto=format&n=i6M2qZmvMNH7UTeu&q=85&s=050e548eb93409d7103e8adf2c67560c" alt="email_account table relationship diagram" width="867" height="809" data-path="media/loc/en/database/tables/email_account.png" />

## Indexes

| Fields         | Types       | Description |
| -------------- | ----------- | ----------- |
| associate\_id  | FK          | Index       |
| email\_address | String(255) | Index       |

## Relationships

| Table                           | Description                                                        |
| ------------------------------- | ------------------------------------------------------------------ |
| [associate](./associate)        | Employees, resources and other users - except for External persons |
| [email\_folder](./email-folder) | Corresponds to an email folder on a mail server                    |
| [email\_item](./email-item)     | Email data                                                         |
| [service\_auth](./service-auth) | Authentication for a service (imap, smtp...)                       |

## Replication Flags

* None

## Security Flags

* No access control via user's Role.


## Related topics

- [email_folder table](/en/database/tables/email-folder.md)
- [What's new in version 12.3.2195.0](/release-notes/database/changelog.md)
- [What's new in version 12.0.342.0](/release-notes/database/changes-12.0.342.md)
- [What's new in version 12.1.1412.0](/release-notes/database/changes-12.1.1412.md)
- [What's new in version 12.2.2072.0](/release-notes/database/changes-12.2.2072.md)
- [What's new in version 10.5.1.1092](/release-notes/database/changes-10.5.1.md)