# Aircall schema ERD

Table and field reference for the Fivetran Aircall connector.

## Table & Field Reference

### webhook

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| created_at | Unknown |  |
| events | Json |  |
| url | Unknown |  |

### user_number

| Column | Type | Keys |
| --- | --- | --- |
| number_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### numbers

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| availability_status | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| digits | Unknown |  |
| is_ivr | Unknown |  |
| is_open | Unknown |  |
| live_recording_activated | Unknown |  |
| messages_after_hours | Unknown |  |
| messages_callback_later | Unknown |  |
| messages_closed | Unknown |  |
| messages_ivr | Unknown |  |
| messages_ringing_tone | Unknown |  |
| messages_unanswered_call | Unknown |  |
| messages_voicemail | Unknown |  |
| messages_waiting | Unknown |  |
| messages_welcome | Unknown |  |
| name | Unknown |  |
| priority | Unknown |  |
| time_zone | Unknown |  |

### call_sentiment_participant

| Column | Type | Keys |
| --- | --- | --- |
| call_sentiment_id | Unknown | PK |
| index | Unknown | PK |
| call_id | Unknown | PK, FK |
| phone_number | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### call_playbook_result_topic

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_id | Unknown | PK, FK |
| call_playbook_result_id | Unknown | PK, FK |
| name | Unknown |  |
| result | Unknown |  |

### call_playbook_result

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| adherence_score | Unknown |  |
| created_at | Unknown |  |
| number_id | Unknown |  |
| playbook_id | Unknown |  |
| playbook_name | Unknown |  |

### call_summary

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_id | Unknown | PK, FK |
| content | Unknown |  |
| created_at | Unknown |  |

### contact_email

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| label | Unknown |  |
| value | Unknown |  |

### contact_number

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| label | Unknown |  |
| value | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_name | Unknown |  |
| created_at | Unknown |  |
| first_name | Unknown |  |
| information | Unknown |  |
| is_shared | Unknown |  |
| last_name | Unknown |  |
| updated_at | Unknown |  |

### user_availability

| Column | Type | Keys |
| --- | --- | --- |
| user_id | Unknown | PK, FK |
| availability | Unknown |  |

### call_topic_content

| Column | Type | Keys |
| --- | --- | --- |
| call_topic_id | Unknown | PK |
| index | Unknown | PK |
| call_id | Unknown | PK, FK |
| call_topic_created_at | Unknown |  |
| content_id | Unknown |  |

### call_action_item

| Column | Type | Keys |
| --- | --- | --- |
| call_id | Unknown | PK |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| ai_generated | Unknown |  |
| content | Unknown |  |
| created_at | Unknown |  |
| updated_at | Unknown |  |

### team_user

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### team

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

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| availability_status | Unknown |  |
| available | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| languages | Unknown |  |
| name | Unknown |  |
| time_zone | Unknown |  |
| wrap_up_time | Unknown |  |

### tags

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

### call_comment

| Column | Type | Keys |
| --- | --- | --- |
| comment_id | Unknown | PK |
| call_id | Unknown | PK, FK |
| posted_by | Unknown | FK |
| content | Unknown |  |
| posted_at | Unknown |  |

### call_tag

| Column | Type | Keys |
| --- | --- | --- |
| call_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |
| tagged_by | Unknown | FK |
| created_at | Unknown |  |

### call_participant

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_id | Unknown | PK, FK |
| id | Unknown |  |
| phone_number | Unknown |  |
| type | Unknown |  |

### call_team

| Column | Type | Keys |
| --- | --- | --- |
| call_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |
| created_at | Unknown |  |

### call_ivr_options_selected

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_id | Unknown | PK, FK |
| branch | Unknown |  |
| created_at | Unknown |  |
| key | Unknown |  |
| title | Unknown |  |
| transition_ended_at | Unknown |  |
| transition_started_at | Unknown |  |

### call

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| number_id | Unknown | FK |
| user_id | Unknown | FK |
| answered_at | Unknown |  |
| archived | Unknown |  |
| asset | Unknown |  |
| assigned_to | Unknown |  |
| contact | Unknown |  |
| cost | Unknown |  |
| direction | Unknown |  |
| duration | Unknown |  |
| ended_at | Unknown |  |
| missed_call_reason | Unknown |  |
| raw_digits | Unknown |  |
| recording | Unknown |  |
| sid | Unknown |  |
| started_at | Unknown |  |
| status | Unknown |  |
| transferred_by | Unknown |  |
| transferred_to | Unknown |  |
| voicemail | Unknown |  |

### dialer_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| created_at | Unknown |  |

### dialer_campaign_number

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| user_id | Unknown | FK |
| called | Unknown |  |
| created_at | Unknown |  |
| number_id | Unknown |  |

### call_transcription_content_utterance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_id | Unknown | PK, FK |
| call_transcription_id | Unknown | PK, FK |
| end_time | Unknown |  |
| participant_type | Unknown |  |
| phone_number | Unknown |  |
| start_time | Unknown |  |
| text | Unknown |  |

### call_transcription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_id | Unknown | PK, FK |
| call_created_at | Unknown |  |
| type | Unknown |  |

### aircall_to_partner_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown |  |
| created_at | Unknown |  |
| external_id | Unknown |  |
| numbers | Json |  |
| update_message | Unknown |  |
| update_status | Unknown |  |
| updated_at | Unknown |  |

### media_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| message_id | Unknown | PK, FK |
| file_name | Unknown |  |
| file_type | Unknown |  |
| presigned_url | Unknown |  |

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| number_id | Unknown | FK |
| body | Unknown |  |
| channel | Unknown |  |
| created_at | Unknown |  |
| direct_link | Unknown |  |
| direction | Unknown |  |
| external_number | Unknown |  |
| metadata | Unknown |  |
| parent_id | Unknown |  |
| raw_digits | Unknown |  |
| recipient_country | Unknown |  |
| sent_at | Unknown |  |
| status | Unknown |  |
| template_content | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| whatsapp_message_category | Unknown |  |
| whatsapp_message_type | Unknown |  |

## Relationships

- user_number(user_id) → users(id)
- user_number(number_id) → numbers(id)
- call_sentiment_participant(call_id) → call(id)
- call_playbook_result_topic(call_playbook_result_id) → call_playbook_result(id)
- call_playbook_result_topic(call_id) → call_playbook_result(call_id)
- call_playbook_result(call_id) → call(id)
- call_playbook_result(user_id) → users(id)
- call_summary(call_id) → call(id)
- contact_email(contact_id) → contact(id)
- contact_number(contact_id) → contact(id)
- user_availability(user_id) → users(id)
- call_topic_content(call_id) → call(id)
- call_action_item(created_by) → users(id)
- call_action_item(updated_by) → users(id)
- team_user(user_id) → users(id)
- team_user(team_id) → team(id)
- call_comment(posted_by) → users(id)
- call_comment(call_id) → call(id)
- call_tag(tag_id) → tags(id)
- call_tag(tagged_by) → users(id)
- call_tag(call_id) → call(id)
- call_participant(call_id) → call(id)
- call_team(team_id) → team(id)
- call_team(call_id) → call(id)
- call_ivr_options_selected(call_id) → call(id)
- call(number_id) → numbers(id)
- call(user_id) → users(id)
- dialer_campaign(user_id) → users(id)
- dialer_campaign_number(user_id) → users(id)
- call_transcription_content_utterance(call_transcription_id) → call_transcription(id)
- call_transcription_content_utterance(call_id) → call_transcription(call_id)
- call_transcription(call_id) → call(id)
- media_detail(message_id) → message(id)
- message(number_id) → numbers(id)
- message(contact_id) → contact(id)