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

🏗️ Construction · Database ERD

Construction Project Database Schema

Tables for a construction project system: projects, sites, work packages, subcontractors, materials, daily logs and payments.

More Construction 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

  • Work packages break the project into billable parts
  • Daily site logs record labour, weather and progress
  • Subcontractor bills are paid against measured work

Prompt used

Construction project database: projects have sites and work packages (foundation, structure, MEP, finishing) with budgets; subcontractors are assigned to packages; materials are requisitioned and delivered to sites; daily logs record manpower, weather and progress; measurement bills (running account bills) are raised by subcontractors and paid.

Mermaid code
erDiagram
  PROJECT ||--|{ SITE : has
  PROJECT ||--|{ WORK_PACKAGE : "divided into"
  SUBCONTRACTOR ||--o{ WORK_PACKAGE : executes
  SITE ||--o{ MATERIAL_DELIVERY : receives
  MATERIAL ||--o{ MATERIAL_DELIVERY : "delivered as"
  SITE ||--o{ DAILY_LOG : records
  WORK_PACKAGE ||--o{ RA_BILL : "billed via"
  RA_BILL ||--o{ PAYMENT : "paid by"
  PROJECT {
    int id PK
    string name
    decimal budget
  }
  SITE {
    int id PK
    int project_id FK
    string address
  }
  WORK_PACKAGE {
    int id PK
    int project_id FK
    int subcontractor_id FK
    string name
    decimal budget
  }
  SUBCONTRACTOR {
    int id PK
    string name
    string trade
  }
  MATERIAL {
    int id PK
    string name
    string unit
  }
  MATERIAL_DELIVERY {
    int id PK
    int site_id FK
    int material_id FK
    decimal quantity
    date delivered_on
  }
  DAILY_LOG {
    int id PK
    int site_id FK
    date log_date
    int manpower
    string weather
  }
  RA_BILL {
    int id PK
    int work_package_id FK
    decimal measured_value
    string status
  }
  PAYMENT {
    int id PK
    int ra_bill_id FK
    decimal amount
    date paid_on
  }

Inside this diagram

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

Tables and their columns

  • PROJECT: id (PK), name, budget
  • SITE: id (PK), project_id (FK), address
  • WORK_PACKAGE: id (PK), project_id (FK), subcontractor_id (FK), name, budget
  • SUBCONTRACTOR: id (PK), name, trade
  • MATERIAL_DELIVERY: id (PK), site_id (FK), material_id (FK), quantity, delivered_on
  • MATERIAL: id (PK), name, unit
  • DAILY_LOG: id (PK), site_id (FK), log_date, manpower, weather
  • RA_BILL: id (PK), work_package_id (FK), measured_value, status
  • PAYMENT: id (PK), ra_bill_id (FK), amount, paid_on

Relationships

  • PROJECT has SITE: each PROJECT has one or more SITE, each SITE belongs to exactly one PROJECT
  • PROJECT divided into WORK_PACKAGE: each PROJECT has one or more WORK_PACKAGE, each WORK_PACKAGE belongs to exactly one PROJECT
  • SUBCONTRACTOR executes WORK_PACKAGE: each SUBCONTRACTOR has zero or more WORK_PACKAGE, each WORK_PACKAGE belongs to exactly one SUBCONTRACTOR
  • SITE receives MATERIAL_DELIVERY: each SITE has zero or more MATERIAL_DELIVERY, each MATERIAL_DELIVERY belongs to exactly one SITE
  • MATERIAL delivered as MATERIAL_DELIVERY: each MATERIAL has zero or more MATERIAL_DELIVERY, each MATERIAL_DELIVERY belongs to exactly one MATERIAL
  • SITE records DAILY_LOG: each SITE has zero or more DAILY_LOG, each DAILY_LOG belongs to exactly one SITE
  • WORK_PACKAGE billed via RA_BILL: each WORK_PACKAGE has zero or more RA_BILL, each RA_BILL belongs to exactly one WORK_PACKAGE
  • RA_BILL paid by PAYMENT: each RA_BILL has zero or more PAYMENT, each PAYMENT belongs to exactly one RA_BILL

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

GanttConstruction

House Construction Project Schedule

A typical schedule for building an independent house, from approvals and foundation to finishing and handover.

FlowchartConstruction

Building Permit and Stage Inspections

How a building project moves through the local authority: plan approval, stage inspections during construction, and the occupancy certificate.

SequenceConstruction

Construction Material Procurement

How a construction site orders materials: site request, quotes from suppliers, purchase order, delivery, quality check and payment.

C4 ArchitectureProConstruction

Construction Project Management Platform

A platform for running building projects: schedules, site diaries, drawings, RFIs, quality and safety checklists, and billing.

Data FlowConstruction

BIM Data Flow

How building information modelling (BIM) data flows between designers, contractors and the owner: coordination, clash detection, quantities and handover.

FlowchartConstruction

Construction Site Safety Inspection

A daily safety inspection routine on a construction site: checklists, hazard reporting, stop-work authority and follow-up.