Table qwat.qwat_od.consumptionzone
consumption zones.

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 serial 10  √  nextval('qwat_od.consumptionzone_id_seq'::regclass)
pressurezone.fk_consumptionzone pressurezone_fk_consumptionzone R
name varchar 50  √  null
population int4 10  √  0
colorcode int2 5  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc consumptionzone_pkey  
name Must be unique Asc consumptionzone_name This unique column is also nullable

Close relationships  within of separation: