Choice Answers Table Schema (choice_answers)


Description

choices performed by users

choice_answers table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
choiceid BIGINT 19 0
choice.id choiansw_cho2_fk R
userid BIGINT 19 0
user.id Implied Constraint R
optionid BIGINT 19 0
choice_options.id choiansw_opt2_fk R
timemodified BIGINT 19 0

Table contained -1 rows

choice_answers table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
choiansw_cho_ix Performance Asc choiceid
choiansw_opt_ix Performance Asc optionid
choiansw_use_ix Performance Asc userid

choice_answers table relationships

Close relationships within degrees of separation