Interior Design Orders Schema

erDiagram
  CUSTOMER ||--o{ PROJECT : starts
  PROJECT ||--|{ ROOM : includes
  ROOM ||--o{ DESIGN_VERSION : "designed in"
  PROJECT ||--o{ QUOTATION : receives
  QUOTATION ||--|{ QUOTE_LINE : contains
  QUOTATION ||--o| ORDER : "becomes"
  ORDER ||--o{ PAYMENT_MILESTONE : "paid in"
  ORDER ||--o{ INSTALL_VISIT : "installed via"
  CUSTOMER {
    int id PK
    string name
    string phone
  }
  PROJECT {
    int id PK
    int customer_id FK
    string address
    string home_type
  }
  ROOM {
    int id PK
    int project_id FK
    string name
  }
  DESIGN_VERSION {
    int id PK
    int room_id FK
    int version
    string render_url
  }
  QUOTATION {
    int id PK
    int project_id FK
    decimal total
    string status
  }
  QUOTE_LINE {
    int id PK
    int quotation_id FK
    string item
    string material
    decimal price
  }
  ORDER {
    int id PK
    int quotation_id FK
    date signed_on
  }
  PAYMENT_MILESTONE {
    int id PK
    int order_id FK
    string stage
    decimal amount
  }
  INSTALL_VISIT {
    int id PK
    int order_id FK
    date visit_date
    string team
  }