SchemaSpy Analysis of erigrid.public - Constraints Generated by
SchemaSpy
70 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
access_controls_comp_id_fkey access_controls.comp_id component.comp_id Cascade on delete 
access_controls_reference_component_fkey access_controls.reference_component component.comp_id Restrict delete 
amplifier_amplifier_mode_fkey amplifier.amplifier_mode amplifier_mode.name Restrict delete 
amplifier_comp_id_fkey amplifier.comp_id component.comp_id Cascade on delete 
amplifier_interface_algorithm_fkey amplifier.interface_algorithm interface_algorithm.code Restrict delete 
amplifier_real_time_simulator_fkey amplifier.real_time_simulator component.comp_id Restrict delete 
antivirus_comp_id_fkey antivirus.comp_id component.comp_id Cascade on delete 
antivirus_reference_component_fkey antivirus.reference_component component.comp_id Restrict delete 
communication_interchange_comp_id_fkey communication_interchange.comp_id component.comp_id Cascade on delete 
communication_interchange_primary_domain_fkey communication_interchange.primary_domain domain.domain_id Restrict delete 
communication_interchange_secondary_domain_fkey communication_interchange.secondary_domain domain.domain_id Restrict delete 
communication_line_segment_comp_id_fkey communication_line_segment.comp_id component.comp_id Cascade on delete 
component_ri_id_fkey component.ri_id research_infrastructure.ri_id Restrict delete 
control_device_comp_id_fkey control_device.comp_id component.comp_id Cascade on delete 
control_device_primary_component_fkey control_device.primary_component component.comp_id Restrict delete 
control_mode_control_device_fkey control_mode.control_device control_device.comp_id Restrict delete 
controller_hosting_capacity_control_device_fkey controller_hosting_capacity.control_device control_device.comp_id Restrict delete 
domain_parent_id_fkey domain.parent_id domain.domain_id Restrict delete 
domain_topology_domain_id_fkey domain_topology.domain_id domain.domain_id Restrict delete 
domain_topology_ri_id_fkey domain_topology.ri_id research_infrastructure.ri_id Restrict delete 
electric_vehicle_comp_id_fkey electric_vehicle.comp_id component.comp_id Cascade on delete 
electric_vehicle_ev_type_fkey electric_vehicle.ev_type electric_vehicle_type.name Restrict delete 
electrical_line_segment_comp_id_fkey electrical_line_segment.comp_id component.comp_id Cascade on delete 
electrical_switch_comp_id_fkey electrical_switch.comp_id component.comp_id Cascade on delete 
ev_charging_station_comp_id_fkey ev_charging_station.comp_id component.comp_id Cascade on delete 
firewall_comp_id_fkey firewall.comp_id component.comp_id Cascade on delete 
generating_unit_comp_id_fkey generating_unit.comp_id component.comp_id Cascade on delete 
generating_unit_gen_type_fkey generating_unit.gen_type generator_type.name Restrict delete 
generating_unit_grid_conn_fkey generating_unit.grid_conn grid_connection.name Restrict delete 
heat_exchanger_comp_id_fkey heat_exchanger.comp_id component.comp_id Cascade on delete 
intrusion_detection_system_comp_id_fkey intrusion_detection_system.comp_id component.comp_id Cascade on delete 
intrusion_detection_system_reference_component_fkey intrusion_detection_system.reference_component component.comp_id Restrict delete 
inverter_comp_id_fkey inverter.comp_id component.comp_id Cascade on delete 
lab_scada_comp_id_fkey lab_scada.comp_id component.comp_id Cascade on delete 
lab_scada_primary_component_fkey lab_scada.primary_component component.comp_id Restrict delete 
load_comp_id_fkey load.comp_id component.comp_id Cascade on delete 
load_load_type_fkey load.load_type load_type.name Restrict delete 
measured_data_measurement_device_fkey measured_data.measurement_device measurement_device.comp_id Restrict delete 
measurement_device_comp_id_fkey measurement_device.comp_id component.comp_id Cascade on delete 
model_file_ri_id_fkey model_file.ri_id research_infrastructure.ri_id Cascade on delete 
network_impairment_simulator_comp_id_fkey network_impairment_simulator.comp_id component.comp_id Cascade on delete 
network_segmentation_comp_id_fkey network_segmentation.comp_id component.comp_id Cascade on delete 
protection_device_comp_id_fkey protection_device.comp_id component.comp_id Cascade on delete 
protection_device_primary_component_fkey protection_device.primary_component component.comp_id Restrict delete 
protection_mode_protection_device_fkey protection_mode.protection_device protection_device.comp_id Restrict delete 
real_time_simulator_comp_id_fkey real_time_simulator.comp_id component.comp_id Cascade on delete 
research_infrastructure_org_id_fkey research_infrastructure.org_id organization.org_id Restrict delete 
secure_communication_comp_id_fkey secure_communication.comp_id component.comp_id Cascade on delete 
secure_communication_component_client_fkey secure_communication.component_client component.comp_id Restrict delete 
secure_communication_component_server_fkey secure_communication.component_server component.comp_id Restrict delete 
server_pc_comp_id_fkey server_pc.comp_id component.comp_id Cascade on delete 
service_comp_id_fkey service.comp_id component.comp_id Cascade on delete 
simulation_capacity_comp_id_fkey simulation_capacity.comp_id component.comp_id Cascade on delete 
source_comp_id_fkey source.comp_id component.comp_id Cascade on delete 
source_source_type_fkey source.source_type source_type.name Restrict delete 
storage_area_network_comp_id_fkey storage_area_network.comp_id component.comp_id Cascade on delete 
terminal_comp_id_fkey terminal.comp_id component.comp_id Restrict delete 
terminal_domain_id_fkey terminal.domain_id domain.domain_id Restrict delete 
terminal_node_id_fkey terminal.node_id connectivity_node.node_id Restrict delete 
thermal_circuit_equipment_comp_id_fkey thermal_circuit_equipment.comp_id component.comp_id Cascade on delete 
thermal_circuit_equipment_der_component_fkey thermal_circuit_equipment.der_component component.comp_id Restrict delete 
thermal_load_comp_id_fkey thermal_load.comp_id component.comp_id Cascade on delete 
thermal_load_der_component_fkey thermal_load.der_component component.comp_id Restrict delete 
thermal_pipeline_comp_id_fkey thermal_pipeline.comp_id component.comp_id Cascade on delete 
thermal_source_comp_id_fkey thermal_source.comp_id component.comp_id Cascade on delete 
thermal_source_der_component_fkey thermal_source.der_component component.comp_id Restrict delete 
thermal_storage_comp_id_fkey thermal_storage.comp_id component.comp_id Cascade on delete 
thermal_storage_der_component_fkey thermal_storage.der_component component.comp_id Restrict delete 
transformer_comp_id_fkey transformer.comp_id component.comp_id Cascade on delete 
virtual_server_environment_comp_id_fkey virtual_server_environment.comp_id component.comp_id Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected