architecture notes

core vs tenant schema — how to decide where a table goes

the actual test for whether a table belongs in the shared core schema or inside each tenant's own schema, worked through with real examples (payments, monitors, notifications, audit logs)

multitenancy with schema-per-tenant

how the uptime monitor saas isolates tenant data using postgres schemas instead of a shared table with tenant_id