Table qwat.qwat_od.tank 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 tank_id_fkey R
fk_overflow int4 10  √  null
overflow.id tank_fk_overflow R
fk_tank_firestorage int4 10  √  null
tank_firestorage.id tank_fk_tank_firestorage R
storage_total numeric 10,1  √  null litres
storage_supply numeric 10,1  √  null litres
storage_fire numeric 10,1  √  null litres
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
cistern.id tank_cistern1type R
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
cistern.id tank_cistern2type R
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

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc tank_pkey
cistern1_fk_type Performance Asc fki_tank_cistern1type
cistern2_fk_type Performance Asc fki_tank_cistern2type
fk_overflow Performance Asc fki_tank_fk_overflow
fk_tank_firestorage Performance Asc fki_tank_fk_tank_firestorage

Close relationships  within of separation: