Table qwat.qwat_od.source 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 source_id_fkey R
fk_source_type int2 5  √  null
source_type.id source_fk_type R
fk_source_quality int2 5  √  null
source_quality.id source_fk_source_quality R
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

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc source_pkey
fk_source_quality Performance Asc fki_source_source_quality
fk_source_type Performance Asc fki_source_source_type

Close relationships  within of separation: