Table qwat.qwat_od.node
Tables for network nodes. Every element of the network (hydrants, valves, element, installations, etc.) inherit from element which itself inherits from node. Node should only contain geometric fields and automatic attributes (district, pressurezone, printmaps, etc).

 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 serial 10  √  nextval('qwat_od.node_id_seq'::regclass)
network_element.id network_element_id_fkey R
pipe.fk_node_a pipe_fk_node_a R
pipe.fk_node_b pipe_fk_node_b R
fk_district int4 10  √  null
district.id node_fk_district R
fk_pressurezone int4 10  √  null
pressurezone.id node_fk_pressurezone R
fk_printmap _int4 10  √  null
_printmaps text 2147483647  √  null
_geometry_alt1_used bool 1  √  null
_geometry_alt2_used bool 1  √  null
_pipe_node_type pipe_connection 2147483647  √  null
_pipe_orientation float8 17,17  √  0
_pipe_schema_visible bool 1  √  false
geometry geometry 2147483647
geometry_alt1 geometry 2147483647  √  null
geometry_alt2 geometry 2147483647  √  null
update_geometry_alt1 bool 1  √  null
update_geometry_alt2 bool 1  √  null

Table contained 9 035 rows at mar. mars 21 17:52 CET 2017

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc node_pkey
fk_district Performance Asc fki_node_fk_district
fk_pressurezone Performance Asc fki_node_fk_pressurezone
geometry Performance Asc node_geoidx
geometry_alt1 Performance Asc node_geoidx_alt1
geometry_alt2 Performance Asc node_geoidx_alt2

Close relationships  within of separation: