Assignment Submission

lms.assignment_submission · every change is kept in the audit log · numbered SUB-{YYYY}-{#####}

Fields

Every record also has id, created_at and updated_at.

Field	Label	Type	Rules
assignment	assignment	link → lms.study_material	required
student	student	link → core.student	required
submission_file	submission file	file	required
comments	comments	longtext	max 2000 characters
status	status	select	one of: Pending, Submitted, Late, Resubmitted, Graded; default "Submitted"
submitted_at	submitted at	datetime
marks	marks	decimal	min 0
total_marks	total marks	number	min 0
feedback	feedback	longtext	max 5000 characters
graded_by	graded by	link → core.user
graded_at	graded at	datetime
extended_due_date	extended due date	datetime
extension_reason	extension reason	longtext	max 1000 characters

Unique together: assignment + student

Permissions

Role	Can
lms:admin	read, create, update, delete
lms:college_admin	read, create, update, delete
lms:hod	read, create, update, delete
lms:faculty	read, update
lms:student	read, create, update — only own rows (via student)
lms:parent	read — only own rows (via student)

API

GET    /api/lms/assignment_submission?<field>=<value>&limit=100&offset=0
POST   /api/lms/assignment_submission
GET    /api/lms/assignment_submission/:id
PATCH  /api/lms/assignment_submission/:id
DELETE /api/lms/assignment_submission/:id