CRM Schema (DBML)

Table users {
  id uuid [pk]
  name varchar
  role varchar
}

Table accounts {
  id uuid [pk]
  name varchar [not null]
  industry varchar
  owner_id uuid [ref: > users.id]
}

Table contacts {
  id uuid [pk]
  account_id uuid [ref: > accounts.id]
  name varchar
  email varchar [unique]
}

Table deals {
  id uuid [pk]
  account_id uuid [ref: > accounts.id]
  stage varchar
  amount decimal
  close_date date
}

Table activities {
  id uuid [pk]
  deal_id uuid [ref: > deals.id]
  type varchar
  note text
  created_at timestamp
}