Table erigrid.public.generating_unit 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 generating_unit_comp_id_fkey C
physical_or_emulated component_type 2147483647  √  'physical'::component_type
rated_u float4 8,8  √  null Nominal voltage (V)
rated_p float4 8,8  √  null Nominal real power (W)
rated_q float4 8,8  √  null Nominal reactive power (VAr)
rated_s float4 8,8  √  null Nominal apparent power (VA)
rated_f float4 8,8  √  null Nominal frequency (Hz)
phases int2 5  √  null Phase number (1 or 3)
gen_type varchar 30  √  null
generator_type.name generating_unit_gen_type_fkey R
Type of the generating unit
grid_conn varchar 25  √  null
grid_connection.name generating_unit_grid_conn_fkey R
Type of grid connection
rated_efficiency float4 8,8  √  null Efficiency of the generating unit (p.u., needed especially for the fossil fueled generators)
grid_forming_capable bool 1  √  false Is the generating unit grid-forming capable?

Analyzed at Thu Apr 27 16:49 EEST 2017

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

Close relationships  within of separation: