# Dialpad schema ERD

Table and field reference for the Fivetran Dialpad connector.

## Table & Field Reference

### channel_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| channel_id | Unknown | PK, FK |
| name | Unknown |  |

### channel

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

### office_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| office_id | Unknown | PK, FK |
| phone_number | Unknown |  |

### office_routing_option_closed_dtmf

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| office_id | Unknown | PK, FK |
| input | Unknown |  |
| option_action | Unknown |  |
| option_action_target_id | Unknown |  |
| option_action_target_type | Unknown |  |

### office_routing_option_open_dtmf

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| office_id | Unknown | PK, FK |
| input | Unknown |  |
| option_action | Unknown |  |
| option_action_target_id | Unknown |  |
| option_action_target_type | Unknown |  |

### office

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| availability_status | Unknown |  |
| country | Unknown |  |
| e_911_address_address | Unknown |  |
| e_911_address_address_2 | Unknown |  |
| e_911_address_city | Unknown |  |
| e_911_address_country | Unknown |  |
| e_911_address_state | Unknown |  |
| e_911_address_zip | Unknown |  |
| first_action | Unknown |  |
| friday_hours | Json |  |
| monday_hours | Json |  |
| name | Unknown |  |
| no_operators_action | Unknown |  |
| ring_seconds | Unknown |  |
| routing_option_closed_action | Unknown |  |
| routing_option_closed_operator_routing | Unknown |  |
| routing_option_closed_try_dial_operator | Unknown |  |
| routing_option_open_action | Unknown |  |
| routing_option_open_action_target_id | Unknown |  |
| routing_option_open_action_target_type | Unknown |  |
| routing_option_open_operator_routing | Unknown |  |
| routing_option_open_try_dial_operator | Unknown |  |
| setting_allow_device_guest_login | Unknown |  |
| setting_block_caller_id_disabled | Unknown |  |
| setting_bridged_target_recording_allowed | Unknown |  |
| setting_disable_desk_phone_self_provision | Unknown |  |
| setting_disable_ivr_voicemail | Unknown |  |
| setting_no_recording_message_on_user_call | Unknown |  |
| setting_set_caller_id_disabled | Unknown |  |
| state | Unknown |  |
| thursday_hours | Json |  |
| timezone | Unknown |  |
| tuesday_hours | Json |  |
| wednesday_hours | Json |  |

### number

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| office_id | Unknown | FK |
| target_id | Unknown | FK |
| area_code | Unknown |  |
| status | Unknown |  |
| target_type | Unknown |  |
| type | Unknown |  |

### call_center_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_center_id | Unknown | PK, FK |
| phone_number | Unknown |  |

### call_center_routing_option_closed_dtmf

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_center_id | Unknown | PK, FK |
| input | Unknown |  |
| option_action | Unknown |  |
| option_action_target_id | Unknown |  |
| option_action_target_type | Unknown |  |

### call_center_routing_option_open_dtmf

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_center_id | Unknown | PK, FK |
| input | Unknown |  |
| option_action | Unknown |  |
| option_action_target_id | Unknown |  |
| option_action_target_type | Unknown |  |

### call_center

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| office_id | Unknown | FK |
| advanced_setting_auto_call_recording_inbound | Unknown |  |
| advanced_setting_auto_call_recording_outbound | Unknown |  |
| advanced_setting_max_wrap_up_seconds | Unknown |  |
| alert_cc_service_level | Unknown |  |
| alert_cc_service_level_seconds | Unknown |  |
| availability_status | Unknown |  |
| country | Unknown |  |
| first_action | Unknown |  |
| friday_hours | Json |  |
| group_description | Unknown |  |
| hold_queue_announce_position | Unknown |  |
| hold_queue_announcement_interval_seconds | Unknown |  |
| hold_queue_max_hold_count | Unknown |  |
| hold_queue_max_hold_seconds | Unknown |  |
| hold_queue_queue_callback_dtmf | Unknown |  |
| hold_queue_queue_callback_threshold | Unknown |  |
| hold_queue_queue_escape_dtmf | Unknown |  |
| hours_on | Unknown |  |
| monday_hours | Json |  |
| name | Unknown |  |
| no_operators_action | Unknown |  |
| ring_second | Unknown |  |
| routing_option_closed_action | Unknown |  |
| routing_option_closed_operator_routing | Unknown |  |
| routing_option_closed_try_dial_operator | Unknown |  |
| routing_option_open_action | Unknown |  |
| routing_option_open_action_target_id | Unknown |  |
| routing_option_open_action_target_type | Unknown |  |
| routing_option_open_operator_routing | Unknown |  |
| routing_option_open_try_dial_operator | Unknown |  |
| state | Unknown |  |
| thursday_hours | Json |  |
| timezone | Unknown |  |
| tuesday_hours | Json |  |
| voice_intelligence_allow_pause | Unknown |  |
| voice_intelligence_auto_start | Unknown |  |
| wednesday_hours | Json |  |

### call_transcript

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| call_id | Unknown | FK |
| contact_id | Unknown |  |
| content | Unknown |  |
| name | Unknown |  |
| time | Unknown |  |
| type | Unknown |  |
| user_id | Unknown |  |

### contact_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| phone_number | Unknown |  |

### contact_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| contact_id | Unknown | PK, FK |
| email | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_name | Unknown |  |
| display_name | Unknown |  |
| extension | Unknown |  |
| first_name | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| owner_id | Unknown |  |
| primary_email | Unknown |  |
| primary_phone | Unknown |  |
| trunk_group | Unknown |  |
| type | Unknown |  |
| urls | Json |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_type | Unknown |  |
| country | Unknown |  |
| domain | Unknown |  |
| name | Unknown |  |

### department_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| department_id | Unknown | PK, FK |
| phone_number | Unknown | FK |

### department_routing_option_closed_dtmf

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| department_id | Unknown | PK, FK |
| input | Unknown |  |
| option_action | Unknown |  |
| option_action_target_id | Unknown |  |
| option_action_target_type | Unknown |  |

### department_routing_option_open_dtmf

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| department_id | Unknown | PK, FK |
| input | Unknown |  |
| option_action | Unknown |  |
| option_action_target_id | Unknown |  |
| option_action_target_type | Unknown |  |

### department

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| office_id | Unknown | FK |
| auto_call_recording | Unknown |  |
| availability_status | Unknown |  |
| country | Unknown |  |
| first_action | Unknown |  |
| friday_hours | Json |  |
| group_description | Unknown |  |
| hold_queue_allow_queuing | Unknown |  |
| hold_queue_max_hold_count | Unknown |  |
| hold_queue_max_hold_seconds | Unknown |  |
| hours_on | Unknown |  |
| monday_hours | Json |  |
| name | Unknown |  |
| no_operators_action | Unknown |  |
| ring_seconds | Unknown |  |
| routing_option_closed_action | Unknown |  |
| routing_option_closed_operator_routing | Unknown |  |
| routing_option_closed_try_dial_operator | Unknown |  |
| routing_option_open_action | Unknown |  |
| routing_option_open_action_target_id | Unknown |  |
| routing_option_open_action_target_type | Unknown |  |
| routing_option_open_operator_routing | Unknown |  |
| routing_option_open_try_dial_operator | Unknown |  |
| state | Unknown |  |
| thursday_hours | Json |  |
| timezone | Unknown |  |
| tuesday_hours | Json |  |
| voice_intelligence_allow_pause | Unknown |  |
| voice_intelligence_auto_start | Unknown |  |
| wednesday_hours | Json |  |

### call_center_operator_duty_status

| Column | Type | Keys |
| --- | --- | --- |
| operator_id | Unknown | PK, FK |
| duty_status_reason | Unknown |  |
| duty_status_started | Unknown |  |
| on_duty | Unknown |  |
| on_duty_started | Unknown |  |
| on_duty_status | Unknown |  |

### call_router

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| office_id | Unknown | FK |
| default_target_id | Unknown |  |
| default_target_type | Unknown |  |
| enabled | Unknown |  |
| name | Unknown |  |
| routing_url | Unknown |  |
| signature_algo | Unknown |  |
| signature_secret | Unknown |  |
| signature_type | Unknown |  |

### office_license

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| office_id | Unknown | FK |
| additional_number_line | Unknown |  |
| contact_center_line | Unknown |  |
| fax_line | Unknown |  |
| room_line | Unknown |  |
| sell_line | Unknown |  |
| talk_line | Unknown |  |
| tollfree_additional_number_line | Unknown |  |
| tollfree_room_line | Unknown |  |
| uberconference_line | Unknown |  |

### call_center_operator_skill

| Column | Type | Keys |
| --- | --- | --- |
| call_center_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| skill_level | Unknown |  |

### user_admin_office_id

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

### user_forward_number

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

### user_group_detail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| do_not_disturb | Unknown |  |
| id | Unknown |  |
| role | Unknown |  |
| type | Unknown |  |

### user_phone_number

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

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| office_id | Unknown | FK |
| country | Unknown |  |
| date_active | Unknown |  |
| date_added | Unknown |  |
| date_first_login | Unknown |  |
| do_not_disturb | Unknown |  |
| extension | Unknown |  |
| first_name | Unknown |  |
| image_url | Unknown |  |
| is_admin | Unknown |  |
| is_available | Unknown |  |
| is_on_duty | Unknown |  |
| is_online | Unknown |  |
| is_super_admin | Unknown |  |
| job_title | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| license | Unknown |  |
| location | Unknown |  |
| muted | Unknown |  |
| state | Unknown |  |
| status_message | Unknown |  |
| timezone | Unknown |  |

### room_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| room_id | Unknown | PK, FK |
| phone_number | Unknown |  |

### room

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| office_id | Unknown | FK |
| country | Unknown |  |
| image_url | Unknown |  |
| is_free | Unknown |  |
| is_on_duty | Unknown |  |
| name | Unknown |  |
| state | Unknown |  |

### call_center_operator_admin

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_center_operator_id | Unknown | PK, FK |
| office_id | Unknown | FK |

### call_center_operator_forwarded_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_center_operator_id | Unknown | PK, FK |
| number | Unknown |  |

### call_center_operator_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_center_operator_id | Unknown | PK, FK |
| email | Unknown |  |

### call_center_operator_group_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_center_operator_id | Unknown | PK, FK |
| do_not_disturb | Unknown |  |
| role | Unknown |  |
| type | Unknown |  |

### call_center_operator_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_center_operator_id | Unknown | PK, FK |
| phone_number | Unknown |  |

### call_center_operator

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_center_id | Unknown | PK, FK |
| company_id | Unknown | FK |
| office_id | Unknown | FK |
| country | Unknown |  |
| date_active | Unknown |  |
| date_added | Unknown |  |
| date_first_login | Unknown |  |
| do_not_disturb | Unknown |  |
| duty_status_reason | Unknown |  |
| duty_status_started | Unknown |  |
| extension | Unknown |  |
| first_name | Unknown |  |
| image_url | Unknown |  |
| is_admin | Unknown |  |
| is_available | Unknown |  |
| is_on_duty | Unknown |  |
| is_online | Unknown |  |
| is_super_admin | Unknown |  |
| job_title | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| license | Unknown |  |
| location | Unknown |  |
| muted | Unknown |  |
| on_duty_started | Unknown |  |
| on_duty_status | Unknown |  |
| state | Unknown |  |
| status_message | Unknown |  |
| timezone | Unknown |  |

### room_deskphone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| room_id | Unknown | PK, FK |
| byod | Unknown |  |
| mac_address | Unknown |  |
| name | Unknown |  |
| owner_id | Unknown |  |
| owner_type | Unknown |  |
| port | Unknown |  |
| realm | Unknown |  |
| ring_notification | Unknown |  |
| type | Unknown |  |

### coaching_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| office_id | Unknown | FK |
| allow_trainee_eavesdrop | Unknown |  |
| country | Unknown |  |
| name | Unknown |  |
| phone_numbers | Json |  |
| ring_seconds | Unknown |  |
| state | Unknown |  |
| team_description | Unknown |  |

### coaching_team_member_admin

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| coaching_team_id | Unknown | PK, FK |
| coaching_team_member_id | Unknown | PK, FK |
| office_id | Unknown | FK |

### coaching_team_member_forward_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| coaching_team_id | Unknown | PK, FK |
| coaching_team_member_id | Unknown | PK, FK |
| number | Unknown |  |

### coaching_team_member_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| coaching_team_id | Unknown | PK, FK |
| coaching_team_member_id | Unknown | PK, FK |
| email | Unknown |  |

### coaching_team_member_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| coaching_team_id | Unknown | PK, FK |
| coaching_team_member_id | Unknown | PK, FK |
| phone_number | Unknown |  |

### coaching_team_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| coaching_team_id | Unknown | PK, FK |
| company_id | Unknown | FK |
| office_id | Unknown | FK |
| country | Unknown |  |
| date_active | Unknown |  |
| date_added | Unknown |  |
| date_first_login | Unknown |  |
| do_not_disturb | Unknown |  |
| extension | Unknown |  |
| first_name | Unknown |  |
| image_url | Unknown |  |
| is_admin | Unknown |  |
| is_available | Unknown |  |
| is_on_duty | Unknown |  |
| is_online | Unknown |  |
| is_super_admin | Unknown |  |
| job_title | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| license | Unknown |  |
| location | Unknown |  |
| muted | Unknown |  |
| name | Unknown |  |
| role | Unknown |  |
| state | Unknown |  |
| status_message | Unknown |  |
| timezone | Unknown |  |

### call_recording_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_id | Unknown | PK, FK |
| duration | Unknown |  |
| recording_type | Unknown |  |
| start_time | Unknown |  |
| url | Unknown |  |

### call_routing_breadcrumb

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_id | Unknown | PK, FK |
| breadcrumb_type | Unknown |  |
| date | Unknown |  |
| request | Json |  |
| response | Json |  |
| url | Unknown |  |

### call

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| admin_call_recording_share_links | Json |  |
| call_recording_share_links | Json |  |
| csat_recording_urls | Json |  |
| csat_score | Unknown |  |
| csat_transcriptions | Json |  |
| custom_data | Unknown |  |
| date_connected | Unknown |  |
| date_ended | Unknown |  |
| date_rang | Unknown |  |
| date_started | Unknown |  |
| direction | Unknown |  |
| duration | Unknown |  |
| entry_point_call_id | Unknown |  |
| entry_point_target_email | Unknown |  |
| entry_point_target_id | Unknown |  |
| entry_point_target_name | Unknown |  |
| entry_point_target_phone | Unknown |  |
| entry_point_target_type | Unknown |  |
| event_timestamp | Unknown |  |
| external_number | Unknown |  |
| group_id | Unknown |  |
| internal_number | Unknown |  |
| is_transferred | Unknown |  |
| labels | Json |  |
| master_call_id | Unknown |  |
| mos_score | Unknown |  |
| operator_call_id | Unknown |  |
| proxy_target_email | Unknown |  |
| proxy_target_id | Unknown |  |
| proxy_target_name | Unknown |  |
| proxy_target_phone | Unknown |  |
| proxy_target_type | Unknown |  |
| screen_recording_urls | Json |  |
| state | Unknown |  |
| target_email | Unknown |  |
| target_id | Unknown |  |
| target_name | Unknown |  |
| target_phone | Unknown |  |
| target_type | Unknown |  |
| total_duration | Unknown |  |
| transcription_text | Unknown |  |
| voicemail_share_link | Unknown |  |
| was_recorded | Unknown |  |

## Relationships

- channel_member(channel_id) → channel(id)
- office_phone_number(office_id) → office(id)
- office_routing_option_closed_dtmf(office_id) → office(id)
- office_routing_option_open_dtmf(office_id) → office(id)
- number(company_id) → company(id)
- number(office_id) → office(id)
- number(target_id) → users(id)
- call_center_phone_number(call_center_id) → call_center(id)
- call_center_routing_option_closed_dtmf(call_center_id) → call_center(id)
- call_center_routing_option_open_dtmf(call_center_id) → call_center(id)
- call_center(office_id) → office(id)
- call_transcript(call_id) → call(id)
- contact_phone_number(contact_id) → contact(id)
- contact_email(contact_id) → contact(id)
- department_phone_number(phone_number) → number(id)
- department_phone_number(department_id) → department(id)
- department_routing_option_closed_dtmf(department_id) → department(id)
- department_routing_option_open_dtmf(department_id) → department(id)
- department(office_id) → office(id)
- call_center_operator_duty_status(operator_id) → call_center_operator(id)
- call_router(office_id) → office(id)
- office_license(office_id) → office(id)
- call_center_operator_skill(call_center_id) → call_center(id)
- call_center_operator_skill(user_id) → call_center_operator(id)
- user_admin_office_id(id) → office(id)
- user_admin_office_id(user_id) → users(id)
- user_forward_number(user_id) → users(id)
- user_group_detail(user_id) → users(id)
- user_phone_number(phone_number) → number(id)
- user_phone_number(user_id) → users(id)
- users(company_id) → company(id)
- users(office_id) → office(id)
- room_phone_number(room_id) → room(id)
- room(company_id) → company(id)
- room(office_id) → office(id)
- call_center_operator_admin(office_id) → office(id)
- call_center_operator_admin(call_center_operator_id) → call_center_operator(id)
- call_center_operator_forwarded_number(call_center_operator_id) → call_center_operator(id)
- call_center_operator_email(call_center_operator_id) → call_center_operator(id)
- call_center_operator_group_detail(call_center_operator_id) → call_center_operator(id)
- call_center_operator_phone_number(call_center_operator_id) → call_center_operator(id)
- call_center_operator(company_id) → company(id)
- call_center_operator(office_id) → office(id)
- call_center_operator(call_center_id) → call_center(id)
- room_deskphone(room_id) → room(id)
- coaching_team(company_id) → company(id)
- coaching_team(office_id) → office(id)
- coaching_team_member_admin(office_id) → office(id)
- coaching_team_member_admin(coaching_team_id) → coaching_team_member(coaching_team_id)
- coaching_team_member_admin(coaching_team_member_id) → coaching_team_member(id)
- coaching_team_member_forward_number(coaching_team_id) → coaching_team_member(coaching_team_id)
- coaching_team_member_forward_number(coaching_team_member_id) → coaching_team_member(id)
- coaching_team_member_email(coaching_team_id) → coaching_team_member(coaching_team_id)
- coaching_team_member_email(coaching_team_member_id) → coaching_team_member(id)
- coaching_team_member_phone_number(coaching_team_id) → coaching_team_member(coaching_team_id)
- coaching_team_member_phone_number(coaching_team_member_id) → coaching_team_member(id)
- coaching_team_member(company_id) → company(id)
- coaching_team_member(office_id) → office(id)
- coaching_team_member(coaching_team_id) → coaching_team(id)
- call_recording_detail(call_id) → call(id)
- call_routing_breadcrumb(call_id) → call(id)
- call(contact_id) → contact(id)