Table qwat.qwat_od.distributor
Companies and distributors list.

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.distributor_id_seq'::regclass)
network_element.fk_distributor element_fk_distributor R
pipe.fk_distributor pipe_fk_distributor R
pressurezone.fk_distributor pressurezone_fk_distributor R
remote.fk_distributor remote_fk_distributor R
valve.fk_distributor valve_fk_distributor R
name varchar 30  √  null

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

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

Close relationships  within of separation: