app_engage_answer_choice

0 rows


Description

Table for the picked option of the question

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_engage_answer_choice_id_seq'::regclass)
questionid int8 19 null
app_engage_question.id Defined in XMLR
optionid int8 19 null
app_engage_answer_option.id Defined in XMLR
userid int8 19 null
app_user.id Defined in XMLR
timecreated int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_engaanswchoi_id_pk Primary key Asc id
app_engaanswchoi_opt_ix Performance Asc optionid
app_engaanswchoi_que_ix Performance Asc questionid
app_engaanswchoi_queoptuse_uix Must be unique Asc/Asc/Asc questionid + optionid + userid
app_engaanswchoi_tim_ix Performance Asc timecreated
app_engaanswchoi_use_ix Performance Asc userid

Relationships