Description: Child table derived from the nested structure of evaluation extracted from Genesys Cloud.
Loading diagram…
erDiagram
EVALUATION__QUESTION_GROUP_SCORE__QUESTION_SCORES {
string question_id PK
string answer_id PK
float score
string comments
string question_group_id PK
boolean exported
string _sdc_source_key_evaluation_id
bigint _sdc_sequence
bigint _sdc_level_0_id
bigint _sdc_level_1_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
}
FORM__QUESTION_GROUPS__QUESTIONS {
string id PK
string question_group_id
string text
string helptext
boolean exported
string _sdc_source_key_id
bigint _sdc_sequence
bigint _sdc_level_0_id
bigint _sdc_level_1_id
}
FORM__QUESTION_GROUPS__QUESTIONS__ANSWER_OPTIONS {
string id PK
string text
float value
boolean exported
string _sdc_source_key_id
bigint _sdc_sequence
bigint _sdc_level_0_id
bigint _sdc_level_1_id
bigint _sdc_level_2_id
}
EVALUATION__QUESTION_GROUP_SCORE__QUESTION_SCORES }o--|| FORM__QUESTION_GROUPS__QUESTIONS__ANSWER_OPTIONS : answer_id
EVALUATION__QUESTION_GROUP_SCORE__QUESTION_SCORES }o--|| FORM__QUESTION_GROUPS : question_group_id
EVALUATION__QUESTION_GROUP_SCORE__QUESTION_SCORES }o--|| FORM__QUESTION_GROUPS__QUESTIONS : question_id
| Source table |
Source column |
Target column |
| - |
- |
- |