# Survicate schema ERD

Table and field reference for the Fivetran Survicate connector.

## Table & Field Reference

### question_answer_choice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| question_id | Unknown | PK, FK |
| survey_id | Unknown | PK, FK |
| content | Unknown |  |

### question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| introduction | Unknown |  |
| question | Unknown |  |
| type | Unknown |  |

### response

| Column | Type | Keys |
| --- | --- | --- |
| uuid | Unknown | PK |
| survey_id | Unknown | FK |
| collected_at | Unknown |  |
| device_type | Unknown |  |
| languages | Unknown |  |
| operating_system | Unknown |  |
| respondent_attributes | Json |  |
| respondent_uuid | Unknown |  |
| url | Unknown |  |

### nps_response

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| response_uuid | Unknown | PK, FK |
| survey_id | Unknown | FK |
| answer_content | Unknown |  |
| answer_tag | Unknown |  |

### text_response

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| response_uuid | Unknown | PK, FK |
| survey_id | Unknown | FK |
| answer | Unknown |  |

### smiley_scale_response

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| response_uuid | Unknown | PK, FK |
| survey_id | Unknown | FK |
| answer_content | Unknown |  |
| answer_id | Unknown |  |
| answer_rating | Unknown |  |

### ranking_response

| Column | Type | Keys |
| --- | --- | --- |
| answer_id | Unknown | PK |
| question_id | Unknown | PK |
| response_uuid | Unknown | PK |
| answer_content | Unknown |  |
| answer_rank | Unknown |  |
| survey_id | Unknown |  |

### form_response

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| response_uuid | Unknown | FK |
| survey_id | Unknown | FK |
| field_content | Unknown |  |
| field_type | Unknown |  |
| question_id | Unknown |  |

### button_next_response

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| response_uuid | Unknown | PK, FK |
| survey_id | Unknown | FK |
| action_performed | Unknown |  |

### empty_response

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| response_uuid | Unknown | PK, FK |
| survey_id | Unknown | FK |
| action_performed | Unknown |  |

### single_response

| Column | Type | Keys |
| --- | --- | --- |
| answer_id | Unknown | PK |
| question_id | Unknown | PK |
| response_uuid | Unknown | PK, FK |
| survey_id | Unknown | FK |
| answer_comment | Unknown |  |
| answer_content | Unknown |  |

### numerical_scale_response

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| response_uuid | Unknown | PK, FK |
| survey_id | Unknown | FK |
| answer_comment | Unknown |  |
| answer_content | Unknown |  |
| answer_disclaimer_accepted | Unknown |  |
| answer_id | Unknown |  |
| answer_rating | Unknown |  |
| answer_translated_comment | Unknown |  |

### matrix_response

| Column | Type | Keys |
| --- | --- | --- |
| answer_id | Unknown | PK |
| question_id | Unknown | PK |
| response_uuid | Unknown | PK |
| answer_content | Unknown |  |
| answer_score | Unknown |  |
| survey_id | Unknown |  |

### rating_response

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| response_uuid | Unknown | PK, FK |
| survey_id | Unknown | FK |
| answer_content | Unknown |  |
| answer_id | Unknown |  |
| answer_rating | Unknown |  |

### date_response

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| response_uuid | Unknown | PK, FK |
| survey_id | Unknown | FK |
| answer | Unknown |  |

### multiple_response

| Column | Type | Keys |
| --- | --- | --- |
| answer_id | Unknown | PK |
| question_id | Unknown | PK |
| response_uuid | Unknown | PK, FK |
| survey_id | Unknown | FK |
| answer_comment | Unknown |  |
| answer_content | Unknown |  |
| question_type | Unknown |  |

### dropdown_response

| Column | Type | Keys |
| --- | --- | --- |
| answer_id | Unknown | PK |
| question_id | Unknown | PK |
| response_uuid | Unknown | PK, FK |
| survey_id | Unknown | FK |
| answer_comment | Unknown |  |
| answer_content | Unknown |  |

### survey

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| enabled | Unknown |  |
| launch_end_at | Unknown |  |
| launch_response_limit | Unknown |  |
| launch_start_at | Unknown |  |
| name | Unknown |  |
| response | Unknown |  |
| type | Unknown |  |

### respondent_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| response_respondent_uuid | Unknown |  |
| value | Unknown |  |

## Relationships

- question_answer_choice(question_id) → question(id)
- question_answer_choice(survey_id) → question(survey_id)
- question(survey_id) → survey(id)
- response(survey_id) → survey(id)
- nps_response(response_uuid) → response(uuid)
- nps_response(survey_id) → response(survey_id)
- text_response(response_uuid) → response(uuid)
- text_response(survey_id) → response(survey_id)
- smiley_scale_response(response_uuid) → response(uuid)
- smiley_scale_response(survey_id) → response(survey_id)
- form_response(response_uuid) → response(uuid)
- form_response(survey_id) → response(survey_id)
- button_next_response(response_uuid) → response(uuid)
- button_next_response(survey_id) → response(survey_id)
- empty_response(response_uuid) → response(uuid)
- empty_response(survey_id) → response(survey_id)
- single_response(response_uuid) → response(uuid)
- single_response(survey_id) → response(survey_id)
- numerical_scale_response(response_uuid) → response(uuid)
- numerical_scale_response(survey_id) → response(survey_id)
- rating_response(response_uuid) → response(uuid)
- rating_response(survey_id) → response(survey_id)
- date_response(response_uuid) → response(uuid)
- date_response(survey_id) → response(survey_id)
- multiple_response(response_uuid) → response(uuid)
- multiple_response(survey_id) → response(survey_id)
- dropdown_response(response_uuid) → response(uuid)
- dropdown_response(survey_id) → response(survey_id)