Table test_seqware_meta_db.public.file_provenance_report
Generated table (essentially a materialized view, generated by SeqWare)

 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
last_modified timestamp 29,6  √  null
study_title text 2147483647  √  null
study_swa int4 10  √  null
study_attrs text 2147483647  √  null
experiment_name text 2147483647  √  null
experiment_swa int4 10  √  null
experiment_attrs text 2147483647  √  null
sample_parent_names text 2147483647  √  null
sample_parent_swas text 2147483647  √  null
parent_organism_ids text 2147483647  √  null
sample_parent_attrs text 2147483647  √  null
sample_name text 2147483647  √  null
sample_swa int4 10  √  null
organism_id int4 10  √  null
organism_code text 2147483647  √  null
sample_attrs text 2147483647  √  null
sequencer_run_name text 2147483647  √  null
sequencer_run_swa int4 10  √  null
sequencer_run_attrs text 2147483647  √  null
platform_id int4 10  √  null
platform_name text 2147483647  √  null
lane_name text 2147483647  √  null
lane_number int4 10  √  null
lane_swa int4 10  √  null
lane_attrs text 2147483647  √  null
ius_tag text 2147483647  √  null
ius_swa int4 10  √  null
ius_attrs text 2147483647  √  null
workflow_name text 2147483647  √  null
workflow_version text 2147483647  √  null
workflow_swa int4 10  √  null
workflow_run_name text 2147483647  √  null
workflow_run_status text 2147483647  √  null
workflow_run_swa int4 10  √  null
processing_algorithm text 2147483647  √  null
processing_swa int4 10  √  null
processing_attrs text 2147483647  √  null
file_meta_type text 2147483647  √  null
file_swa int4 10  √  null
file_attrs text 2147483647  √  null
file_path text 2147483647  √  null
file_md5sum text 2147483647  √  null
file_size int8 19  √  null
file_description text 2147483647  √  null
skip bool 1  √  null

Table contained 81,301 rows at Mon Mar 31 13:20 EDT 2014