SaaS core schema (users, orgs, plans)

Project saas_core {
  database_type: 'PostgreSQL'
}

Table organisations {
  id uuid [pk]
  name varchar [not null]
  plan_id uuid [ref: > plans.id]
  created_at timestamp
}

Table users {
  id uuid [pk]
  org_id uuid [ref: > organisations.id]
  email varchar [unique, not null]
  role varchar [note: 'owner | admin | member']
  created_at timestamp
}

Table plans {
  id uuid [pk]
  name varchar
  seats int
  monthly_price_cents int
}

Table subscriptions {
  id uuid [pk]
  org_id uuid [ref: > organisations.id]
  plan_id uuid [ref: > plans.id]
  status varchar
  current_period_end timestamp
}

Table audit_log {
  id bigserial [pk]
  org_id uuid [ref: > organisations.id]
  actor_id uuid [ref: > users.id]
  action varchar
  payload jsonb
  at timestamp
}