Simplesat
Explore the interactive ERD
Table & Field Reference
answer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
question_id | Unknown | FK |
response_id | Unknown | FK |
survey_id | Unknown | FK |
choice | Unknown | |
choice_label | Unknown | |
choices | Json | |
comment | Unknown | |
created | Unknown | |
follow_up_answer | Unknown | |
follow_up_answer_choice | Unknown | |
follow_up_answer_choices | Json | |
modified | Unknown | |
published_as_testimonial | Unknown | |
sentiment | Unknown |
response_team_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
response_id | Unknown | PKFK |
created | Unknown | |
custom_attributes | Json | |
email | Unknown | |
external_id | Unknown | |
modified | Unknown | |
name | Unknown |
response_answer
| Column | Type | Keys |
|---|---|---|
answer_id | Unknown | PKFK |
response_id | Unknown | PKFK |
response_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
response_id | Unknown | PKFK |
response
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
survey_id | Unknown | FK |
created | Unknown | |
customer_company | Unknown | |
customer_custom_attributes | Unknown | |
customer_email | Unknown | |
customer_external_id | Unknown | |
customer_id | Unknown | |
customer_name | Unknown | |
customer_tags | Unknown | |
ip_address | Unknown | |
modified | Unknown | |
source | Unknown | |
team_member_id | Unknown | |
ticket_custom_attributes | Json | |
ticket_external_id | Unknown | |
ticket_id | Unknown | |
ticket_subject | Unknown |
survey
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
brand_name | Unknown | |
metric | Unknown | |
name | Unknown | |
survey_token | Unknown | |
survey_type | Unknown |
question_rule
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
question_id | Unknown | PKFK |
action | Unknown | |
conditions | Json | |
question | Json |
question
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
survey_id | Unknown | FK |
choices | Json | |
metric | Unknown | |
orders | Unknown | |
rating_scale | Unknown | |
required | Unknown | |
text | Unknown |