Engineering / Free editable template

Multi-tenant SaaS database ER diagram template

An ER diagram for a multi-tenant SaaS shows how customer data stays separated while users, billing and permissions connect. This shared-schema example puts organizations at the centre, links users through memberships with roles, and adds plans, subscriptions, invoices, projects and an audit log, using crow's foot notation.

Use this template →See the example ↓

No account needed · Opens as your own editable page

Preview the multi-tenant saas database er diagram

View full-size preview ↗
Multi-tenant SaaS database ER diagram example showing nine tables with keys marked pk, fk and uk, crow's foot relationships with optional ends, tenant isolation rules and a notation key
Everything in this example is editable. Replace the labels, move the shapes and adapt the layout to your work.

How to use this template

  1. Decide the tenancy model

    This example uses one shared schema with org_id on every tenant table. If you need a schema or database per tenant, keep the entities but move organizations and plans to a central control database.

  2. Model users through memberships

    Keep memberships as a separate table, because people often belong to several workspaces. Putting org_id directly on users makes that impossible later without a painful migration.

  3. Add your domain tables

    Replace projects with the core objects of your product and give each one org_id. Then check that every query path can be filtered by tenant before writing the first migration.

Questions about this template

What do the crow's foot ends on the lines mean?

A crow's foot means many, a single bar means one and a circle marks an optional end. The notation key on the board shows each one.

Do I need an account to use it?

No. Open the template and edit it in your browser. Your work saves on this device. An account is optional if you want to sync your workspace.

Can I export the finished diagram?

Yes. Use Export in the editor to save a PNG, SVG or PDF, or download an editable .epicdraw backup.

More Engineering templates →