Table test_seqware_meta_db.public.experiment
High-level organization of samples (required, used for reporting, created by migration)

 Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
experiment_id serial 10  √  nextval('experiment_experiment_id_seq'::regclass)
experiment_attribute
experiment_link
processing_experiments
sample
share_experiment
study_id int4 10
study
experiment_library_design_id int4 10  √  null
experiment_library_design
experiment_spot_design_id int4 10  √  null
experiment_spot_design
platform_id int4 10  √  null
platform
name text 2147483647  √  null
title text 2147483647  √  null
description text 2147483647  √  null
alias text 2147483647  √  null
accession text 2147483647  √  null
status text 2147483647  √  null
center_name text 2147483647  √  null
sequence_space text 2147483647  √  null
base_caller text 2147483647  √  null
quality_scorer text 2147483647  √  null
quality_number_of_levels int4 10  √  null
quality_multiplier int4 10  √  null
quality_type text 2147483647  √  null
expected_number_runs int4 10  √  null
expected_number_spots int8 19  √  null
expected_number_reads int8 19  √  null
owner_id int4 10  √  null
registration
sw_accession serial 10  √   √  nextval('sw_accession_seq'::regclass)
create_tstmp timestamp 29,6
update_tstmp timestamp 29,6  √  null

Table contained 423 rows at Mon Mar 31 13:20 EDT 2014

Indexes:
Column(s) Type Sort
experiment_id Primary key Asc

Close relationships  within of separation: