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 |
---|---|---|---|---|---|---|---|
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 | |
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 | |
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_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 | ||
connectivity_node | name | varchar | 20 | √ | null | ||
domain | name | varchar | 20 | √ | null | ||
research_infrastructure | name | varchar | 2147483647 | √ | null | Name of the RI | |
terminal | name | varchar | 2147483647 | √ | null | ||
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 | |
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} | |
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 | |
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) | |
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 | ||||
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 | ||||
domain | domain_id | serial | 10 | √ | nextval('domain_domain_id_seq'::regclass) | ||
domain_topology | domain_id | int4 | 10 | ||||
terminal | domain_id | int4 | 10 | ||||
control_mode | mode | varchar | 25 | ||||
protection_mode | mode | varchar | 20 | Protection mode | |||
amplifier_mode | name | varchar | 25 | ||||
electric_vehicle_type | name | varchar | 10 | ||||
generator_type | name | varchar | 30 | ||||
grid_connection | name | varchar | 25 | ||||
load_type | name | varchar | 20 | ||||
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) | ||
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) | ||
controller_hosting_capacity | type | varchar | 2147483647 | Type of the hosting capacity, e.g. ?Java code??, ?Labview?? etc. | |||
measured_data | variable | varchar | 20 | Measured variable |