03
Hospital Inventory System
RBAC stock management for healthcare
!The Problem
A hospital was managing medical supplies, equipment, and consumables using spreadsheets — making it impossible to track real-time stock levels, identify shortages before they became critical, or audit who changed what.
✓The Solution
A centralised web-based inventory system with role-based access control. Admins manage everything, Managers edit stock, Staff only view. Every stock change is logged with a timestamp and user. Automatic alerts fire the moment any item drops below its defined minimum threshold.
Stack & Why Each Technology
Needed a dynamic dashboard that updates stock levels and alerts in real time without full page reloads — React's state model was perfect for this.
REST API backend that handles CRUD operations, RBAC middleware, and alert logic cleanly.
Healthcare data requires strict relational integrity. PostgreSQL's ACID compliance and foreign key constraints ensure no orphaned records or inconsistent stock movements.
JWT for stateless authentication, with a custom RBAC middleware layer that checks role permissions on every protected route before executing any operation.
Key Features
- —Role-Based Access Control: Admin, Manager, Staff
- —Full CRUD for inventory items and categories
- —Real-time stock level tracking with minimum thresholds
- —Automatic low-stock alerts
- —Immutable stock movement audit log
- —Search and filter by name, category, supplier, status
- —Dashboard summary with charts and activity feed