TABLES
94
VIEWS
0
COLUMNS
993
Constraints
395
Anomalies
6
Routines
0
Database Properties
Database Type: PostgreSQL - 14.13 (Debian 14.13-1.pgdg110+1)
Tables
Table / View | Children | Parents | Columns | Rows | Type | Comments |
---|---|---|---|---|---|---|
solids_retention | 0 | 2 | 6 | -1 | Table | |
sludge_treatment | 0 | 4 | 19 | -1 | Table | |
zone | 3 | 2 | 6 | -1 | Table | |
measure | 2 | 7 | 21 | -1 | Table | |
special_structure | 0 | 7 | 8 | -1 | Table | |
damage_manhole | 0 | 3 | 8 | -1 | Table | |
leapingweir | 0 | 2 | 4 | -1 | Table | |
param_ca_mouse1 | 0 | 1 | 7 | -1 | Table | |
infiltration_zone | 0 | 2 | 3 | -1 | Table | |
disposal | 2 | 7 | 12 | -1 | Table | |
wastewater_structure_symbol | 0 | 2 | 9 | -1 | Table | |
farm | 0 | 8 | 24 | -1 | Table | |
mutation | 0 | 3 | 14 | -1 | Table | |
measuring_point | 3 | 8 | 14 | -1 | Table | |
retention_body | 0 | 4 | 9 | -1 | Table | |
wastewater_node | 7 | 4 | 11 | -1 | Table | |
throttle_shut_off_unit | 2 | 10 | 21 | -1 | Table | |
discharge_point | 2 | 2 | 8 | -1 | Table | |
hydraulic_char_data | 1 | 9 | 24 | -1 | Table | |
catchment_area_totals | 0 | 4 | 19 | -1 | Table | |
mechanical_pretreatment | 0 | 4 | 8 | -1 | Table | |
measuring_device | 1 | 4 | 10 | -1 | Table | |
bio_ecol_assessment | 0 | 10 | 18 | -1 | Table | |
network_node | 2 | 2 | 5 | -1 | Table | |
hydr_geometry | 2 | 2 | 11 | -1 | Table | |
examination | 1 | 4 | 10 | -1 | Table | |
catchment_area | 2 | 18 | 40 | -1 | Table | |
access_aid | 0 | 2 | 2 | -1 | Table | |
organisation | 98 | 4 | 13 | -1 | Table | |
log_card | 6 | 9 | 13 | -1 | Table | |
connection_object | 4 | 3 | 8 | -1 | Table | |
damage | 2 | 5 | 11 | -1 | Table | |
dryweather_flume | 0 | 2 | 2 | -1 | Table | |
wwtp_structure | 0 | 3 | 3 | -1 | Table | |
maintenance | 0 | 2 | 2 | -1 | Table | |
channel | 0 | 9 | 11 | -1 | Table | |
benching | 0 | 2 | 2 | -1 | Table | |
overflow | 4 | 11 | 20 | -1 | Table | |
drainage_system | 0 | 2 | 3 | -1 | Table | |
import_manhole_quarantine | 0 | 0 | 46 | -1 | Table | |
re_building_group_disposal | 0 | 2 | 3 | -1 | Table | |
dss15_planning_zone | 0 | 2 | 3 | -1 | Table | |
reach_text | 0 | 4 | 11 | -1 | Table | |
dryweather_downspout | 0 | 1 | 2 | -1 | Table | |
wastewater_structure_text | 0 | 4 | 11 | -1 | Table | |
overflow_char | 3 | 3 | 7 | -1 | Table | |
reach_point | 4 | 6 | 13 | -1 | Table | |
cover | 1 | 7 | 11 | -1 | Table | |
tank_emptying | 0 | 4 | 7 | -1 | Table | |
waste_water_treatment_plant | 5 | 3 | 21 | -1 | Table | |
wastewater_structure | 16 | 13 | 37 | -1 | Table | |
sia405cc_cable_point | 0 | 7 | 21 | -1 | Table | |
network_segment | 0 | 3 | 6 | -1 | Table | |
prank_weir | 0 | 3 | 6 | -1 | Table | |
sia405cc_cable | 0 | 8 | 18 | -1 | Table | |
pump | 2 | 4 | 9 | -1 | Table | |
reach_progression_alternative | 0 | 2 | 5 | -1 | Table | |
control_center | 2 | 2 | 6 | -1 | Table | |
maintenance_event | 4 | 5 | 17 | -1 | Table | |
measurement_series | 1 | 5 | 10 | -1 | Table | |
wwtp_energy_use | 0 | 3 | 10 | -1 | Table | |
building | 0 | 1 | 5 | -1 | Table | |
structure_part | 12 | 4 | 8 | -1 | Table | |
catchment_area_text | 0 | 4 | 11 | -1 | Table | |
measurement_result | 0 | 5 | 12 | -1 | Table | |
infiltration_installation | 2 | 10 | 16 | -1 | Table | |
data_media | 1 | 3 | 9 | -1 | Table | |
file | 0 | 5 | 11 | -1 | Table | |
default_values | 0 | 0 | 3 | -1 | Table | |
electromechanical_equipment | 0 | 2 | 4 | -1 | Table | |
backflow_prevention | 0 | 4 | 6 | -1 | Table | |
tank_cleaning | 0 | 2 | 4 | -1 | Table | |
surface_runoff_parameters | 2 | 3 | 11 | -1 | Table | |
building_group_baugwr | 0 | 3 | 6 | -1 | Table | |
drainless_toilet | 0 | 2 | 2 | -1 | Table | |
individual_surface | 0 | 3 | 5 | -1 | Table | |
wastewater_networkelement | 11 | 3 | 7 | -1 | Table | |
reservoir | 0 | 1 | 3 | -1 | Table | |
profile_geometry | 0 | 3 | 8 | -1 | Table | |
waste_water_treatment | 0 | 4 | 8 | -1 | Table | |
fountain | 0 | 1 | 3 | -1 | Table | |
dss15_aquifer | 1 | 2 | 10 | -1 | Table | |
manhole | 0 | 6 | 9 | -1 | Table | |
param_ca_general | 0 | 1 | 6 | -1 | Table | |
re_maintenance_event_wastewater_structure | 0 | 2 | 3 | -1 | Table | |
reach | 2 | 12 | 23 | -1 | Table | |
pipe_profile | 2 | 3 | 8 | -1 | Table | |
small_treatment_plant | 0 | 3 | 5 | -1 | Table | |
electric_equipment | 0 | 2 | 4 | -1 | Table | |
hydr_geom_relation | 0 | 3 | 8 | -1 | Table | |
flushing_nozzle | 0 | 1 | 2 | -1 | Table | |
damage_channel | 0 | 2 | 7 | -1 | Table | |
building_group | 3 | 12 | 39 | -1 | Table | |
hq_relation | 0 | 3 | 8 | -1 | Table |