Measures
Renovation measures representing specific improvements applied to Buildings . Two complementary models exist: renovation_measures (building-level catalog) and scenario_measures (measures linked to Scenarios for planning and execution).
Source Files
Layer Path Schema — renovation_measures backend/src/db/schema.ts (line ~675)Schema — scenario_measures backend/src/db/schema.ts (line ~949)Routes backend/src/routes/measures.ts, backend/src/routes/scenario-measures.ts
Database Tables
Table Purpose renovation_measuresBuilding-level measures — type, priority, current/target state scenario_measuresMeasures within a scenario — status lifecycle, cost tracking, component linking cost_breakdownsDetailed cost categories per scenario measure (planned vs. actual)
Key Fields — Renovation Measures
Field Type Notes buildingIduuid FK Parent building (cascade) measureTypeenum roof, facade, windows, doors, heating, ventilation, solar_panels, insulation, electrical, plumbing, otherpriorityenum low, medium, high, criticalstatusvarchar Default planned currentStatejsonb Description, energy class, estimated cost/savings targetStatejsonb Target parameters after renovation
Key Fields — Scenario Measures
Field Type Notes projectId / scenarioIduuid FK Parent project and scenario measureTypeenum Same enum as renovation measures statusenum draft → planned → approved → in_progress → completed / cancelledpriorityenum low, medium, high, criticalisLockedboolean Locked when moving to execution phase buildingComponentIduuid FK Links to Building Components currentStatejsonb Current parameters (costs, specs, etc.)
Measure Types
Type Examples roofRoof insulation, re-roofing facadeExternal wall insulation (ETICS/WDVS) windowsWindow replacement, triple glazing doorsDoor replacement, thermal upgrade heatingHeat pump installation, boiler replacement ventilationMechanical ventilation with heat recovery solar_panelsPV installation, solar thermal insulationBasement ceiling, top floor ceiling electrical / plumbingSystem modernization
Relationships
Renovation Measure *──1 Building
Scenario Measure *──1 Scenario
Scenario Measure *──1 Building Component (optional)
Scenario Measure 1──* Cost Breakdowns
Scenario Measure *──* Funding Measures (via funding_measures)
Features
Current/target state tracking — jsonb fields capture before/after parameters
Status lifecycle for scenario measures with locking at execution phase
Cost breakdowns per scenario measure (material, labor, planning) with payment tracking
Component linking — scenario measures reference specific Building Components
Funding eligibility — measures map to Funding Programs measure definitions
Energy Calculations — each measure has energy savings impact
Scenario Planning — compare measure combinations across Scenarios
Related Pages
Buildings | Scenarios | Building Components | Funding Programs | Funding Applications | Energy Calculations | Scenario Planning | Financial Calculations | Database Architecture