RSHP – Hospital Info System

Digitalizing patient registration and doctor scheduling with real-time data integration.

2024 Laravel + MySQL Academic Project

View on GitHub

100% Paperless Ops

Real-time Data Sync

3 Core Modules

Laravel Backend Stack

The Challenge

Data pendaftaran pasien dan jadwal dokter sering bentrok karena kurangnya sinkronisasi real-time. Proses manual menyebabkan antrian panjang dan kesalahan data.

The Solution

Membangun sistem validasi otomatis menggunakan Laravel & Eloquent untuk memastikan integritas data pendaftaran, dengan antrian real-time dan notifikasi dokter.

Database Schema

schema.sql

Table: doctors
  - id (PK), name, specialization
  - schedule_days (JSON), max_patients

Table: appointments
  - id (PK), doctor_id (FK)
  - patient_name, appointment_date
  - status (enum: pending, confirmed, cancelled)

Table: patients
  - id (PK), nik, name, dob, address