# Affinity schema ERD

Table and field reference for the Fivetran Affinity connector.

## Table & Field Reference

### interaction_email_to

| Column | Type | Keys |
| --- | --- | --- |
| interaction_email_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |
| person_to_id | Unknown | PK, FK |

### interaction_email

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| from_id | Unknown | FK |
| organization_id | Unknown | FK |
| cc | Json |  |
| date | Unknown |  |
| direction | Unknown |  |
| subject | Unknown |  |
| type | Unknown |  |

### organization_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entity_id | Unknown | PK, FK |
| field_id | Unknown | FK |
| list_entry_id | Unknown | FK |
| created_at | Unknown |  |
| entity_type | Unknown |  |
| updated_at | Unknown |  |
| value | Json |  |
| value_type | Unknown |  |

### list_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| list_id | Unknown | PK, FK |
| created_at | Unknown |  |
| creator_id | Unknown |  |
| entity_** |  |  |

### person_with_interaction_email

| Column | Type | Keys |
| --- | --- | --- |
| email_id | Unknown | PK |
| person_id | Unknown | PK, FK |

### person_with_interaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| first_name | Unknown |  |
| last_name | Unknown |  |
| primary_email | Unknown |  |
| type | Unknown |  |

### field_dropdown_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| field_id | Unknown | PK, FK |
| rank | Unknown |  |
| text | Unknown |  |

### field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| list_id | Unknown | FK |
| allows_multiple | Unknown |  |
| enrichment_source | Unknown |  |
| name | Unknown |  |
| track_changes | Unknown |  |
| value_type | Unknown |  |

### person_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entity_id | Unknown | PK, FK |
| field_id | Unknown | FK |
| list_entry_id | Unknown | FK |
| created_at | Unknown |  |
| entity_type | Unknown |  |
| updated_at | Unknown |  |
| value | Json |  |
| value_type | Unknown |  |

### organization_with_interaction_domain

| Column | Type | Keys |
| --- | --- | --- |
| domain | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### organization_with_interaction_person_id

| Column | Type | Keys |
| --- | --- | --- |
| organization_id | Unknown | PK, FK |
| person_id | Unknown | PK, FK |

### organization_with_interaction_list_entry

| Column | Type | Keys |
| --- | --- | --- |
| list_entry_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### organization_with_interaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| crunchbase_uuid | Unknown |  |
| domain | Unknown |  |
| global | Unknown |  |
| interaction_first_email_date | Unknown |  |
| interaction_first_event_date | Unknown |  |
| interaction_last_chat_message_date | Unknown |  |
| interaction_last_email_date | Unknown |  |
| interaction_last_event_date | Unknown |  |
| interaction_last_interaction_date | Unknown |  |
| interaction_next_event_date | Unknown |  |
| name | Unknown |  |

### organization_interaction_person_id

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| organization_id | Unknown | PK, FK |
| person_id | Unknown | PK, FK |
| interaction_date | Unknown | FK |

### relationship_strength

| Column | Type | Keys |
| --- | --- | --- |
| external_id | Unknown | PK, FK |
| internal_id | Unknown | PK, FK |
| strength | Unknown |  |

### interaction_meeting_attendee

| Column | Type | Keys |
| --- | --- | --- |
| attendee_email_id | Unknown | PK |
| interaction_meeting_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### interaction_meeting_note

| Column | Type | Keys |
| --- | --- | --- |
| interaction_meeting_id | Unknown | PK, FK |
| note_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### interaction_meeting_person

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| interaction_meeting_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### interaction_meeting

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| date | Unknown |  |
| end_time | Unknown |  |
| manual_creator_id | Unknown |  |
| start_time | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| creator_id | Unknown | FK |
| owner_id | Unknown | FK |
| list_size | Unknown |  |
| name | Unknown |  |
| public | Unknown |  |
| type | Unknown |  |

### person_without_interaction_email

| Column | Type | Keys |
| --- | --- | --- |
| email_id | Unknown | PK |
| person_id | Unknown | PK, FK |

### person_without_interaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| first_name | Unknown |  |
| interaction_first_email_date | Unknown |  |
| interaction_first_event_date | Unknown |  |
| last_name | Unknown |  |
| primary_email | Unknown |  |
| type | Unknown |  |

### organization_without_interaction_domain

| Column | Type | Keys |
| --- | --- | --- |
| domain | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### organization_without_interaction_person_id

| Column | Type | Keys |
| --- | --- | --- |
| organization_id | Unknown | PK, FK |
| person_id | Unknown | PK, FK |

### organization_without_interaction_list_entry

| Column | Type | Keys |
| --- | --- | --- |
| list_entry_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### organization_without_interaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| crunchbase_uuid | Unknown |  |
| domain | Unknown |  |
| global | Unknown |  |
| interaction_first_email_date | Unknown |  |
| interaction_first_event_date | Unknown |  |
| name | Unknown |  |

### global_organization_field

| Column | Type | Keys |
| --- | --- | --- |
| field_id | Unknown | PK, FK |
| list_id | Unknown | FK |

### reminder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| completer_id | Unknown | FK |
| creator_id | Unknown | FK |
| organization_id | Unknown | FK |
| owner_id | Unknown | FK |
| person_id | Unknown | FK |
| completed_at | Unknown |  |
| content | Unknown |  |
| created_at | Unknown |  |
| due_date | Unknown |  |
| opportunity | Json |  |
| reminder_days | Unknown |  |
| reset_type | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### note_person

| Column | Type | Keys |
| --- | --- | --- |
| note_id | Unknown | PK, FK |
| person_id | Unknown | PK, FK |

### note_organization

| Column | Type | Keys |
| --- | --- | --- |
| note_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### note_mentioned_person

| Column | Type | Keys |
| --- | --- | --- |
| mentioned_person_id | Unknown | PK, FK |
| note_id | Unknown | PK, FK |

### note_opportunity

| Column | Type | Keys |
| --- | --- | --- |
| note_id | Unknown | PK, FK |
| opportunity_id | Unknown | PK, FK |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| content | Unknown |  |
| created_at | Unknown |  |
| creator_id | Unknown |  |
| interaction_id | Unknown |  |
| interaction_type | Unknown |  |
| is_meeting | Unknown |  |
| parent_id | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### file

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| opportunity_id | Unknown | FK |
| organization_id | Unknown | FK |
| person_id | Unknown | FK |
| uploader_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| size | Unknown |  |

### interaction_chat_person

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| interaction_chat_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### interaction_chat_note

| Column | Type | Keys |
| --- | --- | --- |
| interaction_chat_id | Unknown | PK, FK |
| note_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### interaction_chat

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| manual_creator_id | Unknown | FK |
| organization_id | Unknown | FK |
| date | Unknown |  |
| direction | Unknown |  |
| type | Unknown |  |

### interaction_call_attendee

| Column | Type | Keys |
| --- | --- | --- |
| attendee_email_id | Unknown | PK |
| interaction_call_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### interaction_call_note

| Column | Type | Keys |
| --- | --- | --- |
| interaction_call_id | Unknown | PK, FK |
| note_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### interaction_call_person

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| interaction_call_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### interaction_call

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organization_id | Unknown | FK |
| date | Unknown |  |
| end_time | Unknown |  |
| manual_creator_id | Unknown |  |
| start_time | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### opportunity_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| entity_id | Unknown | PK, FK |
| field_id | Unknown | FK |
| list_entry_id | Unknown | FK |
| created_at | Unknown |  |
| entity_type | Unknown |  |
| updated_at | Unknown |  |
| value | Json |  |
| value_type | Unknown |  |

### opportunity_list_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| opportunity_id | Unknown | PK, FK |
| creator_id | Unknown | FK |
| list_id | Unknown | FK |
| created_at | Unknown |  |
| entity_id | Unknown |  |
| entity_type | Unknown |  |

### opportunity_person

| Column | Type | Keys |
| --- | --- | --- |
| opportunity_id | Unknown | PK, FK |
| person_id | Unknown | PK, FK |

### opportunity_organization

| Column | Type | Keys |
| --- | --- | --- |
| opportunity_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### opportunity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

## Relationships

- interaction_email_to(person_to_id) → person_with_interaction(id)
- interaction_email_to(interaction_email_id) → interaction_email(id)
- interaction_email_to(organization_id) → interaction_email(organization_id)
- interaction_email(from_id) → person_with_interaction(id)
- interaction_email(organization_id) → organization_with_interaction(id)
- organization_field_value(entity_id) → organization_with_interaction(id)
- organization_field_value(list_entry_id) → list_entry(id)
- organization_field_value(field_id) → field(id)
- list_entry(list_id) → list(id)
- person_with_interaction_email(person_id) → person_with_interaction(id)
- field_dropdown_option(field_id) → field(id)
- field(list_id) → list(id)
- person_field_value(entity_id) → person_without_interaction(id)
- person_field_value(list_entry_id) → list_entry(id)
- person_field_value(field_id) → field(id)
- organization_with_interaction_domain(domain) → organization_with_interaction(domain)
- organization_with_interaction_domain(organization_id) → organization_with_interaction(id)
- organization_with_interaction_person_id(person_id) → person_with_interaction(id)
- organization_with_interaction_person_id(organization_id) → organization_with_interaction(id)
- organization_with_interaction_list_entry(list_entry_id) → list_entry(id)
- organization_with_interaction_list_entry(organization_id) → organization_with_interaction(id)
- organization_interaction_person_id(person_id) → person_with_interaction(id)
- organization_interaction_person_id(organization_id) → organization_with_interaction(id)
- organization_interaction_person_id(interaction_date) → organization_with_interaction(interaction_first_event_date)
- relationship_strength(external_id) → person_with_interaction(id)
- relationship_strength(internal_id) → person_with_interaction(id)
- interaction_meeting_attendee(interaction_meeting_id) → interaction_meeting(id)
- interaction_meeting_attendee(organization_id) → interaction_meeting(organization_id)
- interaction_meeting_note(note_id) → note(id)
- interaction_meeting_note(interaction_meeting_id) → interaction_meeting(id)
- interaction_meeting_note(organization_id) → interaction_meeting(organization_id)
- interaction_meeting_person(interaction_meeting_id) → interaction_meeting(id)
- interaction_meeting_person(organization_id) → interaction_meeting(organization_id)
- interaction_meeting(organization_id) → organization_with_interaction(id)
- list(owner_id) → person_with_interaction(id)
- list(creator_id) → person_with_interaction(id)
- person_without_interaction_email(person_id) → person_without_interaction(id)
- organization_without_interaction_domain(domain) → organization_without_interaction(domain)
- organization_without_interaction_domain(organization_id) → organization_without_interaction(id)
- organization_without_interaction_person_id(person_id) → person_without_interaction(id)
- organization_without_interaction_person_id(organization_id) → organization_without_interaction(id)
- organization_without_interaction_list_entry(list_entry_id) → list_entry(id)
- organization_without_interaction_list_entry(organization_id) → organization_without_interaction(id)
- global_organization_field(field_id) → field(id)
- global_organization_field(list_id) → list(id)
- reminder(completer_id) → person_with_interaction(id)
- reminder(person_id) → person_with_interaction(id)
- reminder(owner_id) → person_with_interaction(id)
- reminder(organization_id) → organization_with_interaction(id)
- reminder(creator_id) → person_with_interaction(id)
- note_person(person_id) → person_with_interaction(id)
- note_person(note_id) → note(id)
- note_organization(organization_id) → organization_with_interaction(id)
- note_organization(note_id) → note(id)
- note_mentioned_person(mentioned_person_id) → person_with_interaction(id)
- note_mentioned_person(note_id) → note(id)
- note_opportunity(opportunity_id) → opportunity(id)
- note_opportunity(note_id) → note(id)
- file(person_id) → person_with_interaction(id)
- file(organization_id) → organization_with_interaction(id)
- file(opportunity_id) → opportunity(id)
- file(uploader_id) → person_with_interaction(id)
- interaction_chat_person(id) → person_with_interaction(id)
- interaction_chat_person(interaction_chat_id) → interaction_chat(id)
- interaction_chat_person(organization_id) → interaction_chat(organization_id)
- interaction_chat_note(note_id) → note(id)
- interaction_chat_note(interaction_chat_id) → interaction_chat(id)
- interaction_chat_note(organization_id) → interaction_chat(organization_id)
- interaction_chat(manual_creator_id) → person_with_interaction(id)
- interaction_chat(organization_id) → organization_with_interaction(id)
- interaction_call_attendee(interaction_call_id) → interaction_call(id)
- interaction_call_attendee(organization_id) → interaction_call(organization_id)
- interaction_call_note(note_id) → note(id)
- interaction_call_note(interaction_call_id) → interaction_call(id)
- interaction_call_note(organization_id) → interaction_call(organization_id)
- interaction_call_person(interaction_call_id) → interaction_call(id)
- interaction_call_person(organization_id) → interaction_call(organization_id)
- interaction_call(organization_id) → organization_with_interaction(id)
- opportunity_field_value(entity_id) → opportunity(id)
- opportunity_field_value(list_entry_id) → list_entry(id)
- opportunity_field_value(field_id) → field(id)
- opportunity_list_entry(list_id) → list(id)
- opportunity_list_entry(creator_id) → person_with_interaction(id)
- opportunity_list_entry(opportunity_id) → opportunity(id)
- opportunity_person(person_id) → person_with_interaction(id)
- opportunity_person(opportunity_id) → opportunity(id)
- opportunity_organization(organization_id) → organization_with_interaction(id)
- opportunity_organization(opportunity_id) → opportunity(id)