Vai al contenuto

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 -

[...]