This table is meant to track the images and other products generated from the raw data.  Each entry in this table is one run of a process that takes in data from the archive and produces other data that will be archived.

Definition:

        Column        |            Type             | Collation | Nullable |                    Default

----------------------+-----------------------------+-----------+----------+------------------------------------------------

 workflow_id          | integer                     |           | not null | nextval('workflows_workflow_id_seq'::regclass)

 workflow_name        | character varying           |           | not null |

 status               | character varying           |           | not null |

 submitted_by         | character varying           |           | not null |

 submitted            | timestamp without time zone |           |          |

 started              | timestamp without time zone |           |          |

 completed            | timestamp without time zone |           |          |

 workflow_qa_analyst  | character varying           |           |          |

 workflow_qa_comments | character varying           |           |          |

 workflow_qa_result   | character varying           |           |          |

 result_qa_analyst    | character varying           |           |          |

 result_qa_comments   | character varying           |           |          |

 result_qa_results    | character varying           |           |          |

 software_version     | character varying           |           | not null |

 output_filegroup_id  | integer                     |           | not null |

Indexes:

    "workflow_id" PRIMARY KEY, btree (workflow_id)

Foreign-key constraints:

    "filegroups_workflows_fk" FOREIGN KEY (output_filegroup_id) REFERENCES workflows(workflow_id) ON UPDATE CASCADE ON DELETE CASCADE

Referenced by:

    TABLE "workflows" CONSTRAINT "filegroups_workflows_fk" FOREIGN KEY (output_filegroup_id) REFERENCES workflows(workflow_id) ON UPDATE CASCADE ON DELETE CASCADE

    TABLE "workflow_parameters" CONSTRAINT "workflow_parametes_pk" FOREIGN KEY (workflow_id) REFERENCES workflows(workflow_id) ON UPDATE CASCADE ON DELETE CASCADE

    TABLE "workflow_input_files" CONSTRAINT "workflows_workflow_input_files_fk" FOREIGN KEY (workflow_id) REFERENCES workflows(workflow_id) ON UPDATE CASCADE ON DELETE CASCADE

    TABLE "workflow_parameters" CONSTRAINT "workflows_workflow_parameters_fk" FOREIGN KEY (workflow_id) REFERENCES workflows(workflow_id)

Columns:

workflow_id:auto-generated id.

workflow_name: a readable name for the process that is being used.

status: the current state of processing, eg. 'Running', 'Completed'.

submitted_by:  the name or username of the person who began the processing job.

submitted: the date and time when the job was submitted for processing.

started: the date and time when the job began being processed.

completed: the date and time when processing was completed, whether successfully or not.

workflow_qa_analyst: the name of the person who checked the workflow for quality assurance.

workflow_qa_comments:  any comments the person may have had about the setup of the workflow.

workflow_qa_results: whether the workflow setup passes QA.  I was not told whether this would be pass/fail, rated, or what.

result_qa_analyst: the name of the person who checked the resulting data for quality assurance.

result_qa_comments:  any comments the person may have had about the data that was produced.

result_qa_results: whether the data passes QA.  I was not told whether this would be pass/fail, rated, or what.

software_version: the version of processing software used, so that the job can be re-created if necessary.

output_filegroup_id: the id of a filegroup to put the resulting data in.