SchemaSpy Analysis of qwat.qwat_od Generated by
SchemaSpy
Generated by SchemaSpy on mar. mars 21 17:52 CET 2017
Database Type: PostgreSQL - 9.5.6 SourceForge.net

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Rows Comments
chamber 1 7 7
consumptionzone 1 4 42 consumption zones.
cover 4 23 0 Table for installation covers. Inherits from node.
crossing 2 9 341
distributor 5 2 14 Companies and distributors list.
district 4 2 18 4 Districts.
folder 4 7 152 Technical folders.
hydrant 6 13 232 hydrant. Inherits from node.
installation 8 4 9 43 This is the base table for all installation types.
leak 4 22 219 pipe leaks
meter 1 2 3 30 Table for meters. Inherits from node.
meter_reference 1 3 1 Table for meter references. These are used to place references to meters if they rely far away from their pipe (i.e. on another printed map). Hence, the reference is printed on the same map than the pipe.
network_element 5 10 25 4 535 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.
node 3 2 15 9 035 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).
part 1 3 3 301 Table for installation parts. Inherits from node.
pipe 10 18 42 4 223 Table for pipes.
pressurecontrol 2 2 11
pressurezone 3 4 24 50 Pressure zones.
printmap 3 20 3 This table is used for polygons for predefined printable maps. shortname would be used as label string, and long_mame would be used in the print composer.
protectionzone 1 7 9 protectionzones.
pump 5 8 2
remote 6 29 10 Table for installation remotes.
samplingpoint 1 1 23 Table for sampling points. Inherits from node.
source 3 8 11
subscriber 1 3 6 1 484 Table for subscriber. Inherits from node.
subscriber_reference 1 3 390 Table for subscriber references. These are used to place references to subscribers if they rely far away from their pipe (i.e. on another printed map). Hence, the reference is printed on the same map than the pipe.
surveypoint 1 4 9 0 Table for sampling points. Inherits from surveypoint.
tank 5 22 10
treatment 1 11 2
valve 17 51 2 312 Table for valve.
vw_consumptionzone 7 view
vw_element_hydrant 51 view
vw_element_installation 100 view
vw_element_meter 41 view
vw_element_part 41 view
vw_element_samplingpoint 39 view
vw_element_subscriber 44 view
vw_export_hydrant 168 view
vw_export_installation 281 view
vw_export_leak 188 view
vw_export_meter 107 view
vw_export_part 117 view
vw_export_pipe 164 view
vw_export_subscriber 120 view
vw_export_valve 149 view
vw_installation_chamber 15 view
vw_installation_pressurecontrol 10 view
vw_installation_pump 16 view
vw_installation_source 16 view
vw_installation_tank 30 view
vw_installation_treatment 19 view
vw_node_element 39 view
vw_pipe_child_parent 3 view
vw_pipe_schema 28 view Final view for schema
vw_pipe_schema_error 3 view Report IDs of parent pipe where pipe concatenation leads to a MultiLineString and not to a LineString or if an infinite referencing loop has been detected.
vw_pipe_schema_merged 8 view
vw_pipe_schema_visibleitems 10 view visible pipe in the schematic view (before merge)
vw_printmap 23 view
vw_protectionzone 9 view
vw_qwat_installation 62 view
vw_qwat_network_element 118 view
vw_qwat_node 40 view
vw_remote 22 view
vw_search_view 3 view
vw_subscriber_pipe_relation 3 view
vw_valve_lines 2 view Valves represented as lines. Each line is made from two points, the handle as starting point and the location on the pipe as ending point.
worker 1 6 0 Table for worker.
           
31 Tables     412 23 496  
36 Views     2 096