Table erigrid.public.measurement_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
measured_data.measurement_device measured_data_measurement_device_fkey R
component.comp_id measurement_device_comp_id_fkey C
type varchar 2147483647  √  null Type of the measurement device. Acceptable values: {Remote terminal unit; Smart meter; PMU; Other measurement device}
data_sampling float4 8,8  √  null Sampling interval of data (s)
data_handling varchar 2147483647  √  null Type of data. Acceptable values: {Instantaneous value; RMS}
upstream_protocol varchar 2147483647  √  null Interface protocol of the unit

Analyzed at Thu Apr 27 16:49 EEST 2017

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

Close relationships  within of separation: