Database Table rundb_plannedexperiment
============================================================================

Postgres database: ``iondb``


Postgres table: ``rundb_plannedexperiment``


.. include:: ../manual_database_ref_docs/rundb_plannedexperiment.rst

Schema
-------

+-------------------------------+-------------------------------------------+----------------------------------------------------+
| Field                         | Type                                      | Description                                        |
+===============================+===========================================+====================================================+
| adapter                       | String (up to 256)                        | adapter                                            |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| applicationGroup              | ApplicationGroup (ForeignKey)             | the related rundb.ApplicationGroup row             |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| autoName                      | String (up to 512)                        | autoName                                           |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| categories                    | String (up to 64)                         | categories                                         |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| chipBarcode                   | String (up to 64)                         | chipBarcode                                        |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| controlSequencekitname        | String (up to 512)                        | controlSequencekitname                             |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| cycles                        | Integer                                   | cycles                                             |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| date                          | Date (with time)                          | date                                               |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| expName                       | String (up to 128)                        | expName                                            |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| get\_sample\_count            | Integer                                   | None                                               |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| id                            | Integer                                   | ID                                                 |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| irworkflow                    | String (up to 1024)                       | irworkflow                                         |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| isFavorite                    | Boolean (Either True or False)            | isFavorite                                         |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| isPlanGroup                   | Boolean (Either True or False)            | isPlanGroup                                        |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| isReusable                    | Boolean (Either True or False)            | isReusable                                         |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| isReverseRun                  | Boolean (Either True or False)            | isReverseRun                                       |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| isSystem                      | Boolean (Either True or False)            | isSystem                                           |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| isSystemDefault               | Boolean (Either True or False)            | isSystemDefault                                    |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| latestEAS                     | ExperimentAnalysisSettings (ForeignKey)   | the related rundb.ExperimentAnalysisSettings row   |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| libkit                        | String (up to 512)                        | libkit                                             |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| libraryReadLength             | Positive integer                          | libraryReadLength                                  |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| metaData                      | Text                                      | metaData                                           |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| pairedEndLibraryAdapterName   | String (up to 512)                        | pairedEndLibraryAdapterName                        |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| parentPlan                    | PlannedExperiment (ForeignKey)            | the related rundb.PlannedExperiment row            |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| planDisplayedName             | String (up to 512)                        | planDisplayedName                                  |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| planExecuted                  | Boolean (Either True or False)            | planExecuted                                       |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| planExecutedDate              | Date (with time)                          | planExecutedDate                                   |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| planGUID                      | String (up to 512)                        | planGUID                                           |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| planName                      | String (up to 512)                        | planName                                           |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| planPGM                       | String (up to 128)                        | planPGM                                            |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| planShortID                   | String (up to 5)                          | planShortID                                        |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| planStatus                    | String (up to 512)                        | planStatus                                         |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| preAnalysis                   | Boolean (Either True or False)            | preAnalysis                                        |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| reverse\_primer               | String (up to 128)                        | reverse primer                                     |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| runMode                       | String (up to 64)                         | runMode                                            |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| runType                       | String (up to 512)                        | runType                                            |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| runname                       | String (up to 255)                        | runname                                            |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| sampleGrouping                | SampleGroupType\_CV (ForeignKey)          | the related rundb.SampleGroupType\_CV row          |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| samplePrepKitName             | String (up to 512)                        | samplePrepKitName                                  |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| sampleSet                     | SampleSet (ForeignKey)                    | the related rundb.SampleSet row                    |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| sampleSet\_planIndex          | Positive integer                          | sampleSet planIndex                                |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| sampleSet\_planTotal          | Positive integer                          | sampleSet planTotal                                |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| sampleSet\_uid                | String (up to 512)                        | sampleSet uid                                      |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| sampleTubeLabel               | String (up to 512)                        | sampleTubeLabel                                    |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| seqKitBarcode                 | String (up to 64)                         | seqKitBarcode                                      |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| storageHost                   | String (up to 128)                        | storageHost                                        |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| storage\_options              | String (up to 200)                        | storage options                                    |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| templatingKitBarcode          | String (up to 64)                         | templatingKitBarcode                               |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| templatingKitName             | String (up to 512)                        | templatingKitName                                  |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| templatingSize                | String (up to 64)                         | templatingSize                                     |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| usePostBeadfind               | Boolean (Either True or False)            | usePostBeadfind                                    |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| usePreBeadfind                | Boolean (Either True or False)            | usePreBeadfind                                     |
+-------------------------------+-------------------------------------------+----------------------------------------------------+
| username                      | String (up to 128)                        | username                                           |
+-------------------------------+-------------------------------------------+----------------------------------------------------+