Table erigrid.public.component Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
comp_id serial 10  √  nextval('component_comp_id_seq'::regclass)
access_controls.comp_id access_controls_comp_id_fkey C
access_controls.reference_component access_controls_reference_component_fkey R
amplifier.comp_id amplifier_comp_id_fkey C
amplifier.real_time_simulator amplifier_real_time_simulator_fkey R
antivirus.comp_id antivirus_comp_id_fkey C
antivirus.reference_component antivirus_reference_component_fkey R
communication_interchange.comp_id communication_interchange_comp_id_fkey C
communication_line_segment.comp_id communication_line_segment_comp_id_fkey C
control_device.comp_id control_device_comp_id_fkey C
control_device.primary_component control_device_primary_component_fkey R
electric_vehicle.comp_id electric_vehicle_comp_id_fkey C
electrical_line_segment.comp_id electrical_line_segment_comp_id_fkey C
electrical_switch.comp_id electrical_switch_comp_id_fkey C
ev_charging_station.comp_id ev_charging_station_comp_id_fkey C
firewall.comp_id firewall_comp_id_fkey C
generating_unit.comp_id generating_unit_comp_id_fkey C
heat_exchanger.comp_id heat_exchanger_comp_id_fkey C
intrusion_detection_system.comp_id intrusion_detection_system_comp_id_fkey C
intrusion_detection_system.reference_component intrusion_detection_system_reference_component_fkey R
inverter.comp_id inverter_comp_id_fkey C
lab_scada.comp_id lab_scada_comp_id_fkey C
lab_scada.primary_component lab_scada_primary_component_fkey R
load.comp_id load_comp_id_fkey C
measurement_device.comp_id measurement_device_comp_id_fkey C
network_impairment_simulator.comp_id network_impairment_simulator_comp_id_fkey C
network_segmentation.comp_id network_segmentation_comp_id_fkey C
protection_device.comp_id protection_device_comp_id_fkey C
protection_device.primary_component protection_device_primary_component_fkey R
real_time_simulator.comp_id real_time_simulator_comp_id_fkey C
secure_communication.comp_id secure_communication_comp_id_fkey C
secure_communication.component_client secure_communication_component_client_fkey R
secure_communication.component_server secure_communication_component_server_fkey R
server_pc.comp_id server_pc_comp_id_fkey C
service.comp_id service_comp_id_fkey C
simulation_capacity.comp_id simulation_capacity_comp_id_fkey C
source.comp_id source_comp_id_fkey C
storage_area_network.comp_id storage_area_network_comp_id_fkey C
terminal.comp_id terminal_comp_id_fkey R
thermal_circuit_equipment.comp_id thermal_circuit_equipment_comp_id_fkey C
thermal_circuit_equipment.der_component thermal_circuit_equipment_der_component_fkey R
thermal_load.comp_id thermal_load_comp_id_fkey C
thermal_load.der_component thermal_load_der_component_fkey R
thermal_pipeline.comp_id thermal_pipeline_comp_id_fkey C
thermal_source.comp_id thermal_source_comp_id_fkey C
thermal_source.der_component thermal_source_der_component_fkey R
thermal_storage.comp_id thermal_storage_comp_id_fkey C
thermal_storage.der_component thermal_storage_der_component_fkey R
transformer.comp_id transformer_comp_id_fkey C
virtual_server_environment.comp_id virtual_server_environment_comp_id_fkey C
comp_name varchar 2147483647  √  null Name of the component
ri_id int4 10  √  null
research_infrastructure.ri_id component_ri_id_fkey R
The research infrasturcture this component belongs to
description text 2147483647  √  null Verbal description
confidential bool 1  √  false If information related to this component is confidential, set as true
author varchar 2147483647  √  null
modified timestamptz 35,6  √  null

Analyzed at Thu Apr 27 16:49 EEST 2017

Indexes:
Column(s) Type Sort Constraint Name
comp_id Primary key Asc component_pkey
comp_id Performance Asc ix_public_component_comp_id

Close relationships  within of separation: