# SurveyMonkey schema ERD

Table and field reference for the Fivetran SurveyMonkey connector.

## Table & Field Reference

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| email | String |  |
| first_name | String |  |
| last_name | String |  |
| phone_number | String |  |

### response_answer

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| question_id | String | PK, FK |
| response_id | String | PK, FK |
| response_page_id | String | PK, FK |
| choice_id | String |  |
| col_id | String |  |
| content_type | String |  |
| download_url | String |  |
| other_id | String |  |
| row_id | String |  |
| tag_data | Json |  |
| text | String |  |

### response_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| collector_id | String | FK |
| recipient_id | String | FK |
| survey_id | String | FK |
| collection_mode | String |  |
| created_at | Instant |  |
| custom_value | String |  |
| ip_address | String |  |
| response_status | String |  |
| total_time | Long |  |
| updated_at | Instant |  |

### recipient

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| message_id | String | FK |
| email | String |  |
| mail_status | String |  |
| phone_number | String |  |
| remove_link | String |  |
| survey_link | String |  |
| survey_response_status | String |  |

### survey_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| category_id | String | FK |
| folder_id | String | FK |
| analyze_url | String |  |
| collect_url | String |  |
| created_at | Instant |  |
| edit_url | String |  |
| footer | Boolean |  |
| href | String |  |
| is_owner | Boolean |  |
| language | String |  |
| nickname | String |  |
| page_count | Int |  |
| preview | String |  |
| question_count | Int |  |
| response_count | Int |  |
| summary_url | String |  |
| title | String |  |
| updated_at | Instant |  |
| buttons_text_** |  |  |

### question_option_history

| Column | Type | Keys |
| --- | --- | --- |
| position | Int | PK |
| question_id | String | PK, FK |
| description | String |  |
| id | String |  |
| is_na | Boolean |  |
| quiz_option_score | Int |  |
| text | String |  |
| visible | Boolean |  |
| weight | Int |  |

### sub_question_history

| Column | Type | Keys |
| --- | --- | --- |
| position | Int | PK |
| question_id | String | PK, FK |
| id | String |  |
| required | Boolean |  |
| text | String |  |
| type | String |  |
| visible | Boolean |  |

### contact_list_contact

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | String | PK, FK |
| contact_list_id | String | PK, FK |

### survey_page_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| survey_id | String | FK |
| description | String |  |
| href | String |  |
| position | Long |  |
| question_count | Int |  |
| title | String |  |

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| collector_id | String | FK |
| body | String |  |
| created_at | Instant |  |
| embed_first_question | Boolean |  |
| is_branding_enabled | Boolean |  |
| is_scheduled | Boolean |  |
| recipient_status | String |  |
| scheduled_date | Instant |  |
| status | String |  |
| subject | String |  |
| type | String |  |

### question_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| survey_page_id | String | PK, FK |
| family | String |  |
| forced_ranking | Boolean |  |
| position | Long |  |
| required_amount | String |  |
| required_text | String |  |
| required_type | String |  |
| sorting_ignore_last | Boolean |  |
| sorting_type | String |  |
| structure_metadata | Json |  |
| subtype | String |  |
| visible | Boolean |  |
| validation_** |  |  |

### collector

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| survey_id | String | FK |
| allow_multiple_responses | Boolean |  |
| anonymous_type | String |  |
| border_color | String |  |
| close_date | Instant |  |
| closed_page_message | String |  |
| created_at | Instant |  |
| display_survey_results | Boolean |  |
| disqualification_message | String |  |
| disqualification_url | String |  |
| edit_response_type | String |  |
| headline | String |  |
| height | Int |  |
| is_branding_enabled | Boolean |  |
| message | String |  |
| name | String |  |
| password_enabled | Boolean |  |
| primary_button_bg_color | String |  |
| primary_button_text | String |  |
| primary_button_text_color | String |  |
| redirect_type | String |  |
| redirect_url | String |  |
| sample_rate | String |  |
| secondary_button_bg_color | String |  |
| secondary_button_text | String |  |
| secondary_button_text_color | String |  |
| sender_email | String |  |
| status | String |  |
| thank_you_message | String |  |
| type | String |  |
| updated_at | Instant |  |
| url | String |  |
| width | Int |  |

### contact_list

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| name | String |  |

### response_page

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| response_id | String | PK, FK |

### survey_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| title | String |  |

### question_heading_history

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| question_id | String | PK, FK |
| description | String |  |
| heading | String |  |
| image_url | String |  |
| random_assignment_** |  |  |

### survey_category

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| name | String |  |

## Relationships

- response_answer(question_id) → question_history(id)
- response_answer(response_page_id) → response_page(id)
- response_answer(response_id) → response_history(id)
- response_history(survey_id) → survey_history(id)
- response_history(collector_id) → collector(id)
- response_history(recipient_id) → recipient(id)
- recipient(message_id) → message(id)
- survey_history(folder_id) → survey_folder(id)
- survey_history(category_id) → survey_category(id)
- question_option_history(question_id) → question_history(id)
- sub_question_history(question_id) → question_history(id)
- contact_list_contact(contact_list_id) → contact_list(id)
- contact_list_contact(contact_id) → contact(id)
- survey_page_history(survey_id) → survey_history(id)
- message(collector_id) → collector(id)
- question_history(survey_page_id) → survey_page_history(id)
- collector(survey_id) → survey_history(id)
- response_page(response_id) → response_history(id)
- question_heading_history(question_id) → question_history(id)