# lc-xander/mochilaiep-fullstack architecture

> Architecture diagram of the GitHub repository lc-xander/mochilaiep-fullstack, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/lc-xander/mochilaiep-fullstack
- Repository: https://github.com/lc-xander/mochilaiep-fullstack

## Overview

Mochila is a student schedule web app with account activation/login, personalized schedule viewing and day comparison, plus role-protected administration of students, subjects, schedules and activation codes. The server routes own API operations and query MySQL; the browser clients call those routes and render results. Connections reflect sampled source and README statements; administrative route coverage is documented, while some implementation details are unsampled.

Main entry points: [`server/db/mysql.js`](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/db/mysql.js) (MySQL pool), [`server/routes/auth.js`](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/routes/auth.js) (Account access), [`script.js`](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/script.js) (Student client), [`server/index.js`](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/index.js) (HTTP server)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_web["Web clients"]
  node_student_ui["Student client<br/>[script.js]"]
  node_admin_ui["Admin client<br/>[admin.js]"]
  node_schedule_compare["Day comparison<br/>[script.js]"]
end

subgraph group_api["API and access"]
  node_server["HTTP server<br/>[index.js]"]
  node_auth_routes["Account access<br/>[auth.js]"]
  node_auth_middleware["Session and roles<br/>[auth.js]"]
end

subgraph group_domain["Schedule and administration"]
  node_schedule_routes["Student schedules<br/>[schedule.js]"]
  node_admin_routes["Admin operations<br/>[admin.js]"]
  node_access_codes["Activation codes<br/>[accessCodes.js]"]
end

subgraph group_data["Persistence"]
  node_db_pool[("MySQL pool<br/>[mysql.js]")]
  node_seed["Academic seed<br/>[seedData.js]"]
  node_schema["Database schema<br/>[schema.sql]"]
end

node_student(("Student"))
node_admin_actor(("Administrator"))
node_mysql[("MySQL")]

node_student -->|"uses"| node_student_ui
node_admin_actor -->|"uses"| node_admin_ui
node_student_ui -->|"activates or logs in"| node_auth_routes
node_student_ui -->|"checks session"| node_auth_routes
node_student_ui -->|"requests schedule"| node_schedule_routes
node_student_ui -->|"renders comparison"| node_schedule_compare
node_admin_ui -->|"manages records"| node_admin_routes
node_admin_ui -->|"logs out"| node_auth_routes
node_server -->|"mounts routes"| node_auth_routes
node_server -->|"mounts routes"| node_schedule_routes
node_server -->|"mounts routes"| node_admin_routes
node_server -->|"loads session user"| node_auth_middleware
node_auth_routes -->|"queries users and codes"| node_db_pool
node_auth_routes -->|"normalizes activation code"| node_seed
node_auth_middleware -->|"loads user"| node_db_pool
node_schedule_routes -->|"requires authentication"| node_auth_middleware
node_schedule_routes -->|"queries group schedule"| node_db_pool
node_admin_routes -->|"requires admin role"| node_auth_middleware
node_admin_routes -->|"queries and updates"| node_db_pool
node_access_codes -->|"queries codes"| node_db_pool
node_seed -->|"seeds records"| node_db_pool
node_db_pool -.->|"connects"| node_mysql
node_schema -->|"defines tables"| node_mysql

click node_student_ui "https://github.com/lc-xander/mochilaiep-fullstack/blob/main/script.js"
click node_admin_ui "https://github.com/lc-xander/mochilaiep-fullstack/blob/main/admin.js"
click node_server "https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/index.js"
click node_auth_routes "https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/routes/auth.js"
click node_auth_middleware "https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/middleware/auth.js"
click node_schedule_routes "https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/routes/schedule.js"
click node_admin_routes "https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/routes/admin.js"
click node_access_codes "https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/services/accessCodes.js"
click node_schedule_compare "https://github.com/lc-xander/mochilaiep-fullstack/blob/main/script.js"
click node_db_pool "https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/db/mysql.js"
click node_seed "https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/db/seedData.js"
click node_schema "https://github.com/lc-xander/mochilaiep-fullstack/blob/main/database/schema.sql"

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_student_ui,node_admin_ui,node_schedule_compare toneBlue
class node_server,node_auth_routes,node_auth_middleware,node_mysql toneAmber
class node_schedule_routes,node_admin_routes,node_access_codes toneMint
class node_db_pool,node_seed,node_schema toneRose
class node_student,node_admin_actor toneIndigo
```

## Components

### Web clients

- [Student client](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/script.js): `script.js`
- [Admin client](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/admin.js): `admin.js`
- [Day comparison](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/script.js): `script.js`

### API and access

- [HTTP server](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/index.js): `server/index.js`
- [Account access](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/routes/auth.js): `server/routes/auth.js`
- [Session and roles](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/middleware/auth.js): `server/middleware/auth.js`

### Schedule and administration

- [Student schedules](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/routes/schedule.js): `server/routes/schedule.js`
- [Admin operations](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/routes/admin.js): `server/routes/admin.js`
- [Activation codes](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/services/accessCodes.js): `server/services/accessCodes.js`

### Persistence

- [MySQL pool](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/db/mysql.js): `server/db/mysql.js`
- [Academic seed](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/server/db/seedData.js): `server/db/seedData.js`
- [Database schema](https://github.com/lc-xander/mochilaiep-fullstack/blob/main/database/schema.sql): `database/schema.sql`

### Other components

- **Student**
- **Administrator**
- **MySQL**

## Connections

- Student → Student client: uses (evidence: `README.md`)
- Administrator → Admin client: uses (evidence: `README.md`)
- Student client → Account access: activates or logs in (evidence: `script.js`)
- Student client → Account access: checks session (evidence: `script.js`)
- Student client → Student schedules: requests schedule (evidence: `script.js`)
- Student client → Day comparison: renders comparison (evidence: `script.js`)
- Admin client → Admin operations: manages records (evidence: `admin.js`)
- Admin client → Account access: logs out (evidence: `admin.js`)
- HTTP server → Account access: mounts routes (evidence: `server/index.js`)
- HTTP server → Student schedules: mounts routes (evidence: `server/index.js`)
- HTTP server → Admin operations: mounts routes (evidence: `server/index.js`)
- HTTP server → Session and roles: loads session user (evidence: `server/index.js`)
- Account access → MySQL pool: queries users and codes (evidence: `server/routes/auth.js`)
- Account access → Academic seed: normalizes activation code (evidence: `server/routes/auth.js`)
- Session and roles → MySQL pool: loads user (evidence: `server/middleware/auth.js`)
- Student schedules → Session and roles: requires authentication (evidence: `server/routes/schedule.js`)
- Student schedules → MySQL pool: queries group schedule (evidence: `server/routes/schedule.js`)
- Admin operations → Session and roles: requires admin role (evidence: `server/routes/admin.js`)
- Admin operations → MySQL pool: queries and updates (evidence: `server/routes/admin.js`)
- Activation codes → MySQL pool: queries codes (evidence: `server/services/accessCodes.js`)
- Academic seed → MySQL pool: seeds records (evidence: `server/db/seedData.js`)
- MySQL pool → MySQL: connects
- Database schema → MySQL: defines tables (evidence: `README.md`)
