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

# Emails Companies

Association table linking emails to companies

**Name:** `v1_0.emails_companies`

Deleted and merged records are covered in [Deletes & Merges](https://developer.affinity.co/pages/data-share/deletes.md).

> [!WARNING]
>
> Grant access to the share only to users who are authorized to view all
> organization data. There are no per-user or per-role visibility filters applied at the
> share level.

## Columns

| Column | Description |
| - | - |
| `id` | Synthetic hash of email\_id and company\_id, not a source record ID. Signed 32-bit, so values may be negative, and collisions can repeat an id across rows. The unique key for this table is email\_id + company\_id. |
| `email_id` | The ID of the email |
| `company_id` | The ID of the company |
| `last_updated_at` | Timestamp when this record was last updated |
| `is_deleted` | Whether the association has been deleted |


## Related topics

- [Deletes & Merges](https://developer.affinity.co/pages/data-share/deletes.md)
- [Companies](https://developer.affinity.co/pages/data-share/companies_v1_0.md)
- [Search Companies](https://developer.affinity.co/api-reference/2024-01-01/companies/search-companies.md)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.