Database Table rundb_results
============================================================================

Postgres database: ``iondb``


Postgres table: ``rundb_results``


.. include:: ../manual_database_ref_docs/rundb_results.rst

Schema
-------

+-------------------+-------------------------------------------+----------------------------------------------------+
| Field             | Type                                      | Description                                        |
+===================+===========================================+====================================================+
| analysisVersion   | String (up to 256)                        | analysisVersion                                    |
+-------------------+-------------------------------------------+----------------------------------------------------+
| analysismetrics   | AnalysisMetrics (ForeignKey)              | the related rundb.AnalysisMetrics row              |
+-------------------+-------------------------------------------+----------------------------------------------------+
| autoExempt        | Boolean (Either True or False)            | autoExempt                                         |
+-------------------+-------------------------------------------+----------------------------------------------------+
| diskusage         | Integer                                   | diskusage                                          |
+-------------------+-------------------------------------------+----------------------------------------------------+
| eas               | ExperimentAnalysisSettings (ForeignKey)   | the related rundb.ExperimentAnalysisSettings row   |
+-------------------+-------------------------------------------+----------------------------------------------------+
| experiment        | Experiment (ForeignKey)                   | the related rundb.Experiment row                   |
+-------------------+-------------------------------------------+----------------------------------------------------+
| fastqLink         | String (up to 512)                        | fastqLink                                          |
+-------------------+-------------------------------------------+----------------------------------------------------+
| framesProcessed   | Integer                                   | framesProcessed                                    |
+-------------------+-------------------------------------------+----------------------------------------------------+
| id                | Integer                                   | ID                                                 |
+-------------------+-------------------------------------------+----------------------------------------------------+
| libmetrics        | LibMetrics (ForeignKey)                   | the related rundb.LibMetrics row                   |
+-------------------+-------------------------------------------+----------------------------------------------------+
| log               | Text                                      | log                                                |
+-------------------+-------------------------------------------+----------------------------------------------------+
| metaData          | Text                                      | metaData                                           |
+-------------------+-------------------------------------------+----------------------------------------------------+
| parentIDs         | String (up to 512)                        | parentIDs                                          |
+-------------------+-------------------------------------------+----------------------------------------------------+
| processedCycles   | Integer                                   | processedCycles                                    |
+-------------------+-------------------------------------------+----------------------------------------------------+
| processedflows    | Integer                                   | processedflows                                     |
+-------------------+-------------------------------------------+----------------------------------------------------+
| qualitymetrics    | QualityMetrics (ForeignKey)               | the related rundb.QualityMetrics row               |
+-------------------+-------------------------------------------+----------------------------------------------------+
| reference         | String (up to 64)                         | reference                                          |
+-------------------+-------------------------------------------+----------------------------------------------------+
| reportLink        | String (up to 512)                        | reportLink                                         |
+-------------------+-------------------------------------------+----------------------------------------------------+
| reportStatus      | String (up to 64)                         | reportStatus                                       |
+-------------------+-------------------------------------------+----------------------------------------------------+
| reportstorage     | ReportStorage (ForeignKey)                | the related rundb.ReportStorage row                |
+-------------------+-------------------------------------------+----------------------------------------------------+
| representative    | Boolean (Either True or False)            | representative                                     |
+-------------------+-------------------------------------------+----------------------------------------------------+
| resultsName       | String (up to 512)                        | resultsName                                        |
+-------------------+-------------------------------------------+----------------------------------------------------+
| resultsType       | String (up to 512)                        | resultsType                                        |
+-------------------+-------------------------------------------+----------------------------------------------------+
| runid             | String (up to 10)                         | runid                                              |
+-------------------+-------------------------------------------+----------------------------------------------------+
| sffLink           | String (up to 512)                        | sffLink                                            |
+-------------------+-------------------------------------------+----------------------------------------------------+
| status            | String (up to 64)                         | status                                             |
+-------------------+-------------------------------------------+----------------------------------------------------+
| tfFastq           | String (up to 512)                        | tfFastq                                            |
+-------------------+-------------------------------------------+----------------------------------------------------+
| tfSffLink         | String (up to 512)                        | tfSffLink                                          |
+-------------------+-------------------------------------------+----------------------------------------------------+
| timeStamp         | Date (with time)                          | timeStamp                                          |
+-------------------+-------------------------------------------+----------------------------------------------------+
| timeToComplete    | String (up to 64)                         | timeToComplete                                     |
+-------------------+-------------------------------------------+----------------------------------------------------+