115 Foreign Key Constraints:

Constraint Name	Child Column	Parent Column	Delete Rule
chamber_id_fkey	chamber.id	installation.id	Restrict delete
cover_fk_installation	cover.fk_installation	installation.id	Restrict delete
cover_fk_type	cover.fk_cover_type	cover_type.id	Restrict delete
cover_label_1_visible	cover.label_1_visible	visible.vl_code_int	Restrict delete
cover_label_2_visible	cover.label_2_visible	visible.vl_code_int	Restrict delete
crossing_pipe1	crossing._pipe1_id	pipe.id	Restrict delete
crossing_pipe2	crossing._pipe2_id	pipe.id	Restrict delete
district_label_1_visible	district.label_1_visible	visible.vl_code_int	Restrict delete
district_label_2_visible	district.label_2_visible	visible.vl_code_int	Restrict delete
element_fk_distributor	network_element.fk_distributor	distributor.id	Restrict delete
element_fk_folder	network_element.fk_folder	folder.id	Restrict delete
element_fk_object_reference	network_element.fk_object_reference	object_reference.id	Restrict delete
element_fk_precision	network_element.fk_precision	precision.id	Restrict delete
element_fk_precisionalti	network_element.fk_precisionalti	precisionalti.id	Restrict delete
element_fk_status	network_element.fk_status	status.id	Restrict delete
hydrant_fk_material	hydrant.fk_material	hydrant_material.id	Restrict delete
hydrant_fk_model_inf	hydrant.fk_model_inf	hydrant_model_inf.id	Restrict delete
hydrant_fk_model_sup	hydrant.fk_model_sup	hydrant_model_sup.id	Restrict delete
hydrant_fk_output	hydrant.fk_output	hydrant_output.id	Restrict delete
hydrant_fk_provider	hydrant.fk_provider	hydrant_provider.id	Restrict delete
hydrant_id_fkey	hydrant.id	network_element.id	Restrict delete
installation_fk_parent	installation.fk_parent	installation.id	Restrict delete
installation_fk_remote	installation.fk_remote	remote_type.id	Restrict delete
installation_fk_watertype	installation.fk_watertype	watertype.id	Restrict delete
installation_id_fkey	installation.id	network_element.id	Restrict delete
leak_fk_cause	leak.fk_cause	leak_cause.id	Restrict delete
leak_fk_pipe	leak.fk_pipe	pipe.id	Restrict delete
leak_label_1_visible	leak.label_1_visible	visible.vl_code_int	Restrict delete
leak_label_2_visible	leak.label_2_visible	visible.vl_code_int	Restrict delete
meter_fk_pipe	meter.fk_pipe	pipe.id	Restrict delete
meter_id_fkey	meter.id	network_element.id	Restrict delete
meter_reference_fk_meter	meter_reference.fk_meter	meter.id	Restrict delete
network_element_id_fkey	network_element.id	node.id	Restrict delete
network_element_label_1_visible	network_element.label_1_visible	visible.vl_code_int	Restrict delete
network_element_label_2_visible	network_element.label_2_visible	visible.vl_code_int	Restrict delete
network_element_schema_force_visible	network_element.schema_force_visible	visible.vl_code	Restrict delete
node_fk_district	node.fk_district	district.id	Restrict delete
node_fk_pressurezone	node.fk_pressurezone	pressurezone.id	Restrict delete
part_fk_pipe	part.fk_pipe	pipe.id	Restrict delete
part_fk_type	part.fk_part_type	part_type.id	Restrict delete
part_id_fkey	part.id	part.id	Restrict delete
pipe_fk_bedding	pipe.fk_bedding	bedding.id	Restrict delete
pipe_fk_distributor	pipe.fk_distributor	distributor.id	Restrict delete
pipe_fk_district	pipe.fk_district	district.id	Restrict delete
pipe_fk_folder	pipe.fk_folder	folder.id	Restrict delete
pipe_fk_function	pipe.fk_function	pipe_function.id	Restrict delete
pipe_fk_installmethod	pipe.fk_installmethod	pipe_installmethod.id	Restrict delete
pipe_fk_material	pipe.fk_material	pipe_material.id	Restrict delete
pipe_fk_node_a	pipe.fk_node_a	node.id	Restrict delete
pipe_fk_node_b	pipe.fk_node_b	node.id	Restrict delete
pipe_fk_parent	pipe.fk_parent	pipe.id	Restrict delete
pipe_fk_precision	pipe.fk_precision	precision.id	Restrict delete
pipe_fk_pressurezone	pipe.fk_pressurezone	pressurezone.id	Restrict delete
pipe_fk_protection	pipe.fk_protection	pipe_protection.id	Restrict delete
pipe_fk_status	pipe.fk_status	status.id	Restrict delete
pipe_fk_watertype	pipe.fk_watertype	watertype.id	Restrict delete
pipe_label_1_visible	pipe.label_1_visible	visible.vl_code_int	Restrict delete
pipe_label_2_visible	pipe.label_2_visible	visible.vl_code_int	Restrict delete
pipe_schema_force_visible	pipe.schema_force_visible	visible.vl_code	Restrict delete
pressurecontrol_fk_type	pressurecontrol.fk_pressurecontrol_type	pressurecontrol_type.id	Restrict delete
pressurecontrol_id_fkey	pressurecontrol.id	installation.id	Restrict delete
pressurezone_fk_consumptionzone	pressurezone.fk_consumptionzone	consumptionzone.id	Restrict delete
pressurezone_fk_distributor	pressurezone.fk_distributor	distributor.id	Restrict delete
pressurezone_label_1_visible	pressurezone.label_1_visible	visible.vl_code_int	Restrict delete
pressurezone_label_2_visible	pressurezone.label_2_visible	visible.vl_code_int	Restrict delete
printmap_fk_district	printmap.fk_district	district.id	Restrict delete
printmap_label_1_visible	printmap.label_1_visible	visible.vl_code_int	Restrict delete
printmap_label_2_visible	printmap.label_2_visible	visible.vl_code_int	Restrict delete
protectionzone_fk_type	protectionzone.fk_type	protectionzone_type.id	Restrict delete
pump_fk_pipe_in	pump.fk_pipe_in	pipe.id	Restrict delete
pump_fk_pipe_out	pump.fk_pipe_out	pipe.id	Restrict delete
pump_fk_pump_operating	pump.fk_pump_operating	pump_operating.id	Restrict delete
pump_fk_type	pump.fk_pump_type	pump_type.id	Restrict delete
pump_id_fkey	pump.id	installation.id	Restrict delete
remote_fk_distributor	remote.fk_distributor	distributor.id	Restrict delete
remote_fk_material	remote.fk_material	pipe_material.id	Restrict delete
remote_fk_precision	remote.fk_precision	precision.id	Restrict delete
remote_fk_status	remote.fk_status	status.id	Restrict delete
remote_label_1_visible	remote.label_1_visible	visible.vl_code_int	Restrict delete
remote_label_2_visible	remote.label_2_visible	visible.vl_code_int	Restrict delete
samplingpoint_id_fkey	samplingpoint.id	network_element.id	Restrict delete
source_fk_source_quality	source.fk_source_quality	source_quality.id	Restrict delete
source_fk_type	source.fk_source_type	source_type.id	Restrict delete
source_id_fkey	source.id	installation.id	Restrict delete
subscriber_fk_pipe	subscriber.fk_pipe	pipe.id	Restrict delete
subscriber_fk_type	subscriber.fk_subscriber_type	subscriber_type.id	Restrict delete
subscriber_id_fkey	subscriber.id	network_element.id	Restrict delete
subscriber_reference_fk_subscriber	subscriber_reference.fk_subscriber	subscriber.id	Restrict delete
surveypoint_fk_folder	surveypoint.fk_folder	folder.id	Restrict delete
surveypoint_fk_type	surveypoint.fk_survey_type	survey_type.id	Restrict delete
surveypoint_fk_worker	surveypoint.fk_worker	worker.id	Restrict delete
surveypoint_id_fkey	surveypoint.id	surveypoint.id	Restrict delete
tank_cistern1type	tank.cistern1_fk_type	cistern.id	Restrict delete
tank_cistern2type	tank.cistern2_fk_type	cistern.id	Restrict delete
tank_fk_overflow	tank.fk_overflow	overflow.id	Restrict delete
tank_fk_tank_firestorage	tank.fk_tank_firestorage	tank_firestorage.id	Restrict delete
tank_id_fkey	tank.id	installation.id	Restrict delete
treatment_id_fkey	treatment.id	installation.id	Restrict delete
valve_fk_distributor	valve.fk_distributor	distributor.id	Restrict delete
valve_fk_district	valve.fk_district	district.id	Restrict delete
valve_fk_folder	valve.fk_folder	folder.id	Restrict delete
valve_fk_function	valve.fk_valve_function	valve_function.id	Restrict delete
valve_fk_handle_precision	valve.fk_handle_precision	precision.id	Restrict delete
valve_fk_handle_precisionalti	valve.fk_handle_precisionalti	precisionalti.id	Restrict delete
valve_fk_object_reference	valve.fk_object_reference	object_reference.id	Restrict delete
valve_fk_pipe	valve.fk_pipe	pipe.id	Restrict delete
valve_fk_precision	valve.fk_precision	precision.id	Restrict delete
valve_fk_precisionalti	valve.fk_precisionalti	precisionalti.id	Restrict delete
valve_fk_pressurezone	valve.fk_pressurezone	pressurezone.id	Restrict delete
valve_fk_status	valve.fk_status	status.id	Restrict delete
valve_fk_type	valve.fk_valve_type	valve_type.id	Restrict delete
valve_fk_valve_actuation	valve.fk_valve_actuation	valve_actuation.id	Restrict delete
valve_label_1_visible	valve.label_1_visible	visible.vl_code_int	Restrict delete
valve_label_2_visible	valve.label_2_visible	visible.vl_code_int	Restrict delete
valve_schema_force_visible	valve.schema_force_visible	visible.vl_code	Restrict delete

Check Constraints:

Table	Constraint Name	Constraint
None detected