Database Table rundb_experiment
============================================================================

Postgres database: ``iondb``


Postgres table: ``rundb_experiment``


.. include:: ../manual_database_ref_docs/rundb_experiment.rst

Schema
-------

+---------------------------+----------------------------------+-------------------------------------------+
| Field                     | Type                             | Description                               |
+===========================+==================================+===========================================+
| autoAnalyze               | Boolean (Either True or False)   | autoAnalyze                               |
+---------------------------+----------------------------------+-------------------------------------------+
| baselineRun               | Boolean (Either True or False)   | baselineRun                               |
+---------------------------+----------------------------------+-------------------------------------------+
| chefChipExpiration1       | String (up to 64)                | chefChipExpiration1                       |
+---------------------------+----------------------------------+-------------------------------------------+
| chefChipExpiration2       | String (up to 64)                | chefChipExpiration2                       |
+---------------------------+----------------------------------+-------------------------------------------+
| chefChipType1             | String (up to 64)                | chefChipType1                             |
+---------------------------+----------------------------------+-------------------------------------------+
| chefChipType2             | String (up to 64)                | chefChipType2                             |
+---------------------------+----------------------------------+-------------------------------------------+
| chefExtraInfo\_1          | String (up to 128)               | chefExtraInfo 1                           |
+---------------------------+----------------------------------+-------------------------------------------+
| chefExtraInfo\_2          | String (up to 128)               | chefExtraInfo 2                           |
+---------------------------+----------------------------------+-------------------------------------------+
| chefInstrumentName        | String (up to 200)               | chefInstrumentName                        |
+---------------------------+----------------------------------+-------------------------------------------+
| chefKitType               | String (up to 64)                | chefKitType                               |
+---------------------------+----------------------------------+-------------------------------------------+
| chefLastUpdate            | Date (with time)                 | chefLastUpdate                            |
+---------------------------+----------------------------------+-------------------------------------------+
| chefLogPath               | String (up to 512)               | chefLogPath                               |
+---------------------------+----------------------------------+-------------------------------------------+
| chefLotNumber             | String (up to 64)                | chefLotNumber                             |
+---------------------------+----------------------------------+-------------------------------------------+
| chefManufactureDate       | String (up to 64)                | chefManufactureDate                       |
+---------------------------+----------------------------------+-------------------------------------------+
| chefMessage               | Text                             | chefMessage                               |
+---------------------------+----------------------------------+-------------------------------------------+
| chefPackageVer            | String (up to 64)                | chefPackageVer                            |
+---------------------------+----------------------------------+-------------------------------------------+
| chefProgress              | Floating point number            | chefProgress                              |
+---------------------------+----------------------------------+-------------------------------------------+
| chefReagentID             | String (up to 64)                | chefReagentID                             |
+---------------------------+----------------------------------+-------------------------------------------+
| chefReagentsExpiration    | String (up to 64)                | chefReagentsExpiration                    |
+---------------------------+----------------------------------+-------------------------------------------+
| chefReagentsLot           | String (up to 64)                | chefReagentsLot                           |
+---------------------------+----------------------------------+-------------------------------------------+
| chefReagentsPart          | String (up to 64)                | chefReagentsPart                          |
+---------------------------+----------------------------------+-------------------------------------------+
| chefSamplePos             | String (up to 64)                | chefSamplePos                             |
+---------------------------+----------------------------------+-------------------------------------------+
| chefSolutionsExpiration   | String (up to 64)                | chefSolutionsExpiration                   |
+---------------------------+----------------------------------+-------------------------------------------+
| chefSolutionsLot          | String (up to 64)                | chefSolutionsLot                          |
+---------------------------+----------------------------------+-------------------------------------------+
| chefSolutionsPart         | String (up to 64)                | chefSolutionsPart                         |
+---------------------------+----------------------------------+-------------------------------------------+
| chefStatus                | String (up to 256)               | chefStatus                                |
+---------------------------+----------------------------------+-------------------------------------------+
| chefTipRackBarcode        | String (up to 64)                | chefTipRackBarcode                        |
+---------------------------+----------------------------------+-------------------------------------------+
| chipBarcode               | String (up to 64)                | chipBarcode                               |
+---------------------------+----------------------------------+-------------------------------------------+
| chipType                  | String (up to 32)                | chipType                                  |
+---------------------------+----------------------------------+-------------------------------------------+
| cycles                    | Integer                          | cycles                                    |
+---------------------------+----------------------------------+-------------------------------------------+
| date                      | Date (with time)                 | date                                      |
+---------------------------+----------------------------------+-------------------------------------------+
| diskusage                 | Integer                          | diskusage                                 |
+---------------------------+----------------------------------+-------------------------------------------+
| displayName               | String (up to 128)               | displayName                               |
+---------------------------+----------------------------------+-------------------------------------------+
| expCompInfo               | Text                             | expCompInfo                               |
+---------------------------+----------------------------------+-------------------------------------------+
| expDir                    | String (up to 512)               | expDir                                    |
+---------------------------+----------------------------------+-------------------------------------------+
| expName                   | String (up to 128)               | expName                                   |
+---------------------------+----------------------------------+-------------------------------------------+
| flows                     | Integer                          | flows                                     |
+---------------------------+----------------------------------+-------------------------------------------+
| flowsInOrder              | Text                             | flowsInOrder                              |
+---------------------------+----------------------------------+-------------------------------------------+
| ftpStatus                 | String (up to 512)               | ftpStatus                                 |
+---------------------------+----------------------------------+-------------------------------------------+
| id                        | Integer                          | ID                                        |
+---------------------------+----------------------------------+-------------------------------------------+
| isReverseRun              | Boolean (Either True or False)   | isReverseRun                              |
+---------------------------+----------------------------------+-------------------------------------------+
| log                       | Text                             | log                                       |
+---------------------------+----------------------------------+-------------------------------------------+
| metaData                  | Text                             | metaData                                  |
+---------------------------+----------------------------------+-------------------------------------------+
| notes                     | String (up to 1024)              | notes                                     |
+---------------------------+----------------------------------+-------------------------------------------+
| pgmName                   | String (up to 64)                | pgmName                                   |
+---------------------------+----------------------------------+-------------------------------------------+
| pinnedRepResult           | Boolean (Either True or False)   | pinned representative result              |
+---------------------------+----------------------------------+-------------------------------------------+
| plan                      | PlannedExperiment (ForeignKey)   | the related rundb.PlannedExperiment row   |
+---------------------------+----------------------------------+-------------------------------------------+
| platform                  | String (up to 128)               | platform                                  |
+---------------------------+----------------------------------+-------------------------------------------+
| rawdatastyle              | String (up to 24)                | rawdatastyle                              |
+---------------------------+----------------------------------+-------------------------------------------+
| reagentBarcode            | String (up to 64)                | reagentBarcode                            |
+---------------------------+----------------------------------+-------------------------------------------+
| repResult                 | Results (ForeignKey)             | the related rundb.Results row             |
+---------------------------+----------------------------------+-------------------------------------------+
| resultDate                | Date (with time)                 | resultDate                                |
+---------------------------+----------------------------------+-------------------------------------------+
| reverse\_primer           | String (up to 128)               | reverse primer                            |
+---------------------------+----------------------------------+-------------------------------------------+
| runMode                   | String (up to 64)                | runMode                                   |
+---------------------------+----------------------------------+-------------------------------------------+
| seqKitBarcode             | String (up to 64)                | seqKitBarcode                             |
+---------------------------+----------------------------------+-------------------------------------------+
| sequencekitbarcode        | String (up to 512)               | sequencekitbarcode                        |
+---------------------------+----------------------------------+-------------------------------------------+
| sequencekitname           | String (up to 512)               | sequencekitname                           |
+---------------------------+----------------------------------+-------------------------------------------+
| star                      | Boolean (Either True or False)   | star                                      |
+---------------------------+----------------------------------+-------------------------------------------+
| status                    | String (up to 512)               | status                                    |
+---------------------------+----------------------------------+-------------------------------------------+
| storageHost               | String (up to 128)               | storageHost                               |
+---------------------------+----------------------------------+-------------------------------------------+
| storage\_options          | String (up to 200)               | storage options                           |
+---------------------------+----------------------------------+-------------------------------------------+
| unique                    | String (up to 512)               | unique                                    |
+---------------------------+----------------------------------+-------------------------------------------+
| usePreBeadfind            | Boolean (Either True or False)   | usePreBeadfind                            |
+---------------------------+----------------------------------+-------------------------------------------+
| user\_ack                 | String (up to 24)                | user ack                                  |
+---------------------------+----------------------------------+-------------------------------------------+