school system table

🔟 Core Tables for a School System Backend
Users

• For authentication (students, teachers, admins, parents)

• Fields: id, name, email, password, role, created_at

Students

• Student-specific data

• Fields: id, user_id, enrollment_number, grade_level, date_of_birth

Teachers

• Teacher-specific data

• Fields: id, user_id, employee_id, department, hire_date

Courses / Subjects

• What is being taught

• Fields: id, name, code, description, grade_level

Classes / Sections

• The actual instance of a subject taught by a teacher

• Fields: id, course_id, teacher_id, semester, schedule

Enrollments

• Links students to classes

• Fields: id, student_id, class_id, enrollment_date, status

Grades

• Stores grades/marks for students in classes

• Fields: id, student_id, class_id, score, grade, remarks

Attendance

• Student attendance per class/session

• Fields: id, student_id, class_id, date, status, remarks

Assignments / Exams

• Tests or homework given in a class

• Fields: id, class_id, title, description, due_date, type

Submissions / Results

• Students' submissions or exam results

• Fields: id, assignment_id, student_id, submitted_at, score, feedback