Table test_seqware_meta_db.public.sequencer_run
High-level organization of lanes, an actual run of a sequencer (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
sequencer_run_id serial 10  √  nextval('sequencer_run_sequencer_run_id_seq'::regclass)
lane.sequencer_run_id lane_sequencer_run_id_fkey R
processing_sequencer_runs.sequencer_run_id processing_sequencer_runs_sequencer_run_id_fkey R
sequencer_run_attribute.sample_id fk_sequencer_run_attribute_sequencer_run_id R
name text 2147483647  √  null
description text 2147483647  √  null
status text 2147483647  √  null
platform_id int4 10  √  null
platform.platform_id sequencer_run_platform_id_fkey R
instrument_name text 2147483647  √  null
cycle_descriptor text 2147483647  √  null
cycle_count int4 10  √  null
cycle_sequence text 2147483647  √  null
file_path text 2147483647  √  null
paired_end bool 1  √  null
process bool 1  √  null
ref_lane int4 10  √  null
paired_file_path text 2147483647  √  null
use_ipar_intensities bool 1  √  null
color_matrix text 2147483647  √  null
color_matrix_code text 2147483647  √  null
slide_count int4 10  √  null
slide_1_lane_count int4 10  √  null
slide_1_file_path text 2147483647  √  null
slide_2_lane_count int4 10  √  null
slide_2_file_path text 2147483647  √  null
flow_sequence text 2147483647  √  null
flow_count int4 10  √  null
owner_id int4 10  √  null
registration.registration_id sequencer_run_owner_id_fkey R
run_center text 2147483647  √  null
base_caller text 2147483647  √  null
quality_scorer text 2147483647  √  null
sw_accession serial 10  √   √  nextval('sw_accession_seq'::regclass)
create_tstmp timestamp 29,6
update_tstmp timestamp 29,6  √  null
skip bool 1  √  false

Table contained 1,130 rows at Mon Mar 31 13:20 EDT 2014

Indexes:
Column(s) Type Sort Constraint Name
sequencer_run_id Primary key Asc sequencer_run_pkey

Close relationships  within of separation: