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 10 null
choiceid bigint 10 0
choice.id choiansw_cho2_fk R
userid bigint 10 0
user.id Implied Constraint R
optionid bigint 10 0
choice_options.id choiansw_opt2_fk R
timemodified bigint 10 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