CloudSketch AI Logo
FeaturesTemplatesPricingEnterpriseAboutContactLog in
🌙☀️
Log inStart free
Home/Templates/Home Interiors

🛋️ Home Interiors · Database ERD

Interior Design Orders Schema

Tables for an interior design business: customers, projects, rooms, design versions, quotations, orders and installation visits.

More Home Interiors templates

Opening a template is free and never counts toward your daily diagrams. Asking the AI to change it counts as one.

Drawing diagram…

What this diagram shows

  • Each room has its own design and quotation lines
  • Design versions keep every revision the customer saw
  • Installation visits are scheduled per order

Prompt used

Home interiors database: customers have projects (one home); a project has rooms; designs are versioned per room; quotations contain line items (modular kitchen, wardrobes, false ceiling) with materials and prices; an accepted quotation becomes an order with payment milestones; installation visits are scheduled with a team.

Mermaid code
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
  }

Inside this diagram

An entity relationship diagram with 9 tables, 34 columns and 8 relationships.

Tables and their columns

  • CUSTOMER: id (PK), name, phone
  • PROJECT: id (PK), customer_id (FK), address, home_type
  • ROOM: id (PK), project_id (FK), name
  • DESIGN_VERSION: id (PK), room_id (FK), version, render_url
  • QUOTATION: id (PK), project_id (FK), total, status
  • QUOTE_LINE: id (PK), quotation_id (FK), item, material, price
  • ORDER: id (PK), quotation_id (FK), signed_on
  • PAYMENT_MILESTONE: id (PK), order_id (FK), stage, amount
  • INSTALL_VISIT: id (PK), order_id (FK), visit_date, team

Relationships

  • CUSTOMER starts PROJECT: each CUSTOMER has zero or more PROJECT, each PROJECT belongs to exactly one CUSTOMER
  • PROJECT includes ROOM: each PROJECT has one or more ROOM, each ROOM belongs to exactly one PROJECT
  • ROOM designed in DESIGN_VERSION: each ROOM has zero or more DESIGN_VERSION, each DESIGN_VERSION belongs to exactly one ROOM
  • PROJECT receives QUOTATION: each PROJECT has zero or more QUOTATION, each QUOTATION belongs to exactly one PROJECT
  • QUOTATION contains QUOTE_LINE: each QUOTATION has one or more QUOTE_LINE, each QUOTE_LINE belongs to exactly one QUOTATION
  • QUOTATION becomes ORDER: each QUOTATION has zero or one ORDER, each ORDER belongs to exactly one QUOTATION
  • ORDER paid in PAYMENT_MILESTONE: each ORDER has zero or more PAYMENT_MILESTONE, each PAYMENT_MILESTONE belongs to exactly one ORDER
  • ORDER installed via INSTALL_VISIT: each ORDER has zero or more INSTALL_VISIT, each INSTALL_VISIT belongs to exactly one ORDER

Make your own diagram like this

Describe your own system in plain English and the AI ER diagram generator draws it in seconds, in the same style as this template.

Related templates

FlowchartHome Interiors

Interior Design to Installation Workflow

An interior design project from the first enquiry to handover: consultation, site measurement, design approval, production and installation.

SequenceHome Interiors

Interior Quote to Order Sequence

How an interiors company turns a site measurement into a confirmed order: measurements, design, pricing from the catalogue, quote and booking payment.

GanttHome Interiors

Home Interior Project Schedule

A typical 45-day schedule for a 3BHK home interior project, from design sign-off to handover.

FlowchartHome Interiors

Modular Furniture Factory Production

How a modular kitchen or wardrobe design becomes finished panels in a factory: design export, cutting optimisation, edge banding, drilling and packing.

C4 ArchitectureProHome Interiors

Interior Design Business Platform

The software for a home interiors company: lead CRM, design tool, quotation engine, factory ERP and project tracking with a customer app.

State MachineHome Interiors

Interior Project Lifecycle

The states of a home interior project from lead to warranty, including design revisions, payment milestones and on-hold periods.