Table qwat.qwat_od.network_element
Tables for network network_elements. Every network_element of the network (hydrants, network_element, installations, etc.) inherit from network_element which itself inherits from node.

 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
id int4 10
hydrant.id hydrant_id_fkey R
installation.id installation_id_fkey R
meter.id meter_id_fkey R
samplingpoint.id samplingpoint_id_fkey R
subscriber.id subscriber_id_fkey R
node.id network_element_id_fkey R
identification varchar 50  √  null
fk_distributor int4 10
distributor.id element_fk_distributor R
fk_status int4 10
status.id element_fk_status R
fk_folder int4 10  √  null
folder.id element_fk_folder R
fk_locationtype _int4 10  √  null
fk_precision int4 10
precision.id element_fk_precision R
fk_precisionalti int4 10  √  null
precisionalti.id element_fk_precisionalti R
fk_object_reference int4 10  √  null
object_reference.id element_fk_object_reference R
altitude numeric 10,3  √  NULL::numeric
year int2 5  √  null
year_end int2 5  √  null
orientation float8 17,17  √  null orientation field aims at overwrtiting qwat_od.node._pipe_orientation which is automatically calculated from the pipes. In the editable views, orientation will be COALESCE(netwrok_element.orientation, node._pipe_orientation). Update will be forwarded to network_element.
remark text 2147483647  √  null
schema_force_visible bool 1  √  null
visible.vl_code network_element_schema_force_visible R
label_1_visible int2 5  √  1
visible.vl_code_int network_element_label_1_visible R
label_1_x float8 17,17  √  null
label_1_y float8 17,17  √  null
label_1_rotation float8 17,17  √  null
label_1_text varchar 120  √  null
label_2_visible int2 5  √  1
visible.vl_code_int network_element_label_2_visible R
label_2_x float8 17,17  √  null
label_2_y float8 17,17  √  null
label_2_rotation float8 17,17  √  null
label_2_text varchar 120  √  null

Table contained 4 535 rows at mar. mars 21 17:52 CET 2017

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc network_element_pkey
fk_distributor Performance Asc fki_element_fk_distributor
fk_folder Performance Asc fki_element_fk_folder
fk_object_reference Performance Asc fki_element_fk_object_reference
fk_precision Performance Asc fki_element_fk_precision
fk_precisionalti Performance Asc fki_element_fk_precisionalti
fk_status Performance Asc fki_element_fk_status
label_1_visible Performance Asc fki_network_element_label_1_visible
label_2_visible Performance Asc fki_network_element_label_2_visible
schema_force_visible Performance Asc fki_network_element_schema_force_visible

Close relationships  within of separation: