Kandypack — Rail & Road Supply Chain System
The Challenge
A logistics platform covering orders, train and truck trips, shipments, and worker rosters needed a database design that stayed consistent across 15+ entities — while enforcing real operational rules like driver working-hour limits and train-capacity overflow that a plain schema can't express on its own.
My Approach
I designed the relational schema and ERD for the full 15+ entity model, then contributed to enforcing those business rules directly in the database using triggers, stored procedures, and views. On the application side, I built backend API endpoints on Elysia.js (Bun runtime) with JWT authentication and implemented the Store Manager Dashboard in Next.js.
Outcome
A normalized, constraint-enforced database where operational rules are guaranteed at the data layer rather than trusted to application code, backed by a working API and dashboard.