Buildings

The core entity in Renewa One representing physical buildings undergoing renovation. Every project, scenario, and financial record traces back to a building.

Source Files

Layer	Path
Schema	backend/src/db/schema.ts (line ~631)
Routes	backend/src/routes/buildings/ (crud.ts, aggregates.ts)
Service	backend/src/services/buildings-service.ts
Pages	frontend/src/pages/Buildings.tsx, frontend/src/pages/BuildingDetail.tsx
Queries	frontend/src/lib/queries/buildingQueries.ts, buildingComponentQueries.ts, buildingRoleQueries.ts

Database Tables

Table	Purpose
buildings	Main entity — address, type, year, geometry, HubSpot sync fields
building_components	Structural elements (walls, roof, windows, etc.) — see Building Components
building_technology	Technical systems (heating, ventilation, PV, solar thermal)
building_calculation_parameters	Parameters for Energy Calculations (residential units, areas)
building_roles	RBAC Authorization — maps Contacts to buildings with roles

Key Fields

Field	Type	Notes
buildingType	enum	single_family_detached, multi_family, commercial, mixed_use_*, etc.
yearBuilt	integer	Construction year
heritageStatus	enum	none, listed_monument, ensemble_protection, unesco_world_heritage, etc.
ownershipStructure	enum	owner_occupied, rental, cooperative, condominium, mixed
street, houseNumber, postalCode, city	varchar	Unified address structure (Issue #1329)
lat, lng	double	GPS coordinates for map view
hubspotId	varchar	Bidirectional sync with HubSpot Integration
archived, deletedAt	bool/timestamp	Soft delete support

Relationships

Building 1──* Projects
Building 1──* Building Components
Building 1──* Building Technology
Building 1──* Building Calculation Parameters
Building 1──* Building Roles ──* Contacts
Building 1──* Files
Building 1──* Quotes
Building 1──* Invoices
Building *──1 Users (creator)

Frontend Components

Component	Purpose
BuildingForm	Create/edit building with address autocomplete
BuildingDetailHeader	Title, status badges, actions
BuildingInfoCards	Summary cards (type, year, heritage, ownership)
BuildingMap	Leaflet map view with building marker
BuildingTabs	Tab navigation on detail page
BuildingFinancialsTab	Quotes and Invoices overview
BuildingFilesTab	Attached Files and Documents

Features

• Map view on the buildings list page (Leaflet) with geocoded markers
• Energy calculations via Building Components and calculation parameters
• Financial overview aggregating Quotes and Invoices per building
• HubSpot sync — buildings map to HubSpot deals with pipeline/stage tracking
• Access control via building_roles table and RBAC Authorization (verifyBuildingAccess())

Related Pages

Projects | Building Components | Scenarios | Files | Quotes | Invoices | Contacts | Energy Calculations | Financial Calculations | HubSpot Integration | Database Architecture