Databases

Multi-Tenant SaaS Workspace and Org Schema

ER Diagrams · made in Skemio

ER diagram displaying organizations, workspaces, users, organization memberships, and workspace member role assignments.
ER diagram displaying organizations, workspaces, users, organization memberships, and workspace member role assignments.
Open it in SkemioMake your own

What it shows

  • Organizations hold billing and global identity; workspaces isolate assets.
  • Memberships bridge users to orgs; workspace roles handle scoped permissions.
  • Foreign keys ensure tenant boundaries cascade safely across all sub-resources.

The takeaway

Separate org-level billing identity from workspace-level resource scoping for bulletproof tenancy.

More er diagrams