CloudTalk
Explore the interactive ERD
Table & Field Reference
agent_associated_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
agent_id | Unknown | PKFK |
associated_number | Unknown |
agent
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
call_number_id | Unknown | FK |
availability_status | Unknown | |
daily_price_limit | Unknown | |
default_number | Unknown | |
email | Unknown | |
extension | Unknown | |
firstname | Unknown | |
is_daily_limit_ok | Unknown | |
lastname | Unknown | |
name | Unknown | |
status_outbound | Unknown |
group_statistics
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
abandon_rate | Unknown | |
answered | Unknown | |
avg_call_duration | Unknown | |
avg_waiting_time | Unknown | |
max_waiting_time | Unknown | |
name | Unknown | |
operator | Unknown | |
real_time_avg_abandonment_time | Unknown | |
real_time_avg_waiting_time | Unknown | |
real_time_max_waiting_time | Unknown | |
real_time_waiting_queue | Unknown | |
unanswered | Unknown |
number
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
area_code | Unknown | |
caller_id_e_164 | Unknown | |
connected_to | Unknown | |
country_code | Unknown | |
internal_name | Unknown | |
is_redirected | Unknown |
contact_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | PKFK |
title | Unknown | |
value | Unknown |
contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company | Unknown | |
contact_number_country_code_id | Unknown | |
contact_number_id | Unknown | |
contact_number_public_number | Unknown | |
email | Unknown | |
name | Unknown |
campaign_button
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | PKFK |
color | Unknown | |
description | Unknown | |
title | Unknown | |
type | Unknown |
campaign_contact_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | PKFK |
name | Unknown |
campaign_agent
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PKFK |
id | Unknown | PKFK |
fullname | Unknown |
campaign_group
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PKFK |
id | Unknown | PKFK |
internal_name | Unknown |
campaign
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
after_call_dialing_auto | Unknown | |
after_call_time | Unknown | |
answer_wait_time | Unknown | |
attempt | Unknown | |
attempt_interval | Unknown | |
has_schedule_date | Unknown | |
is_predictive | Unknown | |
is_recording | Unknown | |
name | Unknown | |
status | Unknown |
call_history_agent_group
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
call_history_id | Unknown | PKFK |
group_id | Unknown |
call_history_contact_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
call_history_id | Unknown | PKFK |
name | Unknown |
call_history_contact_external_url
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
call_history_id | Unknown | PKFK |
external_system | Unknown | |
external_url | Unknown |
call_history_contact_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
call_history_id | Unknown | PKFK |
contact_number | Unknown |
call_history_rating
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
call_history_id | Unknown | PKFK |
rating | Unknown | |
type | Unknown |
call_history_note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
call_history_id | Unknown | PKFK |
name | Unknown |
call_history_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
call_history_id | Unknown | PKFK |
name | Unknown |
call_history
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_id | Unknown | FK |
call_number_id | Unknown | FK |
contact_id | Unknown | FK |
favorite_agent_id | Unknown | FK |
user_id | Unknown | FK |
answered_at | Unknown | |
billsec | Unknown | |
contact_address | Unknown | |
contact_city | Unknown | |
contact_industry | Unknown | |
contact_state | Unknown | |
contact_title | Unknown | |
contact_type | Unknown | |
contact_zip | Unknown | |
country_code | Unknown | |
ended_at | Unknown | |
favorite_agent_default_outbound_number | Unknown | |
favorite_agent_fullname | Unknown | |
favorite_agent_language | Unknown | |
favorite_agent_role | Unknown | |
favorite_agent_status | Unknown | |
fax_email | Unknown | |
is_local | Unknown | |
is_redirected | Unknown | |
is_voicemail | Unknown | |
price | Unknown | |
public_external | Unknown | |
public_internal | Unknown | |
recorded | Unknown | |
recording_link | Unknown | |
redirected_from | Unknown | |
started_at | Unknown | |
talking_time | Unknown | |
transferred_from | Unknown | |
type | Unknown | |
waiting_time | Unknown | |
wrapup_time | Unknown | |
custom_** |
comprehensive_call_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
comprehensive_call_cdr_id | Unknown | PKFK |
label | Unknown |
comprehensive_call_step_type
| Column | Type | Keys |
|---|---|---|
type | Unknown | PK |
comprehensive_call_cdr_id | Unknown | PKFK |
comprehensive_call
| Column | Type | Keys |
|---|---|---|
cdr_id | Unknown | PKFK |
contact_id | Unknown | FK |
internal_id | Unknown | FK |
call_rating | Unknown | |
call_time_ringing_time | Unknown | |
call_time_talking_time | Unknown | |
call_time_total_time | Unknown | |
call_time_waiting_time | Unknown | |
call_time_wrap_up_time | Unknown | |
company_id | Unknown | |
contact_country | Unknown | |
contact_name | Unknown | |
contact_number | Unknown | |
contact_redirected_from | Unknown | |
contact_redirected_to | Unknown | |
date | Unknown | |
direction | Unknown | |
internal_name | Unknown | |
internal_number | Unknown | |
is_anonymous | Unknown | |
note | Json | |
out_of_office | Unknown | |
recorded | Unknown | |
status | Unknown | |
type | Unknown | |
uuid | Unknown |
comprehensive_call_step_queue_agent_call_group_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
comprehensive_call_step_queue_agent_call_id | Unknown | PKFK |
group_id | Unknown | FK |
comprehensive_call_step_queue_agent_call
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
_fivetran_id | Unknown | PKFK |
call_id | Unknown | |
date | Unknown | |
name | Unknown | |
reason | Unknown | |
resolved_by | Unknown | |
status | Unknown | |
type | Unknown |
comprehensive_call_step_queue
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
comprehensive_call_cdr_id | Unknown | FK |
resolved_by_call_agent_id | Unknown | FK |
type | Unknown | FK |
call_time_ringing_time | Unknown | |
call_time_talking_time | Unknown | |
call_time_total_time | Unknown | |
call_time_waiting_time | Unknown | |
call_time_wrap_up_time | Unknown | |
date | Unknown | |
id | Unknown | |
name | Unknown | |
reason | Unknown | |
resolved_by | Unknown | |
resolved_by_call_date | Unknown | |
resolved_by_call_id | Unknown | |
status | Unknown | |
strategy | Unknown |
comprehensive_call_step_transfer
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
comprehensive_call_cdr_id | Unknown | FK |
type | Unknown | FK |
date | Unknown | |
endpoint | Unknown | |
id | Unknown | |
status | Unknown |
comprehensive_call_step_agent_group_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
_fivetran_id | Unknown | PKFK |
group_id | Unknown | FK |
comprehensive_call_step_agent
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
call_id | Unknown | FK |
comprehensive_call_cdr_id | Unknown | FK |
resolved_by_call_agent_id | Unknown | FK |
type | Unknown | FK |
call_time_ringing_time | Unknown | |
call_time_talking_time | Unknown | |
call_time_total_time | Unknown | |
call_time_waiting_time | Unknown | |
call_time_wrap_up_time | Unknown | |
date | Unknown | |
id | Unknown | |
name | Unknown | |
reason | Unknown | |
resolved_by | Unknown | |
resolved_by_call_date | Unknown | |
resolved_by_call_id | Unknown | |
status | Unknown |
comprehensive_call_step_playback
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
comprehensive_call_cdr_id | Unknown | FK |
type | Unknown | FK |
date | Unknown | |
file | Unknown | |
id | Unknown | |
total_time | Unknown |
comprehensive_call_step_ivr
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
comprehensive_call_cdr_id | Unknown | FK |
type | Unknown | FK |
date | Unknown | |
id | Unknown | |
option | Unknown | |
total_time | Unknown |