
Full-Stack · Public SectorKabupaten Sumedang · Disperindag
Overview
MEDAL (Media, Event, Dagang & Lapak) is an event and SME directory platform for Kabupaten Sumedang, managed by the local Disperindag office. It is not a marketplace: it handles event information, stand registration, verification, selection, and booth numbering.
What I Built
- Role-based flows for the public, SMEs, event organizers, and Disperindag admins.
- Stand registration with a status timeline, revisions, cancellation, and notifications.
- Organizer event drafts with PDF proposals, participant selection, and CSV export.
- Admin review, verification, and atomic booth-number assignment with an audit log.
- Row Level Security on every table, with status transitions only through SECURITY DEFINER RPCs.
- Services
- Full-Stack Web Development
- Type of Product
- Event & SME Directory Platform
My Role
Designed and built the platform end to end.
Tech Stack
Next.jsTypeScriptSupabase (PostgreSQL + RLS)Tailwind CSSMotionZodVitestVercel

