01Employer project
Multi-Tenant Workforce Attendance Platform
- Challenge
- A multi-location pottery studio needed one clock-in/attendance system that kept each location's staff data completely separate, with different access for front-desk staff versus owners.
- Solution
- Built a multi-tenant SaaS from the schema up — every table scoped to an organization, enforced twice over: once in application code, once as Postgres row-level security so a missing filter fails closed instead of leaking rows. JWT auth across four role tiers on top.
- Tech
- Next.js 14, NestJS, PostgreSQL, Prisma, Docker
- Result
- Core schema, tenant isolation and auth shipped and verified with a cross-org isolation test; the attendance engine is the current build phase.
