Table test_seqware_meta_db.public.workflow_run
Tracks runs of installed workflows (used by reporting, 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
workflow_run_id serial 10  √  nextval('workflow_run_workflow_run_id_seq'::regclass)
ius_workflow_runs.workflow_run_id fk_ius_workflow_runs_workflow_run_id R
lane_workflow_runs.workflow_run_id fk_lane_workflow_runs_workflow_run_id R
processing.ancestor_workflow_run_id processing_ancestor_workflow_run_id_fkey R
processing.workflow_run_id processing_workflow_run_id_fkey R
share_workflow_run.workflow_run_id fk_share_workflow_run_workflow_run_id R
workflow_run_attribute.workflow_run_id fk35f09d686071c5f8 R
workflow_run_input_files.workflow_run_id workflow_run_id R
workflow_run_param.workflow_run_id fk_workflow_run_param_workflow_run_id R
workflow_id int4 10
workflow.workflow_id workflow_run_workflow_id_fkey R
owner_id int4 10  √  null
registration.registration_id fk_workflow_run_registration_id R
name text 2147483647  √  null
ini_file text 2147483647  √  null
cmd text 2147483647  √  null
workflow_template text 2147483647  √  null
dax text 2147483647  √  null
status text 2147483647  √  null
status_cmd text 2147483647  √  null
seqware_revision text 2147483647  √  null
host text 2147483647  √  'sqwprod.hpc.oicr.on.ca'::text
current_working_dir text 2147483647  √  null
username text 2147483647  √  null
create_tstmp timestamp 29,6
update_tstmp timestamp 29,6  √  null
sw_accession serial 10  √   √  nextval('sw_accession_seq'::regclass)
stderr text 2147483647  √  null
stdout text 2147483647  √  null
workflow_engine text 2147483647  √  null

Table contained 38,550 rows at Mon Mar 31 13:20 EDT 2014

Indexes:
Column(s) Type Sort Constraint Name Anomalies
workflow_run_id Primary key Asc workflow_run_pkey  
status Performance Asc status_workflow_run  
sw_accession Must be unique Asc sw_accession_workflow_run This unique column is also nullable

Close relationships  within of separation: