Assignments Schema

ext_assignments - Assignments

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

---

assignments

Course assignments with grading configuration.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
course_id	uuid	NO	—
instructor_id	uuid	NO	—
title	text	NO	—
description	text	YES	—
instructions	text	YES	—
due_date	timestamptz	YES	—
grade_type	text	NO	'points'
max_score	integer	NO	100
allow_late	boolean	NO	false
late_penalty_percent	numeric	NO	0
type	text	NO	'individual'
max_attempts	integer	YES	—
status	text	NO	'draft'
submission_count	integer	NO	0
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

submissions

Student assignment submissions.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
assignment_id	uuid	NO	—
user_id	uuid	NO	—
content	text	YES	—
file_path	text	YES	—
file_name	text	YES	—
status	text	NO	'submitted'
submitted_at	timestamptz	NO	now()
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

grades

Grading records for submissions.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
submission_id	uuid	NO	—
grader_id	uuid	NO	—
score	numeric	YES	—
max_score	integer	NO	100
letter_grade	text	YES	—
passed	boolean	YES	—
feedback	text	YES	—
graded_at	timestamptz	NO	now()
created_at	timestamptz	NO	now()

assignment_attachments

Files attached to assignments.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
assignment_id	uuid	NO	—
title	text	NO	—
file_path	text	NO	—
file_size	integer	YES	—
file_type	text	YES	—
created_at	timestamptz	NO	now()