Car Dealer Management Schema

erDiagram
  VEHICLE_MODEL ||--o{ VEHICLE : "stock of"
  CUSTOMER ||--o{ LEAD : raises
  LEAD ||--o{ TEST_DRIVE : includes
  VEHICLE ||--o{ TEST_DRIVE : "used in"
  CUSTOMER ||--o{ BOOKING : makes
  VEHICLE ||--o| BOOKING : "reserved by"
  BOOKING ||--o| SALE : "becomes"
  VEHICLE ||--o{ SERVICE_JOB : "serviced in"
  VEHICLE {
    string vin PK
    int model_id FK
    string colour
    string status
  }
  CUSTOMER {
    int id PK
    string name
    string mobile
  }
  BOOKING {
    int id PK
    int customer_id FK
    string vin FK
    decimal booking_amount
  }
  SALE {
    int id PK
    int booking_id FK
    decimal invoice_amount
    date delivered_on
  }
  SERVICE_JOB {
    int id PK
    string vin FK
    int odometer
    date job_date
  }