Vai al contenuto

Table: added_block

Description (EN): This table represents added blocks of buildings. 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 added block 42 PK, FK No Primary key that also acts as a Foreign Key referencing component.id
position VARCHAR [...] EXTERNAL - No [...]
vertical_mat VARCHAR [...] [...] - No [...]
horizontal_mat VARCHAR [...] [...] - No [...]
n_floor BIGINT Number of floors of the added block 2 - No [...]
total_height BIGINT Total height of the added block in [measurement unit] 200 - No [...]
floor_surface BIGINT Total floor surface of the added block in [measurement unit] 200 - No [...]
floor_height BIGINT Total floor height of the added block in [measurement unit] 200 - No [...]
function VARCHAR [...] [...] - No [...]
previous_survey VARCHAR [...] [...] - No [...]

Relationships

  • Inherits from (Sub-type of): component. The added_block table is a specialized extension of the component table.
  • Belongs to: enterprise (A component sub-type is linked to one enterprise)
  • Has many: damage (A component sub-type can be affected by multiple damage over time)

!!! tip "Where is the rest of the data?" To find the name, geographical location (geometry, town, country), or ownership details of a added_block, you must join this table with the component record that shares the exact same id.

Example Query

Retrieve a list of all added blocks, including their names, towns, and spatial coordinates, by joining the table with its parent component entity:

SELECT 
    ab.id, 
    c.name, 
    c.town, 
    ST_AsText(c.geometry) as coordinates 
FROM 
    added_block ab
JOIN 
    component c ON ab.id = c.id
WHERE 
    c.component_kind  = 'ADDED_BLOCK';