NAME
medical-appointment-system — college infirmary booking and records
STATUS
shipped
DESCRIPTION
A full-stack system for a college infirmary: students and staff book appointments, doctors run their schedule and keep consultation records, infirmary staff handle walk-ins and emergencies, admins oversee all of it.
- FastAPI backend with raw SQL throughout, no ORM, in four layers: routes, services, repositories, queries.
- MySQL schema in third normal form, with triggers, views and indexes where they earn it.
- Seven roles, JWT auth with bcrypt; prescriptions and medical certificates from the doctor's side.
- Next.js 14 and TypeScript frontend.
STACK
- FastAPI
- MySQL
- raw SQL
- JWT
- Next.js
- TypeScript
- Tailwind