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.