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
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
experiment_id serial 10  √  nextval('experiment_experiment_id_seq'::regclass)
experiment_attribute.experiment_id experiment_attribute_experiment_id_fkey R
experiment_link.experiment_id experiment_link_experiment_id_fkey R
processing_experiments.experiment_id processing_experiments_experiment_id_fkey R
sample.experiment_id sample_experiment_id_fkey R
share_experiment.experiment_id fk_share_experiment_experiment_id R
study_id int4 10
study.study_id experiment_study_id_fkey R
experiment_library_design_id int4 10  √  null
experiment_library_design.experiment_library_design_id experiment_experiment_library_design_id_fkey R
experiment_spot_design_id int4 10  √  null
experiment_spot_design.experiment_spot_design_id experiment_experiment_spot_design_id_fkey R
platform_id int4 10  √  null
platform.platform_id experiment_platform_id_fkey R
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.registration_id experiment__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 423 rows at Mon Mar 31 13:20 EDT 2014

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

Close relationships  within of separation: