Table erigrid.public.lab_scada 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 lab_scada_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 lab_scada_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}
type varchar 2147483647  √  null The type of the SCADA system. Has to be some of the following {DCS; SCADA}
capacity int2 5  √  null Maximum Number of nodes
employed_standard varchar 2147483647  √  null Interface protocol to applications of same level (e.g. OPC). The characteristics of the protocol can also be described.
data_logging_facilities text 2147483647  √  null Text field to explain the data logging facilities of the SCADA.
hmi text 2147483647  √  null Description field.
platform varchar 2147483647  √  null Platform/language on which the SCADA was built (e.g. Lynx, PCVue, etc).

Analyzed at Thu Apr 27 16:49 EEST 2017

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

Close relationships  within of separation: