View qwat.qwat_od.vw_installation_pump 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  √  null
name varchar 60  √  null
fk_parent int4 10  √  null
fk_remote int4 10  √  null
fk_watertype int4 10  √  null
parcel varchar 30  √  null
eca varchar 30  √  null
open_water_surface bool 1  √  null
geometry_polygon geometry 2147483647  √  null
fk_pump_type int2 5  √  null
fk_pipe_in int4 10  √  null
fk_pipe_out int4 10  √  null
fk_pump_operating int2 5  √  null
no_pumps int2 5  √  null
rejected_flow numeric 10,2  √  null
manometric_height numeric 10,2  √  null

Analyzed at mar. mars 21 17:52 CET 2017