SchemaSpy Analysis of erigrid.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Thu Apr 27 16:49 EEST 2017
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

erigrid.public contains 356 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
component comp_id serial 10  √  nextval('component_comp_id_seq'::regclass)
domain domain_id serial 10  √  nextval('domain_domain_id_seq'::regclass)
connectivity_node node_id serial 10  √  nextval('connectivity_node_node_id_seq'::regclass)
organization org_id serial 10  √  nextval('organization_org_id_seq'::regclass)
research_infrastructure ri_id serial 10  √  nextval('research_infrastructure_ri_id_seq'::regclass)
network_impairment_simulator access_rights text 2147483647  √  null usergroups, roles and rights management
server_pc access_rights text 2147483647  √  null usergroups, roles and rights management
virtual_server_environment access_rights text 2147483647  √  null usergroups, roles and rights management
source acdc acdc_type 2147483647  √  null Is the source AC or DC
amplifier amplifier_mode varchar 25  √  null Amplifier mode
real_time_simulator analog_input_nmbr int2 5  √  null Number of analog input ports
real_time_simulator analog_output_nmbr int2 5  √  null Number of analog output ports
secure_communication authentication varchar 2147483647  √  null Specify whether a secure protocol involves authentication. Acceptable values: {No; Client Authentication; Server Authentication; Mutual Authentication}
secure_communication authentication_key varchar 2147483647  √  null Description of keys which are used for authentication, e.g. password, digital certificates, etc.
component author varchar 2147483647  √  null
research_infrastructure author varchar 2147483647  √  null
thermal_pipeline av_diss float4 8,8  √  null Average pipeline heat losses: watts per meter length and temperature difference (Tfluid-Tamb) (W/(m °C))
thermal_storage av_diss float4 8,8  √  null Average storage heat losses: watts per temperature difference (Tfluid-Tamb) (W/(°C))
communication_line_segment bandwidth float4 8,8  √  null Bandwidth of the communication line as defined by the application. (bit/s)
lab_scada capacity int2 5  √  null Maximum Number of nodes
interface_algorithm code varchar 5
access_controls comp_id int4 10
amplifier comp_id int4 10
antivirus comp_id int4 10
communication_interchange comp_id int4 10
communication_line_segment comp_id int4 10
control_device comp_id int4 10
electric_vehicle comp_id int4 10
electrical_line_segment comp_id int4 10
electrical_switch comp_id int4 10
ev_charging_station comp_id int4 10
firewall comp_id int4 10
generating_unit comp_id int4 10
heat_exchanger comp_id int4 10
intrusion_detection_system comp_id int4 10
inverter comp_id int4 10
lab_scada comp_id int4 10
load comp_id int4 10
measurement_device comp_id int4 10
network_impairment_simulator comp_id int4 10
network_segmentation comp_id int4 10
protection_device comp_id int4 10
real_time_simulator comp_id int4 10
secure_communication comp_id int4 10
server_pc comp_id int4 10
service comp_id int4 10
simulation_capacity comp_id int4 10
source comp_id int4 10
storage_area_network comp_id int4 10
terminal comp_id int4 10
thermal_circuit_equipment comp_id int4 10
thermal_load comp_id int4 10
thermal_pipeline comp_id int4 10
thermal_source comp_id int4 10
thermal_storage comp_id int4 10
transformer comp_id int4 10
virtual_server_environment comp_id int4 10
component comp_name varchar 2147483647  √  null Name of the component
secure_communication component_client int4 10  √  null Second end-point (client) which is involved in data exchange over secure protocol. Foreign key referring to a component in the testbed, e.g. ControlDevice.
secure_communication component_server int4 10  √  null First end-point (server) which is involved in data exchange the secure protocol. Foreign key referring to a component in the testbed, e.g. ServerPC (defined in ICT Components).
component confidential bool 1  √  false If information related to this component is confidential, set as true
domain_topology confidential bool 1  √  false If the topology picture is confidential, set as true
model_file confidential bool 1  √  false If the topology picture is confidential, set as true
research_infrastructure confidential bool 1  √  null If all RI information is confidential, set as true
storage_area_network connection_tech varchar 2147483647  √  null connection technology for servers (e.g. Fibre Channel)
load continuous_or_stepped bool 1  √  false Can the load be controlled continuously or stepwise?
thermal_circuit_equipment continuous_or_stepped bool 1  √  null Can variable be controlled continuously or stepwise?
thermal_load continuous_or_stepped bool 1  √  null Can the ThermalComponent be controlled continuously or stepwise?
thermal_source continuous_or_stepped bool 1  √  null Can the ThermalComponent be controlled continuously or stepwise?
thermal_storage continuous_or_stepped bool 1  √  null Can the ThermalComponent be controlled continuously or stepwise?
control_mode control_device int4 10  √  null
controller_hosting_capacity control_device int4 10  √  null
control_mode control_level ctrl_level_type 2147483647  √  null
controller_hosting_capacity control_level ctrl_level_type 2147483647  √  null The level on which the control operates. Acceptable values: {D1; D2; D3; D4; D5}
server_pc cpu float4 8,8  √  null cpu capacity (Hz)
simulation_capacity cpu float4 8,8  √  null Size of CPU (Hz)
virtual_server_environment cpu float4 8,8  √  null cpu capacity of the cluster (Hz)
measurement_device data_handling varchar 2147483647  √  null Type of data. Acceptable values: {Instantaneous value; RMS}
lab_scada data_logging_facilities text 2147483647  √  null Text field to explain the data logging facilities of the SCADA.
measured_data data_quality varchar 2147483647  √  null Data quality
measurement_device data_sampling float4 8,8  √  null Sampling interval of data (s)
thermal_circuit_equipment der_component int4 10  √  null Foreign key referring to DERComponent table (in particular for pumps as electrical loads)
thermal_load der_component int4 10  √  null Foreign key referring to DERComponent table (in particular for CHP and heat pumps)
thermal_source der_component int4 10  √  null Foreign key referring to DERComponent table (in particular for CHP and heat pumps)
thermal_storage der_component int4 10  √  null Foreign key referring to DERComponent table (in particular for CHP and heat pumps)
component description text 2147483647  √  null Verbal description
control_mode description text 2147483647  √  null
controller_hosting_capacity description text 2147483647  √  null Verbal description
domain description text 2147483647  √  null
domain_topology description text 2147483647  √  null Verbal description
interface_algorithm description varchar 2147483647  √  null
measured_data description text 2147483647  √  null Verbal description
model_file description text 2147483647  √  null Verbal description
protection_mode description text 2147483647  √  null Verbal description
terminal description text 2147483647  √  null
research_infrastructure description_purpose varchar 2147483647  √  null Verbal description of the purpose of the RI
research_infrastructure description_setup varchar 2147483647  √  null Verbal description of the physical setup of the RI
thermal_pipeline dh_connection bool 1  √  null Stand alone Thermal circuit or part of a thermal network connected to District Heating (0/1)
thermal_pipeline dh_p_th_in float4 8,8  √  null If DHconnection=1, Max inlet thermal power (W)
thermal_pipeline dh_p_th_out float4 8,8  √  null If DHconnection=1, Max outlet thermal power (W)
thermal_pipeline dh_t_fr float4 8,8  √  null If DHconnection=1, Nominal inlet/outlet Flow rate (m3/s)
thermal_pipeline dh_t_in float4 8,8  √  null If DHconnection=1, Nominal inlet temperature (°C)
thermal_pipeline dh_t_out float4 8,8  √  null If DHconnection=1, Nominal outlet temperature (°C)
real_time_simulator digital_input_nmbr int2 5  √  null Number of digital input ports
real_time_simulator digital_output_nmbr int2 5  √  null Number of digital output ports
domain_topology domain_id int4 10
terminal domain_id int4 10
lab_scada employed_standard varchar 2147483647  √  null Interface protocol to applications of same level (e.g. OPC). The characteristics of the protocol can also be described.
secure_communication encryption_scheme text 2147483647  √  null Description of encryption scheme used for exchange of data
electric_vehicle ev_type varchar 10  √  null Type of the electric vehicle.
research_infrastructure external_connectivity varchar 2147483647  √  null Real time connectivity of the RI with other Ris
model_file file bytea 2147483647  √  null
amplifier galvanic_isolation bool 1  √  false Galvanic isolation
generating_unit gen_type varchar 30  √  null Type of the generating unit
generating_unit grid_conn varchar 25  √  null Type of grid connection
generating_unit grid_forming_capable bool 1  √  false Is the generating unit grid-forming capable?
server_pc hdd float4 8,8  √  null hard drive space (Byte)
storage_area_network hdd float4 8,8  √  null size of hdd (Byte)
virtual_server_environment hdd float4 8,8  √  null hdd space of the cluster (Byte)
thermal_load heat_fluid varchar 2147483647  √  null Type of heated fluid. Acceptable values: {Water; Steam; Air; Oil; Other}
thermal_pipeline heat_fluid varchar 2147483647  √  null Type of heat fluid. Acceptable values: {Water; Steam; Air; Oil; Other}
thermal_source heat_fluid varchar 2147483647  √  null Type of heated fluid. Acceptable values: {Water; Steam; Air; Oil; Other}
thermal_storage heat_fluid varchar 2147483647  √  null Type of heated fluid. Acceptable values: {Water; Steam; Air; Oil; Other}
heat_exchanger heated_fluid varchar 2147483647  √  null Type of heated fluid (water, steam, air, oil, other) -outlet
heat_exchanger heating_fluid varchar 2147483647  √  null Type of heating fluid (water, steam, air, oil, other) -inlet
virtual_server_environment high_availability text 2147483647  √  null Information about failover in case of faulty hosts
lab_scada hmi text 2147483647  √  null Description field.
control_device horizontallevel_control_device varchar 2147483647  √  null If there is a hierarchical control structure, the control devices at the same control level and protocols that are used to communicate with them are listed here. This is a text field and the format to input data should be as follows:{ControlDevice 1, protocol 1; ControlDevice 2, protocol 2; ?; ControlDevice n, protocol n}
lab_scada horizontallevel_control_device varchar 2147483647  √  null If there is a hierarchical control structure, the control devices at the same control level and protocols that are used to communicate with them are listed here. This is a text field and the format to input data should be as follows:{ControlDevice 1, protocol 1; ControlDevice 2, protocol 2; ?; ControlDevice n, protocol n}
access_controls identification_used varchar 2147483647  √  null Description of identifications used to authenticate the user to the access control system, e.g. user names/passwords, digital certificates, ID cards, personal card, etc.
amplifier identified_transfer_function bool 1  √  false Is the transfer function identified? (Y/N). If yes, please provide the transfer function in description field.
amplifier input_boundary varchar 2147483647  √  null Limits on inputs
protection_device int_protocol varchar 2147483647  √  null Interface protocol of the unit.
firewall integrated_security_services text 2147483647  √  null Description of other security services which are integrated within the firewall, e.g. intrusion detection and prevention, virtual private network, malware protection, etc.
amplifier interface_algorithm varchar 5  √  null Interface algorithm used
amplifier interface_type interface_type 2147483647  √  null current or voltage
amplifier io_nmbr int2 5  √  null Number of channels
server_pc ip varchar 2147483647  √  null ip parameters
server_pc is_virtual bool 1  √  null information if server is hardware or virtual (true or false)
communication_line_segment length float4 8,8  √  null Length of the line segment (m)
electrical_line_segment length float4 8,8  √  null Length of the line segment (m)
thermal_pipeline length float4 8,8  √  null Overall length of the Thermal pipeline (m)
simulation_capacity load_balancing bool 1  √  null Is it possible to balance the load over more than one server or via the usage of virtual machines?(true or false)
load load_type varchar 20  √  null Type of load
control_device lowerlevel_control_device varchar 2147483647  √  null If there is a hierarchical control structure, the lower level control devices and protocols that are used to communicate with them are listed here. This is a text field and the format to input data should be as follows:{ControlDevice 1, protocol 1; ControlDevice 2, protocol 2; ?; ControlDevice n, protocol n}
lab_scada lowerlevel_control_device varchar 2147483647  √  null If there is a hierarchical control structure, the lower level control devices and protocols that are used to communicate with them are listed here. This is a text field and the format to input data should be as follows:{ControlDevice 1, protocol 1; ControlDevice 2, protocol 2; ?; ControlDevice n, protocol n}
source max_f float4 8,8  √  null Maximum frequency (Hz)
real_time_simulator max_node_nmbr int2 5  √  null Maximum number of network nodes that can be modelled
heat_exchanger max_temp_in float4 8,8  √  null Heating fluid max temperature (°C)
heat_exchanger max_temp_out float4 8,8  √  null Heated fluid max temperature (°C)
source max_u float4 8,8  √  null Maximum voltage (V)
measured_data measurement_device int4 10  √  null
communication_line_segment medium varchar 2147483647  √  null The medium of the communication line.
source min_f float4 8,8  √  null Minimum frequency (Hz)
thermal_load min_p_th float4 8,8  √  null Minimum Thermal Power (W)
thermal_source min_p_th float4 8,8  √  null Minimum Thermal Power (W)
thermal_storage min_p_th float4 8,8  √  null Minimum Thermal Power (W)
source min_u float4 8,8  √  null Minimum voltage (V)
control_mode mode varchar 25
protection_mode mode varchar 20 Protection mode
control_device modeltype varchar 2147483647  √  null Modeltype of the controller. In case of manual control this should be set to ?Manual?.
lab_scada modeltype varchar 2147483647  √  null Modeltype of the controller. In case of manual control this should be set to ?Manual?.
protection_device modeltype varchar 2147483647  √  null Modeltype of the protection device.
component modified timestamptz 35,6  √  null
research_infrastructure modified timestamptz 35,6  √  null
amplifier_mode name varchar 25
connectivity_node name varchar 20  √  null
domain name varchar 20  √  null
electric_vehicle_type name varchar 10
generator_type name varchar 30
grid_connection name varchar 25
load_type name varchar 20
research_infrastructure name varchar 2147483647  √  null Name of the RI
source_type name varchar 10
terminal name varchar 2147483647  √  null
terminal node_id int4 10
thermal_pipeline nom_d float4 8,8  √  null Nominal Thermal Pipeline Diameter (average value) (m)
thermal_pipeline nom_dp float4 8,8  √  null Overall pressure losses at Nominal Flow rate (bar)
thermal_pipeline nom_fr float4 8,8  √  null Nominal Flow rate (m3/s)
thermal_pipeline nom_t float4 8,8  √  null Nominal fluid temperature (°C)
research_infrastructure org_id int4 10  √  null Owner of the RI
organization orgname varchar 2147483647  √  null
server_pc os varchar 2147483647  √  null operating system
amplifier output_boundary varchar 2147483647  √  null Limits on outputs
domain parent_id int4 10  √  null
ev_charging_station peak_p float4 8,8  √  null Peak power (W)
electric_vehicle peak_p_charge float4 8,8  √  null Peak power for charging (W)
thermal_storage peak_p_charge float4 8,8  √  null Peak power for charging (W)
electric_vehicle peak_p_discharge float4 8,8  √  null Peak power for discharging (W)
thermal_storage peak_p_discharge float4 8,8  √  null Peak power for discharging (W)
amplifier phases int2 5  √  null Phase number (1 or 3)
electric_vehicle phases int2 5  √  null Phase number (1 or 3)
electrical_line_segment phases int2 5  √  null Phase number (1 or 3)
electrical_switch phases int2 5  √  null Phase number (1 or 3)
ev_charging_station phases int2 5  √  null Phase number (1 or 3)
generating_unit phases int2 5  √  null Phase number (1 or 3)
inverter phases int2 5  √  null Phase number (1 or 3)
load phases int2 5  √  null Phase number (1 or 3)
source phases int2 5  √  null Phase number (1 or 3)
inverter phil_capable bool 1  √  false Can the inverter be used to form a closed-loop simulation?
source phil_capable bool 1  √  false Can the source operate as a part of a closed-loop simulation
amplifier physical_or_emulated component_type 2147483647  √  'physical'::component_type
electric_vehicle physical_or_emulated component_type 2147483647  √  'physical'::component_type
ev_charging_station physical_or_emulated component_type 2147483647  √  'physical'::component_type
generating_unit physical_or_emulated component_type 2147483647  √  'physical'::component_type
inverter physical_or_emulated component_type 2147483647  √  'physical'::component_type
load physical_or_emulated component_type 2147483647  √  'physical'::component_type
source physical_or_emulated component_type 2147483647  √  'physical'::component_type
thermal_load physical_or_emulated bool 1  √  null Is the component a physical component or emulated/simulated?
thermal_source physical_or_emulated bool 1  √  null Is the component a physical component or emulated/simulated?
thermal_storage physical_or_emulated bool 1  √  null Is the component a physical component or emulated/simulated?
domain_topology picture bytea 2147483647  √  null Picture of the topology
lab_scada platform varchar 2147483647  √  null Platform/language on which the SCADA was built (e.g. Lynx, PCVue, etc).
network_impairment_simulator ports int2 5  √  null number of ethernet ports
control_device primary_component int4 10  √  null The controller can be linked to a primary component if desired. The primary component means the physical component which the controller is controlling. This attribute is used only at the lowest levels of the control hierarchy (D3-D5) and refers to one primary component only. It can be used, for example, to associate a generator voltage controller to the generating unit.
lab_scada primary_component int4 10  √  null The controller can be linked to a primary component if desired. The primary component means the physical component which the controller is controlling. This attribute is used only at the lowest levels of the control hierarchy (D3-D5) and refers to one primary component only. It can be used, for example, to associate a generator voltage controller to the generating unit.
protection_device primary_component int4 10  √  null The protection device can be linked to a primary component if desired. The primary component is the breaker/switch which the protection device is controlling.
communication_interchange primary_domain int4 10  √  null Foreign key referring to Domain table. If the device interconnects communication links of the same type (e.g. an ethernet switch or a USB hub), the primary domain is the only one that exists. If the device converts between domains (e.g. a webservices to Modbus/RTU gateway), the primary domain will be on the upstream side if an upstream side can be identified (e.g. towards the master in a master-slave system). If the device converts between domains and no upstream side can be identified (e.g. CAN bus extender over Ethernet), primary and secondary can be assigned at random.
thermal_source primary_energy varchar 2147483647  √  null Type of primary energy/fuel. Acceptable values: {Electricity; Natural gas; Oil; Solar; Other)
antivirus product_name varchar 2147483647  √  null Name of the anti-virus product which is installed in the testbed
firewall product_name varchar 2147483647  √  null Name of the firewall which is installed in the testbed.
intrusion_detection_system product_name varchar 2147483647  √  null Name of the intrusion detection system which is installed in the testbed.
network_impairment_simulator profiles text 2147483647  √  null description of available profiles
protection_mode protection_device int4 10  √  null
secure_communication protocol_type varchar 2147483647  √  null Description of protocol type which is used for communication between two entities in the testbed, e.g. Modbus/TCP, IEC 61850, etc.
transformer r_k float4 8,8  √  null Winding resistance (percentage)
server_pc ram float4 8,8  √  null size of ram (Byte)
simulation_capacity ram float4 8,8  √  null Size of RAM (Byte)
virtual_server_environment ram float4 8,8  √  null ram capacity of the cluster (Byte)
electric_vehicle rated_capacity float4 8,8  √  null Nominal energy capacity of the car batteries (Wh)
thermal_storage rated_capacity float4 8,8  √  null Nominal energy capacity (Wh)
electrical_line_segment rated_current float4 8,8  √  null Rated current of the line segment (A)
electrical_switch rated_current float4 8,8  √  null Rated current of the switch (A)
generating_unit rated_efficiency float4 8,8  √  null Efficiency of the generating unit (p.u., needed especially for the fossil fueled generators)
heat_exchanger rated_efficiency varchar 2147483647  √  null Heat exchanger efficiency at nominal thermal power (pu)
thermal_load rated_efficiency float4 8,8  √  null Efficiency of the ThermalComponent at nominal power(for heat pumps indicate COPheating/cooling, for storage round trip efficiency) (pu)
thermal_source rated_efficiency float4 8,8  √  null Efficiency of the ThermalComponent at nominal power(for heat pumps indicate COPheating/cooling, for storage round trip efficiency) (pu)
thermal_storage rated_efficiency float4 8,8  √  null Efficiency of the ThermalComponent at nominal power(for heat pumps indicate COPheating/cooling, for storage round trip efficiency) (pu)
amplifier rated_f float4 8,8  √  null Nominal frequency (Hz)
electric_vehicle rated_f float4 8,8  √  null Nominal frequency (Hz)
ev_charging_station rated_f float4 8,8  √  null Nominal frequency (Hz)
generating_unit rated_f float4 8,8  √  null Nominal frequency (Hz)
inverter rated_f float4 8,8  √  null Nominal frequency (Hz)
load rated_f float4 8,8  √  null Nominal frequency (Hz)
source rated_f float4 8,8  √  null Nominal frequency (Hz)
thermal_circuit_equipment rated_flow float4 8,8  √  null Nominal Flow rate (m3/s)
amplifier rated_p float4 8,8  √  null Nominal real power (W)
electric_vehicle rated_p float4 8,8  √  null Nominal real power (W)
ev_charging_station rated_p float4 8,8  √  null Nominal real power (W)
generating_unit rated_p float4 8,8  √  null Nominal real power (W)
inverter rated_p float4 8,8  √  null Nominal real power (W)
load rated_p float4 8,8  √  null Nominal real power (W)
source rated_p float4 8,8  √  null Nominal real power (W)
heat_exchanger rated_p_th float4 8,8  √  null Nominal Thermal Power (W)
thermal_load rated_p_th float4 8,8  √  null Nominal Thermal Power (W)
thermal_source rated_p_th float4 8,8  √  null Nominal Thermal Power (W)
thermal_storage rated_p_th float4 8,8  √  null Nominal Thermal Power (W)
amplifier rated_q float4 8,8  √  null Nominal reactive power (VAr)
electric_vehicle rated_q float4 8,8  √  null Nominal reactive power (VAr)
ev_charging_station rated_q float4 8,8  √  null Nominal reactive power (VAr)
generating_unit rated_q float4 8,8  √  null Nominal reactive power (VAr)
inverter rated_q float4 8,8  √  null Nominal reactive power (VAr)
load rated_q float4 8,8  √  null Nominal reactive power (VAr)
source rated_q float4 8,8  √  null Nominal reactive power (VAr)
amplifier rated_s float4 8,8  √  null Nominal apparent power (VA)
electric_vehicle rated_s float4 8,8  √  null Nominal apparent power (VA)
ev_charging_station rated_s float4 8,8  √  null Nominal apparent power (VA)
generating_unit rated_s float4 8,8  √  null Nominal apparent power (VA)
inverter rated_s float4 8,8  √  null Nominal apparent power (VA)
load rated_s float4 8,8  √  null Nominal apparent power (VA)
source rated_s float4 8,8  √  null Nominal apparent power (VA)
transformer rated_s float4 8,8  √  null Nominal apparent power (VA)
thermal_load rated_temp float4 8,8  √  null Heated fluid nominal temperature (°C)
thermal_source rated_temp float4 8,8  √  null Heated fluid nominal temperature (°C)
thermal_storage rated_temp float4 8,8  √  null Heated fluid nominal temperature (°C)
amplifier rated_u float4 8,8  √  null Nominal voltage (V)
electric_vehicle rated_u float4 8,8  √  null Nominal voltage (V)
ev_charging_station rated_u float4 8,8  √  null Nominal voltage (V)
generating_unit rated_u float4 8,8  √  null Nominal voltage (V)
inverter rated_u float4 8,8  √  null Nominal voltage (V)
load rated_u float4 8,8  √  null Nominal voltage (V)
source rated_u float4 8,8  √  null Nominal voltage (V)
transformer rated_u1 float4 8,8  √  null Primary side nominal voltage (V)
transformer rated_u2 float4 8,8  √  null Secondary side nominal voltage (V)
electrical_line_segment reactance float4 8,8  √  null Line reactance (?)
amplifier real_time_simulator int4 10  √  null If the amplifier is associated with a real time simulator, the simulator is indicated in this attribute. If not, the field is left empty.
storage_area_network redundancy text 2147483647  √  null information about redundancy of the SAN
access_controls reference_component int4 10  √  null A components which implement access controls can be referenced, e.g. a firewall component.
antivirus reference_component int4 10  √  null Foreign key referring to the Component table. The reference to the component in the testbed on which the antivirus software is installed.
intrusion_detection_system reference_component int4 10  √  null The reference to the component in the testbed on which the IDS is installed on, e.g. firewall, router, server PC, etc.
electrical_line_segment resistance float4 8,8  √  null Line resistance (?)
virtual_server_environment resource_pools bool 1  √  null management of available resources in pools (for a couple of virtual machines)(true or false)
component ri_id int4 10  √  null The research infrasturcture this component belongs to
domain_topology ri_id int4 10
model_file ri_id int4 10
communication_interchange secondary_domain int4 10  √  null Foreign key referring to Domain table. Empty if the device interconnects communication links of the same type, otherwise the domain of the upstream link if upstream can be identified (see under primaryDomain), otherwise the domain of the link not entered as primary.
secure_communication secure_protocol varchar 2147483647  √  null Type of the secure protocol used for data exchange. Acceptable values: {SSL; IPsec; VPN; Other}
research_infrastructure security_checks varchar 2147483647  √  null Verbal description of the procedures needed to get access to the research infrastructure. More detailed description will be provided in a separate document outside the database.
storage_area_network server_count int2 5  √  null count of servers that can be connected
simulation_capacity single_server bool 1  √  null Is it a single server or integrated in a cluster
network_impairment_simulator size_simult int2 5  √  null Amount of simultaneous emulations
amplifier slew_rate float8 17,17  √  null Maximum rate at which the amplifier can respond to an abrupt change of input level
server_pc software text 2147483647  √  null installed software
source source_type varchar 10  √  null Type of the source
ev_charging_station standards varchar 2147483647  √  null IEC standards according to which the charging station operates
electrical_switch status_monitor bool 1  √  null Can the status of the switch be remotely monitored?
load step_nmbr_p float4 8,8  √  null Number of steps for real power load
load step_nmbr_q float4 8,8  √  null Number of steps for reactive power load
transformer step_size float4 8,8  √  null Tap changer step size (pu)
load step_size_p float4 8,8  √  null Step size for real power load (W)
thermal_load step_size_p_th float4 8,8  √  null Step size for thermal power (if stepped) (W)
thermal_source step_size_p_th float4 8,8  √  null Step size for thermal power (if stepped) (W)
thermal_storage step_size_p_th float4 8,8  √  null Step size for thermal power (if stepped) (W)
load step_size_q float4 8,8  √  null Step size for reactive power load (VAr)
transformer tap_changer bool 1  √  null Is there a tap changer in the transformer?
transformer tap_nmbr_down int2 5  √  null Number of tap steps downwards (decreasing secondary side voltage)
transformer tap_nmbr_up int2 5  √  null Number of tap steps upwards (increasing secondary side voltage)
access_controls threatDefence text 2147483647  √  null Description of threats for which this security control has been deployed.
antivirus threatDefence text 2147483647  √  null Description of threats for which this security control has been deployed.
firewall threatDefence text 2147483647  √  null Description of threats for which this security control has been deployed.
intrusion_detection_system threatDefence text 2147483647  √  null Description of threats for which this security control has been deployed.
network_segmentation threatDefence text 2147483647  √  null Description of threats for which this security control has been deployed.
secure_communication threatDefence text 2147483647  √  null Description of threats for which this security control has been deployed.
network_impairment_simulator time_accuracy float4 8,8  √  null temporal accuracy (s)
communication_interchange type varchar 2147483647  √  null The type of the component. Has to be some of the following: {Hub; Switch; Router; Gateway; Media converter; Other}
controller_hosting_capacity type varchar 2147483647 Type of the hosting capacity, e.g. ?Java code??, ?Labview?? etc.
firewall type varchar 2147483647  √  null The type of the firewall which is used in the facility. Acceptable values: {Packet filtering firewall; Stateful Inspection Firewall; Application-Proxy gateway firewall}
heat_exchanger type varchar 2147483647  √  null Type of the Heat exchanger. Acceptable values: {Tube/shell; Tube in tube; Plate; heat pipes; Other}
intrusion_detection_system type varchar 2147483647  √  null The type of the intrusion detection system which is used in the facility. Acceptable values: {Host-based IDS; Network-based IDS}
lab_scada type varchar 2147483647  √  null The type of the SCADA system. Has to be some of the following {DCS; SCADA}
measurement_device type varchar 2147483647  √  null Type of the measurement device. Acceptable values: {Remote terminal unit; Smart meter; PMU; Other measurement device}
service type varchar 2147483647  √  null Type of the Service, e.g. ?Weather Forecast?, ?Generation Forecast? , ?Load Forecast?, ?Market price?, ?State Estimation?, etc. Detailed verbal description for the service (including data, time window etc.) should be given in the description data attribute.
thermal_circuit_equipment type varchar 2147483647  √  null Type of the Heat Equipment. Acceptable values: {Pump; Valve; Other}
thermal_load type varchar 2147483647  √  null Type of Thermal load. Acceptable values: {Domestic heating; Industrial load; Heat sink;  Other)
thermal_pipeline type varchar 2147483647  √  null Type of the Thermal Pipeline. Acceptable values: {Not insulated; Insulated; Thermal heated }
thermal_source type varchar 2147483647  √  null Type of the heating/cooling unit. Acceptable values: {Boiler, CHP, Heat pump, Solar system, others}
thermal_storage type varchar 2147483647  √  null Type of the storage unit. Acceptable values: {Tank; Phase change storage; Chemical storage; Other}
terminal type_d direction_type 2147483647  √  null
terminal type_e varchar 2147483647  √  null
access_controls type_of_access_control varchar 2147483647  √  null The type of access control which are being used in the system or on the specific component. Acceptable values: {Access Control List; Role-based access control (RBAC); Rule-based access control (RAC); Physical access; Other}
network_segmentation types_of_network_segmentation varchar 2147483647  √  null The type of network segmentation which is used to isolate the testbed networks of different sensitivity. Acceptable values: {Physical isolation; Logical isolation (VLAN); Unidirectional gateways; Firewall based separation between different network zones}.
measured_data unit varchar 2147483647  √  null Unit of the measured data
control_device upperlevel_control_device varchar 2147483647  √  null If there is a hierarchical control structure, the upper level control devices and protocols that are used to communicate with them are listed here. This is a text field and the format to input data should be as follows:{ControlDevice 1, protocol 1; ControlDevice 2, protocol 2; ?; ControlDevice n, protocol n}
lab_scada upperlevel_control_device varchar 2147483647  √  null If there is a hierarchical control structure, the upper level control devices and protocols that are used to communicate with them are listed here. This is a text field and the format to input data should be as follows:{ControlDevice 1, protocol 1; ControlDevice 2, protocol 2; ?; ControlDevice n, protocol n}
measurement_device upstream_protocol varchar 2147483647  √  null Interface protocol of the unit
electric_vehicle v2g bool 1  √  false V2G capable or not
ev_charging_station v2g bool 1  √  false V2G capable or not
measured_data variable varchar 20 Measured variable
access_controls version varchar 10  √  null Version of the software of hardware security control.
antivirus version varchar 10  √  null Version of the software of hardware security control.
firewall version varchar 10  √  null Version of the software of hardware security control.
intrusion_detection_system version varchar 10  √  null Version of the software of hardware security control.
network_segmentation version varchar 10  √  null Version of the software of hardware security control.
secure_communication version varchar 10  √  null Version of the software of hardware security control.
research_infrastructure voltage_level voltage_type 2147483647  √  null The RI voltage level
transformer x_k float4 8,8  √  null Leakage reactance (percentage)