A professional Java Capstone Project and Live Sandbox Simulator designed to support three-way portal workflows (Admins, Doctors, and Patients) within an enterprise clinic setting. It incorporates multi-model persistent models (MySQL + MongoDB), interactive stored SQL procedures, and agile documentation files.
- TypeScript (TSX): Powers both the rich responsive frontend dashboard and the Express production middle-tier sandbox operations.
- Java: The core enterprise backend architecture written using Spring Boot frameworks.
- MySQL SQL: Defines standard schema designs, table relations, indexes, dynamic lookups, and compiled analytics stored procedures.
- MongoDB NoSQL (JSON/BSON): Scalable storage structure used for indexing fluid client prescription records and medical notes.
- HTML5 / CSS3 (Tailwind CSS): Aesthetic layout styling with modern hardware-accelerated animated transitions.
- Framework: React 18+ (bundled with high-efficiency Vite compiling)
- Server: Express middle-tier proxying REST calls and mocking enterprise DB procedures
- Vector Icons: Lucide React
- Styling Engine: Tailwind CSS
- Build Systems: Maven (Java app dependencies / compilation) + npm (React frontend runtime env)
- Deployment & CI: Multi-stage lightweight Docker container & GitHub Actions workflows
/README.md: System capabilities guide, technologies, and system execution instruction. (Written by Brian McCarthy)/project-deliverables.md: Complete list of definitive answers, curl buffers, DB outputs, and answers. (Written by Brian McCarthy)/schema-design.md: Production MySQL tables definition alongside MongoDB BSON/JSON structures./schema-architecture.md: Detailed visual architecture detailing tables, data flows, and JPA mappings./user_stories.md: Role-based agile product definitions for Admin, Doctor, and Patient personas./server.ts: Full-stack backend providing dynamic data APIs, query executions, and session security token states./src/App.tsx: High-polish portal interface containing interactive mockups, JPA model explorers, and active SQL terminal consoles./src/codeSnippets.ts: Embedded source repositorials of fundamental Java models (Doctor.java,Appointment.java, etc.)./index.html: Standard root web document.
- Admin Control Suite: Onboard and delete healthcare providers, assigning shift availabilities.
- Patient Bento Interface: Real-time matching filtering by Practitioner name, speciality (e.g. Cardiology), and time-slot. Custom secure scheduling reserving 1-hour slots.
- Doctor Daily Queue Tracker: Secure doctor dashboard lists dates-focused bookings, processing patient sessions and compiling dynamic medical cards.
- MongoDB Document Store Prescriptions: Handles unstructured prescription records using standard NoSQL formats.
- Simulated SQL Terminal Console: Execute functional stored procedures:
show tables;- lists all relational structuresCALL GetDailyAppointmentReportByDoctor(date)- generates practitioner queuesCALL GetDoctorWithMostPatientsByMonth(month, year)- high patient month metricCALL GetDoctorWithMostPatientsByYear(year)- high patient annual analytics
Ensure node packages are installed and run the full-stack server-client bundle:
npm install
npm run dev- Admin Login: Access using username
adminand passwordadmin@1234to oversee clinic activities and onboard doctors. - Patient Login: Use email
jane.doe@example.comand passwordpassJane1to search specialties, check availability, and book slots. - Doctor Login: Login as
dr.adams@example.comwith passwordpassEmily1to view your schedule and record drug prescriptions.
Navigate to the MySQL CLI Stored Proc tab. Type and run procedures like:
CALL GetDailyAppointmentReportByDoctor('2025-05-01');- Runtime: Node.js v18.0.0+
- Development package tools: npm / npx
- Database standard: MySQL 8.x + MongoDB (simulated locally/container-hosted)
- Java environment: JDK 17+ and Apache Maven 3.8+