Emails
The emails table contains data about email addresses in the organization attached to entities.
This table can be used to determine what email addresses exist and which entities they are attached to, as well as metadata about the email address such as when it was created.
Columns
| Column Name | Description | Type | Nullable |
|---|---|---|---|
| id | The numerical identifier of the object. | INT8 | No |
| The email address. | VARCHAR | No | |
| email_type | The type of address. One of home or work. |
VARCHAR | No |
| owner_id | The numerical identifier of the related entity for this email address. Relates to the id column in the entities table. |
INT8 | No |
| owner_type | The name of the class of object this email address is attached to. Always Entity. |
VARCHAR | No |
| created_by_id | The numerical identifier of the user that created this email address. Relates to the id column in the users table. An ID of 1 typically means a machine-created address, such as over the API. |
INT8 | No |
| status | The status of the email address, as displayed on the user interface. One of user_added, verified, bad, or do_not_contact. |
VARCHAR | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was last updated. | TIMESTAMP | No |
| updated_by_id | The numerical identifier of the user that last updated this email address. Relates to the id column in the users table. An ID of 1 typically means a machine-updated address, such as over the API. |
INT4 | Yes |
| interact_id | The UUID of the email address, for use on the API. | UUID | No |
| source | The source of the address as displayed on the user interface. One of action_builder, upload, action_network, or api. |
VARCHAR | Yes |