Table test_seqware_meta_db.public.workflow_run_input_files
Tracks which files have been used as input for workflow runs (1.0.X, 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 int4 10  √  null
workflow_run.workflow_run_id workflow_run_id R
file_id int4 10  √  null
file.file_id file_id R

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
file_id Performance Asc file_id_workflow_run_input_files  
workflow_run_id Performance Asc workflow_run_id_workflow_run_input_files  
workflow_run_id + file_id Must be unique Asc/Asc workflow_run_input_files_unique These unique columns are also nullable

Close relationships  within of separation: