Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
id 🔑
person_id ➤ PERSON.id
comment
created_at
permalink
score
survey_type
updated_at
properties_*
RESPONSE ⇱
id 🔑
question_id ➤ QUESTION.id
response_id ➤ RESPONSE.id
free_response
name
scale
RESPONSE_ANSWER ⇱
id 🔑
response_answer_id 🔑 ➤ RESPONSE_ANSWER.id
extra_text
text
RESPONSE_ANSWER_SELECTION ⇱
id 🔑
response_id ➤ RESPONSE.id
user_email
text
created_at
RESPONSE_NOTE ⇱
id 🔑
name
created_at
PERSON ⇱
id 🔑
type
text
QUESTION ⇱
response_id 🔑 ➤ RESPONSE
tag 🔑
RESPONSE_TAG ⇱
Note:�Tag in the RESPONSE_TAG Table will be renamed to tags for the new connectors.