# CallRail schema ERD

Table and field reference for the Fivetran CallRail connector.

## Table & Field Reference

### form_submission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| company_id | Unknown | FK |
| campaign | Unknown |  |
| customer_email | Unknown |  |
| customer_name | Unknown |  |
| customer_phone_number | Unknown |  |
| first_form | Unknown |  |
| form_url | Unknown |  |
| formatted_customer_name | Unknown |  |
| formatted_customer_phone_number | Unknown |  |
| keywords | Unknown |  |
| landing_page_url | Unknown |  |
| medium | Unknown |  |
| person_id | Unknown |  |
| referrer | Unknown |  |
| referring_url | Unknown |  |
| source | Unknown |  |
| submitted_at | Unknown |  |
| custom_** |  |  |

### milestone

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| form_submission_id | Unknown | FK |
| ad_position | Unknown |  |
| device | Unknown |  |
| event_date | Unknown |  |
| keywords | Unknown |  |
| landing | Unknown |  |
| landing_page_adgroup_id | Unknown |  |
| landing_page_campaign_id | Unknown |  |
| landing_page_creative | Unknown |  |
| landing_page_fbclid | Unknown |  |
| landing_page_gad_source | Unknown |  |
| landing_page_gbraid | Unknown |  |
| landing_page_gclid | Unknown |  |
| landing_page_network | Unknown |  |
| landing_page_placement | Unknown |  |
| match_type | Unknown |  |
| referrer | Unknown |  |
| referrer_url_param | Json |  |
| session_browser | Unknown |  |
| type | Unknown |  |
| utm_campaign | Unknown |  |
| utm_content | Unknown |  |
| utm_medium | Unknown |  |
| utm_source | Unknown |  |

### summarized_call

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_id | Unknown | FK |
| end_date | Unknown |  |
| start_date | Unknown |  |
| time_zone | Unknown |  |
| total_results_average_duration | Unknown |  |
| total_results_first_time_caller | Unknown |  |
| total_results_formatted_average_duration | Unknown |  |
| total_results_lead | Unknown |  |
| total_results_missed_call | Unknown |  |
| total_results_total_call | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| accepted | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| role | Unknown |  |

### tags

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| company_id | Unknown | FK |
| background_color | Unknown |  |
| color | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| tag_level | Unknown |  |

### call

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| company_id | Unknown | FK |
| tracker_id | Unknown | FK |
| agent_email | Unknown |  |
| answered | Unknown |  |
| business_phone_number | Unknown |  |
| campaign | Unknown |  |
| created_at | Unknown |  |
| customer_city | Unknown |  |
| customer_country | Unknown |  |
| customer_name | Unknown |  |
| customer_phone_number | Unknown |  |
| customer_state | Unknown |  |
| device_type | Unknown |  |
| direction | Unknown |  |
| duration | Unknown |  |
| first_call | Unknown |  |
| first_touch_ad_position | Unknown |  |
| first_touch_campaign | Unknown |  |
| first_touch_device | Unknown |  |
| first_touch_event_date | Unknown |  |
| first_touch_keywords | Unknown |  |
| first_touch_landing | Unknown |  |
| first_touch_landing_page_url_params | Unknown |  |
| first_touch_match_type | Unknown |  |
| first_touch_medium | Unknown |  |
| first_touch_referrer | Unknown |  |
| first_touch_referrer_url_params | Unknown |  |
| first_touch_session_browser | Unknown |  |
| first_touch_source | Unknown |  |
| first_touch_url_utm_params | Unknown |  |
| formatted_business_phone_number | Unknown |  |
| formatted_call_type | Unknown |  |
| formatted_customer_location | Unknown |  |
| formatted_customer_name | Unknown |  |
| formatted_customer_name_or_phone_number | Unknown |  |
| formatted_customer_phone_number | Unknown |  |
| formatted_duration | Unknown |  |
| formatted_tracking_phone_number | Unknown |  |
| formatted_tracking_source | Unknown |  |
| formatted_value | Unknown |  |
| ga | Unknown |  |
| gclid | Unknown |  |
| good_lead_call_id | Unknown |  |
| good_lead_call_time | Unknown |  |
| highlights | Json |  |
| keywords | Unknown |  |
| keywords_spotted | Json |  |
| landing_page_url | Unknown |  |
| last_requested_url | Unknown |  |
| last_touch_ad_position | Unknown |  |
| last_touch_campaign | Unknown |  |
| last_touch_device | Unknown |  |
| last_touch_event_date | Unknown |  |
| last_touch_keywords | Unknown |  |
| last_touch_landing | Unknown |  |
| last_touch_landing_page_url_params | Unknown |  |
| last_touch_match_type | Unknown |  |
| last_touch_medium | Unknown |  |
| last_touch_referrer | Unknown |  |
| last_touch_referrer_url_params | Unknown |  |
| last_touch_session_browser | Unknown |  |
| last_touch_source | Unknown |  |
| last_touch_url_utm_params | Unknown |  |
| lead_created_ad_position | Unknown |  |
| lead_created_campaign | Unknown |  |
| lead_created_device | Unknown |  |
| lead_created_event_date | Unknown |  |
| lead_created_keywords | Unknown |  |
| lead_created_landing | Unknown |  |
| lead_created_landing_page_url_params | Unknown |  |
| lead_created_match_type | Unknown |  |
| lead_created_medium | Unknown |  |
| lead_created_referrer | Unknown |  |
| lead_created_referrer_url_params | Unknown |  |
| lead_created_session_browser | Unknown |  |
| lead_created_source | Unknown |  |
| lead_created_url_utm_params | Unknown |  |
| lead_status | Unknown |  |
| medium | Unknown |  |
| note | Unknown |  |
| person_id | Unknown |  |
| prior_calls | Unknown |  |
| qualified_ad_position | Unknown |  |
| qualified_campaign | Unknown |  |
| qualified_device | Unknown |  |
| qualified_event_date | Unknown |  |
| qualified_keywords | Unknown |  |
| qualified_landing | Unknown |  |
| qualified_landing_page_url_params | Unknown |  |
| qualified_match_type | Unknown |  |
| qualified_medium | Unknown |  |
| qualified_referrer | Unknown |  |
| qualified_referrer_url_params | Unknown |  |
| qualified_session_browser | Unknown |  |
| qualified_source | Unknown |  |
| qualified_url_utm_params | Unknown |  |
| recording | Unknown |  |
| recording_duration | Unknown |  |
| recording_player | Unknown |  |
| referrer_domain | Unknown |  |
| referring_url | Unknown |  |
| sentiment | Unknown |  |
| session_uuid | Unknown |  |
| source | Unknown |  |
| source_name | Unknown |  |
| speaker_percent_agent | Unknown |  |
| speaker_percent_customer | Unknown |  |
| start_time | Unknown |  |
| summary | Unknown |  |
| tags | Json |  |
| timeline_url | Unknown |  |
| total_calls | Unknown |  |
| tracking_phone_number | Unknown |  |
| transcription | Unknown |  |
| type | Unknown |  |
| utm_campaign | Unknown |  |
| utm_content | Unknown |  |
| utm_medium | Unknown |  |
| utm_source | Unknown |  |
| utm_term | Unknown |  |
| value | Unknown |  |
| voice_assist_message | Json |  |
| voicemail | Unknown |  |
| zip_code | Json |  |
| custom_** |  |  |
| keypad_entry_** |  |  |

### notification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| company_id | Unknown | FK |
| tracker_id | Unknown | FK |
| user_id | Unknown | FK |
| agent_id | Unknown |  |
| alert_type | Unknown |  |
| call_enabled | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| send_desktop | Unknown |  |
| send_email | Unknown |  |
| send_push | Unknown |  |
| sms_enabled | Unknown |  |

### summary_email

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| user_id | Unknown | FK |
| config_call_log | Unknown |  |
| config_summary_statistic | Unknown |  |
| config_top_keyword | Unknown |  |
| config_top_source | Unknown |  |
| frequency | Json |  |
| scope_id | Unknown |  |
| scope_name | Unknown |  |
| scope_type | Unknown |  |

### outer_bound

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| company_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| validation_code | Unknown |  |
| verified | Unknown |  |

### text_message_recent_message

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| text_message_id | Unknown | PK, FK |
| content | Unknown |  |
| created_at | Unknown |  |
| direction | Unknown |  |

### text_message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| company_id | Unknown | FK |
| initial_tracker_id | Unknown | FK |
| company_time_zone | Unknown |  |
| current_tracker_id | Unknown |  |
| customer_name | Unknown |  |
| customer_phone_number | Unknown |  |
| formatted_current_tracking_number | Unknown |  |
| formatted_customer_name | Unknown |  |
| formatted_customer_phone_number | Unknown |  |
| formatted_initial_tracking_number | Unknown |  |
| last_message_at | Unknown |  |
| state | Unknown |  |

### integration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| company_id | Unknown | FK |
| api_key | Unknown |  |
| state | Unknown |  |
| type | Unknown |  |

### tracker_tracking_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| tracker_id | Unknown | PK, FK |
| tracking_number | Unknown | FK |

### tracker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| company_id | Unknown | FK |
| created_at | Unknown |  |
| disabled_at | Unknown |  |
| name | Unknown |  |
| sms_enabled | Unknown |  |
| sms_supported | Unknown |  |
| source_search_engine | Unknown |  |
| source_search_type | Unknown |  |
| source_type | Unknown |  |
| status | Unknown |  |
| tracking_number | Json |  |
| type | Unknown |  |
| whisper_message | Unknown |  |
| call_flow_** |  |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| call_score_enabled | Unknown |  |
| call_scribe_enabled | Unknown |  |
| created_at | Unknown |  |
| disabled_at | Unknown |  |
| dni_active | Unknown |  |
| form_capture | Unknown |  |
| keyword_spotting_enabled | Unknown |  |
| lead_scoring_enabled | Unknown |  |
| name | Unknown |  |
| script_url | Unknown |  |
| status | Unknown |  |
| swap_cookie_duration | Unknown |  |
| swap_exclude_jquery | Unknown |  |
| swap_landing_override | Unknown |  |
| swap_ppc_override | Unknown |  |
| time_zone | Unknown |  |

### integration_trigger

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| company_id | Unknown | FK |
| integration_id | Unknown | FK |
| call_type | Unknown |  |
| lead_status | Unknown |  |
| max_duration | Unknown |  |
| min_duration | Unknown |  |
| tracker_id | Json |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agency_in_trial | Unknown |  |
| brand_status | Unknown |  |
| created_at | Unknown |  |
| has_zuora_account | Unknown |  |
| hipaa_account | Unknown |  |
| name | Unknown |  |
| numeric_id | Unknown |  |
| outbound_recording_enabled | Unknown |  |

## Relationships

- form_submission(company_id) → company(id)
- form_submission(account_id) → account(id)
- milestone(form_submission_id) → form_submission(id)
- summarized_call(account_id) → account(id)
- users(account_id) → account(id)
- tags(company_id) → company(id)
- tags(account_id) → account(id)
- call(company_id) → company(id)
- call(tracker_id) → tracker(id)
- call(account_id) → account(id)
- notification(user_id) → users(id)
- notification(company_id) → company(id)
- notification(tracker_id) → tracker(id)
- notification(account_id) → account(id)
- summary_email(user_id) → users(id)
- summary_email(account_id) → account(id)
- outer_bound(account_id) → account(id)
- outer_bound(company_id) → company(id)
- text_message_recent_message(text_message_id) → text_message(id)
- text_message(initial_tracker_id) → tracker(id)
- text_message(company_id) → company(id)
- text_message(account_id) → account(id)
- integration(account_id) → account(id)
- integration(company_id) → company(id)
- tracker_tracking_number(tracking_number) → call(tracking_phone_number)
- tracker_tracking_number(tracker_id) → tracker(id)
- tracker(company_id) → company(id)
- tracker(account_id) → account(id)
- company(account_id) → account(id)
- integration_trigger(company_id) → company(id)
- integration_trigger(integration_id) → integration(id)
- integration_trigger(account_id) → account(id)