SaaS Multi-tenant Schema (DBML)

Tenants, users, and memberships for a multi-tenant SaaS.

Template previewDBML

Make it your own.

Table tenants {
  id uuid [pk]
  name varchar
  plan varchar
  created_at timestamp
}

Table users {
  id uuid [pk]
  email varchar [unique]
  name varchar
}

Table memberships {
  id uuid [pk]
  tenant_id uuid [ref: > tenants.id]
  user_id uuid [ref: > users.id]
  role varchar [note: 'owner | admin | member']
}

Table projects {
  id uuid [pk]
  tenant_id uuid [ref: > tenants.id]
  name varchar
  archived boolean
}