Table erigrid.public.thermal_circuit_equipment 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_circuit_equipment_comp_id_fkey C
type varchar 2147483647  √  null Type of the Heat Equipment. Acceptable values: {Pump; Valve; Other}
der_component int4 10  √  null
component.comp_id thermal_circuit_equipment_der_component_fkey R
Foreign key referring to DERComponent table (in particular for pumps as electrical loads)
rated_flow float4 8,8  √  null Nominal Flow rate (m3/s)
continuous_or_stepped bool 1  √  null Can variable be controlled continuously or stepwise?

Analyzed at Thu Apr 27 16:49 EEST 2017

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

Close relationships  within of separation: