Hospital Operations & Booking
System Architecture Flow
Portals (Doctor / Patient / Admin) ──→ Nginx
↓
Laravel 12
↓
MySQL ──[Pessimistic Locking]
↓
WhatsApp Notification QueueBusiness Problem
A clinic organization faced scheduling friction, doctor availability conflicts, and patient follow-up errors due to fragmented booking rules across locations.
Engineering Challenge
Resolving overlapping availability rules (doctor leaves, emergency blockouts, slot sizing) in a thread-safe environment without double-booking.
Production Constraints
Role-based compliance auditing for patient record exports and appointment status history logs.
Key Decisions
Implemented relational database locks (pessimistic locking) on slot reservations during checkouts, centralizing schedule validation logic.
Architectural Trade-off
Relational row locks limit maximum horizontal concurrency on a single doctor's calendar, but guarantees absolute booking consistency over distributed systems.
Performance & Scalability
Optimized relational calendar queries by nesting slot validations in index scans, keeping booking times under 300ms.
Business Outcome
Eliminated calendar conflict errors, automating slot availability rules and reducing patient no-shows via automated notification reminders.