Scenarios

A renovation scenario within a project, representing one possible approach to renovating a building. Multiple scenarios can be compared before selecting one for execution.

Source Files

Layer	Path
Schema	backend/src/db/schema.ts (line ~923)
Routes	backend/src/routes/scenarios.ts, backend/src/routes/scenario-measures.ts
Pages	frontend/src/pages/ScenarioDetail.tsx
Queries	frontend/src/lib/queries/scenarioQueries.ts

Database Tables

Table	Purpose
scenarios	Main entity — name, costs, savings, energy score, active/selected flags
scenario_measures	Renovation measures linked to a scenario — see Measures

Key Fields

Field	Type	Notes
projectId	uuid FK	Parent project (cascade delete)
name	varchar(200)	Scenario name
scenarioNumber	integer	Display order within project
isActive	boolean	Whether the scenario is still under consideration
isSelected	boolean	Chosen for execution planning
totalEstimatedCost	real	Sum of all measure costs
totalEstimatedSavings	real	Projected annual savings
energyImprovementScore	integer	0-100 score for energy improvement
assumptions	jsonb	Underlying assumptions for calculations
createdBy	uuid FK	User who created the scenario

Relationships

Scenario *──1 Project
Scenario 1──* Scenario Measures (Measures)
Scenario 1──* Funding Applications
Scenario *──1 Users (creator)

A project’s selectedScenarioId points to the winning scenario.

Scenario Measures

Each measure in scenario_measures represents a specific renovation action:

Field	Type	Notes
measureType	enum	roof, facade, windows, doors, heating, ventilation, solar_panels, insulation, electrical, plumbing, other
priority	enum	low, medium, high, critical
status	enum	draft → planned → approved → in_progress → completed / cancelled
isLocked	boolean	Locked when moving to execution phase
buildingComponentId	uuid FK	Links to Building Components
currentState	jsonb	Current parameters (costs, specs, etc.)

Frontend Components

Component	Purpose
ScenarioForm	Create/edit scenario details
ScenarioComparison	Side-by-side comparison of scenarios
ScenarioPlanning	Planning view for measure management
ScenarioMeasures	List/manage Measures within a scenario

Features

• Scenario comparison — side-by-side view of cost, savings, energy impact
• Measure management with status lifecycle and locking for execution
• Energy Calculations — energy improvement scoring per scenario
• Scenario Planning — planning interface for renovation strategy
• Selection flow — chosen scenario links to project’s selectedScenarioId
• Access control via RBAC Authorization (verifyScenarioAccess())

Related Pages

Projects | Buildings | Measures | Building Components | Funding Applications | Energy Calculations | Scenario Planning | Financial Calculations | RBAC Authorization