# Talkdesk schema ERD

Table and field reference for the Fivetran Talkdesk connector.

## Table & Field Reference

### guardian_user_role_change

| Column | Type | Keys |
| --- | --- | --- |
| role | Unknown | PK |
| guardian_user_id | Unknown | PK, FK |
| assigned_at | Instant |  |
| assigned_by | Unknown |  |

### guardian_user_ring_group

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| guardian_user_id | Unknown | PK, FK |

### guardian_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_quality_avg_affected_calls | Unknown |  |
| call_quality_mos_avg | Unknown |  |
| creation_time | Instant |  |
| email | Unknown |  |
| name | Unknown |  |
| presence | Unknown |  |
| presence_type | Unknown |  |
| risk | Unknown |  |
| role | Unknown |  |
| status | Unknown |  |

### user_attribute

| Column | Type | Keys |
| --- | --- | --- |
| attribute_id | Unknown | PK, FK |
| id | Unknown | PK, FK |
| name | Unknown |  |
| proficiency | Unknown |  |
| team | Unknown |  |

### outbound_dialer_calls

| Column | Type | Keys |
| --- | --- | --- |
| interaction_id | Unknown | PK, FK |
| campaign_agent_id | Unknown | FK |
| campaign_id | Unknown | FK |
| campaign_transferred_agent_id | Unknown | FK |
| record_id | Unknown | FK |
| attempt_number | Unknown |  |
| call_finished_time | Unknown |  |
| call_started_time | Unknown |  |
| callback_mode | Unknown |  |
| create_calls_analysis_in_queue | Unknown |  |
| create_calls_analysis_outbound_dialer_record_extra_data | Unknown |  |
| create_calls_analysis_proactive_outbound_phone_type | Unknown |  |
| create_calls_analysis_ringing_at_agent | Unknown |  |
| create_calls_analysis_ringing_at_customer | Unknown |  |
| customer_phone_number | Unknown |  |
| description | Unknown |  |
| disposition | Unknown |  |
| outbound_dialer_system_disposition | Unknown |  |
| sip_hangup_code | Unknown |  |
| talkdesk_phone_number | Unknown |  |
| team_name | Unknown |  |
| total_duration | Unknown |  |

### campaign_user

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

### record_phone_number

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| record_id | Unknown | PK, FK |
| number | Unknown |  |

### record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| record_list_id | Unknown | PK, FK |
| created_at | Instant |  |
| external_id | Unknown |  |
| external_provider | Unknown |  |
| external_url | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| phone_number | Unknown |  |
| priority | Unknown |  |
| sync_external_id | Unknown |  |
| timezone | Unknown |  |
| updated_at | Instant |  |
| custom_** |  |  |

### case_dict_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| case_field_id | Unknown | PK, FK |
| children | Json |  |
| key | Unknown |  |
| value | Unknown |  |

### case_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| create_at | Unknown |  |
| description | Unknown |  |
| key | Unknown |  |
| name | Unknown |  |
| required | Unknown |  |
| type | Unknown |  |
| update_at | Unknown |  |

### contact_phone

| Column | Type | Keys |
| --- | --- | --- |
| label | Unknown | PK |
| contact_id | Unknown | PK, FK |
| number | Unknown |  |

### contact

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

### csat_score

| Column | Type | Keys |
| --- | --- | --- |
| sent_at | Unknown | PK |
| agent_id | Unknown | PK, FK |
| ring_groups_name | Unknown |  |
| score | Unknown |  |
| team_id | Unknown |  |

### talk_time_data

| Column | Type | Keys |
| --- | --- | --- |
| started_at | Unknown | PK |
| agent_id | Unknown | PK, FK |
| ring_groups_name | Unknown |  |
| talk_time_seconds_total | Unknown |  |
| team_id | Unknown |  |

### attribute_category

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

### acw_time_data

| Column | Type | Keys |
| --- | --- | --- |
| started_at | Unknown | PK |
| agent_id | Unknown | PK, FK |
| acw_time_seconds_total | Unknown |  |
| ring_groups_name | Unknown |  |
| team_id | Unknown |  |

### studio_flow_execution

| Column | Type | Keys |
| --- | --- | --- |
| flow_id | Unknown | PK |
| step_name | Unknown | PK |
| interaction_id | Unknown | PK, FK |
| call_sid | Unknown |  |
| component_title | Unknown |  |
| destination_number | Unknown |  |
| execution_finished_time | Unknown |  |
| exit | Unknown |  |
| flow_name | Unknown |  |
| flow_timestamp | Unknown |  |
| origin_number | Unknown |  |
| step_execution_order | Unknown |  |
| time_in_step | Unknown |  |

### wallets

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| account_id | Unknown | FK |
| balance | Unknown |  |
| created_at | Instant |  |
| product_name | Unknown |  |
| updated_at | Instant |  |

### guardian_case

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| baseline | Unknown |  |
| event_id | Unknown |  |
| guardian_case | Unknown |  |
| hits | Unknown |  |
| hits_number | Unknown |  |
| ingest_timestamp | Instant |  |
| pop_baseline | Unknown |  |
| pop_conf | Unknown |  |
| pop_prob | Unknown |  |
| source | Unknown |  |
| specification | Unknown |  |
| user_baseline | Unknown |  |
| user_conf | Unknown |  |
| user_prob | Unknown |  |

### user_ring_group

| Column | Type | Keys |
| --- | --- | --- |
| ring_group_name | Unknown | PK |
| user_id | Unknown | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| created_at | Instant |  |
| email | Unknown |  |
| extension | Unknown |  |
| external_phone_number | Unknown |  |
| gender | Unknown |  |
| name | Unknown |  |

### qm_evaluation_score_ring_group

| Column | Type | Keys |
| --- | --- | --- |
| ring_group_name | Unknown | PK |
| agent_id | Unknown | PK, FK |
| qm_evaluation_score_evaluation_time | Unknown | PK, FK |

### qm_evaluation_score

| Column | Type | Keys |
| --- | --- | --- |
| evaluation_time | Unknown | PK |
| agent_id | Unknown | PK, FK |
| evaluation_max_score | Unknown |  |
| evaluation_obtained_score | Unknown |  |
| team_id | Unknown |  |

### campaign_phone_number

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

### messaging_contact_queue

| Column | Type | Keys |
| --- | --- | --- |
| ring_group_name | Unknown | PK |
| messaging_contact_id | Unknown | PK, FK |

### messaging_contact_handling_queue

| Column | Type | Keys |
| --- | --- | --- |
| ring_group_name | Unknown | PK |
| messaging_contact_id | Unknown | PK, FK |

### messaging_contact

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK, FK |
| interaction_id | Unknown | FK |
| user_id | Unknown | FK |
| virtual_agent_id | Unknown | FK |
| channel_type | Unknown |  |
| contact_assigned_at | Unknown |  |
| contact_duration | Unknown |  |
| contact_finished_at | Unknown |  |
| contact_finished_reason | Unknown |  |
| contact_person_channel_identifier | Unknown |  |
| contact_person_id | Unknown |  |
| contact_person_name | Unknown |  |
| contact_started_at | Unknown |  |
| conversation | Unknown |  |
| direct_assignment_user_id | Unknown |  |
| direction | Unknown |  |
| disposition_name | Unknown |  |
| interaction_duration | Unknown |  |
| interaction_finished_at | Unknown |  |
| interaction_started_at | Unknown |  |
| interaction_status | Unknown |  |
| is_virtual_agent | Unknown |  |
| notes | Unknown |  |
| touchpoint_identifier | Unknown |  |
| touchpoint_name | Unknown |  |
| transfer_out | Unknown |  |
| wrap_up_duration | Unknown |  |

### campaign_record_chain

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| max_attempts | Unknown |  |
| retry_period | Unknown |  |
| retry_period_time_unit | Unknown |  |

### campaign_calling_hour

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| end_time | Unknown |  |
| start_time | Unknown |  |
| week_days | Unknown |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| action_required | Unknown |  |
| dialing_mode | Unknown |  |
| dialing_mode_configuration_abandonment_timeout | Unknown |  |
| dialing_mode_configuration_amd_metadata | Unknown |  |
| dialing_mode_configuration_answering_machine_detection | Unknown |  |
| dialing_mode_configuration_max_abandonment_rate | Unknown |  |
| dialing_mode_configuration_max_dialing_ratio | Unknown |  |
| dialing_mode_configuration_max_ring_time_in_secs | Unknown |  |
| dialing_strategy_dispositions | Json |  |
| dialing_strategy_ivr_enabled | Unknown |  |
| dialing_strategy_lists_sorting_criteria | Unknown |  |
| dialing_strategy_max_attempts | Unknown |  |
| dialing_strategy_max_skip_attempts | Unknown |  |
| dialing_strategy_preview_timeout | Unknown |  |
| dialing_strategy_retry_period | Unknown |  |
| dialing_strategy_retry_time_unit | Unknown |  |
| dialing_strategy_strategy_type | Unknown |  |
| name | Unknown |  |
| priority | Unknown |  |
| run_once | Unknown |  |
| status | Unknown |  |

### contact_call_handling_ring_group

| Column | Type | Keys |
| --- | --- | --- |
| ring_group_name | Unknown | PK |
| contact_call_id | Unknown | PK, FK |

### contact_call_ring_group

| Column | Type | Keys |
| --- | --- | --- |
| ring_group_name | Unknown | PK |
| contact_call_id | Unknown | PK, FK |

### contact_call

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Unknown | PK |
| interaction_id | Unknown | FK |
| user_id | Unknown | FK |
| abandon_time | Unknown |  |
| after_call_work_time | Unknown |  |
| answered_at | Unknown |  |
| attribute | Unknown |  |
| callback | Unknown |  |
| company_number | Unknown |  |
| connect_time | Unknown |  |
| connected_at | Unknown |  |
| contact_person_number | Unknown |  |
| contact_type | Unknown |  |
| data_status | Unknown |  |
| description | Unknown |  |
| direct_assignment_id | Unknown |  |
| direction | Unknown |  |
| disconnected_by_agent | Unknown |  |
| disposition_code | Unknown |  |
| disposition_set | Unknown |  |
| duration | Unknown |  |
| external_phone_number | Unknown |  |
| finished_at | Unknown |  |
| float_custom_field_n_1 | Unknown |  |
| float_custom_field_n_2 | Unknown |  |
| handle_time | Unknown |  |
| hard_hold_time | Unknown |  |
| hold_time | Unknown |  |
| inside_business_hours | Unknown |  |
| inside_service_level | Unknown |  |
| int_custom_field_n_1 | Unknown |  |
| int_custom_field_n_2 | Unknown |  |
| last_contact | Unknown |  |
| nested_disposition | Unknown |  |
| phone_display_name | Unknown |  |
| proficiency | Unknown |  |
| ring_time | Unknown |  |
| short_abandon_time | Unknown |  |
| soft_hold_time | Unknown |  |
| started_at | Unknown |  |
| talk_time | Unknown |  |
| team_id | Unknown |  |
| team_name | Unknown |  |
| text_custom_field_n_1 | Unknown |  |
| text_custom_field_n_2 | Unknown |  |
| text_custom_field_n_3 | Unknown |  |
| text_custom_field_n_4 | Unknown |  |
| time_to_missed | Unknown |  |
| time_to_voicemail | Unknown |  |
| timestamp_custom_field_n_1 | Unknown |  |
| transfer_in | Unknown |  |
| transfer_in_type | Unknown |  |
| transfer_out | Unknown |  |
| transfer_out_type | Unknown |  |
| user_attribute | Unknown |  |
| user_proficiency | Unknown |  |
| wait_time | Unknown |  |
| within_service_level_threshold | Unknown |  |

### messaging_traffic

| Column | Type | Keys |
| --- | --- | --- |
| message_id | Unknown | PK |
| contact_id | Unknown | FK |
| interaction_id | Unknown | FK |
| user_id | Unknown | FK |
| channel_type | Unknown |  |
| contact_person_id | Unknown |  |
| contact_person_name | Unknown |  |
| message_created_at | Unknown |  |
| message_direction | Unknown |  |

### hold_time_data

| Column | Type | Keys |
| --- | --- | --- |
| started_at | Unknown | PK |
| agent_id | Unknown | PK, FK |
| hold_time_seconds_total | Unknown |  |
| ring_groups_name | Unknown |  |
| team_id | Unknown |  |

### do_not_call_number

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| do_not_call_list_id | Unknown | PK, FK |
| created_at | Instant |  |
| expiration_date | Unknown |  |
| phone_number | Unknown |  |
| reason | Unknown |  |
| updated_at | Instant |  |

### campaign_do_not_call_list

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

### record_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| created_at | Instant |  |
| name | Unknown |  |
| records_count | Unknown |  |
| status | Unknown |  |
| teams | Json |  |
| unique_identifier_type | Unknown |  |
| updated_at | Instant |  |

### guardian_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| browser_full | Unknown |  |
| country | Unknown |  |
| ip_address | Unknown |  |
| latitude | Unknown |  |
| login_timestamp | Instant |  |
| logout_timestamp | Instant |  |
| longitude | Unknown |  |
| os_full | Unknown |  |
| sso | Unknown |  |
| support_access | Unknown |  |

### campaign_record_list

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

### guardian_call_quality

| Column | Type | Keys |
| --- | --- | --- |
| call_id | Unknown | PK |
| interaction_id | Unknown | FK |
| user_id | Unknown | FK |
| affected_call | Unknown |  |
| call_timestamp | Instant |  |
| jitter_avg | Unknown |  |
| jitter_max | Unknown |  |
| mos_avg | Unknown |  |
| mos_max | Unknown |  |
| mos_min | Unknown |  |
| packets_loss_percentage | Unknown |  |
| rtt_avg | Unknown |  |
| rtt_max | Unknown |  |
| rtt_min | Unknown |  |

### attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category_id | Unknown | FK |
| active | Unknown |  |
| category_name | Unknown |  |
| default_proficiency | Unknown |  |
| flows_count | Unknown |  |
| name | Unknown |  |
| proficiency | Unknown |  |
| team_ids | Json |  |
| users_count | Unknown |  |

### user_status_ring_group

| Column | Type | Keys |
| --- | --- | --- |
| ring_group_name | Unknown | PK |
| user_id | Unknown | PK, FK |
| user_status_start_at | Unknown | PK, FK |

### user_status

| Column | Type | Keys |
| --- | --- | --- |
| status_start_at | Unknown | PK |
| user_id | Unknown | PK, FK |
| is_user_active | Unknown |  |
| status_end_at | Unknown |  |
| status_label | Unknown |  |
| status_time | Unknown |  |
| team_id | Unknown |  |
| team_name | Unknown |  |

### case_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| case_id | Unknown | PK, FK |
| key_name | Unknown |  |
| label | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### case_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| case_id | Unknown | PK, FK |
| notes_body | Unknown |  |
| notes_title | Unknown |  |
| public | Unknown |  |

### cases

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_id | Unknown | FK |
| about | Unknown |  |
| agent_name | Unknown |  |
| create_at | Unknown |  |
| description | Unknown |  |
| form_name | Unknown |  |
| group_id | Unknown |  |
| group_name | Unknown |  |
| priority | Unknown |  |
| requester_email | Unknown |  |
| requester_id | Unknown |  |
| requester_name | Unknown |  |
| requester_phone | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| update_at | Unknown |  |

### advanced_dialer_call

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agent_id | String | FK |
| campaign_id | String | FK |
| contact_id | String | FK |
| list_id | String | FK |
| transferred_agent_id | String | FK |
| advanced_dialer_interaction_id | String |  |
| advanced_dialer_sip_hangup_code | String |  |
| agent_disposition | String |  |
| attempt_number | String |  |
| call_finished_time | String |  |
| call_started_time | String |  |
| cli | String |  |
| contact_external_id | String |  |
| contact_phone_number | String |  |
| dial_mode | String |  |
| external_call_id | String |  |
| interaction_id | String |  |
| is_callback | String |  |
| notes | String |  |
| ringing_at_customer | String |  |
| system_disposition | String |  |
| total_duration | String |  |

### feedback_flow

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| interaction_id | String | FK |
| agent_name | String |  |
| component_id | String |  |
| component_name | String |  |
| component_text | String |  |
| component_type | String |  |
| date_time | LocalDateTime |  |
| flow_name | String |  |
| interaction_direction | String |  |
| is_kpi | String |  |
| pertains_to_agent | String |  |
| recording_url | String |  |
| respondent_phone_number | String |  |
| response | String |  |
| response_state | String |  |
| ring_group | String |  |
| sms_error | String |  |
| survey_channel | String |  |
| talkdesk_phone_number | String |  |
| team_name | String |  |
| touch_point_id | String |  |
| touch_point_name | String |  |
| touch_point_value | String |  |

### inbound_contact_volume

| Column | Type | Keys |
| --- | --- | --- |
| started_at | Unknown | PK |
| agent_id | Unknown | PK, FK |
| in_contact_volume | Unknown |  |
| ring_groups_name | Unknown |  |
| team_id | Unknown |  |

### ring_attempt_queue

| Column | Type | Keys |
| --- | --- | --- |
| ring_group_name | Unknown | PK |
| ring_attempt_id | Unknown | PK, FK |

### ring_attempt

| Column | Type | Keys |
| --- | --- | --- |
| ring_attempt_id | Unknown | PK |
| contact_id | Unknown | FK |
| interaction_id | Unknown | FK |
| user_email | Unknown | FK |
| attempt_type | Unknown |  |
| batch_ring_id | Unknown |  |
| ring_attempt_duration | Unknown |  |
| ring_finished_at_time | Unknown |  |
| ring_started_at_time | Unknown |  |
| team_name | Unknown |  |

### call_tag

| Column | Type | Keys |
| --- | --- | --- |
| ring_group_name | Unknown | PK |
| interaction_id | Unknown | PK, FK |

### call

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_disconnected | Unknown |  |
| agent_name | Unknown |  |
| agent_speed_to_answer | Unknown |  |
| call_type | Unknown |  |
| callback_from_queue | Unknown |  |
| calls_historical_base_data_status | Unknown |  |
| csat_score | Unknown |  |
| csat_survey_time | Unknown |  |
| customer_phone_number | Unknown |  |
| description | Unknown |  |
| disposition_code | Unknown |  |
| disposition_set | Unknown |  |
| end_time | Unknown |  |
| float_custom_field_n_1 | Unknown |  |
| float_custom_field_n_2 | Unknown |  |
| handling_agent | Unknown |  |
| hangup | Unknown |  |
| holding_time | Unknown |  |
| in_business_hours | Unknown |  |
| int_custom_field_n_1 | Unknown |  |
| int_custom_field_n_2 | Unknown |  |
| ivr_options | Unknown |  |
| mood | Unknown |  |
| mood_prompted | Unknown |  |
| nested_disposition | Unknown |  |
| phone_display_name | Unknown |  |
| rating | Unknown |  |
| rating_reason | Unknown |  |
| record | Unknown |  |
| start_time | Unknown |  |
| talk_time | Unknown |  |
| talkdesk_phone_number | Unknown |  |
| team | Unknown |  |
| text_custom_field_n_1 | Unknown |  |
| text_custom_field_n_2 | Unknown |  |
| text_custom_field_n_3 | Unknown |  |
| text_custom_field_n_4 | Unknown |  |
| timestamp_custom_field_n_1 | Unknown |  |
| transfer | Unknown |  |
| user_email | Unknown |  |
| waiting_time | Unknown |  |

### qm_evaluation_analysis_ring_group

| Column | Type | Keys |
| --- | --- | --- |
| ring_group_name | Unknown | PK |
| evaluation_id | Unknown | PK, FK |

### qm_evaluation_analysis

| Column | Type | Keys |
| --- | --- | --- |
| evaluation_id | Unknown | PK |
| question_id | Unknown | PK |
| agent_id | Unknown | FK |
| evaluator_id | Unknown | FK |
| interaction_id | Unknown | FK |
| branch_to | Unknown |  |
| evaluation_max_score | Unknown |  |
| evaluation_obtained_score | Unknown |  |
| evaluation_time | Unknown |  |
| evaluation_version | Unknown |  |
| first_evaluated_on | Unknown |  |
| form_element_mandatory | Unknown |  |
| form_id | Unknown |  |
| form_name | Unknown |  |
| header_id | Unknown |  |
| header_text | Unknown |  |
| interaction_channel | Unknown |  |
| interaction_date | Unknown |  |
| interaction_direction | Unknown |  |
| interaction_reference | Unknown |  |
| interaction_source | Unknown |  |
| interaction_type | Unknown |  |
| question_answer | Unknown |  |
| question_max_score | Unknown |  |
| question_obtained_score | Unknown |  |
| question_text | Unknown |  |
| question_type | Unknown |  |
| section_id | Unknown |  |
| section_max_score | Unknown |  |
| section_name | Unknown |  |
| section_obtained_score | Unknown |  |
| team_name | Unknown |  |

### do_not_call_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| created_at | Instant |  |
| entries_count | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| teams | Json |  |
| updated_at | Instant |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_name | Unknown |  |
| created_at | Instant |  |
| email | Unknown |  |
| name | Unknown |  |
| timezone | Unknown |  |

## Relationships

- guardian_user_role_change(guardian_user_id) → guardian_user(id)
- guardian_user_ring_group(guardian_user_id) → guardian_user(id)
- user_attribute(id) → users(id)
- user_attribute(attribute_id) → attribute(id)
- outbound_dialer_calls(campaign_id) → campaign(id)
- outbound_dialer_calls(campaign_transferred_agent_id) → users(id)
- outbound_dialer_calls(record_id) → record(id)
- outbound_dialer_calls(campaign_agent_id) → users(id)
- outbound_dialer_calls(interaction_id) → call(id)
- campaign_user(id) → users(id)
- campaign_user(campaign_id) → campaign(id)
- record_phone_number(record_id) → record(id)
- record(record_list_id) → record_list(id)
- case_dict_field(case_field_id) → case_field(id)
- contact_phone(contact_id) → contact(id)
- csat_score(agent_id) → users(id)
- talk_time_data(agent_id) → users(id)
- acw_time_data(agent_id) → users(id)
- studio_flow_execution(interaction_id) → call(id)
- wallets(account_id) → account(id)
- guardian_case(user_id) → guardian_user(id)
- user_ring_group(user_id) → users(id)
- qm_evaluation_score_ring_group(agent_id) → qm_evaluation_score(agent_id)
- qm_evaluation_score_ring_group(qm_evaluation_score_evaluation_time) → qm_evaluation_score(evaluation_time)
- qm_evaluation_score(agent_id) → users(id)
- campaign_phone_number(campaign_id) → campaign(id)
- messaging_contact_queue(messaging_contact_id) → messaging_contact(contact_id)
- messaging_contact_handling_queue(messaging_contact_id) → messaging_contact(contact_id)
- messaging_contact(user_id) → users(id)
- messaging_contact(virtual_agent_id) → users(id)
- messaging_contact(interaction_id) → call(id)
- messaging_contact(contact_id) → contact(id)
- campaign_record_chain(campaign_id) → campaign(id)
- campaign_calling_hour(campaign_id) → campaign(id)
- contact_call_handling_ring_group(contact_call_id) → contact_call(contact_id)
- contact_call_ring_group(contact_call_id) → contact_call(contact_id)
- contact_call(user_id) → users(id)
- contact_call(interaction_id) → call(id)
- messaging_traffic(user_id) → users(id)
- messaging_traffic(interaction_id) → call(id)
- messaging_traffic(contact_id) → contact(id)
- hold_time_data(agent_id) → users(id)
- do_not_call_number(do_not_call_list_id) → do_not_call_list(id)
- campaign_do_not_call_list(id) → do_not_call_list(id)
- campaign_do_not_call_list(campaign_id) → campaign(id)
- record_list(account_id) → account(id)
- guardian_session(user_id) → guardian_user(id)
- campaign_record_list(id) → record_list(id)
- campaign_record_list(campaign_id) → campaign(id)
- guardian_call_quality(interaction_id) → call(id)
- guardian_call_quality(user_id) → guardian_user(id)
- attribute(category_id) → attribute_category(id)
- user_status_ring_group(user_id) → user_status(user_id)
- user_status_ring_group(user_status_start_at) → user_status(status_start_at)
- user_status(user_id) → users(id)
- case_custom_field(case_id) → cases(id)
- case_note(case_id) → cases(id)
- cases(agent_id) → users(id)
- advanced_dialer_call(list_id) → record_list(id)
- advanced_dialer_call(campaign_id) → campaign(id)
- advanced_dialer_call(agent_id) → users(id)
- advanced_dialer_call(transferred_agent_id) → users(id)
- advanced_dialer_call(contact_id) → contact(id)
- feedback_flow(interaction_id) → call(id)
- inbound_contact_volume(agent_id) → users(id)
- ring_attempt_queue(ring_attempt_id) → ring_attempt(ring_attempt_id)
- ring_attempt(user_email) → users(email)
- ring_attempt(interaction_id) → call(id)
- ring_attempt(contact_id) → contact(id)
- call_tag(interaction_id) → call(id)
- qm_evaluation_analysis_ring_group(evaluation_id) → qm_evaluation_analysis(evaluation_id)
- qm_evaluation_analysis(evaluator_id) → users(id)
- qm_evaluation_analysis(agent_id) → users(id)
- qm_evaluation_analysis(interaction_id) → call(id)
- do_not_call_list(account_id) → account(id)