Table test_seqware_meta_db.public.sample
High-level organization of IUS (used for reporting, 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 serial 10  √  nextval('sample_sample_id_seq'::regclass)
ius.sample_id ius__sample_fk R
lane.sample_id lane_sample_id_fkey R
processing_samples.sample_id processing_samples_sample_id_fkey R
sample_attribute.sample_id sample_attribute_sample_id_fkey R
sample_hierarchy.parent_id sample_hierarchy_parent_id_fkey R
sample_hierarchy.sample_id sample_hierarchy_sample_id_fkey R
sample_link.sample_id sample_link_sample_id_fkey R
sample_relationship.child_id sample_relationship_child_id_fkey C
sample_relationship.parent_id sample_relationship_parent_id_fkey R
sample_search.sample_id fk48cd19ddcc73e37d R
share_sample.sample_id fk_share_sample_sample_id R
experiment_id int4 10  √  null
experiment.experiment_id sample_experiment_id_fkey R
organism_id int4 10  √  null
organism.organism_id sample__organism_fk R
name text 2147483647  √  null
title text 2147483647  √  null
alias text 2147483647  √  null
type text 2147483647  √  null
scientific_name text 2147483647  √  null
common_name text 2147483647  √  null
anonymized_name text 2147483647  √  null
individual_name text 2147483647  √  null
description text 2147483647  √  null
taxon_id int4 10  √  null
tags text 2147483647  √  null
adapters text 2147483647  √  null
regions text 2147483647  √  null
expected_number_runs int4 10  √  null
expected_number_spots int4 10  √  null
expected_number_reads int4 10  √  null
skip bool 1  √  null
is_public bool 1  √  null
owner_id int4 10  √  null
registration.registration_id sample__owner_fk R
sw_accession serial 10  √   √  nextval('sw_accession_seq'::regclass)
create_tstmp timestamp 29,6
update_tstmp timestamp 29,6  √  null

Table contained 121,340 rows at Mon Mar 31 13:20 EDT 2014

Indexes:
Column(s) Type Sort Constraint Name
sample_id Primary key Asc sample_pkey
experiment_id Performance Asc experiment_id_sample

Close relationships  within of separation: