# JustCall schema ERD

Table and field reference for the Fivetran JustCall connector.

## Table & Field Reference

### call_ai_data_sales_dialer_moment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_ai_data_id | Unknown | PK, FK |
| call_moment | Unknown |  |

### call_ai_data_sales_dialer_transcription

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_ai_data_id | Unknown | PK, FK |
| end_time | Unknown |  |
| sentence | Unknown |  |
| speaker_id | Unknown |  |
| speaker_name | Unknown |  |
| start_time | Unknown |  |

### call_ai_data_sales_dialer_tags

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_ai_data_id | Unknown | PK, FK |
| tags | Unknown |  |

### call_ai_data_sales_dialer_smart_chapter

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_ai_data_id | Unknown | PK, FK |
| overview | Json |  |
| section | Unknown |  |

### call_ai_data_sales_dialer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| action_items | Unknown |  |
| call_score | Unknown |  |
| call_score_parameters_call_etiquette | Unknown |  |
| call_score_parameters_customer_sentiment_score | Unknown |  |
| call_score_parameters_de_escalation | Unknown |  |
| call_score_parameters_dead_air_time | Unknown |  |
| call_score_parameters_empathy | Unknown |  |
| call_score_parameters_filler_word | Unknown |  |
| call_score_parameters_greetings | Unknown |  |
| call_score_parameters_monologue_duration | Unknown |  |
| call_score_parameters_talk_listen_ratio | Unknown |  |
| call_score_parameters_words_per_minute | Unknown |  |
| call_summary | Unknown |  |
| customer_sentiment | Unknown |  |
| interaction_stats_agent_speak_time | Unknown |  |
| interaction_stats_customer_speak_time | Unknown |  |
| interaction_stats_customer_story_duration | Unknown |  |
| interaction_stats_dead_air_time | Unknown |  |
| interaction_stats_interactivity_count | Unknown |  |
| interaction_stats_monologue_duration | Unknown |  |
| manual_call_score | Unknown |  |
| platform | Unknown |  |

### sale_dialer_campaign

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

### sales_dialer_analytics

| Column | Type | Keys |
| --- | --- | --- |
| agent_id | Unknown | PK, FK |
| abandoned_calls | Unknown |  |
| agent_email | Unknown |  |
| agent_name | Unknown |  |
| agent_success_rate | Unknown |  |
| answered_calls | Unknown |  |
| available_time_in_campaign | Unknown |  |
| average_call_duration | Unknown |  |
| campaigns_run | Unknown |  |
| connection_rate | Unknown |  |
| dialed_calls | Unknown |  |
| max_call_duration | Unknown |  |
| pause_time | Unknown |  |
| total_after_call_work | Unknown |  |
| total_call_duration | Unknown |  |
| total_cost_incurred | Unknown |  |
| total_unanswered_calls | Unknown |  |
| total_voicemails_drops | Unknown |  |

### analytics_daily

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| analytics_agent_id | Unknown | FK |
| day | Unknown |  |
| greaterthan_6_0 | Unknown |  |
| inbound | Unknown |  |
| inbound_minutes | Unknown |  |
| missed | Unknown |  |
| outbound | Unknown |  |
| outbound_minutes | Unknown |  |
| uniqueinbound | Unknown |  |
| uniqueoutbound | Unknown |  |

### analytics

| Column | Type | Keys |
| --- | --- | --- |
| agent_id | Unknown | PK, FK |
| name | Unknown |  |
| summary_inbound_minutes | Unknown |  |
| summary_outbound_minutes | Unknown |  |
| summary_total_inbound | Unknown |  |
| summary_total_outbound | Unknown |  |

### contact_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| key | Unknown |  |
| label | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address | Unknown |  |
| birthday | Unknown |  |
| created_at | Instant |  |
| email | Unknown |  |
| name | Unknown |  |
| occupation | Unknown |  |
| phone_number | Unknown |  |
| status | Unknown |  |
| status_updated_at | Unknown |  |

### text_mms

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| text_id | Unknown | FK |
| content_type | Unknown |  |
| media_url | Unknown |  |

### text

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_id | Unknown | FK |
| justcall_number | Unknown | FK |
| client_number | Unknown |  |
| contact_email | Unknown |  |
| contact_name | Unknown |  |
| contact_number | Unknown |  |
| cost_incurred | Unknown |  |
| datetime | Unknown |  |
| delivery_status | Unknown |  |
| direction | Unknown |  |
| is_deleted | Unknown |  |
| justcall_line_name | Unknown |  |
| medium | Unknown |  |
| sms_date | Unknown |  |
| sms_info_body | Unknown |  |
| sms_info_is_mms | Unknown |  |
| sms_time | Unknown |  |
| sms_user_date | Unknown |  |
| sms_user_time | Unknown |  |

### sales_dialer_call_ai_moment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sales_dialer_call_id | Unknown | PK, FK |
| sales_dialer_call_sid | Unknown | PK, FK |
| call_moment | Unknown |  |

### sales_dialer_call_ai_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sales_dialer_call_id | Unknown | PK, FK |
| sales_dialer_call_sid | Unknown | PK, FK |
| tags | Unknown |  |

### sales_dialer_call

| Column | Type | Keys |
| --- | --- | --- |
| call_id | Unknown | PK |
| call_sid | Unknown | PK |
| agent_id | Unknown | FK |
| campaign_id | Unknown | FK |
| contact_id | Unknown | FK |
| call_date | Unknown |  |
| call_info_call_answered_by | Unknown |  |
| call_info_cost_incurred | Unknown |  |
| call_info_direction | Unknown |  |
| call_info_disposition | Unknown |  |
| call_info_duration | Unknown |  |
| call_info_friendly_duration | Unknown |  |
| call_info_notes | Unknown |  |
| call_info_rating | Unknown |  |
| call_info_reattempt_number | Unknown |  |
| call_info_recording | Unknown |  |
| call_info_type | Unknown |  |
| call_time | Unknown |  |
| call_user_date | Unknown |  |
| call_user_time | Unknown |  |
| justcall_ai_call_score | Unknown |  |
| justcall_ai_call_score_parameters_call_etiquette | Unknown |  |
| justcall_ai_call_score_parameters_customer_sentiment_score | Unknown |  |
| justcall_ai_call_score_parameters_de_escalation | Unknown |  |
| justcall_ai_call_score_parameters_dead_air_time | Unknown |  |
| justcall_ai_call_score_parameters_empathy | Unknown |  |
| justcall_ai_call_score_parameters_filler_word | Unknown |  |
| justcall_ai_call_score_parameters_greeting | Unknown |  |
| justcall_ai_call_score_parameters_monologue_duration | Unknown |  |
| justcall_ai_call_score_parameters_talk_listen_ratio | Unknown |  |
| justcall_ai_call_score_parameters_words_per_minute | Unknown |  |
| justcall_ai_call_summary | Unknown |  |
| justcall_ai_customer_sentiment | Unknown |  |
| justcall_ai_manual_call_score | Unknown |  |
| sales_dialer_number | Unknown |  |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| extension | Unknown |  |
| name | Unknown |  |
| total_members | Unknown |  |
| updated_on | Unknown |  |

### user_group

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

### user_owned_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| owned_number | Unknown |  |

### user_shared_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| shared_number | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| available | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| extention | Unknown |  |
| last_login_timestamp | Unknown |  |
| name | Unknown |  |
| on_call | Unknown |  |
| role | Unknown |  |
| timezone | Unknown |  |
| unavailability_reason | Unknown |  |
| working_hours_type | Unknown |  |

### call_info_trait

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_id | Unknown | PK, FK |
| call_trait | Unknown |  |

### call

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_id | Unknown | FK |
| justcall_number | Unknown | FK |
| agent_active | Unknown |  |
| call_date | Unknown |  |
| call_duration_conversation_time | Unknown |  |
| call_duration_friendly_duration | Unknown |  |
| call_duration_handle_time | Unknown |  |
| call_duration_hold_time | Unknown |  |
| call_duration_queue_wait_time | Unknown |  |
| call_duration_ring_time | Unknown |  |
| call_duration_total_duration | Unknown |  |
| call_duration_wrap_up_time | Unknown |  |
| call_info_direction | Unknown |  |
| call_info_disposition | Unknown |  |
| call_info_missed_call_reason | Unknown |  |
| call_info_notes | Unknown |  |
| call_info_rating | Unknown |  |
| call_info_recording | Unknown |  |
| call_info_recording_child | Unknown |  |
| call_info_status | Unknown |  |
| call_info_type | Unknown |  |
| call_info_voicemail_transcription | Unknown |  |
| call_sid | Unknown |  |
| call_time | Unknown |  |
| call_user_date | Unknown |  |
| call_user_time | Unknown |  |
| contact_email | Unknown |  |
| contact_name | Unknown |  |
| contact_number | Unknown |  |
| cost_incurred | Unknown |  |
| forward_info_datetime | Unknown |  |
| forward_info_from_number | Unknown |  |
| forward_info_to_number | Unknown |  |
| ivr_info_content | Unknown |  |
| ivr_info_digit_pressed | Unknown |  |
| justcall_line_name | Unknown |  |
| queue_callback_attempted | Unknown |  |
| queue_callback_attempted_time | Unknown |  |
| queue_callback_reached | Unknown |  |
| queue_callback_reached_duration | Unknown |  |
| queue_callback_reached_time | Unknown |  |
| queue_callback_requested | Unknown |  |
| queue_callback_requested_time | Unknown |  |
| queue_callback_status | Unknown |  |
| queue_callback_wait_duration | Unknown |  |
| queue_entered_at_position | Unknown |  |
| queue_exit_reason | Unknown |  |

### thread_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| thread_id | Unknown | PK, FK |
| thread_phone_id | Unknown | PK, FK |
| colour | Unknown |  |
| name | Unknown |  |

### recent_message_mms

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| thread_id | Unknown | PK, FK |
| thread_phone_id | Unknown | PK, FK |
| content_type | Unknown |  |
| media_url | Unknown |  |

### thread

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| phone_id | Unknown | PK |
| contact_id | Unknown | FK |
| recent_message_body | Unknown |  |
| recent_message_datetime | Unknown |  |
| recent_message_direction | Unknown |  |
| recent_message_id | Unknown |  |
| recent_message_is_mms | Unknown |  |
| recent_message_readstatus | Unknown |  |

### call_ai_data_justcall_moment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_ai_data_id | Unknown | PK, FK |
| call_moment | Unknown |  |

### call_ai_data_justcall_transcription

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_ai_data_id | Unknown | PK, FK |
| end_time | Unknown |  |
| sentence | Unknown |  |
| speaker_id | Unknown |  |
| speaker_name | Unknown |  |
| start_time | Unknown |  |

### call_ai_data_justcall_tags

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_ai_data_id | Unknown | PK, FK |
| tags | Unknown |  |

### call_ai_data_justcall_smart_chapter

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_ai_data_id | Unknown | PK, FK |
| overview | Json |  |
| section | Unknown |  |

### call_ai_data_justcall

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| action_items | Unknown |  |
| call_score | Unknown |  |
| call_score_parameters_call_etiquette | Unknown |  |
| call_score_parameters_customer_sentiment_score | Unknown |  |
| call_score_parameters_de_escalation | Unknown |  |
| call_score_parameters_dead_air_time | Unknown |  |
| call_score_parameters_empathy | Unknown |  |
| call_score_parameters_filler_word | Unknown |  |
| call_score_parameters_greetings | Unknown |  |
| call_score_parameters_monologue_duration | Unknown |  |
| call_score_parameters_talk_listen_ratio | Unknown |  |
| call_score_parameters_words_per_minute | Unknown |  |
| call_summary | Unknown |  |
| customer_sentiment | Unknown |  |
| interaction_stats_agent_speak_time | Unknown |  |
| interaction_stats_customer_speak_time | Unknown |  |
| interaction_stats_customer_story_duration | Unknown |  |
| interaction_stats_dead_air_time | Unknown |  |
| interaction_stats_interactivity_count | Unknown |  |
| interaction_stats_monologue_duration | Unknown |  |
| manual_call_score | Unknown |  |
| platform | Unknown |  |

### text_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_agent_id | Unknown | FK |
| color_code | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |

### phone_number_user_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| phone_number_id | Unknown | PK, FK |
| group_id | Unknown | FK |

### phone_number_team_member

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| phone_number_id | Unknown | PK, FK |
| email | Unknown |  |
| id | Unknown |  |
| name | Unknown |  |

### phone_number

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| number_owner_id | Unknown | FK |
| availability_setting | Unknown |  |
| business_registration | Unknown |  |
| capabilities_call | Unknown |  |
| capabilities_mms | Unknown |  |
| capabilities_sms | Unknown |  |
| current_status | Unknown |  |
| friendly_number | Unknown |  |
| justcall_line_name | Unknown |  |
| justcall_number | Unknown |  |
| number_type | Unknown |  |
| sms_compliance | Unknown |  |

## Relationships

- call_ai_data_sales_dialer_moment(call_ai_data_id) → call_ai_data_sales_dialer(id)
- call_ai_data_sales_dialer_transcription(call_ai_data_id) → call_ai_data_sales_dialer(id)
- call_ai_data_sales_dialer_tags(call_ai_data_id) → call_ai_data_sales_dialer(id)
- call_ai_data_sales_dialer_smart_chapter(call_ai_data_id) → call_ai_data_sales_dialer(id)
- call_ai_data_sales_dialer(id) → call(id)
- sales_dialer_analytics(agent_id) → users(id)
- analytics_daily(analytics_agent_id) → users(id)
- analytics(agent_id) → users(id)
- contact_custom_field(contact_id) → contact(id)
- text_mms(text_id) → text(id)
- text(justcall_number) → phone_number(id)
- text(agent_id) → users(id)
- sales_dialer_call_ai_moment(sales_dialer_call_sid) → sales_dialer_call(call_sid)
- sales_dialer_call_ai_moment(sales_dialer_call_id) → sales_dialer_call(call_id)
- sales_dialer_call_ai_tag(sales_dialer_call_sid) → sales_dialer_call(call_sid)
- sales_dialer_call_ai_tag(sales_dialer_call_id) → sales_dialer_call(call_id)
- sales_dialer_call(campaign_id) → sale_dialer_campaign(id)
- sales_dialer_call(agent_id) → users(id)
- sales_dialer_call(contact_id) → contact(id)
- user_group(group_id) → groups(id)
- user_group(user_id) → users(id)
- user_owned_number(user_id) → users(id)
- user_shared_number(user_id) → users(id)
- call_info_trait(call_id) → call(id)
- call(justcall_number) → phone_number(id)
- call(agent_id) → users(id)
- thread_tag(thread_id) → thread(id)
- thread_tag(thread_phone_id) → thread(phone_id)
- recent_message_mms(thread_id) → thread(id)
- recent_message_mms(thread_phone_id) → thread(phone_id)
- thread(contact_id) → contact(id)
- call_ai_data_justcall_moment(call_ai_data_id) → call_ai_data_justcall(id)
- call_ai_data_justcall_transcription(call_ai_data_id) → call_ai_data_justcall(id)
- call_ai_data_justcall_tags(call_ai_data_id) → call_ai_data_justcall(id)
- call_ai_data_justcall_smart_chapter(call_ai_data_id) → call_ai_data_justcall(id)
- call_ai_data_justcall(id) → call(id)
- text_tag(created_by_agent_id) → users(id)
- phone_number_user_group(group_id) → groups(id)
- phone_number_user_group(phone_number_id) → phone_number(id)
- phone_number_team_member(phone_number_id) → phone_number(id)
- phone_number(number_owner_id) → users(id)