SchemaSpy Analysis of erigrid.public - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Thu Apr 27 16:49 EEST 2017 |
| ||||||
|
erigrid.public contains 356 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
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 | |
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? | |
thermal_pipeline | dh_connection | bool | 1 | √ | null | Stand alone Thermal circuit or part of a thermal network connected to District Heating (0/1) | |
amplifier | galvanic_isolation | bool | 1 | √ | false | Galvanic isolation | |
generating_unit | grid_forming_capable | bool | 1 | √ | false | Is the generating unit grid-forming capable? | |
amplifier | identified_transfer_function | bool | 1 | √ | false | Is the transfer function identified? (Y/N). If yes, please provide the transfer function in description field. | |
server_pc | is_virtual | bool | 1 | √ | null | information if server is hardware or virtual (true or false) | |
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) | |
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 | |
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? | |
virtual_server_environment | resource_pools | bool | 1 | √ | null | management of available resources in pools (for a couple of virtual machines)(true or false) | |
simulation_capacity | single_server | bool | 1 | √ | null | Is it a single server or integrated in a cluster | |
electrical_switch | status_monitor | bool | 1 | √ | null | Can the status of the switch be remotely monitored? | |
transformer | tap_changer | bool | 1 | √ | null | Is there a tap changer in the transformer? | |
electric_vehicle | v2g | bool | 1 | √ | false | V2G capable or not | |
ev_charging_station | v2g | bool | 1 | √ | false | V2G capable or not | |
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 | |
lab_scada | capacity | int2 | 5 | √ | null | Maximum Number of nodes | |
interface_algorithm | code | varchar | 5 | ||||
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 | |
amplifier | interface_algorithm | varchar | 5 | √ | null | Interface algorithm used | |
amplifier | io_nmbr | int2 | 5 | √ | null | Number of channels | |
real_time_simulator | max_node_nmbr | int2 | 5 | √ | null | Maximum number of network nodes that can be modelled | |
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) | |
network_impairment_simulator | ports | int2 | 5 | √ | null | number of ethernet ports | |
storage_area_network | server_count | int2 | 5 | √ | null | count of servers that can be connected | |
network_impairment_simulator | size_simult | int2 | 5 | √ | null | Amount of simultaneous emulations | |
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) | |
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) | |
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_sampling | float4 | 8,8 | √ | null | Sampling interval of data (s) | |
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) | |
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) | |
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) | |
source | max_f | float4 | 8,8 | √ | null | Maximum frequency (Hz) | |
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) | |
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) | |
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) | |
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) | |
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) | |
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 (?) | |
electrical_line_segment | resistance | float4 | 8,8 | √ | null | Line resistance (?) | |
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) | |
network_impairment_simulator | time_accuracy | float4 | 8,8 | √ | null | temporal accuracy (s) | |
transformer | x_k | float4 | 8,8 | √ | null | Leakage reactance (percentage) | |
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 | ||||
component | comp_id | serial | 10 | √ | nextval('component_comp_id_seq'::regclass) | ||
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 | ||||
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). | |
control_mode | control_device | int4 | 10 | √ | null | ||
controller_hosting_capacity | control_device | int4 | 10 | √ | null | ||
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) | |
domain | domain_id | serial | 10 | √ | nextval('domain_domain_id_seq'::regclass) | ||
domain_topology | domain_id | int4 | 10 | ||||
terminal | domain_id | int4 | 10 | ||||
electric_vehicle | ev_type | varchar | 10 | √ | null | Type of the electric vehicle. | |
measured_data | measurement_device | int4 | 10 | √ | null | ||
electric_vehicle_type | name | varchar | 10 | ||||
source_type | name | varchar | 10 | ||||
connectivity_node | node_id | serial | 10 | √ | nextval('connectivity_node_node_id_seq'::regclass) | ||
terminal | node_id | int4 | 10 | ||||
organization | org_id | serial | 10 | √ | nextval('organization_org_id_seq'::regclass) | ||
research_infrastructure | org_id | int4 | 10 | √ | null | Owner of the RI | |
domain | parent_id | int4 | 10 | √ | null | ||
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. | |
protection_mode | protection_device | int4 | 10 | √ | null | ||
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. | |
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. | |
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 | ||||
research_infrastructure | ri_id | serial | 10 | √ | nextval('research_infrastructure_ri_id_seq'::regclass) | ||
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. | |
source | source_type | varchar | 10 | √ | null | Type of the source | |
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. | |
amplifier | slew_rate | float8 | 17,17 | √ | null | Maximum rate at which the amplifier can respond to an abrupt change of input level | |
load | load_type | varchar | 20 | √ | null | Type of load | |
protection_mode | mode | varchar | 20 | Protection mode | |||
connectivity_node | name | varchar | 20 | √ | null | ||
domain | name | varchar | 20 | √ | null | ||
load_type | name | varchar | 20 | ||||
measured_data | variable | varchar | 20 | Measured variable | |||
amplifier | amplifier_mode | varchar | 25 | √ | null | Amplifier mode | |
generating_unit | grid_conn | varchar | 25 | √ | null | Type of grid connection | |
control_mode | mode | varchar | 25 | ||||
amplifier_mode | name | varchar | 25 | ||||
grid_connection | name | varchar | 25 | ||||
generating_unit | gen_type | varchar | 30 | √ | null | Type of the generating unit | |
generator_type | name | varchar | 30 | ||||
component | modified | timestamptz | 35,6 | √ | null | ||
research_infrastructure | modified | timestamptz | 35,6 | √ | null | ||
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 | |
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 | ||
component | comp_name | varchar | 2147483647 | √ | null | Name of the component | |
storage_area_network | connection_tech | varchar | 2147483647 | √ | null | connection technology for servers (e.g. Fibre Channel) | |
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} | |
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 | |
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 | |
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 | |
research_infrastructure | external_connectivity | varchar | 2147483647 | √ | null | Real time connectivity of the RI with other Ris | |
model_file | file | bytea | 2147483647 | √ | null | ||
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 | 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_type | interface_type | 2147483647 | √ | null | current or voltage | |
server_pc | ip | varchar | 2147483647 | √ | null | ip parameters | |
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} | |
communication_line_segment | medium | varchar | 2147483647 | √ | null | The medium of the communication line. | |
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. | |
research_infrastructure | name | varchar | 2147483647 | √ | null | Name of the RI | |
terminal | name | varchar | 2147483647 | √ | null | ||
organization | orgname | varchar | 2147483647 | √ | null | ||
server_pc | os | varchar | 2147483647 | √ | null | operating system | |
amplifier | output_boundary | varchar | 2147483647 | √ | null | Limits on outputs | |
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 | ||
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). | |
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 | |
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. | |
heat_exchanger | rated_efficiency | varchar | 2147483647 | √ | null | Heat exchanger efficiency at nominal thermal power (pu) | |
storage_area_network | redundancy | text | 2147483647 | √ | null | information about redundancy of the SAN | |
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. | |
server_pc | software | text | 2147483647 | √ | null | installed software | |
ev_charging_station | standards | varchar | 2147483647 | √ | null | IEC standards according to which the charging station operates | |
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. | |
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 | |
research_infrastructure | voltage_level | voltage_type | 2147483647 | √ | null | The RI voltage level |