Skip to content

Assignments Schema

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


Course assignments with grading configuration.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
course_iduuidNO—
instructor_iduuidNO—
titletextNO—
descriptiontextYES—
instructionstextYES—
due_datetimestamptzYES—
grade_typetextNO'points'
max_scoreintegerNO100
allow_latebooleanNOfalse
late_penalty_percentnumericNO0
typetextNO'individual'
max_attemptsintegerYES—
statustextNO'draft'
submission_countintegerNO0
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Student assignment submissions.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
assignment_iduuidNO—
user_iduuidNO—
contenttextYES—
file_pathtextYES—
file_nametextYES—
statustextNO'submitted'
submitted_attimestamptzNOnow()
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Grading records for submissions.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
submission_iduuidNO—
grader_iduuidNO—
scorenumericYES—
max_scoreintegerNO100
letter_gradetextYES—
passedbooleanYES—
feedbacktextYES—
graded_attimestamptzNOnow()
created_attimestamptzNOnow()

Files attached to assignments.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
assignment_iduuidNO—
titletextNO—
file_pathtextNO—
file_sizeintegerYES—
file_typetextYES—
created_attimestamptzNOnow()