space
Core TablePortfolio & Properties
Defines physical spaces within buildings including usage, occupancy and capacity information.
Primary Key
space_code
Record Type
Operational
Log Tables
space_occupancy_log
Summary Views
monthly_space_occupancy_summary
Last Updated
May 20, 2026
AI Usefulness
4.5
/ 5.0
High value for AI analytics, prediction and automation.
All (7)Key (1)Calculated (2)
| Field Code | Caption | Data Type | Length | PK | Calculated | Description |
|---|---|---|---|---|---|---|
| space_code | Space Code | Varchar | 50 | — | Unique code for each space. | |
| space_name | Space Name | Varchar | 255 | — | — | Name of the space. |
| building_code | Building Code | Varchar | 50 | — | — | Building where the space is located. |
| floor_code | Floor Code | Varchar | 50 | — | — | Floor where the space is located. |
| space_type_code | Space Type Code | Varchar | 50 | — | — | Reference to space_type. |
| area_m2 | Area (m²) | Decimal | 18,2 | — | — | Net area of the space. |
| capacity | Capacity | Integer | — | — | — | Occupancy capacity. |
Showing 7 of 7 (41 total in schema)
Relationships (Links to)
- building N:1Space belongs to a building.
- floor N:1Space belongs to a floor.
- space_type N:1Space classification.
- zone N:NSpaces aggregated into zones.
Operational Meaning
Drives space planning, occupancy analytics, MAC projects and cleaning/security routing.
AI Opportunities
- Occupancy optimization
- Space utilization scoring
- Capacity planning
- Cleaning route optimization
Suggested Queries
- "Show occupancy rate by floor for the Toronto portfolio."
- "Which spaces are under 30% utilized this quarter?"
- "List spaces with capacity reductions in the last MAC project."