View qwat.qwat_od.vw_qwat_installation 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
installation_type installation_type 2147483647  √  null
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_source_type int2 5  √  null
fk_source_quality int2 5  √  null
flow_lowest numeric 10,3  √  null
flow_average numeric 10,3  √  null
flow_concession numeric 10,2  √  null
contract_end date 13  √  null
gathering_chamber bool 1  √  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
fk_overflow int4 10  √  null
fk_tank_firestorage int4 10  √  null
storage_total numeric 10,1  √  null
storage_supply numeric 10,1  √  null
storage_fire numeric 10,1  √  null
altitude_overflow numeric 7,3  √  null
altitude_apron numeric 7,3  √  null
height_max numeric 7,3  √  null
fire_valve bool 1  √  null
fire_remote bool 1  √  null
_litrepercm numeric 9,3  √  null
cistern1_fk_type int4 10  √  null
cistern1_dimension_1 numeric 10,2  √  null
cistern1_dimension_2 numeric 10,2  √  null
cistern1_storage numeric 10,2  √  null
_cistern1_litrepercm numeric 9,3  √  null
cistern2_fk_type int4 10  √  null
cistern2_dimension_1 numeric 10,2  √  null
cistern2_dimension_2 numeric 10,2  √  null
cistern2_storage numeric 10,2  √  null
_cistern2_litrepercm numeric 9,3  √  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
networkseparation bool 1  √  null
flow_meter bool 1  √  null
water_meter bool 1  √  null
manometer bool 1  √  null
depth numeric 10,3  √  null
no_valves int2 5  √  null
fk_pressurecontrol_type int4 10  √  null

Analyzed at mar. mars 21 17:52 CET 2017