Table qwat.qwat_od.hydrant
hydrant. Inherits from node.

 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
network_element.id hydrant_id_fkey R
fk_provider int4 10  √  null
hydrant_provider.id hydrant_fk_provider R
fk_model_sup int4 10
hydrant_model_sup.id hydrant_fk_model_sup R
fk_model_inf int4 10
hydrant_model_inf.id hydrant_fk_model_inf R
fk_material int4 10
hydrant_material.id hydrant_fk_material R
fk_output int4 10
hydrant_output.id hydrant_fk_output R
underground bool 1  √  false
marked bool 1  √  false does it have markings pointing to it
pressure_static numeric 5,2  √  null pression statique [bar]
pressure_dynamic numeric 5,2  √  null pression dynamique [bar]
flow numeric 8,2  √  null debit dynamique pour une pression dynamique de 2 bars [l/min]
observation_date date 13  √  null
observation_source varchar 45  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc hydrant_pkey
fk_material Performance Asc fki_hydrant_fk_material
fk_model_inf Performance Asc fki_hydrant_fk_model_inf
fk_model_sup Performance Asc fki_hydrant_fk_model_sup
fk_output Performance Asc fki_hydrant_fk_output
fk_provider Performance Asc fki_hydrant_fk_provider

Close relationships  within of separation: