Multi-Tenant Clinical Equipment Tracking
Running across 4 Vancouver Coastal Health sites, tracking 800+ wheelchairs and clinical assets through an 11-state lifecycle the database enforces directly — so a transition that skips a step, or a role that is not permitted to make it, simply cannot be written.
- Live across 4 Vancouver Coastal Health sites, tracking 800+ assets
- An 11-state request lifecycle whose transitions are gated by role in the database
- Postgres row-level security isolating every tenant, enforced below the API
- QR scanning driving intake, assignment, and return from the floor
React · Vite · Supabase · PostgreSQL · Row-Level Security · Edge Functions · QR workflows
Read the case studyRequest lifecycle · 11 states
- Requested
- Acknowledged
- Searching
- Waiting
- On Hold
- Assigned
- In Use
- Discharged
- Completed
- Cleaning
- Available
Enforcement path
4 sites
live deployment
800+
assets tracked
11
workflow states
243
test files