An internal ticketing system with roles, a status workflow, and a change history.
ServiceDesk Lite is a demo internal system for handling employee tickets: roles, a status workflow, comments, and a full change history for every ticket.
01 / THE PROBLEM
Internal technical tickets often live in chats or email: it's hard to track status, who's handling what, and what's already been done — history gets lost, and access to other people's tickets isn't restricted at all.
02 / THE SOLUTION
ServiceDesk Lite gives employees and admins separate roles, a clear ticket status workflow, comments, and a full change history, with data access restricted at the database level (row-level security) rather than only by interface checks.
03 / KEY FEATURES
Only the capabilities that support the core user journey.
05 / ARCHITECTURE
A Next.js application with a role model (employee/admin), a ticket status workflow, and a change history. Data access is restricted at the PostgreSQL level (row-level security), not only by checks in the application code.
06 / VERIFICATION
These figures refer to the recorded, verified version of the project.
07 / LIMITATIONS
NEXT STEP
Describe it in your own words — I'll reply with how I'd approach it.
