building
Core TablePortfolio & Properties
Stores buildings within a property including physical attributes, classifications and key references.
Primary Key
building_code
Record Type
Operational
Log Tables
building_log
Summary Views
daily_building_summary
Last Updated
May 20, 2026
AI Usefulness
4.6
/ 5.0
High value for AI analytics, prediction and automation.
All (8)Key (1)Calculated (2)
| Field Code | Caption | Data Type | Length | PK | Calculated | Description |
|---|---|---|---|---|---|---|
| building_code | Building Code | Varchar | 50 | — | Unique code for each building. | |
| building_name | Building Name | Varchar | 255 | — | — | Name of the building. |
| property_code | Property Code | Varchar | 50 | — | — | Property where the building is located. |
| building_type_code | Building Type Code | Varchar | 50 | — | — | Reference to building_type table. |
| year_built | Year Built | Integer | — | — | — | Year the building was constructed. |
| gross_floor_area | Gross Floor Area (m²) | Decimal | 18,2 | — | — | Total gross floor area. |
| net_floor_area | Net Floor Area (m²) | Decimal | 18,2 | — | — | Net area of the building. |
| status_code | Status Code | Varchar | 50 | — | — | Current status of the building. |
Showing 8 of 8 (47 total in schema)
Relationships (Links to)
- property N:1Building belongs to a property.
- floor 1:NBuilding contains floors.
- building_type N:1Reference to classification.
Operational Meaning
The building table anchors every physical operation in the platform — from work orders and inspections to occupancy and energy use. Every space, asset and task ultimately resolves to a building.
AI Opportunities
- Maintenance cost benchmarking by building
- Energy & utility usage prediction
- Compliance risk scoring
- Portfolio-wide condition assessment
Suggested Queries
- "Show all buildings with the highest maintenance cost in the last 90 days."
- "Which buildings are due for fire-system inspection this quarter?"
- "Rank buildings by open work order backlog."