PLM ICTO Help Desk is a full-stack, enterprise-grade IT support platform built for the Information and Communications Technology Office of Pamantasan ng Lungsod ng Maynila. The platform streamlines ticket management across three distinct user roles (Client, Technician, and Admin) with robust security and real-time collaboration.
- Granular Role-Based Access Control (RBAC): Enforced at the database level using Supabase Row-Level Security (RLS), Postgres role hooks, and strict per-table policies to ensure total data isolation.
- Real-Time Live Updates: Features an instant notification bell driven by Supabase Realtime, pushing critical lifecycle event updates to users immediately.
- Cross-Role Collaboration Hub: Supports interactive comment threads and secure file attachments across all roles, with dynamic author and uploader metadata rendering.
- Advanced Admin Dashboard: Displays 5 core KPI stat cards computed via Postgres Remote Procedure Calls (RPC) alongside a high-performance, searchable, and filterable data table for ticket management.











