Tenant Isolation by Design
- All application queries are scoped by tenant identifier
- Postgres Row-Level Security (RLS) policies enforce tenant boundaries
- Cross-tenant access is prevented at the database level, not just in application code
- Referential constraints ensure records cannot reference data outside their tenant
This means data isolation is not dependent on UI filtering or business logic alone: it is enforced at the storage layer.