Description: Quality evaluation forms.
Loading diagram…
erDiagram
CALIBRATIONS {
string id PK
string calibrator__id
string agent__id
string conversation__id
string evaluation_form__id
float average_score
float high_score
float low_score
datetime created_date
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
CALIBRATIONS__EVALUATIONS {
string id
string conversation__id
string evaluation_form__id
string evaluator__id
string agent__id
string calibration__id
float calibration__average_score
float calibration__high_score
float calibration__low_score
string status
float answers__total_score
float answers__total_critical_score
float answers__total_non_critical_score
boolean agent_has_read
datetime assigned_date
datetime created_date
boolean never_release
boolean exported
string _sdc_source_key_id
bigint _sdc_sequence
bigint _sdc_level_0_id
}
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
}
FORM {
string id PK
string name
boolean exported
datetime _sdc_received_at
bigint _sdc_sequence
bigint _sdc_table_version
datetime _sdc_batched_at
}
CALIBRATIONS }o--|| FORM : evaluation_form__id
CALIBRATIONS__EVALUATIONS }o--|| FORM : evaluation_form__id
EVALUATION }o--|| FORM : evaluation_form_id
| Source column |
Target table |
Target column |
| - |
- |
- |