Description: Interaction quality evaluations.
Loading diagram…
erDiagram
EVALUATION {
string evaluation_id PK
string evaluator_id
string agent_id
string conversation_id
boolean agent_reviewed
datetime assigned_date
string media_type
string evaluation_form_id
string evaluation_form_name
float total_score
string comments
string status
string agent_comments
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
datetime changed_date
}
EVALUATION__QUESTION_GROUP_SCORE {
string question_group_id PK
string evaluation_id PK
boolean exported
string _sdc_source_key_evaluation_id
bigint _sdc_sequence
bigint _sdc_level_0_id
}
FORM {
string id PK
string name
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
USERS {
string id PK
string name
string division__id
string department
string email
string state
string title
string username
string manager__id
float version
string employer_info__official_name
string employer_info__employee_id
string employer_info__employee_type
string employer_info__date_hire
string routing_status__status
datetime routing_status__start_time
string presence__id
string presence__name
string presence__source
boolean presence__primary
string presence__presence_definition__id
string presence__presence_definition__system_presence
string presence__message
datetime presence__modified_date
string team__id
string team__name
string team__description
datetime team__date_modified
float team__member_count
boolean acd_auto_answer
string language_preference
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
EVALUATION }o--|| USERS : agent_id
EVALUATION }o--|| FORM : evaluation_form_id
EVALUATION }o--|| USERS : evaluator_id
EVALUATION__QUESTION_GROUP_SCORE }o--|| EVALUATION : evaluation_id
| Source column |
Target table |
Target column |
agent_id |
users |
id |
evaluation_form_id |
form |
id |
evaluator_id |
users |
id |