Table erigrid.public.thermal_source Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
comp_id int4 10
component.comp_id thermal_source_comp_id_fkey C
physical_or_emulated bool 1  √  null Is the component a physical component or emulated/simulated?
der_component int4 10  √  null
component.comp_id thermal_source_der_component_fkey R
Foreign key referring to DERComponent table (in particular for CHP and heat pumps)
rated_p_th float4 8,8  √  null Nominal Thermal Power (W)
min_p_th float4 8,8  √  null Minimum Thermal Power (W)
rated_temp float4 8,8  √  null Heated fluid nominal temperature (°C)
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)
heat_fluid varchar 2147483647  √  null Type of heated fluid. Acceptable values: {Water; Steam; Air; Oil; Other}
continuous_or_stepped bool 1  √  null Can the ThermalComponent be controlled continuously or stepwise?
step_size_p_th float4 8,8  √  null Step size for thermal power (if stepped) (W)
type varchar 2147483647  √  null Type of the heating/cooling unit. Acceptable values: {Boiler, CHP, Heat pump, Solar system, others}
primary_energy varchar 2147483647  √  null Type of primary energy/fuel. Acceptable values: {Electricity; Natural gas; Oil; Solar; Other)

Analyzed at Thu Apr 27 16:49 EEST 2017

Indexes:
Column(s) Type Sort Constraint Name
comp_id Primary key Asc thermal_source_pkey

Close relationships  within of separation: