Quizzes Schema

ext_quizzes - Quizzes

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

---

quizzes

Quiz definitions linked to courses.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
course_id	uuid	NO	—
instructor_id	uuid	NO	—
title	text	NO	—
description	text	YES	—
pass_mark	integer	NO	50
time_limit_minutes	integer	YES	—
attempts_allowed	integer	YES	—
shuffle_questions	boolean	NO	false
show_answers_after	boolean	NO	true
status	text	NO	'draft'
question_count	integer	NO	0
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

questions

Quiz questions.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
quiz_id	uuid	NO	—
type	text	NO	'multiple_choice'
content	text	NO	—
explanation	text	YES	—
points	integer	NO	1
sort_order	integer	NO	0
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

answers

Question answer options.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
question_id	uuid	NO	—
content	text	NO	—
is_correct	boolean	NO	false
sort_order	integer	NO	0
created_at	timestamptz	NO	now()

attempts

User quiz attempt records.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
quiz_id	uuid	NO	—
user_id	uuid	NO	—
score	numeric	YES	—
total_points	integer	NO	0
max_points	integer	NO	0
status	text	NO	'in_progress'
passed	boolean	YES	—
started_at	timestamptz	NO	now()
finished_at	timestamptz	YES	—
created_at	timestamptz	NO	now()

attempt_answers

Individual answers per attempt.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
attempt_id	uuid	NO	—
question_id	uuid	NO	—
answer_id	uuid	YES	—
text_response	text	YES	—
is_correct	boolean	YES	—
points_earned	integer	NO	0
created_at	timestamptz	NO	now()