Table: building_functionality
Description (EN): This table represents building functionality of components. In the database's inheritance architecture, it acts as a direct sub-type of the component table. It does not store redundant descriptive columns; instead, it uses a shared primary key to inherit all high-level attributes (such as name, location, management type, and geometry) from its parent component record.
Column Structure
| Column | Data type | Definition | Example value | Constraint? | Geometry? | Comments |
|---|---|---|---|---|---|---|
id |
BIGINT | Unique identifier for the building component functionality | 42 |
PK, FK | No | Primary key that also acts as a Foreign Key referencing component.id |
floor_number |
BIGINT | Number of floors | 2 |
- | No | - |
[...]