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

erigrid.public contains 356 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
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)