Talkdesk
Explore the interactive ERD
Table & Field Reference
guardian_user_role_change
| Column | Type | Keys |
|---|---|---|
role | Unknown | PK |
guardian_user_id | Unknown | PKFK |
assigned_at | Instant | |
assigned_by | Unknown |
guardian_user_ring_group
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
guardian_user_id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
name | Unknown | |
proficiency | Unknown | |
team | Unknown |
outbound_dialer_calls
| Column | Type | Keys |
|---|---|---|
interaction_id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
record_phone_number
| Column | Type | Keys |
|---|---|---|
type | Unknown | PK |
record_id | Unknown | PKFK |
number | Unknown |
record
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
record_list_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
ring_groups_name | Unknown | |
score | Unknown | |
team_id | Unknown |
talk_time_data
| Column | Type | Keys |
|---|---|---|
started_at | Unknown | PK |
agent_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
qm_evaluation_score_evaluation_time | Unknown | PKFK |
qm_evaluation_score
| Column | Type | Keys |
|---|---|---|
evaluation_time | Unknown | PK |
agent_id | Unknown | PKFK |
evaluation_max_score | Unknown | |
evaluation_obtained_score | Unknown | |
team_id | Unknown |
campaign_phone_number
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | PKFK |
phone_number | Unknown |
messaging_contact_queue
| Column | Type | Keys |
|---|---|---|
ring_group_name | Unknown | PK |
messaging_contact_id | Unknown | PKFK |
messaging_contact_handling_queue
| Column | Type | Keys |
|---|---|---|
ring_group_name | Unknown | PK |
messaging_contact_id | Unknown | PKFK |
messaging_contact
| Column | Type | Keys |
|---|---|---|
contact_id | Unknown | PKFK |
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 | PKFK |
max_attempts | Unknown | |
retry_period | Unknown | |
retry_period_time_unit | Unknown |
campaign_calling_hour
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | PKFK |
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 | PKFK |
contact_call_ring_group
| Column | Type | Keys |
|---|---|---|
ring_group_name | Unknown | PK |
contact_call_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
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 | PKFK |
id | Unknown | PKFK |
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 | PKFK |
user_status_start_at | Unknown | PKFK |
user_status
| Column | Type | Keys |
|---|---|---|
status_start_at | Unknown | PK |
user_id | Unknown | PKFK |
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 | PKFK |
key_name | Unknown | |
label | Unknown | |
name | Unknown | |
value | Unknown |
case_note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
case_id | Unknown | PKFK |
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 |
|---|---|---|
interaction_id | Unknown | PK |
agent_id | Unknown | FK |
campaign_id | Unknown | FK |
contact_id | Unknown | FK |
list_id | Unknown | FK |
transferred_agent_id | Unknown | FK |
advanced_dialer_interaction_id | Unknown | |
advanced_dialer_sip_hangup_code | Unknown | |
agent_disposition | Unknown | |
attempt_number | Unknown | |
call_finished_time | Unknown | |
call_started_time | Unknown | |
cli | Unknown | |
contact_external_id | Unknown | |
contact_phone_number | Unknown | |
dial_mode | Unknown | |
external_call_id | Unknown | |
is_callback | Unknown | |
notes | Unknown | |
ringing_at_customer | Unknown | |
system_disposition | Unknown | |
total_duration | Unknown |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 |
queue
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_waiting_music_type | Unknown | |
agent_waiting_music_value | Unknown | |
created_at | Instant | |
description | Unknown | |
maximum_waiting_time | Unknown | |
name | Unknown | |
offer_time | Unknown | |
updated_at | Instant |
account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_name | Unknown | |
created_at | Instant | |
email | Unknown | |
name | Unknown | |
timezone | Unknown |