Table erigrid.public.thermal_pipeline 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_pipeline_comp_id_fkey C
type varchar 2147483647  √  null Type of the Thermal Pipeline. Acceptable values: {Not insulated; Insulated; Thermal heated }
nom_d float4 8,8  √  null Nominal Thermal Pipeline Diameter (average value) (m)
length float4 8,8  √  null Overall length of the Thermal pipeline (m)
nom_t float4 8,8  √  null Nominal fluid temperature (°C)
heat_fluid varchar 2147483647  √  null Type of heat fluid. Acceptable values: {Water; Steam; Air; Oil; Other}
av_diss float4 8,8  √  null Average pipeline heat losses: watts per meter length and temperature difference (Tfluid-Tamb) (W/(m °C))
nom_fr float4 8,8  √  null Nominal Flow rate (m3/s)
nom_dp float4 8,8  √  null Overall pressure losses at Nominal Flow rate (bar)
dh_connection bool 1  √  null Stand alone Thermal circuit or part of a thermal network connected to District Heating (0/1)
dh_p_th_in float4 8,8  √  null If DHconnection=1, Max inlet thermal power (W)
dh_p_th_out float4 8,8  √  null If DHconnection=1, Max outlet thermal power (W)
dh_t_in float4 8,8  √  null If DHconnection=1, Nominal inlet temperature (°C)
dh_t_out float4 8,8  √  null If DHconnection=1, Nominal outlet temperature (°C)
dh_t_fr float4 8,8  √  null If DHconnection=1, Nominal inlet/outlet Flow rate (m3/s)

Analyzed at Thu Apr 27 16:49 EEST 2017

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

Close relationships  within of separation: