395 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| oorel_od_solids_retention_structure_part |
|
|
Cascade on delete | ||
| fkey_vl_solids_retention_kind |
|
|
Restrict delete | ||
| rel_sludge_treatment_waste_water_treatment_plant |
|
|
Cascade on delete | ||
| rel_od_sludge_treatment_fk_dataprovider |
|
|
Restrict delete | ||
| rel_od_sludge_treatment_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_sludge_treatment_stabilisation |
|
|
Restrict delete | ||
| rel_od_zone_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_zone_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_measure_category |
|
|
Restrict delete | ||
| fkey_vl_measure_priority |
|
|
Restrict delete | ||
| fkey_vl_measure_status |
|
|
Restrict delete | ||
| rel_measure_responsible_entity |
|
|
Null on delete | ||
| rel_measure_responsible_start |
|
|
Null on delete | ||
| rel_od_measure_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_measure_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_special_structure_function |
|
|
Restrict delete | ||
| oorel_od_special_structure_wastewater_structure |
|
|
Cascade on delete | ||
| fkey_vl_special_structure_emergency_overflow |
|
|
Restrict delete | ||
| fkey_vl_special_structure_possibility_intervention |
|
|
Restrict delete | ||
| fkey_vl_special_structure_stormwater_tank_arrangement |
|
|
Restrict delete | ||
| fkey_vl_special_structure_amphibian_exit |
|
|
Restrict delete | ||
| fkey_vl_special_structure_bypass |
|
|
Restrict delete | ||
| oorel_od_damage_manhole_damage |
|
|
Cascade on delete | ||
| fkey_vl_damage_manhole_manhole_shaft_area |
|
|
Restrict delete | ||
| fkey_vl_damage_manhole_manhole_damage_code |
|
|
Restrict delete | ||
| fkey_vl_leapingweir_opening_shape |
|
|
Restrict delete | ||
| oorel_od_leapingweir_overflow |
|
|
Cascade on delete | ||
| oorel_od_param_ca_mouse1_surface_runoff_parameters |
|
|
Cascade on delete | ||
| fkey_vl_infiltration_zone_infiltration_capacity |
|
|
Restrict delete | ||
| oorel_od_infiltration_zone_zone |
|
|
Cascade on delete | ||
| rel_od_disposal_fk_dataprovider |
|
|
Restrict delete | ||
| rel_od_disposal_fk_dataowner |
|
|
Restrict delete | ||
| rel_disposal_wastewater_structure |
|
|
Null on delete | ||
| rel_disposal_discharge_point |
|
|
Null on delete | ||
| rel_disposal_infiltration_installation |
|
|
Null on delete | ||
| fkey_vl_disposal_disposal_place_current |
|
|
Restrict delete | ||
| fkey_vl_disposal_disposal_place_planned |
|
|
Restrict delete | ||
| fkey_vl_wastewater_structure_symbol_plantype |
|
|
Restrict delete | ||
| rel_wastewater_structure_symbol_wastewater_structure |
|
|
Cascade on delete | ||
| rel_od_farm_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_farm_shepherds_hut_wastewater |
|
|
Restrict delete | ||
| fkey_vl_farm_conformity |
|
|
Restrict delete | ||
| rel_farm_building_group |
|
|
Cascade on delete | ||
| fkey_vl_farm_cesspit_volume |
|
|
Restrict delete | ||
| fkey_vl_farm_stable_cattle |
|
|
Restrict delete | ||
| rel_od_farm_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_farm_continuance |
|
|
Restrict delete | ||
| rel_od_mutation_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_mutation_kind |
|
|
Restrict delete | ||
| rel_od_mutation_fk_dataowner |
|
|
Restrict delete | ||
| rel_measuring_point_wastewater_structure |
|
|
Null on delete | ||
| rel_measuring_point_waste_water_treatment_plant |
|
|
Null on delete | ||
| rel_od_measuring_point_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_measuring_point_damming_device |
|
|
Restrict delete | ||
| rel_measuring_point_reference_station |
|
|
Null on delete | ||
| rel_measuring_point_operator |
|
|
Null on delete | ||
| rel_od_measuring_point_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_measuring_point_purpose |
|
|
Restrict delete | ||
| rel_od_retention_body_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_retention_body_kind |
|
|
Restrict delete | ||
| rel_retention_body_infiltration_installation |
|
|
Cascade on delete | ||
| rel_od_retention_body_fk_dataowner |
|
|
Restrict delete | ||
| rel_wastewater_node_hydr_geometry |
|
|
Cascade on delete | ||
| fkey_vl_wastewater_node_function_node_amelioration |
|
|
Restrict delete | ||
| fkey_vl_wastewater_node_elevation_accuracy |
|
|
Restrict delete | ||
| oorel_od_wastewater_node_wastewater_networkelement |
|
|
Cascade on delete | ||
| rel_throttle_shut_off_unit_wastewater_node |
|
|
Cascade on delete | ||
| fkey_vl_throttle_shut_off_unit_signal_transmission |
|
|
Restrict delete | ||
| rel_od_throttle_shut_off_unit_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_throttle_shut_off_unit_actuation |
|
|
Restrict delete | ||
| rel_throttle_shut_off_unit_control_center |
|
|
Null on delete | ||
| rel_od_throttle_shut_off_unit_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_throttle_shut_off_unit_kind |
|
|
Restrict delete | ||
| fkey_vl_throttle_shut_off_unit_adjustability |
|
|
Restrict delete | ||
| rel_throttle_shut_off_unit_overflow |
|
|
Null on delete | ||
| fkey_vl_throttle_shut_off_unit_control |
|
|
Restrict delete | ||
| oorel_od_discharge_point_wastewater_structure |
|
|
Cascade on delete | ||
| fkey_vl_discharge_point_relevance |
|
|
Restrict delete | ||
| rel_od_hydraulic_char_data_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_hydraulic_char_data_status |
|
|
Restrict delete | ||
| rel_hydraulic_char_data_wastewater_node |
|
|
Null on delete | ||
| fkey_vl_hydraulic_char_data_is_overflowing |
|
|
Restrict delete | ||
| fkey_vl_hydraulic_char_data_main_weir_kind |
|
|
Restrict delete | ||
| rel_hydraulic_char_data_primary_direction |
|
|
Null on delete | ||
| fkey_vl_hydraulic_char_data_pump_characteristics |
|
|
Restrict delete | ||
| rel_od_hydraulic_char_data_fk_dataprovider |
|
|
Restrict delete | ||
| rel_hydraulic_char_data_overflow_char |
|
|
Null on delete | ||
| rel_catchment_area_totals_hydraulic_char_data |
|
|
Null on delete | ||
| rel_od_catchment_area_totals_fk_dataprovider |
|
|
Restrict delete | ||
| rel_catchment_area_totals_discharge_point |
|
|
Null on delete | ||
| rel_od_catchment_area_totals_fk_dataowner |
|
|
Restrict delete | ||
| rel_mechanical_pretreatment_wastewater_structure |
|
|
Cascade on delete | ||
| rel_od_mechanical_pretreatment_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_mechanical_pretreatment_kind |
|
|
Restrict delete | ||
| rel_od_mechanical_pretreatment_fk_dataprovider |
|
|
Restrict delete | ||
| rel_measuring_device_measuring_point |
|
|
Null on delete | ||
| rel_od_measuring_device_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_measuring_device_kind |
|
|
Restrict delete | ||
| rel_od_measuring_device_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_bio_ecol_assessment_comparison_last |
|
|
Restrict delete | ||
| oorel_od_bio_ecol_assessment_maintenance_event |
|
|
Cascade on delete | ||
| fkey_vl_bio_ecol_assessment_relevance_matrix |
|
|
Restrict delete | ||
| fkey_vl_bio_ecol_assessment_impact_auxiliary_indic |
|
|
Restrict delete | ||
| fkey_vl_bio_ecol_assessment_intervention_demand |
|
|
Restrict delete | ||
| fkey_vl_bio_ecol_assessment_impact_water_plants |
|
|
Restrict delete | ||
| fkey_vl_bio_ecol_assessment_impact_external_aspect |
|
|
Restrict delete | ||
| fkey_vl_bio_ecol_assessment_kind_water_body |
|
|
Restrict delete | ||
| fkey_vl_bio_ecol_assessment_impact_macroinvertebrates |
|
|
Restrict delete | ||
| fkey_vl_bio_ecol_assessment_io_calculation |
|
|
Restrict delete | ||
| network_node_rp_id_fkey |
|
|
Cascade on delete | ||
| network_node_ne_id_fkey |
|
|
Cascade on delete | ||
| rel_od_hydr_geometry_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_hydr_geometry_fk_dataprovider |
|
|
Restrict delete | ||
| oorel_od_examination_maintenance_event |
|
|
Cascade on delete | ||
| rel_examination_reach_point |
|
|
Null on delete | ||
| fkey_vl_examination_weather |
|
|
Restrict delete | ||
| fkey_vl_examination_recording_type |
|
|
Restrict delete | ||
| rel_catchment_area_special_building_rw_current |
|
|
Null on delete | ||
| rel_od_catchment_area_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_catchment_area_retention_planned |
|
|
Restrict delete | ||
| rel_od_catchment_area_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_catchment_area_direct_discharge_planned |
|
|
Restrict delete | ||
| rel_catchment_area_wastewater_networkelement_ww_planned |
|
|
Null on delete | ||
| fkey_vl_catchment_area_infiltration_planned |
|
|
Restrict delete | ||
| fkey_vl_catchment_area_infiltration_current |
|
|
Restrict delete | ||
| rel_catchment_area_special_building_rw_planned |
|
|
Null on delete | ||
| fkey_vl_catchment_area_drainage_system_planned |
|
|
Restrict delete | ||
| rel_catchment_area_wastewater_networkelement_rw_current |
|
|
Null on delete | ||
| rel_catchment_area_special_building_ww_planned |
|
|
Null on delete | ||
| rel_catchment_area_wastewater_networkelement_rw_planned |
|
|
Null on delete | ||
| rel_catchment_area_special_building_ww_current |
|
|
Null on delete | ||
| fkey_vl_catchment_area_direct_discharge_current |
|
|
Restrict delete | ||
| fkey_vl_catchment_area_retention_current |
|
|
Restrict delete | ||
| rel_catchment_area_wastewater_networkelement_ww_current |
|
|
Null on delete | ||
| fkey_vl_catchment_area_drainage_system_current |
|
|
Restrict delete | ||
| oorel_od_access_aid_structure_part |
|
|
Cascade on delete | ||
| fkey_vl_access_aid_kind |
|
|
Restrict delete | ||
| rel_od_organisation_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_organisation_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_organisation_organisation_type |
|
|
Restrict delete | ||
| fkey_vl_organisation_status |
|
|
Restrict delete | ||
| rel_log_card_main_structure |
|
|
Null on delete | ||
| rel_log_card_pwwf_wastewater_node |
|
|
Null on delete | ||
| rel_od_log_card_fk_dataowner |
|
|
Restrict delete | ||
| rel_log_card_next_special_building |
|
|
Null on delete | ||
| rel_log_card_location_municipality |
|
|
Null on delete | ||
| rel_od_log_card_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_log_card_control_remote_control |
|
|
Restrict delete | ||
| fkey_vl_log_card_information_source |
|
|
Restrict delete | ||
| rel_log_card_agency |
|
|
Null on delete | ||
| rel_od_connection_object_fk_dataowner |
|
|
Restrict delete | ||
| rel_connection_object_wastewater_networkelement |
|
|
Null on delete | ||
| rel_od_connection_object_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_damage_connection |
|
|
Restrict delete | ||
| rel_damage_examination |
|
|
Cascade on delete | ||
| rel_od_damage_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_damage_single_damage_class |
|
|
Restrict delete | ||
| rel_od_damage_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_dryweather_flume_material |
|
|
Restrict delete | ||
| oorel_od_dryweather_flume_structure_part |
|
|
Cascade on delete | ||
| oorel_od_wwtp_structure_wastewater_structure |
|
|
Cascade on delete | ||
| fkey_vl_wwtp_structure_kind |
|
|
Restrict delete | ||
| rel_wwtp_structure_waste_water_treatment_plant |
|
|
Null on delete | ||
| oorel_od_maintenance_maintenance_event |
|
|
Cascade on delete | ||
| fkey_vl_maintenance_kind |
|
|
Restrict delete | ||
| oorel_od_channel_wastewater_structure |
|
|
Cascade on delete | ||
| fkey_vl_channel_usage_planned |
|
|
Restrict delete | ||
| fkey_vl_channel_function_amelioration |
|
|
Restrict delete | ||
| fkey_vl_channel_function_hydraulic |
|
|
Restrict delete | ||
| fkey_vl_channel_connection_type |
|
|
Restrict delete | ||
| fkey_vl_channel_seepage |
|
|
Restrict delete | ||
| fkey_vl_channel_bedding_encasement |
|
|
Restrict delete | ||
| fkey_vl_channel_usage_current |
|
|
Restrict delete | ||
| fkey_vl_channel_function_hierarchic |
|
|
Restrict delete | ||
| oorel_od_benching_structure_part |
|
|
Cascade on delete | ||
| fkey_vl_benching_kind |
|
|
Restrict delete | ||
| rel_overflow_overflow_to |
|
|
Null on delete | ||
| rel_od_overflow_fk_dataowner |
|
|
Restrict delete | ||
| rel_overflow_overflow_char |
|
|
Null on delete | ||
| fkey_vl_overflow_adjustability |
|
|
Restrict delete | ||
| fkey_vl_overflow_control |
|
|
Restrict delete | ||
| fkey_vl_overflow_actuation |
|
|
Restrict delete | ||
| rel_overflow_control_center |
|
|
Null on delete | ||
| fkey_vl_overflow_signal_transmission |
|
|
Restrict delete | ||
| rel_od_overflow_fk_dataprovider |
|
|
Restrict delete | ||
| rel_overflow_wastewater_node |
|
|
Cascade on delete | ||
| fkey_vl_overflow_function |
|
|
Restrict delete | ||
| fkey_vl_drainage_system_kind |
|
|
Restrict delete | ||
| oorel_od_drainage_system_zone |
|
|
Cascade on delete | ||
| rel_building_group_disposal_building_group |
|
|
Cascade on delete | ||
| rel_building_group_disposal_disposal |
|
|
Cascade on delete | ||
| oorel_od_dss15_planning_zone_zone |
|
|
Cascade on delete | ||
| fkey_vl_dss15_planning_zone_kind |
|
|
Restrict delete | ||
| rel_reach_text_reach |
|
|
Cascade on delete | ||
| fkey_vl_reach_text_texthali |
|
|
Restrict delete | ||
| fkey_vl_reach_text_plantype |
|
|
Restrict delete | ||
| fkey_vl_reach_text_textvali |
|
|
Restrict delete | ||
| oorel_od_dryweather_downspout_structure_part |
|
|
Cascade on delete | ||
| fkey_vl_wastewater_structure_text_plantype |
|
|
Restrict delete | ||
| fkey_vl_wastewater_structure_text_textvali |
|
|
Restrict delete | ||
| fkey_vl_wastewater_structure_text_texthali |
|
|
Restrict delete | ||
| rel_wastewater_structure_text_wastewater_structure |
|
|
Cascade on delete | ||
| rel_od_overflow_char_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_overflow_char_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_overflow_char_kind_overflow_char |
|
|
Restrict delete | ||
| fkey_vl_reach_point_pipe_closure |
|
|
Restrict delete | ||
| rel_od_reach_point_fk_dataprovider |
|
|
Restrict delete | ||
| rel_reach_point_wastewater_networkelement |
|
|
Null on delete | ||
| fkey_vl_reach_point_outlet_shape |
|
|
Restrict delete | ||
| rel_od_reach_point_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_reach_point_elevation_accuracy |
|
|
Restrict delete | ||
| fkey_vl_cover_cover_shape |
|
|
Restrict delete | ||
| fkey_vl_cover_material |
|
|
Restrict delete | ||
| oorel_od_cover_structure_part |
|
|
Cascade on delete | ||
| fkey_vl_cover_positional_accuracy |
|
|
Restrict delete | ||
| fkey_vl_cover_fastening |
|
|
Restrict delete | ||
| fkey_vl_cover_venting |
|
|
Restrict delete | ||
| fkey_vl_cover_sludge_bucket |
|
|
Restrict delete | ||
| fkey_vl_tank_emptying_kind |
|
|
Restrict delete | ||
| oorel_od_tank_emptying_structure_part |
|
|
Cascade on delete | ||
| rel_tank_emptying_overflow |
|
|
Null on delete | ||
| rel_tank_emptying_throttle_shut_off_unit |
|
|
Null on delete | ||
| rel_od_waste_water_treatment_plant_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_waste_water_treatment_plant_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_waste_water_treatment_plant_operator_type |
|
|
Restrict delete | ||
| fkey_vl_wastewater_structure_rv_construction_type |
|
|
Restrict delete | ||
| fkey_vl_wastewater_structure_structure_condition |
|
|
Restrict delete | ||
| fkey_vl_wastewater_structure_status |
|
|
Restrict delete | ||
| rel_wastewater_structure_owner |
|
|
Null on delete | ||
| fkey_vl_wastewater_structure_accessibility |
|
|
Restrict delete | ||
| rel_od_wastewater_structure_fk_dataprovider |
|
|
Restrict delete | ||
| rel_od_wastewater_structure_fk_dataowner |
|
|
Restrict delete | ||
| rel_wastewater_structure_main_wastewater_node |
|
|
Null on delete | ||
| fkey_vl_wastewater_structure_elevation_determination |
|
|
Restrict delete | ||
| rel_wastewater_structure_main_cover |
|
|
Null on delete | ||
| rel_wastewater_structure_operator |
|
|
Null on delete | ||
| fkey_vl_wastewater_structure_renovation_necessity |
|
|
Restrict delete | ||
| fkey_vl_wastewater_structure_financing |
|
|
Restrict delete | ||
| rel_od_sia405cc_cable_point_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_sia405cc_cable_point_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_point_elevation_determination |
|
|
Restrict delete | ||
| rel_sia405cc_cable_point_owner |
|
|
Null on delete | ||
| fkey_vl_sia405cc_cable_point_status |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_point_horizontal_positioning |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_point_kind |
|
|
Restrict delete | ||
| network_segment_to_node_fkey |
|
|
Cascade on delete | ||
| network_segment_ne_id_fkey |
|
|
Cascade on delete | ||
| network_segment_from_node_fkey |
|
|
Cascade on delete | ||
| fkey_vl_prank_weir_weir_edge |
|
|
Restrict delete | ||
| oorel_od_prank_weir_overflow |
|
|
Cascade on delete | ||
| fkey_vl_prank_weir_weir_kind |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_horizontal_positioning |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_status |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_cable_type |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_elevation_determination |
|
|
Restrict delete | ||
| fkey_vl_sia405cc_cable_function |
|
|
Restrict delete | ||
| rel_cable_owner |
|
|
Null on delete | ||
| rel_od_sia405cc_cable_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_sia405cc_cable_fk_dataprovider |
|
|
Restrict delete | ||
| oorel_od_pump_overflow |
|
|
Cascade on delete | ||
| fkey_vl_pump_placement_of_pump |
|
|
Restrict delete | ||
| fkey_vl_pump_construction_type |
|
|
Restrict delete | ||
| fkey_vl_pump_placement_of_actuation |
|
|
Restrict delete | ||
| rel_reach_progression_alternative_reach |
|
|
Cascade on delete | ||
| fkey_vl_reach_progression_alternative_plantype |
|
|
Restrict delete | ||
| rel_od_control_center_fk_dataprovider |
|
|
Restrict delete | ||
| rel_od_control_center_fk_dataowner |
|
|
Restrict delete | ||
| rel_maintenance_event_operating_company |
|
|
Null on delete | ||
| rel_od_maintenance_event_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_maintenance_event_status |
|
|
Restrict delete | ||
| rel_maintenance_event_measure |
|
|
Null on delete | ||
| rel_od_maintenance_event_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_measurement_series_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_measurement_series_kind |
|
|
Restrict delete | ||
| rel_measurement_series_wastewater_networkelement |
|
|
Null on delete | ||
| rel_od_measurement_series_fk_dataowner |
|
|
Restrict delete | ||
| rel_measurement_series_measuring_point |
|
|
Cascade on delete | ||
| rel_od_wwtp_energy_use_fk_dataprovider |
|
|
Restrict delete | ||
| rel_od_wwtp_energy_use_fk_dataowner |
|
|
Restrict delete | ||
| rel_wwtp_energy_use_waste_water_treatment_plant |
|
|
Cascade on delete | ||
| oorel_od_building_connection_object |
|
|
Cascade on delete | ||
| fkey_vl_structure_part_renovation_demand |
|
|
Restrict delete | ||
| rel_od_structure_part_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_structure_part_fk_dataprovider |
|
|
Restrict delete | ||
| rel_structure_part_wastewater_structure |
|
|
Cascade on delete | ||
| fkey_vl_catchment_area_text_plantype |
|
|
Restrict delete | ||
| rel_catchment_area_text_catchment_area |
|
|
Cascade on delete | ||
| fkey_vl_catchment_area_text_textvali |
|
|
Restrict delete | ||
| fkey_vl_catchment_area_text_texthali |
|
|
Restrict delete | ||
| fkey_vl_measurement_result_measurement_type |
|
|
Restrict delete | ||
| rel_od_measurement_result_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_measurement_result_fk_dataprovider |
|
|
Restrict delete | ||
| rel_measurement_result_measurement_series |
|
|
Cascade on delete | ||
| rel_measurement_result_measuring_device |
|
|
Null on delete | ||
| fkey_vl_infiltration_installation_defects |
|
|
Restrict delete | ||
| fkey_vl_infiltration_installation_vehicle_access |
|
|
Restrict delete | ||
| fkey_vl_infiltration_installation_kind |
|
|
Restrict delete | ||
| oorel_od_infiltration_installation_wastewater_structure |
|
|
Cascade on delete | ||
| rel_infiltration_installation_dss15_aquifer |
|
|
Null on delete | ||
| fkey_vl_infiltration_installation_watertightness |
|
|
Restrict delete | ||
| fkey_vl_infiltration_installation_filling_material |
|
|
Restrict delete | ||
| fkey_vl_infiltration_installation_seepage_utilization |
|
|
Restrict delete | ||
| fkey_vl_infiltration_installation_emergency_overflow |
|
|
Restrict delete | ||
| fkey_vl_infiltration_installation_labeling |
|
|
Restrict delete | ||
| rel_od_data_media_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_data_media_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_data_media_kind |
|
|
Restrict delete | ||
| fkey_vl_file_kind |
|
|
Restrict delete | ||
| rel_file_data_media |
|
|
Null on delete | ||
| rel_od_file_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_file_classname |
|
|
Restrict delete | ||
| rel_od_file_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_electromechanical_equipment_kind |
|
|
Restrict delete | ||
| oorel_od_electromechanical_equipment_structure_part |
|
|
Cascade on delete | ||
| rel_backflow_prevention_pump |
|
|
Null on delete | ||
| fkey_vl_backflow_prevention_kind |
|
|
Restrict delete | ||
| oorel_od_backflow_prevention_structure_part |
|
|
Cascade on delete | ||
| rel_backflow_prevention_throttle_shut_off_unit |
|
|
Null on delete | ||
| oorel_od_tank_cleaning_structure_part |
|
|
Cascade on delete | ||
| fkey_vl_tank_cleaning_kind |
|
|
Restrict delete | ||
| rel_surface_runoff_parameters_catchment_area |
|
|
Cascade on delete | ||
| rel_od_surface_runoff_parameters_fk_dataprovider |
|
|
Restrict delete | ||
| rel_od_surface_runoff_parameters_fk_dataowner |
|
|
Restrict delete | ||
| rel_building_group_baugwr_building_group |
|
|
Null on delete | ||
| rel_od_building_group_baugwr_fk_dataprovider |
|
|
Restrict delete | ||
| rel_od_building_group_baugwr_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_drainless_toilet_kind |
|
|
Restrict delete | ||
| oorel_od_drainless_toilet_wastewater_structure |
|
|
Cascade on delete | ||
| fkey_vl_individual_surface_function |
|
|
Restrict delete | ||
| fkey_vl_individual_surface_pavement |
|
|
Restrict delete | ||
| oorel_od_individual_surface_connection_object |
|
|
Cascade on delete | ||
| rel_od_wastewater_networkelement_fk_dataowner |
|
|
Restrict delete | ||
| rel_wastewater_networkelement_wastewater_structure |
|
|
Cascade on delete | ||
| rel_od_wastewater_networkelement_fk_dataprovider |
|
|
Restrict delete | ||
| oorel_od_reservoir_connection_object |
|
|
Cascade on delete | ||
| rel_od_profile_geometry_fk_dataprovider |
|
|
Restrict delete | ||
| rel_profile_geometry_pipe_profile |
|
|
Cascade on delete | ||
| rel_od_profile_geometry_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_waste_water_treatment_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_waste_water_treatment_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_waste_water_treatment_kind |
|
|
Restrict delete | ||
| rel_waste_water_treatment_waste_water_treatment_plant |
|
|
Cascade on delete | ||
| oorel_od_fountain_connection_object |
|
|
Cascade on delete | ||
| rel_od_dss15_aquifer_fk_dataowner |
|
|
Restrict delete | ||
| rel_od_dss15_aquifer_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_manhole_function |
|
|
Restrict delete | ||
| fkey_vl_manhole_possibility_intervention |
|
|
Restrict delete | ||
| fkey_vl_manhole_surface_inflow |
|
|
Restrict delete | ||
| oorel_od_manhole_wastewater_structure |
|
|
Cascade on delete | ||
| fkey_vl_manhole_material |
|
|
Restrict delete | ||
| fkey_vl_manhole_amphibian_exit |
|
|
Restrict delete | ||
| oorel_od_param_ca_general_surface_runoff_parameters |
|
|
Cascade on delete | ||
| rel_maintenance_event_wastewater_structure_wastewater_structure |
|
|
Cascade on delete | ||
| rel_maintenance_event_wastewater_structure_maintenance_event |
|
|
Cascade on delete | ||
| fkey_vl_reach_horizontal_positioning |
|
|
Restrict delete | ||
| fkey_vl_reach_relining_construction |
|
|
Restrict delete | ||
| rel_reach_pipe_profile |
|
|
Null on delete | ||
| fkey_vl_reach_leak_protection |
|
|
Restrict delete | ||
| fkey_vl_reach_relining_kind |
|
|
Restrict delete | ||
| fkey_vl_reach_material |
|
|
Restrict delete | ||
| fkey_vl_reach_inside_coating |
|
|
Restrict delete | ||
| fkey_vl_reach_reliner_material |
|
|
Restrict delete | ||
| rel_reach_reach_point_from |
|
|
Cascade on delete | ||
| fkey_vl_reach_elevation_determination |
|
|
Restrict delete | ||
| rel_reach_reach_point_to |
|
|
Cascade on delete | ||
| oorel_od_reach_wastewater_networkelement |
|
|
Cascade on delete | ||
| rel_od_pipe_profile_fk_dataprovider |
|
|
Restrict delete | ||
| rel_od_pipe_profile_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_pipe_profile_profile_type |
|
|
Restrict delete | ||
| oorel_od_small_treatment_plant_wastewater_structure |
|
|
Cascade on delete | ||
| fkey_vl_small_treatment_plant_remote_monitoring |
|
|
Restrict delete | ||
| fkey_vl_small_treatment_plant_function |
|
|
Restrict delete | ||
| oorel_od_electric_equipment_structure_part |
|
|
Cascade on delete | ||
| fkey_vl_electric_equipment_kind |
|
|
Restrict delete | ||
| rel_od_hydr_geom_relation_fk_dataowner |
|
|
Restrict delete | ||
| rel_hydr_geom_relation_hydr_geometry |
|
|
Cascade on delete | ||
| rel_od_hydr_geom_relation_fk_dataprovider |
|
|
Restrict delete | ||
| oorel_od_flushing_nozzle_structure_part |
|
|
Cascade on delete | ||
| oorel_od_damage_channel_damage |
|
|
Cascade on delete | ||
| fkey_vl_damage_channel_channel_damage_code |
|
|
Restrict delete | ||
| fkey_vl_building_group_renovation_necessity |
|
|
Restrict delete | ||
| fkey_vl_building_group_drinking_water_network |
|
|
Restrict delete | ||
| fkey_vl_building_group_electric_connection |
|
|
Restrict delete | ||
| fkey_vl_building_group_function |
|
|
Restrict delete | ||
| fkey_vl_building_group_connecting_obligation |
|
|
Restrict delete | ||
| rel_od_building_group_fk_dataowner |
|
|
Restrict delete | ||
| fkey_vl_building_group_drainage_map |
|
|
Restrict delete | ||
| rel_od_building_group_fk_dataprovider |
|
|
Restrict delete | ||
| fkey_vl_building_group_drinking_water_others |
|
|
Restrict delete | ||
| rel_building_group_disposal |
|
|
Null on delete | ||
| rel_building_group_measure |
|
|
Null on delete | ||
| fkey_vl_building_group_connection_wwtp |
|
|
Restrict delete | ||
| rel_od_hq_relation_fk_dataprovider |
|
|
Restrict delete | ||
| rel_od_hq_relation_fk_dataowner |
|
|
Restrict delete | ||
| rel_hq_relation_overflow_char |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| sludge_treatment | st_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| sludge_treatment | st_remark_length_max_80 | ((char_length(remark) <= 80)) |
| zone | zo_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| zone | zo_remark_length_max_80 | ((char_length(remark) <= 80)) |
| measure | mm_description_length_max_100 | ((char_length(description) <= 100)) |
| measure | mm_identifier_length_max_50 | ((char_length(identifier) <= 50)) |
| measure | mm_intervention_demand_length_max_255 | ((char_length(intervention_demand) <= 255)) |
| measure | mm_link_length_max_255 | ((char_length(link) <= 255)) |
| measure | mm_remark_length_max_80 | ((char_length(remark) <= 80)) |
| damage_manhole | dm_manhole_quantification1_length_max_20 | ((char_length(manhole_quantification1) <= 20)) |
| damage_manhole | dm_manhole_quantification2_length_max_20 | ((char_length(manhole_quantification2) <= 20)) |
| param_ca_mouse1 | pm_usage_length_max_50 | ((char_length(usage) <= 50)) |
| wastewater_structure_symbol | bx_classname_length_max_50 | ((char_length(classname) <= 50)) |
| farm | fa_cesspit_comment_length_max_100 | ((char_length(cesspit_comment) <= 100)) |
| farm | fa_continuance_comment_length_max_80 | ((char_length(continuance_comment) <= 80)) |
| farm | fa_remark_length_max_80 | ((char_length(remark) <= 80)) |
| farm | fa_shepherds_hut_comment_length_max_80 | ((char_length(shepherds_hut_comment) <= 80)) |
| mutation | md_attribute_length_max_60 | ((char_length(attribute) <= 60)) |
| mutation | md_classname_length_max_50 | ((char_length(classname) <= 50)) |
| mutation | md_last_value_length_max_255 | ((char_length(last_value) <= 255)) |
| mutation | md_object_length_max_16 | ((char_length(object) <= 16)) |
| mutation | md_recorded_by_length_max_255 | ((char_length(recorded_by) <= 255)) |
| mutation | md_remark_length_max_80 | ((char_length(remark) <= 80)) |
| mutation | md_user_system_length_max_60 | ((char_length(user_system) <= 60)) |
| measuring_point | mp_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| measuring_point | mp_kind_length_max_50 | ((char_length(kind) <= 50)) |
| measuring_point | mp_remark_length_max_80 | ((char_length(remark) <= 80)) |
| retention_body | rb_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| retention_body | rb_remark_length_max_80 | ((char_length(remark) <= 80)) |
| throttle_shut_off_unit | ts_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| throttle_shut_off_unit | ts_manufacturer_length_max_50 | ((char_length(manufacturer) <= 50)) |
| throttle_shut_off_unit | ts_remark_length_max_80 | ((char_length(remark) <= 80)) |
| discharge_point | dp_water_course_number_length_max_25 | ((char_length(water_course_number) <= 25)) |
| discharge_point | dp_water_course_segment_canton_length_max_36 | ((char_length(water_course_segment_canton) <= 36)) |
| hydraulic_char_data | hc_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| hydraulic_char_data | hc_remark_length_max_80 | ((char_length(remark) <= 80)) |
| catchment_area_totals | cm_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| mechanical_pretreatment | mt_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| mechanical_pretreatment | mt_remark_length_max_80 | ((char_length(remark) <= 80)) |
| measuring_device | mv_brand_length_max_50 | ((char_length(brand) <= 50)) |
| measuring_device | mv_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| measuring_device | mv_remark_length_max_80 | ((char_length(remark) <= 80)) |
| measuring_device | mv_serial_number_length_max_50 | ((char_length(serial_number) <= 50)) |
| bio_ecol_assessment | bo_surface_water_bodies_length_max_100 | ((char_length(surface_water_bodies) <= 100)) |
| hydr_geometry | hg_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| hydr_geometry | hg_remark_length_max_80 | ((char_length(remark) <= 80)) |
| examination | ex_equipment_length_max_50 | ((char_length(equipment) <= 50)) |
| examination | ex_from_point_identifier_length_max_20 | ((char_length(from_point_identifier) <= 20)) |
| examination | ex_to_point_identifier_length_max_20 | ((char_length(to_point_identifier) <= 20)) |
| examination | ex_vehicle_length_max_50 | ((char_length(vehicle) <= 50)) |
| examination | ex_videonumber_length_max_20 | ((char_length(videonumber) <= 20)) |
| catchment_area | ca_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| catchment_area | ca_remark_length_max_80 | ((char_length(remark) <= 80)) |
| organisation | og_identifier_length_max_255 | ((char_length(identifier) <= 255)) |
| organisation | og_identifier_short_length_max_12 | ((char_length(identifier_short) <= 12)) |
| organisation | og_remark_length_max_255 | ((char_length(remark) <= 255)) |
| organisation | og_uid_length_max_12 | ((char_length(uid) <= 12)) |
| log_card | lc_person_in_charge_length_max_50 | ((char_length(person_in_charge) <= 50)) |
| log_card | lc_remark_length_max_80 | ((char_length(remark) <= 80)) |
| connection_object | cn_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| connection_object | cn_remark_length_max_80 | ((char_length(remark) <= 80)) |
| damage | dg_comments_length_max_100 | ((char_length(comments) <= 100)) |
| damage | dg_line_damage_length_max_3 | ((char_length(line_damage) <= 3)) |
| damage | dg_video_counter_length_max_11 | ((char_length(video_counter) <= 11)) |
| damage | dg_view_parameters_length_max_200 | ((char_length(view_parameters) <= 200)) |
| overflow | ov_brand_length_max_50 | ((char_length(brand) <= 50)) |
| overflow | ov_discharge_point_length_max_20 | ((char_length(discharge_point) <= 20)) |
| overflow | ov_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| overflow | ov_remark_length_max_80 | ((char_length(remark) <= 80)) |
| reach_text | rx_classname_length_max_50 | ((char_length(classname) <= 50)) |
| reach_text | rx_remark_length_max_80 | ((char_length(remark) <= 80)) |
| wastewater_structure_text | wx_classname_length_max_50 | ((char_length(classname) <= 50)) |
| wastewater_structure_text | wx_remark_length_max_80 | ((char_length(remark) <= 80)) |
| overflow_char | oc_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| overflow_char | oc_remark_length_max_80 | ((char_length(remark) <= 80)) |
| reach_point | rp_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| reach_point | rp_remark_length_max_80 | ((char_length(remark) <= 80)) |
| cover | co_brand_length_max_50 | ((char_length(brand) <= 50)) |
| waste_water_treatment_plant | tp_identifier_length_max_255 | ((char_length(identifier) <= 255)) |
| waste_water_treatment_plant | tp_kind_length_max_50 | ((char_length(kind) <= 50)) |
| waste_water_treatment_plant | tp_remark_length_max_255 | ((char_length(remark) <= 255)) |
| wastewater_structure | ws_contract_section_length_max_50 | ((char_length(contract_section) <= 50)) |
| wastewater_structure | ws_identifier_length_max_41 | ((char_length(identifier) <= 41)) |
| wastewater_structure | ws_location_name_length_max_50 | ((char_length(location_name) <= 50)) |
| wastewater_structure | ws_records_length_max_255 | ((char_length(records) <= 255)) |
| wastewater_structure | ws_remark_length_max_80 | ((char_length(remark) <= 80)) |
| sia405cc_cable_point | _condition_length_max_40 | ((char_length(condition) <= 40)) |
| sia405cc_cable_point | _name_number_length_max_40 | ((char_length(name_number) <= 40)) |
| sia405cc_cable_point | _remark_length_max_80 | ((char_length(remark) <= 80)) |
| sia405cc_cable | _condition_length_max_40 | ((char_length(condition) <= 40)) |
| sia405cc_cable | _name_number_length_max_40 | ((char_length(name_number) <= 40)) |
| sia405cc_cable | _remark_length_max_80 | ((char_length(remark) <= 80)) |
| control_center | cc_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| maintenance_event | me_base_data_length_max_50 | ((char_length(base_data) <= 50)) |
| maintenance_event | me_data_details_length_max_50 | ((char_length(data_details) <= 50)) |
| maintenance_event | me_identifier_length_max_41 | ((char_length(identifier) <= 41)) |
| maintenance_event | me_operator_length_max_50 | ((char_length(operator) <= 50)) |
| maintenance_event | me_reason_length_max_50 | ((char_length(reason) <= 50)) |
| maintenance_event | me_remark_length_max_80 | ((char_length(remark) <= 80)) |
| maintenance_event | me_result_length_max_255 | ((char_length(result) <= 255)) |
| measurement_series | ms_dimension_length_max_50 | ((char_length(dimension) <= 50)) |
| measurement_series | ms_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| measurement_series | ms_remark_length_max_80 | ((char_length(remark) <= 80)) |
| wwtp_energy_use | eu_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| wwtp_energy_use | eu_remark_length_max_80 | ((char_length(remark) <= 80)) |
| building | bu_house_number_length_max_50 | ((char_length(house_number) <= 50)) |
| building | bu_location_name_length_max_50 | ((char_length(location_name) <= 50)) |
| structure_part | sp_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| structure_part | sp_remark_length_max_80 | ((char_length(remark) <= 80)) |
| catchment_area_text | cx_classname_length_max_50 | ((char_length(classname) <= 50)) |
| catchment_area_text | cx_remark_length_max_80 | ((char_length(remark) <= 80)) |
| measurement_result | mr_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| measurement_result | mr_remark_length_max_80 | ((char_length(remark) <= 80)) |
| data_media | vo_identifier_length_max_60 | ((char_length(identifier) <= 60)) |
| data_media | vo_location_length_max_50 | ((char_length(location) <= 50)) |
| data_media | vo_path_length_max_1023 | ((char_length(path) <= 1023)) |
| data_media | vo_remark_length_max_80 | ((char_length(remark) <= 80)) |
| file | fi_identifier_length_max_120 | ((char_length(identifier) <= 120)) |
| file | fi_object_length_max_16 | ((char_length(object) <= 16)) |
| file | fi_path_relative_length_max_200 | ((char_length(path_relative) <= 200)) |
| file | fi_remark_length_max_80 | ((char_length(remark) <= 80)) |
| surface_runoff_parameters | sr_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| surface_runoff_parameters | sr_remark_length_max_80 | ((char_length(remark) <= 80)) |
| wastewater_networkelement | we_identifier_length_max_41 | ((char_length(identifier) <= 41)) |
| wastewater_networkelement | we_remark_length_max_80 | ((char_length(remark) <= 80)) |
| reservoir | rv_location_name_length_max_50 | ((char_length(location_name) <= 50)) |
| waste_water_treatment | tr_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| waste_water_treatment | tr_remark_length_max_80 | ((char_length(remark) <= 80)) |
| fountain | fo_location_name_length_max_50 | ((char_length(location_name) <= 50)) |
| pipe_profile | pp_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| pipe_profile | pp_remark_length_max_80 | ((char_length(remark) <= 80)) |
| small_treatment_plant | sm_approval_number_length_max_50 | ((char_length(approval_number) <= 50)) |
| building_group | bg_identifier_length_max_20 | ((char_length(identifier) <= 20)) |
| building_group | bg_other_usage_type_length_max_50 | ((char_length(other_usage_type) <= 50)) |
| building_group | bg_remark_length_max_80 | ((char_length(remark) <= 80)) |
| building_group | bg_restructuring_concept_length_max_255 | ((char_length(restructuring_concept) <= 255)) |