Table petascopedb.public.ps_range_type_component 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_range_type_component_id_seq'::regclass)
coverage_id int4 10
ps_coverage.id ps9_range_type_component_coverage_id_fkey C
name text 2147483647
data_type_id int4 10
ps_range_data_type.id ps9_range_type_component_data_type_id_fkey C
component_order int4 10
field_id int4 10
field_table text 2147483647  √  'ps_quantity'::text

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc ps_range_type_component_pkey
coverage_id + component_order Must be unique Asc/Asc ps_range_type_component_coverage_id_component_order_key
coverage_id + name Must be unique Asc/Asc ps_range_type_component_coverage_id_name_key

Close relationships  within of separation: