Table test_seqware_meta_db.public.processing
Record details for steps of a workflow_run (created 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
processing_id serial 10  √  nextval('processing_processing_id_seq'::regclass)
processing_attribute.processing_id processing_attribute_processing_id_fkey R
processing_experiments.processing_id processing_experiments_processing_id_fkey R
processing_files.processing_id processing_files_processing_id_fkey R
processing_ius.processing_id processing_ius_processing_id_fkey R
processing_lanes.processing_id processing_lanes_processing_id_fkey R
processing_relationship.child_id processing_relationship_child_id_fkey C
processing_relationship.parent_id processing_relationship_parent_id_fkey R
processing_samples.processing_id processing_samples_processing_id_fkey R
processing_sequencer_runs.processing_id processing_sequencer_runs_processing_id_fkey R
processing_studies.processing_id processing_studies_processing_id_fkey R
share_processing.processing_id fk_share_processing_processing_id R
workflow_run_id int4 10  √  null
workflow_run.workflow_run_id processing_workflow_run_id_fkey R
ancestor_workflow_run_id int4 10  √  null
workflow_run.workflow_run_id processing_ancestor_workflow_run_id_fkey R
algorithm text 2147483647  √  null
status text 2147483647  √  null
description text 2147483647  √  null
url text 2147483647  √  null
url_label text 2147483647  √  null
version text 2147483647  √  null
parameters text 2147483647  √  null
stdout text 2147483647  √  null
stderr text 2147483647  √  null
exit_status int4 10  √  null
process_exit_status int4 10  √  null
task_group bool 1  √  false
owner_id int4 10  √  null
registration.registration_id fk_processing_owner_id R
sw_accession serial 10  √   √  nextval('sw_accession_seq'::regclass)
run_start_tstmp timestamp 29,6  √  null
run_stop_tstmp timestamp 29,6  √  null
create_tstmp timestamp 29,6
update_tstmp timestamp 29,6  √  null

Table contained 518,682 rows at Mon Mar 31 13:20 EDT 2014

Indexes:
Column(s) Type Sort Constraint Name Anomalies
processing_id Primary key Asc processing_pkey  
ancestor_workflow_run_id Performance Asc ancestor_workflow_run_processing  
sw_accession Must be unique Asc sw_accession_processing This unique column is also nullable
workflow_run_id Performance Asc workflow_run_processing  

Close relationships  within of separation: