REVIEWS.io
Explore the interactive ERD
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 | PKFK |
photo | Unknown |
review_video
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
review_and_question_id | Unknown | PKFK |
thumbnail | Unknown | |
video | Unknown |
review_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
review_and_question_id | Unknown | PKFK |
tags | Unknown |
review_reply
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
review_and_question_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
survey_response_id | Unknown | PKFK |
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 | PKFK |
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 |