Playvox
Explore the interactive ERD
Table & Field Reference
evaluation_collaborator
| Column | Type | Keys |
|---|---|---|
collaborator_id | Unknown | PK |
evaluation_id | Unknown | PKFK |
evaluation_section_answer
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
evaluation_id | Unknown | FK |
evaluation_section_id | Unknown | FK |
answer_id | Unknown | |
answer_type | Unknown | |
comment | Unknown | |
feedback | Json | |
question_id | Unknown | |
value | Unknown |
evaluation_section_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
evaluation_id | Unknown | PKFK |
evaluation_section_id | Unknown | PKFK |
value | Unknown |
evaluation_section
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
evaluation_id | Unknown | PKFK |
comment | Unknown | |
passed | Unknown | |
score | Unknown | |
type_fail | Unknown |
evaluation_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
evaluation_id | Unknown | PKFK |
value | Unknown |
evaluation_coaching
| Column | Type | Keys |
|---|---|---|
coaching_id | Unknown | PK |
evaluation_id | Unknown | PKFK |
coaching_sequence | Unknown |
evaluation_subscriber
| Column | Type | Keys |
|---|---|---|
evaluation_id | Unknown | PKFK |
subscriber_id | Unknown | PKFK |
evaluation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_id | Unknown | FK |
calibration_id | Unknown | FK |
monitor_id | Unknown | FK |
scorecard_id | Unknown | FK |
team_id | Unknown | FK |
team_leader_id | Unknown | FK |
agent_agree | Unknown | |
attachments | Json | |
comments | Json | |
created_at | Unknown | |
date_created | Unknown | |
entity_id | Unknown | |
evaluation_time | Unknown | |
event_subtype | Unknown | |
event_type | Unknown | |
feedback | Unknown | |
interaction_id | Unknown | |
migrated | Unknown | |
passed | Unknown | |
reference | Unknown | |
rules_applied | Json | |
schedule_date | Unknown | |
score | Unknown | |
score_avg | Unknown | |
sequence | Unknown | |
site_id | Unknown | |
status | Unknown | |
total_errors | Unknown | |
type | Unknown | |
updated_at | Instant | |
workload_history_id | Unknown | |
workload_id | Unknown |
coaching_coach_id
| Column | Type | Keys |
|---|---|---|
coach_id | Unknown | PKFK |
coaching_id | Unknown | PKFK |
coaching_team
| Column | Type | Keys |
|---|---|---|
coaching_id | Unknown | PKFK |
team_id | Unknown | PKFK |
coaching_collaborator
| Column | Type | Keys |
|---|---|---|
collaborator_id | Unknown | PK |
coaching_id | Unknown | PKFK |
coaching_coach_log_interaction
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
coaching_id | Unknown | FK |
date | Unknown | |
followup | Unknown | |
opens | Unknown |
coaching_trainee_log_interaction
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
coaching_id | Unknown | FK |
date | Unknown | |
followup | Unknown | |
opens | Unknown |
coaching_evaluation
| Column | Type | Keys |
|---|---|---|
coaching_id | Unknown | PKFK |
evaluation_id | Unknown | PKFK |
coaching_kpi
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
coaching_id | Unknown | PKFK |
threshold_value | Unknown |
coaching
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
trainee_id | Unknown | FK |
achieved | Unknown | |
attachments | Json | |
coach_log_last_followup | Unknown | |
coach_log_total_followups | Unknown | |
coach_log_total_opens | Unknown | |
created_at | Unknown | |
custom_area_id | Unknown | |
custom_area_title | Unknown | |
data_after_end | Unknown | |
data_after_start | Unknown | |
data_before_end | Unknown | |
data_before_start | Unknown | |
ent_id | Unknown | |
entity_id | Unknown | |
entity_type | Unknown | |
feedback | Unknown | |
flag_coach | Unknown | |
follow_up | Unknown | |
form_id | Unknown | |
messages_read | Unknown | |
messages_total | Unknown | |
satisfaction | Json | |
scorecard_id | Unknown | |
scorecard_name | Unknown | |
scorecard_status | Unknown | |
seen_coach | Unknown | |
seen_trainee | Unknown | |
sequence | Unknown | |
site_id | Unknown | |
snapshots | Json | |
stage_id | Unknown | |
status | Unknown | |
trainee_agree_date | Unknown | |
trainee_agree_signed | Unknown | |
updated_at | Instant |
user_role
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
user_id | Unknown | PKFK |
role | Unknown |
user_status_log
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
user_id | Unknown | FK |
changed_by | Unknown | |
ended_to | Unknown | |
reason | Unknown | |
started_from | Unknown | |
status | Unknown | |
type | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
assigned_last_date_reward | Unknown | |
auth_hash | Unknown | |
auth_overwrite | Json | |
avatar | Unknown | |
change_password | Unknown | |
created_at | Unknown | |
created_at_readable | Unknown | |
current_ui | Unknown | |
deactivated_by | Unknown | |
deactivation_reason | Unknown | |
deactivation_type | Unknown | |
email | Unknown | |
ent_id | Unknown | |
external_profile | Json | |
first_login_date | Unknown | |
founder | Unknown | |
full_name | Unknown | |
google_id | Unknown | |
ignore_notifications | Json | |
integration_intercom | Unknown | |
interaction_scorecard | Unknown | |
invisible | Unknown | |
lang | Unknown | |
languages | Json | |
last_feed_view | Json | |
last_login_date | Unknown | |
last_name | Unknown | |
last_notifications_view | Unknown | |
last_seen_at | Unknown | |
light | Unknown | |
name | Unknown | |
onboarding_completed | Unknown | |
profile_about_me | Unknown | |
profile_birthdate | Unknown | |
profile_start_date | Unknown | |
provisioning | Json | |
saml_id | Unknown | |
site_id | Unknown | |
stats | Unknown | |
status | Unknown | |
time_zone_id | Unknown | |
times_assigned_reward | Unknown | |
total_invitations_sent | Unknown | |
type | Unknown | |
tz | Unknown | |
updated_at | Instant | |
updated_at_readable | Unknown | |
username | Unknown | |
custom_** |
integration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
created_at | Unknown | |
description | Unknown | |
ent_id | Unknown | |
metadata | Json | |
name | Unknown | |
settings_data_storage_minutes | Unknown | |
settings_delete_only_non_audited_interactions | Unknown | |
site_id | Unknown | |
status | Unknown | |
updated_at | Unknown |
campaign_user
| Column | Type | Keys |
|---|---|---|
campaign_id | Unknown | PKFK |
user_id | Unknown | PKFK |
campaign_data_source
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | PKFK |
connector_id | Unknown | |
type | Unknown |
campaign_kpi
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | PKFK |
code | Unknown | |
custom_ranges_colors | Unknown | |
custom_threshold_value | Unknown | |
name | Unknown | |
threshold_direction | Unknown | |
threshold_value | Unknown | |
type | Unknown | |
unit_id | Unknown | |
weight | Unknown |
campaign_team_leader_info
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
campaign_id | Unknown | PKFK |
avatar | Unknown | |
email | Unknown | |
last_name | Unknown | |
name | Unknown | |
status | Unknown | |
username | Unknown |
campaign
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
created_at_readable | Unknown | |
created_by | Unknown | |
default_filters | Unknown | |
is_published | Unknown | |
latest_entry | Unknown | |
name | Unknown | |
site_id | Unknown | |
status | Unknown | |
team_id | Unknown | |
updated_at | Instant | |
updated_at_readable | Unknown |
job_completed
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
interaction_id | Unknown |
job_failed
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
job_id | Unknown | PKFK |
error | Unknown | |
interaction_id | Unknown |
job
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
created_by | Unknown | |
ent_id | Unknown | |
site_id | Unknown | |
status | Unknown | |
total | Unknown | |
total_completed | Unknown | |
total_failed | Unknown | |
updated_at | Unknown |
course_record
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
activity_id | Unknown | |
created_at | Unknown | |
extra_finished | Unknown | |
extra_finished_at | Unknown | |
learner_id | Unknown | |
progress | Unknown | |
time | Unknown |
role_read
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
role_id | Unknown | PKFK |
read | Unknown |
role_write
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
role_id | Unknown | PKFK |
write | Unknown |
role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
code | Unknown | |
created_at | Unknown | |
created_at_readable | Unknown | |
defaults | Unknown | |
description | Unknown | |
name | Unknown | |
role_inherit | Unknown | |
site_id | Unknown | |
updated_at | Instant | |
updated_at_readable | Unknown |
scorecard_team
| Column | Type | Keys |
|---|---|---|
scorecard_id | Unknown | PKFK |
team_id | Unknown | PKFK |
scorecard_section_question_answer_feedback_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
scorecard_answer_id | Unknown | PKFK |
scorecard_feedback_id | Unknown | PKFK |
scorecard_id | Unknown | PKFK |
scorecard_question_id | Unknown | PKFK |
scorecard_section_id | Unknown | PKFK |
value | Unknown |
scorecard_section_question_answer_feedback
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
scorecard_answer_id | Unknown | PKFK |
scorecard_id | Unknown | PKFK |
scorecard_question_id | Unknown | PKFK |
scorecard_section_id | Unknown | PKFK |
label | Unknown | |
required | Unknown | |
type | Unknown |
scorecard_section_question_answer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
scorecard_id | Unknown | PKFK |
scorecard_question_id | Unknown | PKFK |
scorecard_section_id | Unknown | PKFK |
format | Unknown | |
group_fail | Unknown | |
label | Unknown | |
type | Unknown | |
value | Unknown |
scorecard_section_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
scorecard_id | Unknown | PKFK |
scorecard_section_id | Unknown | PKFK |
component | Unknown | |
description | Unknown | |
group_id | Unknown | |
step | Unknown | |
tip | Unknown | |
type | Unknown |
scorecard_section
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
scorecard_id | Unknown | PKFK |
max_score | Unknown | |
name | Unknown | |
type | Unknown | |
weight | Unknown |
scorecard_custom_field_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
scorecard_custom_field_id | Unknown | PKFK |
scorecard_id | Unknown | PKFK |
value | Unknown |
scorecard_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
scorecard_id | Unknown | PKFK |
label | Unknown | |
operation | Unknown | |
required | Unknown | |
type | Unknown |
scorecard
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
checkbox_threshold | Unknown | |
cloned_from | Unknown | |
created_at | Unknown | |
created_at_readable | Unknown | |
created_by | Unknown | |
custom_reports | Json | |
description | Unknown | |
effectiveness_goal | Unknown | |
evaluations_scheduled | Unknown | |
last_evaluation | Unknown | |
last_evaluation_readable | Unknown | |
max_score | Unknown | |
name | Unknown | |
pre_check_answers | Unknown | |
reference_name | Unknown | |
reference_required | Unknown | |
site_id | Unknown | |
status | Unknown | |
target | Unknown | |
total_questions | Unknown | |
two_steps_approval | Unknown | |
type | Unknown | |
updated_at | Instant | |
updated_at_readable | Unknown |
course_skill
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
course_id | Unknown | PKFK |
title | Unknown |
course
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
approval_percent | Unknown | |
created_at | Unknown | |
deadline_date | Unknown | |
deadline_days | Unknown | |
deadline_type | Unknown | |
enrollment_approval | Unknown | |
order_type | Unknown | |
public | Unknown | |
site_id | Unknown | |
status | Unknown | |
title | Unknown | |
updated_at | Instant |
calibration_analyst_section_question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
calibration_analyst_id | Unknown | PKFK |
calibration_analyst_section_id | Unknown | PKFK |
calibration_id | Unknown | PKFK |
is_calibrated | Unknown |
calibration_analyst_section
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
calibration_analyst_id | Unknown | PKFK |
calibration_id | Unknown | PKFK |
percentage | Unknown | |
type_fail | Unknown |
calibration_analyst
| Column | Type | Keys |
|---|---|---|
calibration_id | Unknown | PKFK |
id | Unknown | PKFK |
qa_score | Unknown | |
results_answers_equals | Unknown | |
results_answers_score | Unknown | |
scorecard_answer_date | Unknown | |
scorecard_answer_id | Unknown |
calibration_collaborator
| Column | Type | Keys |
|---|---|---|
calibration_id | Unknown | PKFK |
collaborator_id | Unknown | PKFK |
calibration_category
| Column | Type | Keys |
|---|---|---|
category_id | Unknown | PK |
calibration_id | Unknown | PKFK |
calibration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_id | Unknown | FK |
interaction_id | Unknown | FK |
scorecard_id | Unknown | FK |
team_id | Unknown | FK |
auto_fill_evaluation | Unknown | |
calibration_is_ready_to_update_after_completed | Unknown | |
category_ids | Unknown | |
comments | Unknown | |
completed_at | Unknown | |
created_at | Unknown | |
created_at_readable | Unknown | |
created_by | Unknown | |
due_date | Unknown | |
expert_id | Unknown | |
interaction_reference | Unknown | |
review_scorecard_id | Unknown | |
scorecard_answer_id_reference | Unknown | |
sequence | Unknown | |
site_id | Unknown | |
status | Unknown | |
summary_answers_score | Unknown | |
summary_answers_total | Unknown | |
type | Unknown | |
update_after_completed | Unknown | |
updated_at | Instant | |
updated_at_readable | Unknown | |
validate_fail_answers | Unknown | |
workload_history_id | Unknown | |
workload_id | Unknown |
dispute_reason_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
dispute_id | Unknown | PKFK |
dispute_reason_id | Unknown | PKFK |
user_id | Unknown | FK |
created_at | Unknown | |
message | Unknown |
dispute_reason
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
dispute_id | Unknown | PKFK |
accepted | Unknown | |
answer_feedback | Unknown | |
answer_id | Unknown | |
answer_value | Unknown | |
parent_id | Unknown | |
parent_type | Unknown | |
previous_answer_id | Unknown | |
previous_answer_value | Unknown | |
reference_id | Unknown | |
reference_type | Unknown |
dispute_assignation_log
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
dispute_id | Unknown | FK |
user_id | Unknown | FK |
assigned_at | Unknown | |
changed_by | Unknown |
dispute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_id | Unknown | FK |
arbitrator_id | Unknown | FK |
requester_id | Unknown | FK |
responsible_id | Unknown | FK |
scorecard_id | Unknown | FK |
team_id | Unknown | FK |
category_ids | Json | |
closed_at | Unknown | |
collaborator_ids | Json | |
created_at | Unknown | |
ent_id | Unknown | |
entity_id | Unknown | |
entity_type | Unknown | |
evaluated_at | Unknown | |
expired_at | Unknown | |
last_opened_at | Unknown | |
previous_score | Unknown | |
resolution_for | Unknown | |
resolved_by | Unknown | |
score | Unknown | |
sequence | Unknown | |
site_id | Unknown | |
started_at | Instant | |
status | Unknown | |
total_reopens | Unknown | |
type | Unknown | |
updated_at | Unknown |
custom_field_option
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
custom_field_id | Unknown | PKFK |
value | Unknown |
custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
code | Unknown | |
created_at | Unknown | |
created_by | Unknown | |
entity_type | Unknown | |
is_valid | Unknown | |
name | Unknown | |
position | Unknown | |
required | Unknown | |
site_id | Unknown | |
type | Unknown | |
updated_at | Instant |
team_leader
| Column | Type | Keys |
|---|---|---|
team_id | Unknown | PKFK |
team_leader_id | Unknown | PKFK |
team_user
| Column | Type | Keys |
|---|---|---|
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
created_by | Unknown | |
defaults | Unknown | |
description | Unknown | |
name | Unknown | |
site_id | Unknown | |
status | Unknown | |
total_users | Unknown | |
updated_at | Instant |
course_stat
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
activities | Unknown | |
learners | Unknown | |
learners_completed | Unknown | |
learners_in_progress | Unknown | |
learners_not_started | Unknown | |
learners_overdue | Unknown | |
time_spent | Unknown |
workload_assignment_stat_interaction
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
workload_assignment_id | Unknown | PKFK |
workload_assignment_stat_id | Unknown | PKFK |
evaluation_id | Unknown | FK |
user_id | Unknown | FK |
completed | Unknown | |
id | Unknown |
workload_assignment_stat
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
workload_assignment_id | Unknown | PKFK |
completed | Unknown | |
goal | Unknown | |
progress | Unknown | |
workload | Unknown |
workload_assignment_filters
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
workload_assignment_id | Unknown | FK |
field | Unknown | |
filterable | Unknown | |
groups | Unknown | |
label | Unknown | |
operator | Unknown | |
type | Unknown | |
value | Unknown |
workload_assignment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
created_at_readable | Unknown | |
custom_data_assignation_date | Unknown | |
custom_data_connector_id | Unknown | |
custom_data_date_filter_field | Unknown | |
custom_data_days | Unknown | |
custom_data_due_date | Unknown | |
custom_data_entity | Unknown | |
custom_data_errors | Json | |
custom_data_lock_date_range | Unknown | |
custom_data_pull_data | Unknown | |
custom_data_segment_id | Unknown | |
custom_data_type | Unknown | |
custom_data_users_without_interactions | Json | |
ent_id | Unknown | |
normalized_interactions | Unknown | |
site_id | Unknown | |
status | Unknown | |
total_assigned_interactions | Unknown | |
total_expected_interactions | Unknown | |
type | Unknown | |
updated_at | Instant | |
updated_at_readable | Unknown | |
workload_id | Unknown |
interaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
interaction_id | Unknown | PK |
integration_id | Unknown | FK |
assignee_id | Unknown | |
author_id | Unknown | |
collaborators | Json | |
created_at | Unknown | |
created_by | Unknown | |
custom_ranges_colors | Unknown | |
ent_id | Unknown | |
interaction_date | Unknown | |
is_deleted | Unknown | |
priority | Unknown | |
site_id | Unknown | |
tags | Json | |
type | Unknown | |
updated_at | Unknown |