app_quiz_slots

0 rows


Description

Stores the question used in a quiz, with the order, and for each question, which page it appears on, and the maximum mark (weight).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_quiz_slots_id_seq'::regclass)
slot int8 19 null
quizid int8 19 0
app_quiz.id Defined in XMLR
page int8 19 null
requireprevious int2 5 0
questionid int8 19 0
app_question.id Defined in XMLR
maxmark numeric 12,7 0

Indexes

Constraint Name Type Sort Column(s)
app_quizslot_id_pk Primary key Asc id
app_quizslot_que_ix Performance Asc questionid
app_quizslot_qui_ix Performance Asc quizid
app_quizslot_quislo_ix Performance Asc/Asc quizid + slot

Relationships