Table qwat.qwat_od.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
installation.id pump_id_fkey R
fk_pump_type int2 5  √  null
pump_type.id pump_fk_type R
fk_pipe_in int4 10  √  null
pipe.id pump_fk_pipe_in R
fk_pipe_out int4 10  √  null
pipe.id pump_fk_pipe_out R
fk_pump_operating int2 5  √  null
pump_operating.id pump_fk_pump_operating R
no_pumps int2 5  √  null
rejected_flow numeric 10,2  √  null
manometric_height numeric 10,2  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc pump_pkey
fk_pump_operating Performance Asc fki_pump_operating
fk_pipe_in Performance Asc fki_pump_pipe_in
fk_pipe_out Performance Asc fki_pump_pipe_out
fk_pump_type Performance Asc fki_pump_vl_pump_type

Close relationships  within of separation: