Tables


SchemaSpy Analysis of tww.tww_vl

Generated on Sun Nov 24 04:45 GMT 2024

XML Representation
Insertion Order Deletion Order
TABLES 178
VIEWS 0
COLUMNS 2319
Constraints 0
Anomalies 0
Routines 0

Database Properties

Database Type: PostgreSQL - 14.13 (Debian 14.13-1.pgdg110+1)

Tables

Table / View Children Parents Columns Rows Type Comments
catchment_area_text_textvali 1 0 13 -1 Table
reach_point_outlet_shape 1 0 13 -1 Table
wwtp_structure_kind 1 0 13 -1 Table
channel_seepage 1 0 13 -1 Table
measure_status 1 0 13 -1 Table
disposal_disposal_place_current 1 0 13 -1 Table
maintenance_kind 1 0 13 -1 Table
wastewater_node_elevation_accuracy 1 0 13 -1 Table
throttle_shut_off_unit_kind 1 0 13 -1 Table
wastewater_structure_rv_construction_type 1 0 13 -1 Table
reach_inside_coating 1 0 13 -1 Table
drainless_toilet_kind 1 0 13 -1 Table
file_kind 1 0 13 -1 Table
infiltration_zone_infiltration_capacity 1 0 13 -1 Table
manhole_amphibian_exit 1 0 13 -1 Table
building_group_drinking_water_others 1 0 13 -1 Table
wastewater_structure_accessibility 1 0 13 -1 Table
pump_placement_of_actuation 1 0 13 -1 Table
individual_surface_pavement 1 0 13 -1 Table
channel_connection_type 1 0 13 -1 Table
small_treatment_plant_remote_monitoring 1 0 13 -1 Table
channel_usage_planned 1 0 13 -1 Table
disposal_disposal_place_planned 1 0 13 -1 Table
waste_water_treatment_kind 1 0 13 -1 Table
retention_body_kind 1 0 13 -1 Table
log_card_information_source 1 0 13 -1 Table
mutation_kind 1 0 13 -1 Table
channel_function_amelioration 1 0 13 -1 Table
sia405cc_cable_elevation_determination 1 0 13 -1 Table
sia405cc_cable_point_horizontal_positioning 1 0 13 -1 Table
farm_cesspit_volume 1 0 13 -1 Table
examination_recording_type 1 0 13 -1 Table
overflow_actuation 1 0 13 -1 Table
channel_function_hierarchic 1 0 17 14 Table
throttle_shut_off_unit_adjustability 1 0 13 -1 Table
prank_weir_weir_edge 1 0 13 -1 Table
overflow_signal_transmission 1 0 13 -1 Table
catchment_area_text_texthali 1 0 13 -1 Table
measure_category 1 0 13 -1 Table
data_media_kind 1 0 13 -1 Table
throttle_shut_off_unit_signal_transmission 1 0 13 -1 Table
building_group_function 1 0 13 -1 Table
sia405cc_cable_point_kind 1 0 13 -1 Table
catchment_area_infiltration_current 1 0 13 -1 Table
reach_material 1 0 13 -1 Table
catchment_area_direct_discharge_current 1 0 13 -1 Table
mechanical_pretreatment_kind 1 0 13 -1 Table
wastewater_structure_renovation_necessity 1 0 13 -1 Table
discharge_point_relevance 1 0 13 -1 Table
catchment_area_drainage_system_planned 1 0 13 -1 Table
infiltration_installation_watertightness 1 0 13 -1 Table
solids_retention_kind 1 0 13 -1 Table
infiltration_installation_defects 1 0 13 -1 Table
bio_ecol_assessment_io_calculation 1 0 13 -1 Table
overflow_adjustability 1 0 13 -1 Table
individual_surface_function 1 0 13 -1 Table
pump_placement_of_pump 1 0 13 -1 Table
leapingweir_opening_shape 1 0 13 -1 Table
infiltration_installation_vehicle_access 1 0 13 -1 Table
measurement_result_measurement_type 1 0 13 -1 Table
reach_progression_alternative_plantype 1 0 13 -1 Table
damage_manhole_manhole_shaft_area 1 0 13 -1 Table
catchment_area_infiltration_planned 1 0 13 -1 Table
infiltration_installation_filling_material 1 0 13 -1 Table
organisation_status 1 0 13 -1 Table
bio_ecol_assessment_relevance_matrix 1 0 13 -1 Table
damage_single_damage_class 1 0 13 -1 Table
sludge_treatment_stabilisation 1 0 13 -1 Table
small_treatment_plant_function 1 0 13 -1 Table
catchment_area_text_plantype 1 0 13 -1 Table
cover_positional_accuracy 1 0 13 -1 Table
prank_weir_weir_kind 1 0 13 -1 Table
damage_channel_channel_damage_code 1 0 13 311 Table
channel_function_hydraulic 1 0 13 -1 Table
special_structure_bypass 1 0 13 -1 Table
hydraulic_char_data_status 1 0 13 -1 Table
bio_ecol_assessment_intervention_demand 1 0 13 -1 Table
channel_usage_current 1 0 14 -1 Table
building_group_connection_wwtp 1 0 13 -1 Table
bio_ecol_assessment_impact_external_aspect 1 0 13 -1 Table
dryweather_flume_material 1 0 13 -1 Table
pipe_profile_profile_type 1 0 13 -1 Table
overflow_function 1 0 13 -1 Table
sia405cc_cable_status 1 0 13 -1 Table
infiltration_installation_kind 1 0 13 -1 Table
reach_text_plantype 1 0 13 -1 Table
cover_venting 1 0 13 -1 Table
building_group_drainage_map 1 0 13 -1 Table
bio_ecol_assessment_impact_macroinvertebrates 1 0 13 -1 Table
infiltration_installation_emergency_overflow 1 0 13 -1 Table
wastewater_structure_elevation_determination 1 0 13 -1 Table
special_structure_stormwater_tank_arrangement 1 0 13 -1 Table
tank_emptying_kind 1 0 13 -1 Table
building_group_renovation_necessity 1 0 13 -1 Table
tank_cleaning_kind 1 0 13 -1 Table
throttle_shut_off_unit_actuation 1 0 13 -1 Table
damage_connection 1 0 13 -1 Table
sia405cc_cable_horizontal_positioning 1 0 13 -1 Table
special_structure_emergency_overflow 1 0 13 -1 Table
farm_shepherds_hut_wastewater 1 0 13 -1 Table
special_structure_function 1 0 13 -1 Table
maintenance_event_status 1 0 13 -1 Table
wastewater_structure_text_plantype 1 0 13 -1 Table
manhole_function 1 0 13 -1 Table
farm_conformity 1 0 13 -1 Table
wastewater_structure_status 1 0 13 -1 Table
damage_manhole_manhole_damage_code 1 0 13 322 Table
manhole_material 1 0 13 -1 Table
wastewater_structure_structure_condition 1 0 13 -1 Table
hydraulic_char_data_pump_characteristics 1 0 13 -1 Table
building_group_electric_connection 1 0 13 -1 Table
cover_cover_shape 1 0 13 -1 Table
manhole_surface_inflow 1 0 13 -1 Table
building_group_connecting_obligation 1 0 13 -1 Table
sia405cc_cable_point_elevation_determination 1 0 13 -1 Table
bio_ecol_assessment_kind_water_body 1 0 13 -1 Table
examination_weather 1 0 13 -1 Table
sia405cc_cable_point_status 1 0 13 -1 Table
benching_kind 1 0 13 -1 Table
overflow_char_kind_overflow_char 1 0 13 -1 Table
reach_relining_construction 1 0 13 -1 Table
catchment_area_retention_planned 1 0 13 -1 Table
special_structure_possibility_intervention 1 0 13 -1 Table
measuring_point_damming_device 1 0 13 -1 Table
organisation_organisation_type 1 0 13 -1 Table
sia405cc_cable_cable_type 1 0 13 -1 Table
reach_relining_kind 1 0 13 -1 Table
farm_stable_cattle 1 0 13 -1 Table
sia405cc_cable_function 1 0 13 -1 Table
measurement_series_kind 1 0 13 -1 Table
reach_leak_protection 1 0 13 -1 Table
reach_text_texthali 1 0 13 -1 Table
backflow_prevention_kind 1 0 13 -1 Table
bio_ecol_assessment_impact_auxiliary_indic 1 0 13 -1 Table
measuring_point_purpose 1 0 13 -1 Table
reach_elevation_determination 1 0 13 -1 Table
wastewater_node_function_node_amelioration 1 0 13 -1 Table
measuring_device_kind 1 0 13 -1 Table
pump_construction_type 1 0 13 -1 Table
reach_reliner_material 1 0 13 -1 Table
value_list_base 0 0 13 -1 Table
access_aid_kind 1 0 13 -1 Table
bio_ecol_assessment_impact_water_plants 1 0 13 -1 Table
structure_part_renovation_demand 1 0 13 -1 Table
manhole_possibility_intervention 1 0 13 -1 Table
catchment_area_drainage_system_current 1 0 13 -1 Table
file_classname 1 0 13 110 Table
hydraulic_char_data_main_weir_kind 1 0 13 -1 Table
reach_horizontal_positioning 1 0 13 -1 Table
waste_water_treatment_plant_operator_type 1 0 13 -1 Table
wastewater_structure_text_textvali 1 0 13 -1 Table
bio_ecol_assessment_comparison_last 1 0 13 -1 Table
cover_sludge_bucket 1 0 13 -1 Table
cover_fastening 1 0 13 -1 Table
reach_point_elevation_accuracy 1 0 13 -1 Table
hydraulic_char_data_is_overflowing 1 0 13 -1 Table
wastewater_structure_text_texthali 1 0 13 -1 Table
farm_continuance 1 0 13 -1 Table
catchment_area_direct_discharge_planned 1 0 13 -1 Table
wastewater_structure_symbol_plantype 1 0 13 -1 Table
drainage_system_kind 1 0 13 -1 Table
electromechanical_equipment_kind 1 0 13 -1 Table
special_structure_amphibian_exit 1 0 13 -1 Table
building_group_drinking_water_network 1 0 13 -1 Table
dss15_planning_zone_kind 1 0 13 -1 Table
log_card_control_remote_control 1 0 13 -1 Table
reach_text_textvali 1 0 13 -1 Table
infiltration_installation_seepage_utilization 1 0 13 -1 Table
measure_priority 1 0 13 -1 Table
overflow_control 1 0 13 -1 Table
electric_equipment_kind 1 0 13 -1 Table
infiltration_installation_labeling 1 0 13 -1 Table
reach_point_pipe_closure 1 0 13 -1 Table
catchment_area_retention_current 1 0 13 -1 Table
wastewater_structure_financing 1 0 13 -1 Table
channel_bedding_encasement 1 0 13 -1 Table
cover_material 1 0 13 -1 Table
throttle_shut_off_unit_control 1 0 13 -1 Table