Table petascopedb.public.ps_quantity 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_quantity_id_seq'::regclass)
ps_quantity_interval.quantity_id ps9_quantity_interval_quantity_id_fkey R
uom_id int4 10
ps_uom.id ps9_quantity_uom_id_fkey R
label text 2147483647  √  ''::text
description text 2147483647  √  ''::text
definition_uri text 2147483647  √  null
significant_figures int4 10  √  null
nil_ids _int4 10  √  null

Table contained 14 rows at Mon Jul 07 14:34 CEST 2014

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc ps_quantity_pkey
uom_id + label + description Must be unique Asc/Asc/Asc ps_quantity_uom_id_label_description_key

Close relationships  within of separation: