JustCall

Explore the interactive ERD

Table & Field Reference

call_ai_data_sales_dialer_moment

Column	Type	Keys
`index`	Unknown	PK
`call_ai_data_id`	Unknown	PKFK
`call_moment`	Unknown

call_ai_data_sales_dialer_transcription

Column	Type	Keys
`index`	Unknown	PK
`call_ai_data_id`	Unknown	PKFK
`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	PKFK
`tags`	Unknown

call_ai_data_sales_dialer_smart_chapter

Column	Type	Keys
`index`	Unknown	PK
`call_ai_data_id`	Unknown	PKFK
`overview`	Json
`section`	Unknown

call_ai_data_sales_dialer

Column	Type	Keys
`id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`sales_dialer_call_sid`	Unknown	PKFK
`call_moment`	Unknown

sales_dialer_call_ai_tag

Column	Type	Keys
`index`	Unknown	PK
`sales_dialer_call_id`	Unknown	PKFK
`sales_dialer_call_sid`	Unknown	PKFK
`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	PKFK
`user_id`	Unknown	PKFK

user_owned_number

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`owned_number`	Unknown

user_shared_number

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`thread_phone_id`	Unknown	PKFK
`colour`	Unknown
`name`	Unknown

recent_message_mms

Column	Type	Keys
`index`	Unknown	PK
`thread_id`	Unknown	PKFK
`thread_phone_id`	Unknown	PKFK
`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	PKFK
`call_moment`	Unknown

call_ai_data_justcall_transcription

Column	Type	Keys
`index`	Unknown	PK
`call_ai_data_id`	Unknown	PKFK
`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	PKFK
`tags`	Unknown

call_ai_data_justcall_smart_chapter

Column	Type	Keys
`index`	Unknown	PK
`call_ai_data_id`	Unknown	PKFK
`overview`	Json
`section`	Unknown

call_ai_data_justcall

Column	Type	Keys
`id`	Unknown	PKFK
`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	PKFK
`group_id`	Unknown	FK

phone_number_team_member

Column	Type	Keys
`index`	Unknown	PK
`phone_number_id`	Unknown	PKFK
`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