Dialpad
Explore the interactive ERD
Table & Field Reference
channel_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
channel_id | Unknown | PKFK |
name | Unknown |
channel
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown |
office_phone_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
office_id | Unknown | PKFK |
phone_number | Unknown |
office_routing_option_closed_dtmf
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
office_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
phone_number | Unknown |
call_center_routing_option_closed_dtmf
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
call_center_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
phone_number | Unknown |
contact_email
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
contact_id | Unknown | PKFK |
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 | PKFK |
phone_number | Unknown | FK |
department_routing_option_closed_dtmf
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
department_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
skill_level | Unknown |
user_admin_office_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
id | Unknown | FK |
user_forward_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
number | Unknown |
user_group_detail
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
do_not_disturb | Unknown | |
id | Unknown | |
role | Unknown | |
type | Unknown |
user_phone_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
office_id | Unknown | FK |
call_center_operator_forwarded_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
call_center_operator_id | Unknown | PKFK |
number | Unknown |
call_center_operator_email
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
call_center_operator_id | Unknown | PKFK |
email | Unknown |
call_center_operator_group_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
call_center_operator_id | Unknown | PKFK |
do_not_disturb | Unknown | |
role | Unknown | |
type | Unknown |
call_center_operator_phone_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
call_center_operator_id | Unknown | PKFK |
phone_number | Unknown |
call_center_operator
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
call_center_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
coaching_team_member_id | Unknown | PKFK |
office_id | Unknown | FK |
coaching_team_member_forward_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
coaching_team_id | Unknown | PKFK |
coaching_team_member_id | Unknown | PKFK |
number | Unknown |
coaching_team_member_email
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
coaching_team_id | Unknown | PKFK |
coaching_team_member_id | Unknown | PKFK |
email | Unknown |
coaching_team_member_phone_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
coaching_team_id | Unknown | PKFK |
coaching_team_member_id | Unknown | PKFK |
phone_number | Unknown |
coaching_team_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
coaching_team_id | Unknown | PKFK |
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 | PKFK |
duration | Unknown | |
recording_type | Unknown | |
start_time | Unknown | |
url | Unknown |
call_routing_breadcrumb
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
call_id | Unknown | PKFK |
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 |