Survey Answers Table Schema (survey_answers)


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 Implied Constraint R
survey BIGINT 19 0 survansw_sur2_fk R
question BIGINT 19 0 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