CRM Sales Pipeline Schema

erDiagram
  ACCOUNT ||--o{ CONTACT : employs
  ACCOUNT ||--o{ OPPORTUNITY : has
  LEAD ||--o| CONTACT : "converts to"
  SALES_USER ||--o{ OPPORTUNITY : owns
  OPPORTUNITY ||--o{ ACTIVITY : logs
  CONTACT ||--o{ ACTIVITY : involves
  OPPORTUNITY ||--o{ QUOTE : receives
  QUOTE ||--|{ QUOTE_ITEM : contains
  ACCOUNT {
    int id PK
    string name
    string industry
    string city
  }
  CONTACT {
    int id PK
    int account_id FK
    string name
    string email
  }
  LEAD {
    int id PK
    string name
    string source
    string status
  }
  SALES_USER {
    int id PK
    string name
    string team
  }
  OPPORTUNITY {
    int id PK
    int account_id FK
    int owner_id FK
    string stage
    decimal amount
    date close_date
  }
  ACTIVITY {
    int id PK
    int opportunity_id FK
    int contact_id FK
    string type
    datetime happened_at
  }
  QUOTE {
    int id PK
    int opportunity_id FK
    decimal total
    string status
  }
  QUOTE_ITEM {
    int id PK
    int quote_id FK
    string product
    int quantity
    decimal price
  }