Database Properties
Database Type: PostgreSQL - 16.10
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| pipe_point_elevation_determination | 1 | 0 | 23 | -1 | Table | |
| structure_grid_type | 1 | 0 | 23 | -1 | Table | |
| pipe_section_coating | 1 | 0 | 23 | -1 | Table | |
| sia405pt_protection_tube_status | 1 | 0 | 23 | -1 | Table | |
| structure_kind | 1 | 0 | 23 | -1 | Table | |
| pipe_section_pipeline_quality | 1 | 0 | 23 | -1 | Table | |
| trench_embedding | 1 | 0 | 23 | -1 | Table | |
| pipe_section_pipe_type | 1 | 0 | 23 | -1 | Table | |
| structure_horizontal_positioning | 1 | 0 | 23 | -1 | Table | |
| sia405pt_protection_tube_horizontal_positioning | 1 | 0 | 23 | -1 | Table | |
| sia405cc_cable_horizontal_positioning | 1 | 0 | 23 | -1 | Table | |
| file_kind | 1 | 0 | 23 | -1 | Table | |
| pipe_section_mg_signaling_band | 1 | 0 | 23 | -1 | Table | |
| trench_cable_conduits | 1 | 0 | 23 | -1 | Table | |
| pipe_section_horizontal_positioning | 1 | 0 | 23 | -1 | Table | |
| pipe_section_mg_trench_type | 1 | 0 | 23 | -1 | Table | |
| pipe_point_feed_kind | 1 | 0 | 23 | -1 | Table | |
| sia405cc_cable_elevation_determination | 1 | 0 | 23 | -1 | Table | |
| sia405cc_cable_point_elevation_determination | 1 | 0 | 23 | -1 | Table | |
| sia405cc_cable_point_horizontal_positioning | 1 | 0 | 23 | -1 | Table | |
| sia405cc_cable_point_status | 1 | 0 | 23 | -1 | Table | |
| pipe_section_status | 1 | 0 | 23 | -1 | Table | |
| trench_point_kind | 1 | 0 | 23 | -1 | Table | |
| organisation_organisation_type | 1 | 0 | 23 | -1 | Table | |
| trench_trench_type | 1 | 0 | 23 | -1 | Table | |
| pipe_section_mg_diameter | 1 | 0 | 28 | -1 | Table | List of materials for pipe. All the possible combinations material/diameter are listed in this table. _displayname_fr, _displayname_de and _displayname_en are automatically generated by rules on insert and update. They are meant to be used in QGIS for the combo box of pipe.fk_material. Remark: The pipe industry maintains two different ways to refer to the dimension of a pipe: - Nominal Diameter (DN) which is commonly used for steel/iron, plastic pipes. Both diameter_inner and diameter_outer refer to the tube. - Outer Diameter(OD) is taken into consideration for the insulation of the pre-insulated metal, flexible metal and plastic pipes (from 1 to 3 are maintained in pipe_section_pipe_od table) The DN is a number that represents the approximate interior diameter, in mm. The value represents only an approximation of the pipe diameter so that engineers use a nice round number; the actual value is usually off by a few mm. So, when referring simply to the diameter, it is assumed that for plastic pipes you’re referring to the outer one, and for iron/steel and GRP ones to the approximate interior one - Nominal Diameter (DN). |
| structure_condition | 1 | 0 | 23 | -1 | Table | |
| data_media_kind | 1 | 0 | 23 | -1 | Table | |
| sia405cc_cable_cable_type | 1 | 0 | 23 | -1 | Table | |
| trench_status | 1 | 0 | 23 | -1 | Table | |
| structure_discharge_type | 1 | 0 | 23 | -1 | Table | |
| trench_point_horizontal_positioning | 1 | 0 | 23 | -1 | Table | |
| sia405cc_cable_function | 1 | 0 | 23 | -1 | Table | |
| sia405cc_cable_point_kind | 1 | 0 | 23 | -1 | Table | |
| pipe_point_horizontal_positioning | 1 | 0 | 23 | -1 | Table | |
| value_list_base | 0 | 0 | 23 | -1 | Table | |
| pipe_point_feed_category | 1 | 0 | 23 | -1 | Table | |
| pipe_section_insulation_kind | 1 | 0 | 23 | -1 | Table | |
| pipe_point_normal_armature_setting | 1 | 0 | 23 | -1 | Table | |
| trench_point_elevation_determination | 1 | 0 | 23 | -1 | Table | |
| file_classname | 1 | 0 | 23 | -1 | Table | |
| structure_measuring_system | 1 | 0 | 23 | -1 | Table | |
| trench_control_system | 1 | 0 | 23 | -1 | Table | |
| pipe_section_fluent | 1 | 0 | 23 | -1 | Table | |
| pipe_section_mg_material | 1 | 0 | 23 | -1 | Table | |
| sia405pt_protection_tube_material | 1 | 0 | 23 | -1 | Table | |
| structure_drainage_pump | 1 | 0 | 23 | -1 | Table | |
| organisation_status | 1 | 0 | 23 | -1 | Table | |
| pipe_point_normal_material | 1 | 0 | 23 | -1 | Table | |
| trench_horizontal_positioning | 1 | 0 | 23 | -1 | Table | |
| structure_status | 1 | 0 | 23 | -1 | Table | |
| structure_venting | 1 | 0 | 23 | -1 | Table | |
| structure_power_connection | 1 | 0 | 23 | -1 | Table | |
| pipe_point_normal_kind | 1 | 0 | 23 | -1 | Table | |
| pipe_section_function | 1 | 0 | 23 | -1 | Table | |
| sia405cc_cable_status | 1 | 0 | 23 | -1 | Table |