View qwat.qwat_od.vw_installation_treatment 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
sanitization_uv bool 1  √  null
sanitization_chlorine_liquid bool 1  √  null
sanitization_chlorine_gazeous bool 1  √  null
sanitization_ozone bool 1  √  null
filtration_membrane bool 1  √  null
filtration_sandorgravel bool 1  √  null
flocculation bool 1  √  null
activatedcharcoal bool 1  √  null
settling bool 1  √  null
treatment_capacity numeric 10,2  √  null

Analyzed at mar. mars 21 17:52 CET 2017