Skip to content

Quizzes Schema

Schema: ext_quizzes | Auto-generated on 2026-03-30


Quiz definitions linked to courses.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
course_iduuidNO—
instructor_iduuidNO—
titletextNO—
descriptiontextYES—
pass_markintegerNO50
time_limit_minutesintegerYES—
attempts_allowedintegerYES—
shuffle_questionsbooleanNOfalse
show_answers_afterbooleanNOtrue
statustextNO'draft'
question_countintegerNO0
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Quiz questions.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
quiz_iduuidNO—
typetextNO'multiple_choice'
contenttextNO—
explanationtextYES—
pointsintegerNO1
sort_orderintegerNO0
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Question answer options.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
question_iduuidNO—
contenttextNO—
is_correctbooleanNOfalse
sort_orderintegerNO0
created_attimestamptzNOnow()

User quiz attempt records.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
quiz_iduuidNO—
user_iduuidNO—
scorenumericYES—
total_pointsintegerNO0
max_pointsintegerNO0
statustextNO'in_progress'
passedbooleanYES—
started_attimestamptzNOnow()
finished_attimestamptzYES—
created_attimestamptzNOnow()

Individual answers per attempt.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
attempt_iduuidNO—
question_iduuidNO—
answer_iduuidYES—
text_responsetextYES—
is_correctbooleanYES—
points_earnedintegerNO0
created_attimestamptzNOnow()