# CloudTalk schema ERD

Table and field reference for the Fivetran CloudTalk connector.

## Table & Field Reference

### agent_associated_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| agent_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| color | Unknown |  |
| description | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### campaign_contact_tag

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

### campaign_agent

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| fullname | Unknown |  |

### campaign_group

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| 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 | PK, FK |
| group_id | Unknown |  |

### call_history_contact_tag

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

### call_history_contact_external_url

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_history_id | Unknown | PK, FK |
| external_system | Unknown |  |
| external_url | Unknown |  |

### call_history_contact_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_history_id | Unknown | PK, FK |
| contact_number | Unknown |  |

### call_history_rating

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_history_id | Unknown | PK, FK |
| rating | Unknown |  |
| type | Unknown |  |

### call_history_note

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

### call_history_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_history_id | Unknown | PK, FK |
| 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 | PK, FK |
| label | Unknown |  |

### comprehensive_call_step_type

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| comprehensive_call_cdr_id | Unknown | PK, FK |

### comprehensive_call

| Column | Type | Keys |
| --- | --- | --- |
| cdr_id | Unknown | PK, FK |
| 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 | PK, FK |
| comprehensive_call_step_queue_agent_call_id | Unknown | PK, FK |
| group_id | Unknown | FK |

### comprehensive_call_step_queue_agent_call

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- agent_associated_number(agent_id) → agent(id)
- agent(call_number_id) → number(id)
- contact_attribute(contact_id) → contact(id)
- campaign_button(campaign_id) → campaign(id)
- campaign_contact_tag(campaign_id) → campaign(id)
- campaign_agent(id) → agent(id)
- campaign_agent(campaign_id) → campaign(id)
- campaign_group(id) → group_statistics(id)
- campaign_group(campaign_id) → campaign(id)
- call_history_agent_group(call_history_id) → call_history(id)
- call_history_contact_tag(call_history_id) → call_history(id)
- call_history_contact_external_url(call_history_id) → call_history(id)
- call_history_contact_number(call_history_id) → call_history(id)
- call_history_rating(call_history_id) → call_history(id)
- call_history_note(call_history_id) → call_history(id)
- call_history_tag(call_history_id) → call_history(id)
- call_history(user_id) → agent(id)
- call_history(call_number_id) → number(id)
- call_history(agent_id) → agent(id)
- call_history(contact_id) → contact(id)
- call_history(favorite_agent_id) → agent(id)
- comprehensive_call_tag(comprehensive_call_cdr_id) → comprehensive_call(cdr_id)
- comprehensive_call_step_type(comprehensive_call_cdr_id) → comprehensive_call(cdr_id)
- comprehensive_call(cdr_id) → call_history(id)
- comprehensive_call(contact_id) → contact(id)
- comprehensive_call(internal_id) → number(id)
- comprehensive_call_step_queue_agent_call_group_id(group_id) → group_statistics(id)
- comprehensive_call_step_queue_agent_call_group_id(comprehensive_call_step_queue_agent_call_id) → comprehensive_call_step_queue_agent_call(id)
- comprehensive_call_step_queue_agent_call_group_id(_fivetran_id) → comprehensive_call_step_queue_agent_call(_fivetran_id)
- comprehensive_call_step_queue_agent_call(_fivetran_id) → comprehensive_call_step_queue(_fivetran_id)
- comprehensive_call_step_queue(type) → comprehensive_call_step_type(type)
- comprehensive_call_step_queue(resolved_by_call_agent_id) → agent(id)
- comprehensive_call_step_queue(comprehensive_call_cdr_id) → comprehensive_call_step_type(comprehensive_call_cdr_id)
- comprehensive_call_step_transfer(type) → comprehensive_call_step_type(type)
- comprehensive_call_step_transfer(comprehensive_call_cdr_id) → comprehensive_call_step_type(comprehensive_call_cdr_id)
- comprehensive_call_step_agent_group_id(group_id) → group_statistics(id)
- comprehensive_call_step_agent_group_id(_fivetran_id) → comprehensive_call_step_agent(_fivetran_id)
- comprehensive_call_step_agent(type) → comprehensive_call_step_type(type)
- comprehensive_call_step_agent(call_id) → comprehensive_call(uuid)
- comprehensive_call_step_agent(resolved_by_call_agent_id) → agent(id)
- comprehensive_call_step_agent(comprehensive_call_cdr_id) → comprehensive_call_step_type(comprehensive_call_cdr_id)
- comprehensive_call_step_playback(type) → comprehensive_call_step_type(type)
- comprehensive_call_step_playback(comprehensive_call_cdr_id) → comprehensive_call_step_type(comprehensive_call_cdr_id)
- comprehensive_call_step_ivr(type) → comprehensive_call_step_type(type)
- comprehensive_call_step_ivr(comprehensive_call_cdr_id) → comprehensive_call_step_type(comprehensive_call_cdr_id)