DBML — SaaS multi-tenant schema

Table tenants {
  id uuid [pk]
  slug varchar [unique]
  plan varchar
  created_at timestamp
}
Table users {
  id uuid [pk]
  tenant_id uuid [ref: > tenants.id]
  email varchar
  role varchar
}
Table subscriptions {
  id uuid [pk]
  tenant_id uuid [ref: > tenants.id]
  status varchar
  current_period_end timestamp
}
Table audit_log {
  id bigint [pk, increment]
  tenant_id uuid [ref: > tenants.id]
  actor_id uuid [ref: > users.id]
  action varchar
  at timestamp
}