Table erigrid.public.load 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 load_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)
load_type varchar 20  √  null
load_type.name load_load_type_fkey R
Type of load
continuous_or_stepped bool 1  √  false Can the load be controlled continuously or stepwise?
step_nmbr_p float4 8,8  √  null Number of steps for real power load
step_size_p float4 8,8  √  null Step size for real power load (W)
step_size_q float4 8,8  √  null Step size for reactive power load (VAr)
step_nmbr_q float4 8,8  √  null Number of steps for reactive power load

Analyzed at Thu Apr 27 16:49 EEST 2017

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

Close relationships  within of separation: