Table test_seqware_meta_db.public.sample_hierarchy
Relationship of samples as they pass through the wet lab (created by migration)

Generated by
SchemaSpy
Legend:
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
sample_id int4 10
sample.sample_id sample_hierarchy_sample_id_fkey R
parent_id int4 10  √  null
sample.sample_id sample_hierarchy_parent_id_fkey R

Table contained 120,260 rows at Mon Mar 31 13:20 EDT 2014

Indexes:
Column(s) Type Sort Constraint Name
parent_id Performance Asc parent_sample_hierarchy
sample_id + parent_id Must be unique Asc/Asc sample_hierarchy_not_null
sample_id Must be unique Asc sample_hierarchy_null
sample_id + parent_id Must be unique Asc/Asc sample_hierarchy_sample_id_key

Close relationships  within of separation: