# REVIEWS.io schema ERD

Table and field reference for the Fivetran REVIEWS.io connector.

## Table & Field Reference

### company_review_invitation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_email | Unknown |  |
| customer_name | Unknown |  |
| date_send | Unknown |  |
| email_sent | Unknown |  |
| order_id | Unknown |  |
| resent | Unknown |  |
| status | Unknown |  |

### product_review_invitation

| Column | Type | Keys |
| --- | --- | --- |
| product_id | Unknown | PK |
| service_feedback_email_id | Unknown | FK |
| brand | Unknown |  |
| description | Unknown |  |
| image | Unknown |  |
| name | Unknown |  |
| sku | Unknown |  |

### survey

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| question_count | Unknown |  |
| responses_count | Unknown |  |
| title | Unknown |  |

### review_nugget

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| review_id | Unknown | FK |
| date_created_nugget | Unknown |  |
| rating | Unknown |  |
| text | Unknown |  |
| type | Unknown |  |

### review_photo

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_and_question_id | Unknown | PK, FK |
| photo | Unknown |  |

### review_video

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_and_question_id | Unknown | PK, FK |
| thumbnail | Unknown |  |
| video | Unknown |  |

### review_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_and_question_id | Unknown | PK, FK |
| tags | Unknown |  |

### review_reply

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| review_and_question_id | Unknown | PK, FK |
| author_avatar | Unknown |  |
| author_name | Unknown |  |
| comment | Unknown |  |
| date_created | Unknown |  |

### review_and_question

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| author_location | Unknown |  |
| author_name | Unknown |  |
| comment | Unknown |  |
| date_created | Unknown |  |
| helpful_count | Unknown |  |
| nps | Unknown |  |
| order_id | Unknown |  |
| product_name | Unknown |  |
| rating | Unknown |  |
| sku | Unknown |  |
| source | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| type_label | Unknown |  |

### review_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| review_and_question_id | Unknown | PK, FK |
| kind | Unknown |  |
| label | Unknown |  |
| option | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### survey_response_answer

| Column | Type | Keys |
| --- | --- | --- |
| question_id | Unknown | PK |
| res_id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| survey_response_id | Unknown | PK, FK |
| question | Unknown |  |
| res_image_url | Unknown |  |
| res_response | Unknown |  |
| res_store_widget_survey_submission_id | Unknown |  |
| type | Unknown |  |
| widget_survey_active | Unknown |  |
| widget_survey_active_in_shopify | Unknown |  |
| widget_survey_answer_conditions | Unknown |  |
| widget_survey_condition_default | Unknown |  |
| widget_survey_date_created | Unknown |  |
| widget_survey_date_updated | Unknown |  |
| widget_survey_deleted | Unknown |  |
| widget_survey_filters | Unknown |  |
| widget_survey_follow_up | Unknown |  |
| widget_survey_image_capture | Unknown |  |
| widget_survey_mandatory | Unknown |  |
| widget_survey_options | Unknown |  |
| widget_survey_shopify | Unknown |  |
| widget_survey_show_as_button | Unknown |  |
| widget_survey_show_as_images | Unknown |  |
| widget_survey_show_follow_up | Unknown |  |
| widget_survey_store_id | Unknown |  |
| widget_survey_store_widget_survey_campaign_id | Unknown |  |
| widget_survey_thank_you | Unknown |  |
| widget_survey_title | Unknown |  |

### survey_response

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| survey_id | Unknown | PK, FK |
| browser | Unknown |  |
| completion_time | Unknown |  |
| country_code | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| href | Unknown |  |
| ip_address | Unknown |  |
| order_count | Unknown |  |
| tags | Unknown |  |
| total_price | Unknown |  |
| user_id | Unknown |  |

## Relationships

- product_review_invitation(service_feedback_email_id) → company_review_invitation(id)
- review_nugget(review_id) → review_and_question(id)
- review_photo(review_and_question_id) → review_and_question(id)
- review_video(review_and_question_id) → review_and_question(id)
- review_tag(review_and_question_id) → review_and_question(id)
- review_reply(review_and_question_id) → review_and_question(id)
- review_attribute(review_and_question_id) → review_and_question(id)
- survey_response_answer(survey_response_id) → survey_response(id)
- survey_response_answer(survey_id) → survey_response(survey_id)
- survey_response(survey_id) → survey(id)