# bansagjohndave915-cloud/grading-portal-system architecture

> Architecture diagram of the GitHub repository bansagjohndave915-cloud/grading-portal-system, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-08). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/bansagjohndave915-cloud/grading-portal-system
- Repository: https://github.com/bansagjohndave915-cloud/grading-portal-system

## Overview

GradeSystem is a school grade-management web application with administrator, teacher, and student interfaces backed by an Express API and MySQL. Its central workflow lets teachers preview and submit Excel grade sheets, administrators review or lock uploads, and students access grades; the API also supports student imports, school-year and class administration, and reporting. The graph preserves these distinct capabilities and the database layer. The README is empty, and the available frontend excerpts do not establish the UI-to-API calls, so those links are omitted; unsampled routes are represented only where the source index identifies their wiring.

Main entry points: [`GradeSystem/CLIENT/backend/server.js`](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/server.js) (HTTP server), [`GradeSystem/CLIENT/backend/config/db.js`](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/config/db.js) (MySQL database), [`GradeSystem/CLIENT/backend/routes/studentRoutes.js`](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/studentRoutes.js) (Student routes), [`GradeSystem/CLIENT/backend/routes/gradeRoutes.js`](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/gradeRoutes.js) (Grade routes)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_clients["User interfaces"]
  node_admin["Admin interface<br/>[admin.js]"]
  node_teacher["Teacher interface<br/>[teacher.js]"]
  node_student["Student interface<br/>[student.js]"]
  node_login["Login interface<br/>[login.js]"]
  node_api_client["API client<br/>[api.js]"]
end

subgraph group_api["API routing"]
  node_server["HTTP server<br/>[server.js]"]
  node_auth_routes["Auth routes<br/>[authRoutes.js]"]
  node_student_routes["Student routes<br/>[studentRoutes.js]"]
  node_teacher_routes["Teacher routes<br/>[teacherRoutes.js]"]
  node_subject_routes["Subject routes<br/>[subjectRoutes.js]"]
  node_year_routes["School-year routes"]
  node_section_routes["Section routes<br/>[sectionRoutes.js]"]
  node_grade_routes["Grade routes<br/>[gradeRoutes.js]"]
  node_report_routes["Report routes<br/>[reportRoutes.js]"]
  node_auth["Authentication<br/>[authController.js]"]
  node_auth_middleware["Role checks<br/>[authMiddleware.js]"]
end

subgraph group_school["School records"]
  node_students["Student records"]
  node_student_import["Student import"]
  node_teachers["Teacher assignments"]
  node_subjects["Subject records"]
  node_school_years["School-year setup"]
  node_sections["Section records"]
end

subgraph group_grades["Grade workflow"]
  node_grades["Grade uploads<br/>[gradeController.js]"]
  node_reports["Reports"]
end

subgraph group_data["Data access"]
  node_db[("MySQL database<br/>[db.js]")]
end

node_server -->|"mounts"| node_auth_routes
node_server -->|"mounts"| node_student_routes
node_server -->|"mounts"| node_teacher_routes
node_server -->|"mounts"| node_subject_routes
node_server -->|"mounts"| node_year_routes
node_server -->|"mounts"| node_section_routes
node_server -->|"mounts"| node_grade_routes
node_server -->|"mounts"| node_report_routes
node_auth_routes -->|"routes to"| node_auth
node_student_routes -->|"routes to"| node_students
node_student_routes -->|"routes to"| node_student_import
node_teacher_routes -->|"routes to"| node_teachers
node_subject_routes -->|"routes to"| node_subjects
node_year_routes -->|"routes to"| node_school_years
node_section_routes -->|"routes to"| node_sections
node_grade_routes -->|"routes to"| node_grades
node_report_routes -->|"routes to"| node_reports
node_student_routes -->|"checks access"| node_auth_middleware
node_grade_routes -->|"checks access"| node_auth_middleware
node_report_routes -->|"checks access"| node_auth_middleware
node_auth -->|"queries"| node_db
node_students -->|"queries"| node_db
node_student_import -->|"imports records"| node_db
node_teachers -->|"queries"| node_db
node_subjects -->|"queries"| node_db
node_school_years -->|"queries"| node_db
node_sections -.->|"queries"| node_db
node_grades -->|"queries"| node_db
node_reports -->|"queries"| node_db

click node_admin "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/JS/admin.js"
click node_teacher "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/JS/teacher.js"
click node_student "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/JS/student.js"
click node_login "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/JS/login.js"
click node_api_client "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/JS/api.js"
click node_server "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/server.js"
click node_auth_routes "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/authRoutes.js"
click node_student_routes "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/studentRoutes.js"
click node_teacher_routes "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/teacherRoutes.js"
click node_subject_routes "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/subjectRoutes.js"
click node_year_routes "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/schoolYearRoutes.js"
click node_section_routes "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/sectionRoutes.js"
click node_grade_routes "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/gradeRoutes.js"
click node_report_routes "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/reportRoutes.js"
click node_auth "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/authController.js"
click node_students "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/studentController.js"
click node_student_import "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/studentImportController.js"
click node_teachers "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/teacherController.js"
click node_subjects "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/subjectController.js"
click node_school_years "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/schoolYearController.js"
click node_sections "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/sectionController.js"
click node_grades "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/gradeController.js"
click node_reports "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/reportController.js"
click node_auth_middleware "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/middleware/authMiddleware.js"
click node_db "https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/config/db.js"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_admin,node_teacher,node_student,node_login,node_api_client toneBlue
class node_server,node_auth_routes,node_student_routes,node_teacher_routes,node_subject_routes,node_year_routes,node_section_routes,node_grade_routes,node_report_routes,node_auth,node_auth_middleware toneAmber
class node_students,node_student_import,node_teachers,node_subjects,node_school_years,node_sections toneMint
class node_grades,node_reports toneRose
class node_db toneIndigo
```

## Components

### User interfaces

- [Admin interface](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/JS/admin.js): `GradeSystem/CLIENT/JS/admin.js`
- [Teacher interface](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/JS/teacher.js): `GradeSystem/CLIENT/JS/teacher.js`
- [Student interface](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/JS/student.js): `GradeSystem/CLIENT/JS/student.js`
- [Login interface](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/JS/login.js): `GradeSystem/CLIENT/JS/login.js`
- [API client](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/JS/api.js): `GradeSystem/CLIENT/JS/api.js`

### API routing

- [HTTP server](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/server.js): `GradeSystem/CLIENT/backend/server.js`
- [Auth routes](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/authRoutes.js): `GradeSystem/CLIENT/backend/routes/authRoutes.js`
- [Student routes](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/studentRoutes.js): `GradeSystem/CLIENT/backend/routes/studentRoutes.js`
- [Teacher routes](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/teacherRoutes.js): `GradeSystem/CLIENT/backend/routes/teacherRoutes.js`
- [Subject routes](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/subjectRoutes.js): `GradeSystem/CLIENT/backend/routes/subjectRoutes.js`
- [School-year routes](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/schoolYearRoutes.js): `GradeSystem/CLIENT/backend/routes/schoolYearRoutes.js`
- [Section routes](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/sectionRoutes.js): `GradeSystem/CLIENT/backend/routes/sectionRoutes.js`
- [Grade routes](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/gradeRoutes.js): `GradeSystem/CLIENT/backend/routes/gradeRoutes.js`
- [Report routes](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/routes/reportRoutes.js): `GradeSystem/CLIENT/backend/routes/reportRoutes.js`
- [Authentication](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/authController.js): `GradeSystem/CLIENT/backend/controllers/authController.js`
- [Role checks](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/middleware/authMiddleware.js): `GradeSystem/CLIENT/backend/middleware/authMiddleware.js`

### School records

- [Student records](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/studentController.js): `GradeSystem/CLIENT/backend/controllers/studentController.js`
- [Student import](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/studentImportController.js): `GradeSystem/CLIENT/backend/controllers/studentImportController.js`
- [Teacher assignments](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/teacherController.js): `GradeSystem/CLIENT/backend/controllers/teacherController.js`
- [Subject records](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/subjectController.js): `GradeSystem/CLIENT/backend/controllers/subjectController.js`
- [School-year setup](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/schoolYearController.js): `GradeSystem/CLIENT/backend/controllers/schoolYearController.js`
- [Section records](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/sectionController.js): `GradeSystem/CLIENT/backend/controllers/sectionController.js`

### Grade workflow

- [Grade uploads](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/gradeController.js): `GradeSystem/CLIENT/backend/controllers/gradeController.js`
- [Reports](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/controllers/reportController.js): `GradeSystem/CLIENT/backend/controllers/reportController.js`

### Data access

- [MySQL database](https://github.com/bansagjohndave915-cloud/grading-portal-system/blob/main/GradeSystem/CLIENT/backend/config/db.js): `GradeSystem/CLIENT/backend/config/db.js`

## Connections

- HTTP server → Auth routes: mounts (evidence: `GradeSystem/CLIENT/backend/server.js`)
- HTTP server → Student routes: mounts (evidence: `GradeSystem/CLIENT/backend/server.js`)
- HTTP server → Teacher routes: mounts (evidence: `GradeSystem/CLIENT/backend/server.js`)
- HTTP server → Subject routes: mounts (evidence: `GradeSystem/CLIENT/backend/server.js`)
- HTTP server → School-year routes: mounts (evidence: `GradeSystem/CLIENT/backend/server.js`)
- HTTP server → Section routes: mounts (evidence: `GradeSystem/CLIENT/backend/server.js`)
- HTTP server → Grade routes: mounts (evidence: `GradeSystem/CLIENT/backend/server.js`)
- HTTP server → Report routes: mounts (evidence: `GradeSystem/CLIENT/backend/server.js`)
- Auth routes → Authentication: routes to (evidence: `GradeSystem/CLIENT/backend/routes/authRoutes.js`)
- Student routes → Student records: routes to (evidence: `GradeSystem/CLIENT/backend/routes/studentRoutes.js`)
- Student routes → Student import: routes to (evidence: `GradeSystem/CLIENT/backend/routes/studentRoutes.js`)
- Teacher routes → Teacher assignments: routes to (evidence: `GradeSystem/CLIENT/backend/routes/teacherRoutes.js`)
- Subject routes → Subject records: routes to (evidence: `GradeSystem/CLIENT/backend/routes/subjectRoutes.js`)
- School-year routes → School-year setup: routes to (evidence: `GradeSystem/CLIENT/backend/routes/schoolYearRoutes.js`)
- Section routes → Section records: routes to (evidence: `GradeSystem/CLIENT/backend/routes/sectionRoutes.js`)
- Grade routes → Grade uploads: routes to (evidence: `GradeSystem/CLIENT/backend/routes/gradeRoutes.js`)
- Report routes → Reports: routes to (evidence: `GradeSystem/CLIENT/backend/routes/reportRoutes.js`)
- Student routes → Role checks: checks access (evidence: `GradeSystem/CLIENT/backend/routes/studentRoutes.js`)
- Grade routes → Role checks: checks access (evidence: `GradeSystem/CLIENT/backend/routes/gradeRoutes.js`)
- Report routes → Role checks: checks access (evidence: `GradeSystem/CLIENT/backend/routes/reportRoutes.js`)
- Authentication → MySQL database: queries (evidence: `GradeSystem/CLIENT/backend/controllers/authController.js`)
- Student records → MySQL database: queries (evidence: `GradeSystem/CLIENT/backend/controllers/studentController.js`)
- Student import → MySQL database: imports records (evidence: `GradeSystem/CLIENT/backend/controllers/studentImportController.js`)
- Teacher assignments → MySQL database: queries (evidence: `GradeSystem/CLIENT/backend/controllers/teacherController.js`)
- Subject records → MySQL database: queries (evidence: `GradeSystem/CLIENT/backend/controllers/subjectController.js`)
- School-year setup → MySQL database: queries (evidence: `GradeSystem/CLIENT/backend/controllers/schoolYearController.js`)
- Section records → MySQL database: queries (evidence: `GradeSystem/CLIENT/backend/controllers/sectionController.js`)
- Grade uploads → MySQL database: queries (evidence: `GradeSystem/CLIENT/backend/controllers/gradeController.js`)
- Reports → MySQL database: queries (evidence: `GradeSystem/CLIENT/backend/controllers/reportController.js`)
