Survey Answers Table Schema (survey_answers)


Description

the answers to each questions filled by the users

survey_answers table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userid BIGINT 19 0
user.id Implied Constraint R
survey BIGINT 19 0
survey.id survansw_sur2_fk R
question BIGINT 19 0
survey_questions.id survansw_que2_fk R
time BIGINT 19 0
answer1 LONGTEXT 2147483647 null
answer2 LONGTEXT 2147483647 null

Table contained -1 rows

survey_answers table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
survansw_que_ix Performance Asc question
survansw_sur_ix Performance Asc survey
survansw_use_ix Performance Asc userid

survey_answers table relationships

Close relationships within degrees of separation