Table pvsadmin.public.zipcode_local 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
zipcode_local_id serial 10  √  nextval('zipcode_local_zipcode_local_id_seq'::regclass)
zip5 int4 10  √  null
local_id int4 10  √  null
local.local_id zipcode__local_id_fk C

Table contained 51,404 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
zipcode_local_id Primary key Asc zipcode_local_pkey  
zip5 + local_id Must be unique Asc/Asc zipcode_local__unique These unique columns are also nullable

Close relationships  within of separation: