Table qwat.qwat_od.installation
This is the base table for all installation types.

 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
chamber.id chamber_id_fkey R
cover.fk_installation cover_fk_installation R
installation.fk_parent installation_fk_parent R
pressurecontrol.id pressurecontrol_id_fkey R
pump.id pump_id_fkey R
source.id source_id_fkey R
tank.id tank_id_fkey R
treatment.id treatment_id_fkey R
network_element.id installation_id_fkey R
name varchar 60  √  null
fk_parent int4 10  √  null
installation.id installation_fk_parent R
fk_remote int4 10  √  null
remote_type.id installation_fk_remote R
fk_watertype int4 10
watertype.id installation_fk_watertype R
parcel varchar 30  √  null
eca varchar 30  √  null
open_water_surface bool 1  √  false
geometry_polygon geometry 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc installation_pkey
fk_parent Performance Asc fki_installation_fk_parent
fk_remote Performance Asc fki_installation_fk_remote
fk_watertype Performance Asc fki_installation_watertype
geometry_polygon Performance Asc installation_poly_geoidx

Close relationships  within of separation: