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

# Opportunities Companies

Association table linking opportunities to companies

**Name:** `v1_0.opportunities_companies`

Deleted and merged records are covered in [Deletes & Merges](/pages/data-share/deletes).

<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.
</Warning>

## Columns

| Column | Description |
| - | - |
| `id` | The association's unique identifier |
| `opportunity_id` | The ID of the opportunity |
| `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

- [Opportunities](/pages/data-share/opportunities_v1_0.md)
- [Get Notes for an Opportunity](/api-reference/2024-01-01/opportunities/get-notes-for-an-opportunity.md)
- [Opportunities Value Changes](/pages/data-share/opportunities_value_changes_v1_0.md)


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