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 (renovationMeasures)
Schema — scenario_measures	backend/src/db/schema.ts (scenarioMeasures)
Routes	backend/src/routes/measures.ts, backend/src/routes/scenario-measures.ts

Database Tables

Table	Purpose
renovation_measures	Building-level measures — type, priority, current/target state
scenario_measures	Measures within a scenario — status lifecycle, cost tracking, component linking
cost_breakdowns	Detailed cost categories per scenario measure (planned vs. actual)

Key Fields — Renovation Measures

Field	Type	Notes
buildingId	uuid FK	Parent building (cascade)
measureType	enum	roof, facade, windows, doors, heating, ventilation, solar_panels, insulation, electrical, plumbing, other
priority	enum	low, medium, high, critical
status	varchar	Default planned
currentState	jsonb	Description, energy class, estimated cost/savings
targetState	jsonb	Target parameters after renovation

Key Fields — Scenario Measures

Field	Type	Notes
scenarioId	uuid FK	Parent scenario (cascade)
buildingId	uuid FK	Parent building (cascade) — no direct projectId; the project comes via the scenario
measureType	enum	Same enum as renovation measures
status	enum	draft → planned → approved → in_progress → completed / cancelled
priority	enum	low, medium, high, critical
isLocked, lockedAt, lockedBy	bool/timestamp/uuid	Locked when moving to execution phase
buildingComponentId	uuid FK	Links to Building Components (set null)
currentState / targetState	jsonb	Before/after parameters (costs, specs, energy class)
executionOrder	integer	Order of execution within the scenario
dependencies	jsonb	IDs of measures that must be completed first

Measure Types

Type	Examples
roof	Roof insulation, re-roofing
facade	External wall insulation (ETICS/WDVS)
windows	Window replacement, triple glazing
doors	Door replacement, thermal upgrade
heating	Heat pump installation, boiler replacement
ventilation	Mechanical ventilation with heat recovery
solar_panels	PV installation, solar thermal
insulation	Basement ceiling, top floor ceiling
electrical / plumbing	System modernization

Relationships

Renovation Measure *──1 Building
Scenario Measure *──1 Scenario
Scenario Measure *──1 Building (denormalized FK)
Scenario Measure *──1 Building Component (optional)
Scenario Measure 1──* Cost Breakdowns
Funding Measure *──1 Building Component (funding links go through components, not scenario 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 — funding_measures rows link Funding Applications to Funding Programs measure definitions, optionally tied to a building component
• 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