Aircall
Explore the interactive ERD
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 | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
phone_number | Unknown | |
type | Unknown | |
value | Unknown |
call_playbook_result_topic
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
call_id | Unknown | PKFK |
call_playbook_result_id | Unknown | PKFK |
name | Unknown | |
result | Unknown |
call_playbook_result
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
call_id | Unknown | PKFK |
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 | PKFK |
content | Unknown | |
created_at | Unknown |
contact_email
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | PKFK |
label | Unknown | |
value | Unknown |
contact_number
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | PKFK |
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 | PKFK |
availability | Unknown |
call_topic_content
| Column | Type | Keys |
|---|---|---|
call_topic_id | Unknown | PK |
index | Unknown | PK |
call_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
posted_by | Unknown | FK |
content | Unknown | |
posted_at | Unknown |
call_tag
| Column | Type | Keys |
|---|---|---|
call_id | Unknown | PKFK |
tag_id | Unknown | PKFK |
tagged_by | Unknown | FK |
created_at | Unknown |
call_participant
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
call_id | Unknown | PKFK |
id | Unknown | |
phone_number | Unknown | |
type | Unknown |
call_team
| Column | Type | Keys |
|---|---|---|
call_id | Unknown | PKFK |
team_id | Unknown | PKFK |
created_at | Unknown |
call_ivr_options_selected
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
call_id | Unknown | PKFK |
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 | PKFK |
call_transcription_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 |