Table erigrid.public.control_device 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
control_mode.control_device control_mode_control_device_fkey R
controller_hosting_capacity.control_device controller_hosting_capacity_control_device_fkey R
component.comp_id control_device_comp_id_fkey C
modeltype varchar 2147483647  √  null Modeltype of the controller. In case of manual control this should be set to ?Manual?.
primary_component int4 10  √  null
component.comp_id control_device_primary_component_fkey R
The controller can be linked to a primary component if desired. The primary component means the physical component which the controller is controlling. This attribute is used only at the lowest levels of the control hierarchy (D3-D5) and refers to one primary component only. It can be used, for example, to associate a generator voltage controller to the generating unit.
upperlevel_control_device varchar 2147483647  √  null If there is a hierarchical control structure, the upper level control devices and protocols that are used to communicate with them are listed here. This is a text field and the format to input data should be as follows:{ControlDevice 1, protocol 1; ControlDevice 2, protocol 2; ?; ControlDevice n, protocol n}
lowerlevel_control_device varchar 2147483647  √  null If there is a hierarchical control structure, the lower level control devices and protocols that are used to communicate with them are listed here. This is a text field and the format to input data should be as follows:{ControlDevice 1, protocol 1; ControlDevice 2, protocol 2; ?; ControlDevice n, protocol n}
horizontallevel_control_device varchar 2147483647  √  null If there is a hierarchical control structure, the control devices at the same control level and protocols that are used to communicate with them are listed here. This is a text field and the format to input data should be as follows:{ControlDevice 1, protocol 1; ControlDevice 2, protocol 2; ?; ControlDevice n, protocol n}

Analyzed at Thu Apr 27 16:49 EEST 2017

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

Close relationships  within of separation: