CPE241 · Database Systems
Maintenance Tracking System
A full-stack maintenance platform for employees to submit repair requests and managers to review, assign, and track work through role-specific workflows.
- Status
- Completed
- Role
- Team course project · 4 contributors
- Source reviewed
- 9 June 2026
What it solves
Maintenance work crosses employees, managers, parts, products, departments, work orders, and status histories. The system needed to keep those records connected while giving each role a focused workflow instead of exposing one undifferentiated CRUD interface.
The project delivers an end-to-end repair workflow across separate web and API repositories: employees create and follow requests, managers review and assign work, master-data screens maintain operational records, and dashboards summarize repair activity for decision-making.
Architecture
- React feature client
- React Router pages compose feature modules that reach the API through typed services and resource clients.
- Layered Elysia API
- Validated controllers delegate maintenance workflows to application services backed by repository contracts.
- Drizzle persistence
- Concrete repositories use a shared Drizzle connection to persist PostgreSQL data.
Technology
- TypeScript
- React 19
- React Router 7
- Bun
- ElysiaJS
- PostgreSQL
- Drizzle ORM
- Tailwind CSS
- shadcn/ui
- Zod
- JWT
- OpenAPI
Team
Suthang Sukrueangkun, Phirada Lekpaeng, Phenwatsa, Chompuwell.
The repository remains the source of truth for implementation details. Inspect the source