Description: Child table derived from the nested structure of evaluation extracted from Genesys Cloud.
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__QUESTION_GROUPS {
string id PK
string name
string form_id
string type
boolean exported
string _sdc_source_key_id
bigint _sdc_sequence
bigint _sdc_level_0_id
}
EVALUATION__QUESTION_GROUP_SCORE }o--|| EVALUATION : evaluation_id
EVALUATION__QUESTION_GROUP_SCORE }o--|| FORM__QUESTION_GROUPS : question_group_id
| Source table |
Source column |
Target column |
| - |
- |
- |