> ## 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_flow table

> A set of properties related to the email workflow.

## email\_flow Table (527)

A set of properties related to the email workflow.

## Fields

| Name                            | Description                                                                                            | Type                                                  | Nullable |
| ------------------------------- | ------------------------------------------------------------------------------------------------------ | ----------------------------------------------------- | :------: |
| email\_flow\_id                 | Primary key                                                                                            | PK                                                    |    No    |
| workflow\_id                    | The workflow this emailflow belongs to                                                                 | FK [workflow](./workflow.mdx)                         |    Yes   |
| shipment\_type\_id              | Mailing type (subscription type)                                                                       | FK [ShipmentType](./shipmenttype.mdx)                 |    Yes   |
| override\_consent\_subscription | Override consent and subscription                                                                      | Bool                                                  |    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    |
| hierarchy\_id                   | This email flow is inside that hierarchy folder                                                        | FK [hierarchy](./hierarchy.mdx)                       |    No    |
| from\_name                      | Email From name                                                                                        | String(255)                                           |    Yes   |
| from\_addr                      | Email From address: [name@domain.com](mailto:name@domain.com)                                          | String(255)                                           |    Yes   |
| reply\_to\_addr                 | Reply to address, if different from From-address                                                       | String(255)                                           |    Yes   |
| sms\_sender                     | SMS sender (number or name)                                                                            | String(255)                                           |    Yes   |
| use\_timeframe                  | Use sender timeframe settings, only send email/sms within the timeframe                                | Bool                                                  |    Yes   |
| selected\_days                  | Selected days (flags, so several days can be selected) for time frame                                  | Enum [Weekday](./enums/weekday.mdx)                   |    Yes   |
| timeframe\_start                | Start of email/sms sending timeframe, interpreted in stored timezone or as UTC, only time part is used | UtcDateTime                                           |    Yes   |
| timeframe\_end                  | End of email/sms sending timeframe, interpreted in stored timezone or as UTC, only time part is used   | UtcDateTime                                           |    Yes   |
| use\_google\_analytics          | Use Google Analytics                                                                                   | Bool                                                  |    Yes   |
| ga\_source                      | GA Source                                                                                              | String(255)                                           |    Yes   |
| ga\_campaign                    | GA Campaign                                                                                            | String(255)                                           |    Yes   |
| from\_type                      | Email/Mailing From field address algorithm                                                             | Enum [EmailFromType](./enums/emailfromtype.mdx)       |    Yes   |
| reply\_to\_type                 | Email/Mailing Reply-To field address algorithm                                                         | Enum [EmailReplyToType](./enums/emailreplytotype.mdx) |    Yes   |
| reply\_to\_name                 | Email Reply-To name                                                                                    | String(255)                                           |    Yes   |
| main\_message\_id               | The main email message, used for thumbnail creation                                                    | FK [s\_message](./s-message.mdx)                      |    Yes   |

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

## Indexes

| Fields        | Types | Description |
| ------------- | ----- | ----------- |
| hierarchy\_id | FK    | Index       |

## Relationships

| Table                                                   | Description                                                                                      |
| ------------------------------------------------------- | ------------------------------------------------------------------------------------------------ |
| [associate](./associate)                                | Employees, resources and other users - except for External persons                               |
| [email\_flow\_content\_link](./email-flow-content-link) | Links content to an email workflow                                                               |
| [hierarchy](./hierarchy)                                | This table contains folders used to group the extra tables in the system.                        |
| [s\_message](./s-message)                               | A message used in a shipment. Can be html and/or plain text                                      |
| [ShipmentType](./shipmenttype)                          | Shipment type list table. Classification of a mailing, allowing recipients to subscribe to lists |
| [workflow](./workflow)                                  | SuperOffice specific info about a workflow                                                       |

## Replication Flags

* None

## Security Flags

* Sentry controls access to items in this table using user's Role and data rights matrix on the table's parent.


## Related topics

- [EmailFlows](/en/api/archive-providers/reference/emailflows.md)
- [email_flow_content_link table](/en/database/tables/email-flow-content-link.md)
- [EmailFlowFolders](/en/api/archive-providers/reference/emailflowfolders.md)
- [EmailFlowsAndFolders](/en/api/archive-providers/reference/emailflowsandfolders.md)
- [EmailFlowInstances](/en/api/archive-providers/reference/emailflowinstances.md)
- [EmailFlowEmailContent](/en/api/archive-providers/reference/emailflowemailcontent.md)