Table petascopedb.public.ps_uom 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('ps_uom_id_seq'::regclass)
ps_domain.uom uom_fk C
ps_range.uom uom_fk C
uom text 2147483647  √  null
link text 2147483647  √  null

Table contained 0 rows at Mon Nov 19 22:04 CET 2012

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc ps_uom_pkey  
link Must be unique Asc ps_uom_link_key This unique column is also nullable
uom Must be unique Asc ps_uom_uom_key This unique column is also nullable

Close relationships  within of separation: