This table represents the various associations between entities in Affinity. You can use this table to join other tables together. The supported associations include: List Entries to Entities (Company, Person, Opportunity depending on the List Type), Companies to People, People to Opportunities, and Opportunities to Companies
Name: associations
Grant access to the Snowflake 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 | The association’s unique identifier |
from_entity_type | The entity type of the source entity |
from_entity_id | The ID of the source entity |
to_entity_type | The entity type of the target entity |
to_entity_id | The ID of the target entity |
last_updated_at | Timestamp when this record was last updated |
