Table test_seqware_meta_db.public.sample_report
Legacy table inspired by SRA schema (unused at OICR)

 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
study_id int4 10  √  null
child_sample_id int4 10  √  null
workflow_id int4 10  √  null
status varchar 255  √  null
row_id serial 10  √  nextval('sample_report_row_id_seq'::regclass)
file_report.row_id Implied Constraint R

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

Indexes:
Column(s) Type Sort Constraint Name
row_id Primary key Asc sample_report_pkey
study_id + child_sample_id + workflow_id Performance Asc/Asc/Asc sample_report_study_id_child_sample_id_workflow_id_idx

Close relationships: