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

Close relationships within degrees of separation