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 |
---|---|---|---|---|---|---|---|
access_controls | comp_id | int4 | 10 | ||||
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. | |
access_controls | reference_component | int4 | 10 | √ | null | A components which implement access controls can be referenced, e.g. a firewall component. | |
access_controls | threatDefence | text | 2147483647 | √ | null | Description of threats for which this security control has been deployed. | |
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} | |
access_controls | version | varchar | 10 | √ | null | Version of the software of hardware security control. | |
amplifier | amplifier_mode | varchar | 25 | √ | null | Amplifier mode | |
amplifier | comp_id | int4 | 10 | ||||
amplifier | galvanic_isolation | bool | 1 | √ | false | Galvanic isolation | |
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 | |
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 | |
amplifier | output_boundary | varchar | 2147483647 | √ | null | Limits on outputs | |
amplifier | phases | int2 | 5 | √ | null | Phase number (1 or 3) | |
amplifier | physical_or_emulated | component_type | 2147483647 | √ | 'physical'::component_type | ||
amplifier | rated_f | float4 | 8,8 | √ | null | Nominal frequency (Hz) | |
amplifier | rated_p | float4 | 8,8 | √ | null | Nominal real power (W) | |
amplifier | rated_q | float4 | 8,8 | √ | null | Nominal reactive power (VAr) | |
amplifier | rated_s | float4 | 8,8 | √ | null | Nominal apparent power (VA) | |
amplifier | rated_u | float4 | 8,8 | √ | null | Nominal voltage (V) | |
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. | |
amplifier | slew_rate | float8 | 17,17 | √ | null | Maximum rate at which the amplifier can respond to an abrupt change of input level | |
amplifier_mode | name | varchar | 25 | ||||
antivirus | comp_id | int4 | 10 | ||||
antivirus | product_name | varchar | 2147483647 | √ | null | Name of the anti-virus product which is installed in the testbed | |
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. | |
antivirus | threatDefence | text | 2147483647 | √ | null | Description of threats for which this security control has been deployed. | |
antivirus | version | varchar | 10 | √ | null | Version of the software of hardware security control. | |
communication_interchange | comp_id | int4 | 10 | ||||
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. | |
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. | |
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} | |
communication_line_segment | bandwidth | float4 | 8,8 | √ | null | Bandwidth of the communication line as defined by the application. (bit/s) | |
communication_line_segment | comp_id | int4 | 10 | ||||
communication_line_segment | length | float4 | 8,8 | √ | null | Length of the line segment (m) | |
communication_line_segment | medium | varchar | 2147483647 | √ | null | The medium of the communication line. | |
component | author | varchar | 2147483647 | √ | null | ||
component | comp_id | serial | 10 | √ | nextval('component_comp_id_seq'::regclass) | ||
component | comp_name | varchar | 2147483647 | √ | null | Name of the component | |
component | confidential | bool | 1 | √ | false | If information related to this component is confidential, set as true | |
component | description | text | 2147483647 | √ | null | Verbal description | |
component | modified | timestamptz | 35,6 | √ | null | ||
component | ri_id | int4 | 10 | √ | null | The research infrasturcture this component belongs to | |
connectivity_node | name | varchar | 20 | √ | null | ||
connectivity_node | node_id | serial | 10 | √ | nextval('connectivity_node_node_id_seq'::regclass) | ||
control_device | comp_id | int4 | 10 | ||||
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} | |
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} | |
control_device | modeltype | varchar | 2147483647 | √ | null | Modeltype of the controller. In case of manual control this should be set to ?Manual?. | |
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. | |
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} | |
control_mode | control_device | int4 | 10 | √ | null | ||
control_mode | control_level | ctrl_level_type | 2147483647 | √ | null | ||
control_mode | description | text | 2147483647 | √ | null | ||
control_mode | mode | varchar | 25 | ||||
controller_hosting_capacity | control_device | int4 | 10 | √ | 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} | |
controller_hosting_capacity | description | text | 2147483647 | √ | null | Verbal description | |
controller_hosting_capacity | type | varchar | 2147483647 | Type of the hosting capacity, e.g. ?Java code??, ?Labview?? etc. | |||
domain | description | text | 2147483647 | √ | null | ||
domain | domain_id | serial | 10 | √ | nextval('domain_domain_id_seq'::regclass) | ||
domain | name | varchar | 20 | √ | null | ||
domain | parent_id | int4 | 10 | √ | null | ||
domain_topology | confidential | bool | 1 | √ | false | If the topology picture is confidential, set as true | |
domain_topology | description | text | 2147483647 | √ | null | Verbal description | |
domain_topology | domain_id | int4 | 10 | ||||
domain_topology | picture | bytea | 2147483647 | √ | null | Picture of the topology | |
domain_topology | ri_id | int4 | 10 | ||||
electric_vehicle | comp_id | int4 | 10 | ||||
electric_vehicle | ev_type | varchar | 10 | √ | null | Type of the electric vehicle. | |
electric_vehicle | 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) | |
electric_vehicle | phases | int2 | 5 | √ | null | Phase number (1 or 3) | |
electric_vehicle | physical_or_emulated | component_type | 2147483647 | √ | 'physical'::component_type | ||
electric_vehicle | rated_capacity | float4 | 8,8 | √ | null | Nominal energy capacity of the car batteries (Wh) | |
electric_vehicle | rated_f | float4 | 8,8 | √ | null | Nominal frequency (Hz) | |
electric_vehicle | rated_p | float4 | 8,8 | √ | null | Nominal real power (W) | |
electric_vehicle | rated_q | float4 | 8,8 | √ | null | Nominal reactive power (VAr) | |
electric_vehicle | rated_s | float4 | 8,8 | √ | null | Nominal apparent power (VA) | |
electric_vehicle | rated_u | float4 | 8,8 | √ | null | Nominal voltage (V) | |
electric_vehicle | v2g | bool | 1 | √ | false | V2G capable or not | |
electric_vehicle_type | name | varchar | 10 | ||||
electrical_line_segment | comp_id | int4 | 10 | ||||
electrical_line_segment | length | float4 | 8,8 | √ | null | Length of the line segment (m) | |
electrical_line_segment | phases | int2 | 5 | √ | null | Phase number (1 or 3) | |
electrical_line_segment | rated_current | float4 | 8,8 | √ | null | Rated current of the line segment (A) | |
electrical_line_segment | reactance | float4 | 8,8 | √ | null | Line reactance (?) | |
electrical_line_segment | resistance | float4 | 8,8 | √ | null | Line resistance (?) | |
electrical_switch | comp_id | int4 | 10 | ||||
electrical_switch | phases | int2 | 5 | √ | null | Phase number (1 or 3) | |
electrical_switch | rated_current | float4 | 8,8 | √ | null | Rated current of the switch (A) | |
electrical_switch | status_monitor | bool | 1 | √ | null | Can the status of the switch be remotely monitored? | |
ev_charging_station | comp_id | int4 | 10 | ||||
ev_charging_station | peak_p | float4 | 8,8 | √ | null | Peak power (W) | |
ev_charging_station | phases | int2 | 5 | √ | null | Phase number (1 or 3) | |
ev_charging_station | physical_or_emulated | component_type | 2147483647 | √ | 'physical'::component_type | ||
ev_charging_station | rated_f | float4 | 8,8 | √ | null | Nominal frequency (Hz) | |
ev_charging_station | rated_p | float4 | 8,8 | √ | null | Nominal real power (W) | |
ev_charging_station | rated_q | float4 | 8,8 | √ | null | Nominal reactive power (VAr) | |
ev_charging_station | rated_s | float4 | 8,8 | √ | null | Nominal apparent power (VA) | |
ev_charging_station | rated_u | float4 | 8,8 | √ | null | Nominal voltage (V) | |
ev_charging_station | standards | varchar | 2147483647 | √ | null | IEC standards according to which the charging station operates | |
ev_charging_station | v2g | bool | 1 | √ | false | V2G capable or not | |
firewall | comp_id | int4 | 10 | ||||
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. | |
firewall | product_name | varchar | 2147483647 | √ | null | Name of the firewall which is installed in the testbed. | |
firewall | threatDefence | text | 2147483647 | √ | null | Description of threats for which this security control has been deployed. | |
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} | |
firewall | version | varchar | 10 | √ | null | Version of the software of hardware security control. | |
generating_unit | comp_id | int4 | 10 | ||||
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? | |
generating_unit | phases | int2 | 5 | √ | null | Phase number (1 or 3) | |
generating_unit | physical_or_emulated | component_type | 2147483647 | √ | 'physical'::component_type | ||
generating_unit | rated_efficiency | float4 | 8,8 | √ | null | Efficiency of the generating unit (p.u., needed especially for the fossil fueled generators) | |
generating_unit | rated_f | float4 | 8,8 | √ | null | Nominal frequency (Hz) | |
generating_unit | rated_p | float4 | 8,8 | √ | null | Nominal real power (W) | |
generating_unit | rated_q | float4 | 8,8 | √ | null | Nominal reactive power (VAr) | |
generating_unit | rated_s | float4 | 8,8 | √ | null | Nominal apparent power (VA) | |
generating_unit | rated_u | float4 | 8,8 | √ | null | Nominal voltage (V) | |
generator_type | name | varchar | 30 | ||||
grid_connection | name | varchar | 25 | ||||
heat_exchanger | comp_id | int4 | 10 | ||||
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 | |
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) | |
heat_exchanger | rated_efficiency | varchar | 2147483647 | √ | null | Heat exchanger efficiency at nominal thermal power (pu) | |
heat_exchanger | rated_p_th | float4 | 8,8 | √ | null | Nominal Thermal Power (W) | |
heat_exchanger | type | varchar | 2147483647 | √ | null | Type of the Heat exchanger. Acceptable values: {Tube/shell; Tube in tube; Plate; heat pipes; Other} | |
interface_algorithm | code | varchar | 5 | ||||
interface_algorithm | description | varchar | 2147483647 | √ | null | ||
intrusion_detection_system | comp_id | int4 | 10 | ||||
intrusion_detection_system | product_name | varchar | 2147483647 | √ | null | Name of the intrusion detection system which is installed in the testbed. | |
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. | |
intrusion_detection_system | threatDefence | text | 2147483647 | √ | null | Description of threats for which this security control has been deployed. | |
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} | |
intrusion_detection_system | version | varchar | 10 | √ | null | Version of the software of hardware security control. | |
inverter | comp_id | int4 | 10 | ||||
inverter | 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? | |
inverter | physical_or_emulated | component_type | 2147483647 | √ | 'physical'::component_type | ||
inverter | rated_f | float4 | 8,8 | √ | null | Nominal frequency (Hz) | |
inverter | rated_p | float4 | 8,8 | √ | null | Nominal real power (W) | |
inverter | rated_q | float4 | 8,8 | √ | null | Nominal reactive power (VAr) | |
inverter | rated_s | float4 | 8,8 | √ | null | Nominal apparent power (VA) | |
inverter | rated_u | float4 | 8,8 | √ | null | Nominal voltage (V) | |
lab_scada | capacity | int2 | 5 | √ | null | Maximum Number of nodes | |
lab_scada | comp_id | int4 | 10 | ||||
lab_scada | data_logging_facilities | text | 2147483647 | √ | null | Text field to explain the data logging facilities of the SCADA. | |
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. | |
lab_scada | hmi | text | 2147483647 | √ | null | Description field. | |
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} | |
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} | |
lab_scada | modeltype | varchar | 2147483647 | √ | null | Modeltype of the controller. In case of manual control this should be set to ?Manual?. | |
lab_scada | platform | varchar | 2147483647 | √ | null | Platform/language on which the SCADA was built (e.g. Lynx, PCVue, etc). | |
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. | |
lab_scada | type | varchar | 2147483647 | √ | null | The type of the SCADA system. Has to be some of the following {DCS; SCADA} | |
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} | |
load | comp_id | int4 | 10 | ||||
load | continuous_or_stepped | bool | 1 | √ | false | Can the load be controlled continuously or stepwise? | |
load | load_type | varchar | 20 | √ | null | Type of load | |
load | phases | int2 | 5 | √ | null | Phase number (1 or 3) | |
load | physical_or_emulated | component_type | 2147483647 | √ | 'physical'::component_type | ||
load | rated_f | float4 | 8,8 | √ | null | Nominal frequency (Hz) | |
load | rated_p | float4 | 8,8 | √ | null | Nominal real power (W) | |
load | rated_q | float4 | 8,8 | √ | null | Nominal reactive power (VAr) | |
load | rated_s | float4 | 8,8 | √ | null | Nominal apparent power (VA) | |
load | rated_u | float4 | 8,8 | √ | null | Nominal voltage (V) | |
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 | |
load | step_size_p | float4 | 8,8 | √ | null | Step size for real power load (W) | |
load | step_size_q | float4 | 8,8 | √ | null | Step size for reactive power load (VAr) | |
load_type | name | varchar | 20 | ||||
measured_data | data_quality | varchar | 2147483647 | √ | null | Data quality | |
measured_data | description | text | 2147483647 | √ | null | Verbal description | |
measured_data | measurement_device | int4 | 10 | √ | null | ||
measured_data | unit | varchar | 2147483647 | √ | null | Unit of the measured data | |
measured_data | variable | varchar | 20 | Measured variable | |||
measurement_device | comp_id | int4 | 10 | ||||
measurement_device | data_handling | varchar | 2147483647 | √ | null | Type of data. Acceptable values: {Instantaneous value; RMS} | |
measurement_device | data_sampling | float4 | 8,8 | √ | null | Sampling interval of data (s) | |
measurement_device | type | varchar | 2147483647 | √ | null | Type of the measurement device. Acceptable values: {Remote terminal unit; Smart meter; PMU; Other measurement device} | |
measurement_device | upstream_protocol | varchar | 2147483647 | √ | null | Interface protocol of the unit | |
model_file | confidential | bool | 1 | √ | false | If the topology picture is confidential, set as true | |
model_file | description | text | 2147483647 | √ | null | Verbal description | |
model_file | file | bytea | 2147483647 | √ | null | ||
model_file | ri_id | int4 | 10 | ||||
network_impairment_simulator | access_rights | text | 2147483647 | √ | null | usergroups, roles and rights management | |
network_impairment_simulator | comp_id | int4 | 10 | ||||
network_impairment_simulator | ports | int2 | 5 | √ | null | number of ethernet ports | |
network_impairment_simulator | profiles | text | 2147483647 | √ | null | description of available profiles | |
network_impairment_simulator | size_simult | int2 | 5 | √ | null | Amount of simultaneous emulations | |
network_impairment_simulator | time_accuracy | float4 | 8,8 | √ | null | temporal accuracy (s) | |
network_segmentation | comp_id | int4 | 10 | ||||
network_segmentation | threatDefence | text | 2147483647 | √ | null | Description of threats for which this security control has been deployed. | |
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}. | |
network_segmentation | version | varchar | 10 | √ | null | Version of the software of hardware security control. | |
organization | org_id | serial | 10 | √ | nextval('organization_org_id_seq'::regclass) | ||
organization | orgname | varchar | 2147483647 | √ | null | ||
protection_device | comp_id | int4 | 10 | ||||
protection_device | int_protocol | varchar | 2147483647 | √ | null | Interface protocol of the unit. | |
protection_device | modeltype | varchar | 2147483647 | √ | null | Modeltype of the protection device. | |
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. | |
protection_mode | description | text | 2147483647 | √ | null | Verbal description | |
protection_mode | mode | varchar | 20 | Protection mode | |||
protection_mode | protection_device | int4 | 10 | √ | null | ||
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 | |
real_time_simulator | comp_id | int4 | 10 | ||||
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 | |
real_time_simulator | max_node_nmbr | int2 | 5 | √ | null | Maximum number of network nodes that can be modelled | |
research_infrastructure | author | varchar | 2147483647 | √ | null | ||
research_infrastructure | confidential | bool | 1 | √ | null | If all RI information is confidential, set as true | |
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 | |
research_infrastructure | external_connectivity | varchar | 2147483647 | √ | null | Real time connectivity of the RI with other Ris | |
research_infrastructure | modified | timestamptz | 35,6 | √ | null | ||
research_infrastructure | name | varchar | 2147483647 | √ | null | Name of the RI | |
research_infrastructure | org_id | int4 | 10 | √ | null | Owner of the RI | |
research_infrastructure | ri_id | serial | 10 | √ | nextval('research_infrastructure_ri_id_seq'::regclass) | ||
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. | |
research_infrastructure | voltage_level | voltage_type | 2147483647 | √ | null | The RI voltage level | |
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. | |
secure_communication | 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). | |
secure_communication | encryption_scheme | text | 2147483647 | √ | null | Description of encryption scheme used for exchange of data | |
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. | |
secure_communication | secure_protocol | varchar | 2147483647 | √ | null | Type of the secure protocol used for data exchange. Acceptable values: {SSL; IPsec; VPN; Other} | |
secure_communication | threatDefence | text | 2147483647 | √ | null | Description of threats for which this security control has been deployed. | |
secure_communication | version | varchar | 10 | √ | null | Version of the software of hardware security control. | |
server_pc | access_rights | text | 2147483647 | √ | null | usergroups, roles and rights management | |
server_pc | comp_id | int4 | 10 | ||||
server_pc | cpu | float4 | 8,8 | √ | null | cpu capacity (Hz) | |
server_pc | hdd | float4 | 8,8 | √ | null | hard drive space (Byte) | |
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) | |
server_pc | os | varchar | 2147483647 | √ | null | operating system | |
server_pc | ram | float4 | 8,8 | √ | null | size of ram (Byte) | |
server_pc | software | text | 2147483647 | √ | null | installed software | |
service | comp_id | int4 | 10 | ||||
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. | |
simulation_capacity | comp_id | int4 | 10 | ||||
simulation_capacity | cpu | float4 | 8,8 | √ | null | Size of CPU (Hz) | |
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) | |
simulation_capacity | ram | float4 | 8,8 | √ | null | Size of RAM (Byte) | |
simulation_capacity | single_server | bool | 1 | √ | null | Is it a single server or integrated in a cluster | |
source | acdc | acdc_type | 2147483647 | √ | null | Is the source AC or DC | |
source | comp_id | int4 | 10 | ||||
source | max_f | float4 | 8,8 | √ | null | Maximum frequency (Hz) | |
source | max_u | float4 | 8,8 | √ | null | Maximum voltage (V) | |
source | min_f | float4 | 8,8 | √ | null | Minimum frequency (Hz) | |
source | min_u | float4 | 8,8 | √ | null | Minimum voltage (V) | |
source | phases | int2 | 5 | √ | null | Phase number (1 or 3) | |
source | phil_capable | bool | 1 | √ | false | Can the source operate as a part of a closed-loop simulation | |
source | physical_or_emulated | component_type | 2147483647 | √ | 'physical'::component_type | ||
source | rated_f | float4 | 8,8 | √ | null | Nominal frequency (Hz) | |
source | rated_p | float4 | 8,8 | √ | null | Nominal real power (W) | |
source | rated_q | float4 | 8,8 | √ | null | Nominal reactive power (VAr) | |
source | rated_s | float4 | 8,8 | √ | null | Nominal apparent power (VA) | |
source | rated_u | float4 | 8,8 | √ | null | Nominal voltage (V) | |
source | source_type | varchar | 10 | √ | null | Type of the source | |
source_type | name | varchar | 10 | ||||
storage_area_network | comp_id | int4 | 10 | ||||
storage_area_network | connection_tech | varchar | 2147483647 | √ | null | connection technology for servers (e.g. Fibre Channel) | |
storage_area_network | hdd | float4 | 8,8 | √ | null | size of hdd (Byte) | |
storage_area_network | redundancy | text | 2147483647 | √ | null | information about redundancy of the SAN | |
storage_area_network | server_count | int2 | 5 | √ | null | count of servers that can be connected | |
terminal | comp_id | int4 | 10 | ||||
terminal | description | text | 2147483647 | √ | null | ||
terminal | domain_id | int4 | 10 | ||||
terminal | name | varchar | 2147483647 | √ | null | ||
terminal | node_id | int4 | 10 | ||||
terminal | type_d | direction_type | 2147483647 | √ | null | ||
terminal | type_e | varchar | 2147483647 | √ | null | ||
thermal_circuit_equipment | comp_id | int4 | 10 | ||||
thermal_circuit_equipment | continuous_or_stepped | bool | 1 | √ | null | Can variable be controlled continuously or stepwise? | |
thermal_circuit_equipment | der_component | int4 | 10 | √ | null | Foreign key referring to DERComponent table (in particular for pumps as electrical loads) | |
thermal_circuit_equipment | rated_flow | float4 | 8,8 | √ | null | Nominal Flow rate (m3/s) | |
thermal_circuit_equipment | type | varchar | 2147483647 | √ | null | Type of the Heat Equipment. Acceptable values: {Pump; Valve; Other} | |
thermal_load | comp_id | int4 | 10 | ||||
thermal_load | continuous_or_stepped | bool | 1 | √ | null | Can the ThermalComponent be controlled continuously or stepwise? | |
thermal_load | der_component | int4 | 10 | √ | null | Foreign key referring to DERComponent table (in particular for CHP and heat pumps) | |
thermal_load | heat_fluid | varchar | 2147483647 | √ | null | Type of heated fluid. Acceptable values: {Water; Steam; Air; Oil; Other} | |
thermal_load | min_p_th | float4 | 8,8 | √ | null | Minimum Thermal Power (W) | |
thermal_load | physical_or_emulated | bool | 1 | √ | null | Is the component a physical component or emulated/simulated? | |
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_load | rated_p_th | float4 | 8,8 | √ | null | Nominal Thermal Power (W) | |
thermal_load | rated_temp | float4 | 8,8 | √ | null | Heated fluid nominal temperature (°C) | |
thermal_load | step_size_p_th | float4 | 8,8 | √ | null | Step size for thermal power (if stepped) (W) | |
thermal_load | type | varchar | 2147483647 | √ | null | Type of Thermal load. Acceptable values: {Domestic heating; Industrial load; Heat sink; Other) | |
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_pipeline | comp_id | int4 | 10 | ||||
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) | |
thermal_pipeline | heat_fluid | varchar | 2147483647 | √ | null | Type of heat fluid. Acceptable values: {Water; Steam; Air; Oil; Other} | |
thermal_pipeline | length | float4 | 8,8 | √ | null | Overall length of the Thermal pipeline (m) | |
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) | |
thermal_pipeline | type | varchar | 2147483647 | √ | null | Type of the Thermal Pipeline. Acceptable values: {Not insulated; Insulated; Thermal heated } | |
thermal_source | comp_id | int4 | 10 | ||||
thermal_source | continuous_or_stepped | bool | 1 | √ | null | Can the ThermalComponent be controlled continuously or stepwise? | |
thermal_source | der_component | int4 | 10 | √ | null | Foreign key referring to DERComponent table (in particular for CHP and heat pumps) | |
thermal_source | heat_fluid | varchar | 2147483647 | √ | null | Type of heated fluid. Acceptable values: {Water; Steam; Air; Oil; Other} | |
thermal_source | min_p_th | float4 | 8,8 | √ | null | Minimum Thermal Power (W) | |
thermal_source | physical_or_emulated | bool | 1 | √ | null | Is the component a physical component or emulated/simulated? | |
thermal_source | primary_energy | varchar | 2147483647 | √ | null | Type of primary energy/fuel. Acceptable values: {Electricity; Natural gas; Oil; Solar; Other) | |
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_source | rated_p_th | float4 | 8,8 | √ | null | Nominal Thermal Power (W) | |
thermal_source | rated_temp | float4 | 8,8 | √ | null | Heated fluid nominal temperature (°C) | |
thermal_source | step_size_p_th | float4 | 8,8 | √ | null | Step size for thermal power (if stepped) (W) | |
thermal_source | type | varchar | 2147483647 | √ | null | Type of the heating/cooling unit. Acceptable values: {Boiler, CHP, Heat pump, Solar system, others} | |
thermal_storage | av_diss | float4 | 8,8 | √ | null | Average storage heat losses: watts per temperature difference (Tfluid-Tamb) (W/(°C)) | |
thermal_storage | comp_id | int4 | 10 | ||||
thermal_storage | continuous_or_stepped | bool | 1 | √ | null | Can the ThermalComponent be controlled continuously or stepwise? | |
thermal_storage | der_component | int4 | 10 | √ | null | Foreign key referring to DERComponent table (in particular for CHP and heat pumps) | |
thermal_storage | heat_fluid | varchar | 2147483647 | √ | null | Type of heated fluid. Acceptable values: {Water; Steam; Air; Oil; Other} | |
thermal_storage | min_p_th | float4 | 8,8 | √ | null | Minimum Thermal Power (W) | |
thermal_storage | peak_p_charge | float4 | 8,8 | √ | null | Peak power for charging (W) | |
thermal_storage | peak_p_discharge | float4 | 8,8 | √ | null | Peak power for discharging (W) | |
thermal_storage | physical_or_emulated | bool | 1 | √ | null | Is the component a physical component or emulated/simulated? | |
thermal_storage | rated_capacity | float4 | 8,8 | √ | null | Nominal energy capacity (Wh) | |
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) | |
thermal_storage | rated_p_th | float4 | 8,8 | √ | null | Nominal Thermal Power (W) | |
thermal_storage | rated_temp | float4 | 8,8 | √ | null | Heated fluid nominal temperature (°C) | |
thermal_storage | step_size_p_th | float4 | 8,8 | √ | null | Step size for thermal power (if stepped) (W) | |
thermal_storage | type | varchar | 2147483647 | √ | null | Type of the storage unit. Acceptable values: {Tank; Phase change storage; Chemical storage; Other} | |
transformer | comp_id | int4 | 10 | ||||
transformer | r_k | float4 | 8,8 | √ | null | Winding resistance (percentage) | |
transformer | rated_s | float4 | 8,8 | √ | null | Nominal apparent power (VA) | |
transformer | rated_u1 | float4 | 8,8 | √ | null | Primary side nominal voltage (V) | |
transformer | rated_u2 | float4 | 8,8 | √ | null | Secondary side nominal voltage (V) | |
transformer | step_size | float4 | 8,8 | √ | null | Tap changer step size (pu) | |
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) | |
transformer | x_k | float4 | 8,8 | √ | null | Leakage reactance (percentage) | |
virtual_server_environment | access_rights | text | 2147483647 | √ | null | usergroups, roles and rights management | |
virtual_server_environment | comp_id | int4 | 10 | ||||
virtual_server_environment | cpu | float4 | 8,8 | √ | null | cpu capacity of the cluster (Hz) | |
virtual_server_environment | hdd | float4 | 8,8 | √ | null | hdd space of the cluster (Byte) | |
virtual_server_environment | high_availability | text | 2147483647 | √ | null | Information about failover in case of faulty hosts | |
virtual_server_environment | ram | float4 | 8,8 | √ | null | ram capacity of the cluster (Byte) | |
virtual_server_environment | resource_pools | bool | 1 | √ | null | management of available resources in pools (for a couple of virtual machines)(true or false) |