Base1 Tables

ArrayBatch
ArrayBlock
ArraySlide
ArrayType
ArrayTypePlate
BaseControl
BaseFileSection
BioAssay
BioAssayOrigin
BioAssayParent
BioAssaySample
BioAssaySet
BioAssaySetExplore
BioAssaySetExtraColumn
BioAssaySetSearch
ComputationServer
Cookie
EventLog
Experiment
ExperimentExplore
ExperimentRawBioAssay
ExtraDataColumn
Extract
Feature
Hardware
Hybridization
HybridizedLabeled
Image
ImageAcquisition
Item
Job
JobFile
JobFileSection
JobSetting
Label
LabeledExtract
News
Plate
PlateEvent
PlateEventType
PlateParent
PlateType
Preset
Probe
Program
ProgramParameter
ProgramServer
Protocol
ProtocolType
RawBioAssay
RawBioAssayData
RawBioAssayHeader
Reporter
ReporterList
Sample
SampleAnnotation
SampleAnnotationType
SampleTissue
SchemaVersion
Search
SearchCriterion
Software
TemplateBioAssayData
TemplateBioAssayExtraFloat
TemplateBioAssayExtraString
TemplateBioAssaySetGene
TemplateBioAssaySetPosGene
TemplateReporterListRow
Transformation
TransformationCollapse
TransformationSearch
Upload
UserAccount
UserGroup
UserGroupParent
UserSearch
Well
WellAncestor
Wizzzard


ArrayBatch

+----------------+--------------+------+-----+---------------------+----------------+
| Field          | Type         | Null | Key | Default             | Extra          |
+----------------+--------------+------+-----+---------------------+----------------+
| id             | int(11)      |      | PRI | NULL                | auto_increment |
| arrayType      | int(11)      |      | MUL | 0                   |                |
| descr          | text         |      |     |                     |                |
| printStartDate | datetime     |      |     | 0000-00-00 00:00:00 |                |
| printEndDate   | datetime     |      |     | 0000-00-00 00:00:00 |                |
| owner          | int(11)      |      |     | 0                   |                |
| name           | varchar(80)  |      | MUL |                     |                |
| addedDate      | date         |      |     | 0000-00-00          |                |
| surfaceType    | varchar(255) |      |     |                     |                |
| protocol       | int(11)      |      |     | 0                   |                |
| notes          | text         |      |     |                     |                |
| removed        | tinyint(1)   |      |     | 0                   |                |
| gid            | int(11)      |      |     | 0                   |                |
| groupAccess    | tinyint(1)   |      |     | 0                   |                |
| worldAccess    | tinyint(1)   |      |     | 0                   |                |
+----------------+--------------+------+-----+---------------------+----------------+
ArrayBlock

+-----------------+-------------+------+-----+---------+-------+
| Field           | Type        | Null | Key | Default | Extra |
+-----------------+-------------+------+-----+---------+-------+
| arrayType       | int(11)     |      | PRI | 0       |       |
| blockNum        | smallint(6) |      | PRI | 0       |       |
| xOrigin         | float       |      |     | 0       |       |
| yOrigin         | float       |      |     | 0       |       |
| featureDiameter | float       |      |     | 0       |       |
| xFeatures       | float       |      |     | 0       |       |
| xSpacing        | float       |      |     | 0       |       |
| yFeatures       | float       |      |     | 0       |       |
| ySpacing        | float       |      |     | 0       |       |
| metaRow         | smallint(6) |      |     | 0       |       |
| metaColumn      | smallint(6) |      |     | 0       |       |
+-----------------+-------------+------+-----+---------+-------+
ArraySlide

+---------------+-------------+------+-----+------------+----------------+
| Field         | Type        | Null | Key | Default    | Extra          |
+---------------+-------------+------+-----+------------+----------------+
| id            | int(11)     |      | PRI | NULL       | auto_increment |
| batch         | int(11)     |      | MUL | 0          |                |
| orderNumber   | smallint(6) |      |     | 0          |                |
| name          | varchar(80) | YES  | MUL | NULL       |                |
| destroyed     | tinyint(1)  |      |     | 0          |                |
| hybridization | int(11)     | YES  | MUL | NULL       |                |
| descr         | text        |      |     |            |                |
| owner         | int(11)     |      |     | 0          |                |
| addedDate     | date        |      |     | 0000-00-00 |                |
| removed       | tinyint(1)  |      |     | 0          |                |
| gid           | int(11)     |      |     | 0          |                |
| groupAccess   | tinyint(1)  |      |     | 0          |                |
| worldAccess   | tinyint(1)  |      |     | 0          |                |
+---------------+-------------+------+-----+------------+----------------+
ArrayType

+---------------+--------------+------+-----+------------+----------------+
| Field         | Type         | Null | Key | Default    | Extra          |
+---------------+--------------+------+-----+------------+----------------+
| id            | int(11)      |      | PRI | NULL       | auto_increment |
| owner         | int(11)      |      |     | 0          |                |
| name          | varchar(80)  |      | MUL |            |                |
| platform      | varchar(255) |      |     |            |                |
| protocol      | int(11)      |      |     | 0          |                |
| descr         | text         |      |     |            |                |
| addedDate     | date         |      |     | 0000-00-00 |                |
| printed       | tinyint(1)   |      |     | 0          |                |
| printMapName  | varchar(255) |      |     |            |                |
| removed       | tinyint(1)   |      |     | 0          |                |
| gid           | int(11)      |      |     | 0          |                |
| groupAccess   | tinyint(1)   |      |     | 0          |                |
| worldAccess   | tinyint(1)   |      |     | 0          |                |
| featureLock   | smallint(6)  |      |     | 0          |                |
| featureCount  | int(11)      |      |     | 0          |                |
| blankFeatures | int(11)      |      |     | 0          |                |
+---------------+--------------+------+-----+------------+----------------+
ArrayTypePlate

+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| arrayType | int(11)     |      | PRI | 0       |       |
| plate     | int(11)     |      |     | 0       |       |
| position  | smallint(6) |      | PRI | 0       |       |
+-----------+-------------+------+-----+---------+-------+
BaseControl

+----------------------+------------+------+-----+---------------------+-------+
| Field                | Type       | Null | Key | Default             | Extra |
+----------------------+------------+------+-----+---------------------+-------+
| startTime            | datetime   |      |     | 0000-00-00 00:00:00 |       |
| shutDown             | tinyint(4) |      |     | 0                   |       |
| pendingTransactions  | int(11)    |      |     | 0                   |       |
| finishedTransactions | int(11)    |      |     | 0                   |       |
| startedScripts       | int(11)    |      |     | 0                   |       |
+----------------------+------------+------+-----+---------------------+-------+
BaseFileSection

+-------+--------------+------+-----+---------+----------------+
| Field | Type         | Null | Key | Default | Extra          |
+-------+--------------+------+-----+---------+----------------+
| id    | int(11)      |      | PRI | NULL    | auto_increment |
| name  | varchar(255) |      | UNI |         |                |
+-------+--------------+------+-----+---------+----------------+
BioAssay

+-------------+--------------+------+-----+------------+----------------+
| Field       | Type         | Null | Key | Default    | Extra          |
+-------------+--------------+------+-----+------------+----------------+
| id          | int(11)      |      | PRI | NULL       | auto_increment |
| name        | varchar(80)  |      |     |            |                |
| descr       | text         |      |     |            |                |
| owner       | int(11)      |      |     | 0          |                |
| addedDate   | date         |      |     | 0000-00-00 |                |
| bioAssaySet | int(11)      |      | MUL | 0          |                |
| experiment  | int(11)      |      |     | 0          |                |
| spots       | mediumint(9) |      |     | 0          |                |
| removed     | tinyint(1)   |      |     | 3          |                |
| channels    | tinyint(4)   |      |     | 2          |                |
+-------------+--------------+------+-----+------------+----------------+
BioAssayOrigin

+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| bioAssay    | int(11)     |      | PRI | 0       |                |
| rawBioAssay | int(11)     |      | MUL | 0       |                |
| position    | smallint(6) |      | PRI | NULL    | auto_increment |
+-------------+-------------+------+-----+---------+----------------+
BioAssayParent

+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| bioAssay | int(11)     |      | PRI | 0       |                |
| parent   | int(11)     |      | MUL | 0       |                |
| position | smallint(6) |      | PRI | NULL    | auto_increment |
+----------+-------------+------+-----+---------+----------------+
BioAssaySample

+----------+------------+------+-----+---------+-------+
| Field    | Type       | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| bioAssay | int(11)    |      | PRI | 0       |       |
| sample   | int(11)    |      |     | 0       |       |
| channel  | tinyint(4) |      | PRI | 0       |       |
+----------+------------+------+-----+---------+-------+
BioAssaySet

+------------------+--------------+------+-----+------------+----------------+
| Field            | Type         | Null | Key | Default    | Extra          |
+------------------+--------------+------+-----+------------+----------------+
| id               | int(11)      |      | PRI | NULL       | auto_increment |
| name             | varchar(80)  |      | MUL |            |                |
| descr            | text         |      |     |            |                |
| owner            | int(11)      |      |     | 0          |                |
| addedDate        | date         |      |     | 0000-00-00 |                |
| experiment       | int(11)      |      | MUL | 0          |                |
| transformation   | int(11)      |      | MUL | 0          |                |
| assayCount       | smallint(6)  |      |     | 0          |                |
| spotCount        | int(11)      |      |     | 0          |                |
| geneCount        | mediumint(9) |      |     | 0          |                |
| removed          | tinyint(1)   |      |     | 3          |                |
| intensityMeasure | varchar(80)  | YES  |     | NULL       |                |
| hasExtraColumns  | tinyint(1)   |      |     | 0          |                |
+------------------+--------------+------+-----+------------+----------------+
BioAssaySetExplore

+----------------+--------------+------+-----+---------+-------+
| Field          | Type         | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| bioAssaySet    | int(11)      |      | PRI | 0       |       |
| userGroup      | int(11)      |      | PRI | 0       |       |
| hits           | int(11)      |      |     | 0       |       |
| page           | int(11)      |      |     | 0       |       |
| reporter       | mediumint(9) |      |     | 0       |       |
| subPage        | smallint(6)  |      |     | 1       |       |
| annotationType | int(11)      |      |     | 0       |       |
| exploreMode    | tinyint(1)   |      |     | 0       |       |
| showBackend    | tinyint(1)   |      |     | 0       |       |
| spotSize       | tinyint(4)   |      |     | 0       |       |
| rawLevel       | tinyint(1)   |      |     | 3       |       |
+----------------+--------------+------+-----+---------+-------+
BioAssaySetExtraColumn

+-----------------+------------+------+-----+---------+----------------+
| Field           | Type       | Null | Key | Default | Extra          |
+-----------------+------------+------+-----+---------+----------------+
| bioAssaySet     | int(11)    |      | PRI | 0       |                |
| extraDataColumn | int(11)    |      |     | 0       |                |
| position        | tinyint(4) |      | PRI | NULL    | auto_increment |
+-----------------+------------+------+-----+---------+----------------+
BioAssaySetSearch

+-------------+-------------+------+-----+---------+-------+
| Field       | Type        | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| bioAssaySet | int(11)     |      | MUL | 0       |       |
| userGroup   | int(11)     |      |     | 0       |       |
| searchType  | varchar(80) |      |     |         |       |
| search      | int(11)     |      | PRI | 0       |       |
+-------------+-------------+------+-----+---------+-------+
ComputationServer

+---------------+--------------+------+-----+------------+----------------+
| Field         | Type         | Null | Key | Default    | Extra          |
+---------------+--------------+------+-----+------------+----------------+
| id            | int(11)      |      | PRI | NULL       | auto_increment |
| name          | varchar(80)  |      |     |            |                |
| descr         | text         |      |     |            |                |
| owner         | int(11)      |      |     | 0          |                |
| addedDate     | date         |      |     | 0000-00-00 |                |
| removed       | tinyint(1)   |      |     | 3          |                |
| gid           | int(11)      |      |     | 0          |                |
| groupAccess   | tinyint(4)   |      |     | 0          |                |
| worldAccess   | tinyint(4)   |      |     | 0          |                |
| serverType    | tinyint(4)   |      |     | 0          |                |
| userHost      | varchar(255) |      |     |            |                |
| remoteRootDir | varchar(255) |      |     |            |                |
| remoteDataDir | varchar(255) |      |     |            |                |
| localUrl      | varchar(255) |      |     |            |                |
| maxJobs       | int(11)      |      |     | 0          |                |
| minTime       | int(11)      |      |     | 60         |                |
| maxTime       | int(11)      |      |     | 86400      |                |
| jobSlots      | smallint(6)  |      |     | 3          |                |
| infSlots      | smallint(6)  |      |     | 1          |                |
| totalRam      | double       |      |     | 268435000  |                |
+---------------+--------------+------+-----+------------+----------------+
Cookie

+--------------+-------------+------+-----+---------------------+-------+
| Field        | Type        | Null | Key | Default             | Extra |
+--------------+-------------+------+-----+---------------------+-------+
| cookie       | varchar(40) |      | PRI |                     |       |
| owner        | int(11)     |      |     | 0                   |       |
| lastSeen     | datetime    |      | MUL | 0000-00-00 00:00:00 |       |
| IP           | tinytext    |      |     |                     |       |
| loginDate    | datetime    |      |     | 0000-00-00 00:00:00 |       |
| lastActivity | datetime    |      |     | 0000-00-00 00:00:00 |       |
+--------------+-------------+------+-----+---------------------+-------+
EventLog

+-------------+--------------+------+-----+---------------------+----------------+
| Field       | Type         | Null | Key | Default             | Extra          |
+-------------+--------------+------+-----+---------------------+----------------+
| id          | int(11)      |      | PRI | NULL                | auto_increment |
| name        | varchar(255) |      |     |                     |                |
| descr       | text         |      |     |                     |                |
| owner       | int(11)      |      |     | 0                   |                |
| addedDate   | datetime     |      | MUL | 0000-00-00 00:00:00 |                |
| removed     | tinyint(1)   |      |     | 0                   |                |
| gid         | int(11)      |      |     | 0                   |                |
| groupAccess | tinyint(1)   |      |     | 0                   |                |
| worldAccess | tinyint(1)   |      |     | 0                   |                |
| eventType   | smallint(6)  |      |     | 0                   |                |
| linkInfo    | varchar(255) |      |     |                     |                |
+-------------+--------------+------+-----+---------------------+----------------+
Experiment

+-------------------+--------------+------+-----+------------+----------------+
| Field             | Type         | Null | Key | Default    | Extra          |
+-------------------+--------------+------+-----+------------+----------------+
| id                | int(11)      |      | PRI | NULL       | auto_increment |
| name              | varchar(80)  |      |     |            |                |
| descr             | text         |      |     |            |                |
| owner             | int(11)      |      |     | 0          |                |
| addedDate         | date         |      |     | 0000-00-00 |                |
| authors           | text         |      |     |            |                |
| affiliations      | text         |      |     |            |                |
| experimentType    | varchar(255) |      |     |            |                |
| experimentDesign  | text         |      |     |            |                |
| publication       | text         |      |     |            |                |
| abstract          | text         |      |     |            |                |
| pubMedId          | varchar(80)  |      |     |            |                |
| publicationDate   | date         |      |     | 0000-00-00 |                |
| removed           | tinyint(1)   |      |     | 3          |                |
| gid               | int(11)      |      |     | 0          |                |
| groupAccess       | tinyint(1)   |      |     | 0          |                |
| worldAccess       | tinyint(1)   |      |     | 0          |                |
| channels          | tinyint(4)   |      |     | 2          |                |
| hasMageml         | smallint(1)  |      |     | 0          |                |
| extraColumnTables | int(11)      |      |     | 0          |                |
+-------------------+--------------+------+-----+------------+----------------+
ExperimentExplore

+-----------------------+------------+------+-----+---------+-------+
| Field                 | Type       | Null | Key | Default | Extra |
+-----------------------+------------+------+-----+---------+-------+
| experiment            | int(11)    |      | PRI | 0       |       |
| userGroup             | int(11)    |      | PRI | 0       |       |
| shownTab              | tinyint(4) |      |     | 0       |       |
| currentTransformation | int(11)    |      |     | 0       |       |
| currentSet            | int(11)    |      |     | 0       |       |
+-----------------------+------------+------+-----+---------+-------+
ExperimentRawBioAssay

+-------------+---------+------+-----+---------+-------+
| Field       | Type    | Null | Key | Default | Extra |
+-------------+---------+------+-----+---------+-------+
| experiment  | int(11) |      | PRI | 0       |       |
| rawBioAssay | int(11) |      | PRI | 0       |       |
+-------------+---------+------+-----+---------+-------+
ExtraDataColumn

+-----------+-------------+------+-----+---------+----------------+
| Field     | Type        | Null | Key | Default | Extra          |
+-----------+-------------+------+-----+---------+----------------+
| id        | int(11)     |      | PRI | NULL    | auto_increment |
| name      | varchar(80) |      | MUL |         |                |
| valueType | tinyint(4)  |      |     | 0       |                |
+-----------+-------------+------+-----+---------+----------------+
Extract

+----------------+-------------+------+-----+------------+----------------+
| Field          | Type        | Null | Key | Default    | Extra          |
+----------------+-------------+------+-----+------------+----------------+
| id             | int(11)     |      | PRI | NULL       | auto_increment |
| protocol       | int(11)     |      |     | 0          |                |
| extractionDate | date        |      |     | 0000-00-00 |                |
| sample         | int(11)     |      | MUL | 0          |                |
| name           | varchar(80) |      | MUL |            |                |
| descr          | text        |      |     |            |                |
| quantity       | float       |      |     | 0          |                |
| quantityLeft   | float       | YES  |     | NULL       |                |
| owner          | int(11)     |      |     | 0          |                |
| addedDate      | date        |      |     | 0000-00-00 |                |
| removed        | tinyint(1)  |      |     | 0          |                |
| gid            | int(11)     |      |     | 0          |                |
| groupAccess    | tinyint(1)  |      |     | 0          |                |
| worldAccess    | tinyint(1)  |      |     | 0          |                |
+----------------+-------------+------+-----+------------+----------------+
Feature

+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| id        | int(11)      |      | PRI | NULL    | auto_increment |
| arrayType | int(11)      |      | MUL | 0       |                |
| block     | smallint(6)  |      |     | 0       |                |
| x         | smallint(6)  |      |     | 0       |                |
| y         | smallint(6)  |      |     | 0       |                |
| position  | mediumint(9) |      |     | 0       |                |
| reporter  | mediumint(9) |      |     | 0       |                |
| well      | int(11)      | YES  |     | NULL    |                |
+-----------+--------------+------+-----+---------+----------------+
Hardware

+-------------+-------------+------+-----+------------+----------------+
| Field       | Type        | Null | Key | Default    | Extra          |
+-------------+-------------+------+-----+------------+----------------+
| id          | int(11)     |      | PRI | NULL       | auto_increment |
| name        | varchar(80) |      | MUL |            |                |
| descr       | text        |      |     |            |                |
| owner       | int(11)     |      |     | 0          |                |
| addedDate   | date        |      |     | 0000-00-00 |                |
| version     | varchar(80) |      |     |            |                |
| removed     | tinyint(1)  |      |     | 0          |                |
| gid         | int(11)     |      |     | 0          |                |
| groupAccess | tinyint(1)  |      |     | 0          |                |
| worldAccess | tinyint(1)  |      |     | 0          |                |
+-------------+-------------+------+-----+------------+----------------+
Hybridization

+-------------------+-------------+------+-----+------------+----------------+
| Field             | Type        | Null | Key | Default    | Extra          |
+-------------------+-------------+------+-----+------------+----------------+
| id                | int(11)     |      | PRI | NULL       | auto_increment |
| owner             | int(11)     |      |     | 0          |                |
| name              | varchar(80) |      | MUL |            |                |
| descr             | text        |      |     |            |                |
| addedDate         | date        |      |     | 0000-00-00 |                |
| hybridizationDate | date        |      |     | 0000-00-00 |                |
| protocol          | int(11)     |      |     | 0          |                |
| removed           | tinyint(1)  |      |     | 0          |                |
| gid               | int(11)     |      |     | 0          |                |
| groupAccess       | tinyint(1)  |      |     | 0          |                |
| worldAccess       | tinyint(1)  |      |     | 0          |                |
+-------------------+-------------+------+-----+------------+----------------+
HybridizedLabeled

+---------------+------------+------+-----+---------+-------+
| Field         | Type       | Null | Key | Default | Extra |
+---------------+------------+------+-----+---------+-------+
| hybridization | int(11)    |      | PRI | 0       |       |
| channel       | tinyint(4) |      | PRI | 0       |       |
| labeled       | int(11)    |      | MUL | 0       |       |
| quantity      | float      |      |     | 0       |       |
+---------------+------------+------+-----+---------+-------+
Image

+------------------+--------------+------+-----+------------+----------------+
| Field            | Type         | Null | Key | Default    | Extra          |
+------------------+--------------+------+-----+------------+----------------+
| id               | int(11)      |      | PRI | NULL       | auto_increment |
| name             | varchar(255) |      |     |            |                |
| descr            | text         |      |     |            |                |
| owner            | int(11)      |      |     | 0          |                |
| addedDate        | date         |      |     | 0000-00-00 |                |
| imageAcquisition | int(11)      |      | MUL | 0          |                |
| channels         | tinyint(4)   |      |     | 0          |                |
| useForJpeg       | tinyint(1)   |      |     | 0          |                |
| fileSize         | int(11)      |      |     | 0          |                |
| removed          | tinyint(1)   |      |     | 0          |                |
+------------------+--------------+------+-----+------------+----------------+
ImageAcquisition

+---------------+-------------+------+-----+------------+----------------+
| Field         | Type        | Null | Key | Default    | Extra          |
+---------------+-------------+------+-----+------------+----------------+
| id            | int(11)     |      | PRI | NULL       | auto_increment |
| name          | varchar(80) |      |     |            |                |
| descr         | text        |      |     |            |                |
| owner         | int(11)     |      |     | 0          |                |
| addedDate     | date        |      |     | 0000-00-00 |                |
| hybridization | int(11)     |      | MUL | 0          |                |
| scanDate      | date        |      |     | 0000-00-00 |                |
| scanner       | int(11)     |      |     | 0          |                |
| removed       | tinyint(1)  |      |     | 0          |                |
| gid           | int(11)     |      |     | 0          |                |
| groupAccess   | tinyint(1)  |      |     | 0          |                |
| worldAccess   | tinyint(1)  |      |     | 0          |                |
+---------------+-------------+------+-----+------------+----------------+
Item

+-------------+-------------+------+-----+------------+----------------+
| Field       | Type        | Null | Key | Default    | Extra          |
+-------------+-------------+------+-----+------------+----------------+
| id          | int(11)     |      | PRI | NULL       | auto_increment |
| name        | varchar(80) |      |     |            |                |
| descr       | text        |      |     |            |                |
| owner       | int(11)     |      |     | 0          |                |
| addedDate   | date        |      |     | 0000-00-00 |                |
| removed     | tinyint(1)  |      |     | 0          |                |
| gid         | int(11)     |      |     | 0          |                |
| groupAccess | tinyint(1)  |      |     | 0          |                |
| worldAccess | tinyint(1)  |      |     | 0          |                |
+-------------+-------------+------+-----+------------+----------------+
Job

+-------------------+---------------+------+-----+---------------------+-------+
| Field             | Type          | Null | Key | Default             | Extra |
+-------------------+---------------+------+-----+---------------------+-------+
| submitTime        | datetime      |      |     | 0000-00-00 00:00:00 |       |
| handlerTime       | datetime      |      |     | 0000-00-00 00:00:00 |       |
| startTime         | datetime      |      | MUL | 0000-00-00 00:00:00 |       |
| endTime           | datetime      |      |     | 0000-00-00 00:00:00 |       |
| doneTime          | datetime      |      |     | 0000-00-00 00:00:00 |       |
| program           | int(11)       |      |     | 0                   |       |
| resultText        | mediumtext    |      |     |                     |       |
| transformation    | int(11)       |      | PRI | 0                   |       |
| duration          | decimal(10,2) |      |     | -1.00               |       |
| cpuTime           | decimal(10,2) |      |     | -1.00               |       |
| exportCpuTime     | decimal(10,2) |      |     | -1.00               |       |
| handlerCpuTime    | decimal(10,2) |      |     | -1.00               |       |
| controlSha1       | varchar(42)   | YES  | MUL | NULL                |       |
| curStatus         | tinyint(4)    |      | MUL | 0                   |       |
| computationServer | int(11)       | YES  |     | NULL                |       |
| handlerPid        | int(11)       | YES  |     | NULL                |       |
| estimatedTime     | int(11)       |      |     | 60                  |       |
| maxCpu            | int(11)       |      |     | -1                  |       |
| maxRam            | double        |      |     | 67108864            |       |
| matrixSize        | double        |      |     | -1                  |       |
| queuePosition     | int(11)       | YES  | MUL | NULL                |       |
+-------------------+---------------+------+-----+---------------------+-------+
JobFile

+----------------+--------------+------+-----+---------+----------------+
| Field          | Type         | Null | Key | Default | Extra          |
+----------------+--------------+------+-----+---------+----------------+
| id             | int(11)      |      | PRI | NULL    | auto_increment |
| transformation | int(11)      |      | MUL | 0       |                |
| name           | varchar(255) |      |     |         |                |
| fileSize       | int(11)      |      |     | 0       |                |
+----------------+--------------+------+-----+---------+----------------+
JobFileSection

+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| jobFile      | int(11)     |      | PRI | 0       |       |
| fileSection  | int(11)     |      | PRI | 0       |       |
| sectionCount | smallint(6) |      |     | 0       |       |
+--------------+-------------+------+-----+---------+-------+
JobSetting

+----------------+------------+------+-----+---------+-------+
| Field          | Type       | Null | Key | Default | Extra |
+----------------+------------+------+-----+---------+-------+
| transformation | int(11)    |      | PRI | 0       |       |
| position       | tinyint(4) |      | PRI | 0       |       |
| setting        | text       |      |     |         |       |
+----------------+------------+------+-----+---------+-------+
Label

+-------------+-------------+------+-----+------------+----------------+
| Field       | Type        | Null | Key | Default    | Extra          |
+-------------+-------------+------+-----+------------+----------------+
| id          | int(11)     |      | PRI | NULL       | auto_increment |
| name        | varchar(80) |      | MUL |            |                |
| descr       | text        |      |     |            |                |
| owner       | int(11)     |      |     | 0          |                |
| addedDate   | date        |      |     | 0000-00-00 |                |
| removed     | tinyint(1)  |      |     | 0          |                |
| gid         | int(11)     |      |     | 0          |                |
| groupAccess | tinyint(1)  |      |     | 0          |                |
| worldAccess | tinyint(1)  |      |     | 0          |                |
+-------------+-------------+------+-----+------------+----------------+
LabeledExtract

+--------------+-------------+------+-----+------------+----------------+
| Field        | Type        | Null | Key | Default    | Extra          |
+--------------+-------------+------+-----+------------+----------------+
| id           | int(11)     |      | PRI | NULL       | auto_increment |
| owner        | int(11)     |      |     | 0          |                |
| name         | varchar(80) |      | MUL |            |                |
| descr        | text        |      |     |            |                |
| addedDate    | date        |      |     | 0000-00-00 |                |
| extract      | int(11)     |      | MUL | 0          |                |
| protocol     | int(11)     |      |     | 0          |                |
| labelingDate | date        |      |     | 0000-00-00 |                |
| quantity     | float       |      |     | 0          |                |
| quantityLeft | float       | YES  |     | NULL       |                |
| removed      | tinyint(1)  |      |     | 0          |                |
| gid          | int(11)     |      |     | 0          |                |
| groupAccess  | tinyint(1)  |      |     | 0          |                |
| worldAccess  | tinyint(1)  |      |     | 0          |                |
| label        | int(11)     |      |     | 0          |                |
+--------------+-------------+------+-----+------------+----------------+
News

+-----------+--------------+------+-----+---------------------+----------------+
| Field     | Type         | Null | Key | Default             | Extra          |
+-----------+--------------+------+-----+---------------------+----------------+
| id        | int(11)      |      | PRI | NULL                | auto_increment |
| name      | varchar(255) |      |     |                     |                |
| descr     | text         |      |     |                     |                |
| owner     | int(11)      |      |     | 0                   |                |
| addedDate | datetime     |      | MUL | 0000-00-00 00:00:00 |                |
| removed   | tinyint(1)   |      |     | 0                   |                |
+-----------+--------------+------+-----+---------------------+----------------+
Plate

+-------------+--------------+------+-----+------------+----------------+
| Field       | Type         | Null | Key | Default    | Extra          |
+-------------+--------------+------+-----+------------+----------------+
| id          | int(11)      |      | PRI | NULL       | auto_increment |
| plateType   | int(11)      |      |     | 0          |                |
| name        | varchar(255) | YES  | MUL | NULL       |                |
| descr       | text         |      |     |            |                |
| owner       | int(11)      |      |     | 0          |                |
| addedDate   | date         |      |     | 0000-00-00 |                |
| destroyed   | tinyint(1)   |      |     | 0          |                |
| barcode     | varchar(255) | YES  | MUL | NULL       |                |
| wizzzard    | int(11)      |      |     | 0          |                |
| removed     | tinyint(1)   |      |     | 3          |                |
| gid         | int(11)      |      |     | 0          |                |
| groupAccess | tinyint(1)   |      |     | 0          |                |
| worldAccess | tinyint(1)   |      |     | 0          |                |
+-------------+--------------+------+-----+------------+----------------+
PlateEvent

+-----------+---------+------+-----+------------+-------+
| Field     | Type    | Null | Key | Default    | Extra |
+-----------+---------+------+-----+------------+-------+
| plate     | int(11) |      | PRI | 0          |       |
| etype     | int(11) |      | PRI | 0          |       |
| eventDate | date    |      | MUL | 0000-00-00 |       |
| protocol  | int(11) |      |     | 0          |       |
+-----------+---------+------+-----+------------+-------+
PlateEventType

+--------------+-------------+------+-----+------------+----------------+
| Field        | Type        | Null | Key | Default    | Extra          |
+--------------+-------------+------+-----+------------+----------------+
| id           | int(11)     |      | PRI | NULL       | auto_increment |
| name         | varchar(80) |      |     |            |                |
| plateType    | int(11)     |      | MUL | 0          |                |
| protocolType | int(11)     |      |     | 0          |                |
| descr        | text        |      |     |            |                |
| addedDate    | date        |      |     | 0000-00-00 |                |
| owner        | int(11)     |      |     | 0          |                |
| removed      | tinyint(1)  |      |     | 0          |                |
+--------------+-------------+------+-----+------------+----------------+
PlateParent

+----------+------------+------+-----+---------+-------+
| Field    | Type       | Null | Key | Default | Extra |
+----------+------------+------+-----+---------+-------+
| parent   | int(11)    |      | MUL | 0       |       |
| plate    | int(11)    |      | MUL | 0       |       |
| position | tinyint(4) |      |     | 0       |       |
+----------+------------+------+-----+---------+-------+
PlateType

+----------------+-------------+------+-----+------------+----------------+
| Field          | Type        | Null | Key | Default    | Extra          |
+----------------+-------------+------+-----+------------+----------------+
| id             | int(11)     |      | PRI | NULL       | auto_increment |
| name           | varchar(80) |      | MUL |            |                |
| descr          | text        |      |     |            |                |
| owner          | int(11)     |      |     | 0          |                |
| addedDate      | date        |      |     | 0000-00-00 |                |
| wells          | smallint(6) |      |     | 0          |                |
| hasGrowth      | tinyint(1)  |      |     | 0          |                |
| hasSeqVerified | tinyint(1)  |      |     | 0          |                |
| hasBands       | tinyint(1)  |      |     | 0          |                |
| hasComment     | tinyint(1)  |      |     | 0          |                |
| namePrefix     | varchar(40) |      |     |            |                |
| parentSuffix   | tinyint(1)  |      |     | 0          |                |
| removed        | tinyint(1)  |      |     | 0          |                |
| gid            | int(11)     |      |     | 0          |                |
| groupAccess    | tinyint(1)  |      |     | 0          |                |
| worldAccess    | tinyint(1)  |      |     | 0          |                |
+----------------+-------------+------+-----+------------+----------------+
Preset

+-------------+---------------+------+-----+---------+-------+
| Field       | Type          | Null | Key | Default | Extra |
+-------------+---------------+------+-----+---------+-------+
| search      | int(11)       |      | PRI | 0       |       |
| searchType  | varchar(80)   |      |     |         |       |
| owner       | int(11)       |      | MUL | 0       |       |
| name        | varchar(80)   |      |     |         |       |
| lastTouched | timestamp(14) | YES  |     | NULL    |       |
+-------------+---------------+------+-----+---------+-------+
Probe

+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | int(11)      |      | PRI | NULL    | auto_increment |
| reporter | mediumint(9) |      |     | 0       |                |
+----------+--------------+------+-----+---------+----------------+
Program

+---------------+--------------+------+-----+------------+----------------+
| Field         | Type         | Null | Key | Default    | Extra          |
+---------------+--------------+------+-----+------------+----------------+
| id            | int(11)      |      | PRI | NULL       | auto_increment |
| execName      | varchar(255) |      |     |            |                |
| descr         | text         |      |     |            |                |
| addedDate     | date         |      |     | 0000-00-00 |                |
| owner         | int(11)      |      |     | 0          |                |
| name          | varchar(80)  |      | MUL |            |                |
| usedColumns   | text         |      |     |            |                |
| usedFields    | text         |      |     |            |                |
| onServer      | tinyint(1)   |      |     | 0          |                |
| geneAverages  | tinyint(1)   |      |     | 0          |                |
| serialFormat  | tinyint(1)   |      |     | 0          |                |
| url           | varchar(255) |      |     |            |                |
| removed       | tinyint(1)   |      |     | 0          |                |
| gid           | int(11)      |      |     | 0          |                |
| groupAccess   | tinyint(1)   |      |     | 0          |                |
| worldAccess   | tinyint(1)   |      |     | 0          |                |
| minChannels   | tinyint(4)   |      |     | 2          |                |
| leaveStdin    | tinyint(1)   |      |     | 0          |                |
| leaveStdout   | tinyint(1)   |      |     | 0          |                |
| maxChannels   | smallint(6)  |      |     | 0          |                |
| uniqueName    | varchar(255) |      |     |            |                |
| versionNumber | varchar(20)  |      |     |            |                |
| estimatedTime | int(11)      |      |     | 3600       |                |
| defaultMaxRam | double       |      |     | 134218000  |                |
+---------------+--------------+------+-----+------------+----------------+
ProgramParameter

+--------------+-----------------------------------+------+-----+---------+----------------+
| Field        | Type                              | Null | Key | Default | Extra          |
+--------------+-----------------------------------+------+-----+---------+----------------+
| program      | int(11)                           |      | PRI | 0       |                |
| position     | smallint(6)                       |      | PRI | NULL    | auto_increment |
| name         | varchar(80)                       |      |     |         |                |
| commonName   | varchar(80)                       |      |     |         |                |
| valueType    | enum('i','f','t','a','n','h','e') |      |     | i       |                |
| options      | text                              |      |     |         |                |
| defaultValue | text                              |      |     |         |                |
| enumOptions  | text                              |      |     |         |                |
| removed      | smallint(1)                       |      |     | 0       |                |
+--------------+-----------------------------------+------+-----+---------+----------------+
ProgramServer

+-------------------+---------+------+-----+---------+-------+
| Field             | Type    | Null | Key | Default | Extra |
+-------------------+---------+------+-----+---------+-------+
| program           | int(11) |      | PRI | 0       |       |
| computationServer | int(11) |      | PRI | 0       |       |
+-------------------+---------+------+-----+---------+-------+
Protocol

+--------------+--------------+------+-----+------------+----------------+
| Field        | Type         | Null | Key | Default    | Extra          |
+--------------+--------------+------+-----+------------+----------------+
| id           | int(11)      |      | PRI | NULL       | auto_increment |
| protocolType | int(11)      |      | MUL | 0          |                |
| name         | varchar(80)  |      |     |            |                |
| descr        | text         |      |     |            |                |
| owner        | int(11)      |      |     | 0          |                |
| addedDate    | date         |      |     | 0000-00-00 |                |
| removed      | tinyint(1)   |      |     | 0          |                |
| gid          | int(11)      |      |     | 0          |                |
| groupAccess  | tinyint(1)   |      |     | 0          |                |
| worldAccess  | tinyint(1)   |      |     | 0          |                |
| fileSize     | int(11)      |      |     | 0          |                |
| filename     | varchar(255) | YES  |     | NULL       |                |
+--------------+--------------+------+-----+------------+----------------+
ProtocolType

+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(11)     |      | PRI | NULL    | auto_increment |
| name  | varchar(80) |      | UNI |         |                |
+-------+-------------+------+-----+---------+----------------+
RawBioAssay

+------------------+--------------+------+-----+------------+----------------+
| Field            | Type         | Null | Key | Default    | Extra          |
+------------------+--------------+------+-----+------------+----------------+
| id               | int(11)      |      | PRI | NULL       | auto_increment |
| name             | varchar(80)  |      |     |            |                |
| descr            | text         |      |     |            |                |
| owner            | int(11)      |      |     | 0          |                |
| addedDate        | date         |      |     | 0000-00-00 |                |
| imageAcquisition | int(11)      |      | MUL | 0          |                |
| featureDate      | date         |      |     | 0000-00-00 |                |
| featureSoftware  | int(11)      |      |     | 0          |                |
| filename         | varchar(255) |      |     |            |                |
| spots            | mediumint(9) |      |     | 0          |                |
| hasSpotImages    | tinyint(1)   |      |     | 0          |                |
| spotImagePixels  | smallint(6)  |      |     | 15         |                |
| spotImageOffsetX | float        |      |     | 0          |                |
| spotImageOffsetY | float        |      |     | 0          |                |
| spotImageScale   | float        |      |     | 1          |                |
| wizzzard         | int(11)      |      |     | 0          |                |
| removed          | tinyint(1)   |      |     | 3          |                |
| gid              | int(11)      |      |     | 0          |                |
| groupAccess      | tinyint(1)   |      |     | 0          |                |
| worldAccess      | tinyint(1)   |      |     | 0          |                |
| arrayType        | int(11)      | YES  |     | NULL       |                |
| positionMode     | tinyint(4)   |      |     | 0          |                |
+------------------+--------------+------+-----+------------+----------------+
RawBioAssayData

+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| rawBioAssay | mediumint(9) |      | PRI | 0       |       |
| position    | mediumint(9) |      | PRI | 0       |       |
| element     | mediumint(9) |      |     | 0       |       |
| reporter    | mediumint(9) |      |     | 0       |       |
| block       | smallint(6)  | YES  |     | NULL    |       |
| numCol      | tinyint(4)   | YES  |     | NULL    |       |
| numRow      | tinyint(4)   | YES  |     | NULL    |       |
| x           | float        |      |     | 0       |       |
| y           | float        |      |     | 0       |       |
| dia         | float        | YES  |     | NULL    |       |
| FCh1Median  | float        | YES  |     | NULL    |       |
| FCh1Mean    | float        | YES  |     | NULL    |       |
| FCh1SD      | float        | YES  |     | NULL    |       |
| BCh1Median  | float        | YES  |     | NULL    |       |
| BCh1Mean    | float        | YES  |     | NULL    |       |
| BCh1SD      | float        | YES  |     | NULL    |       |
| percCh1SD1  | tinyint(4)   | YES  |     | NULL    |       |
| percCh1SD2  | tinyint(4)   | YES  |     | NULL    |       |
| percCh1Sat  | tinyint(4)   | YES  |     | NULL    |       |
| FCh2Median  | float        | YES  |     | NULL    |       |
| FCh2Mean    | float        | YES  |     | NULL    |       |
| FCh2SD      | float        | YES  |     | NULL    |       |
| BCh2Median  | float        | YES  |     | NULL    |       |
| BCh2Mean    | float        | YES  |     | NULL    |       |
| BCh2SD      | float        | YES  |     | NULL    |       |
| percCh2SD1  | tinyint(4)   | YES  |     | NULL    |       |
| percCh2SD2  | tinyint(4)   | YES  |     | NULL    |       |
| percCh2Sat  | tinyint(4)   | YES  |     | NULL    |       |
| ratiosSD    | float        | YES  |     | NULL    |       |
| rgnRatio    | float        | YES  |     | NULL    |       |
| rgnR2       | float        | YES  |     | NULL    |       |
| FPixels     | smallint(6)  | YES  |     | NULL    |       |
| BPixels     | smallint(6)  | YES  |     | NULL    |       |
| flags       | tinyint(4)   | YES  |     | NULL    |       |
| MValue      | float        | YES  |     | NULL    |       |
| CV          | float        | YES  |     | NULL    |       |
+-------------+--------------+------+-----+---------+-------+
RawBioAssayHeader

+-------------+------------+------+-----+---------+-------+
| Field       | Type       | Null | Key | Default | Extra |
+-------------+------------+------+-----+---------+-------+
| rawBioAssay | int(11)    |      | PRI | 0       |       |
| fileHeader  | mediumtext |      |     |         |       |
+-------------+------------+------+-----+---------+-------+
Reporter

+---------------+--------------+------+-----+---------------------+----------------+
| Field         | Type         | Null | Key | Default             | Extra          |
+---------------+--------------+------+-----+---------------------+----------------+
| id            | mediumint(9) |      | PRI | NULL                | auto_increment |
| reporterId    | varchar(255) |      | UNI |                     |                |
| species       | varchar(255) |      |     |                     |                |
| clusterId     | int(11)      |      |     | 0                   |                |
| geneName      | varchar(255) |      | MUL |                     |                |
| geneSymbol    | varchar(255) |      |     |                     |                |
| lastUpdate    | datetime     |      |     | 0000-00-00 00:00:00 |                |
| length        | int(11)      | YES  |     | 0                   |                |
| sequence      | text         | YES  |     | NULL                |                |
| vector        | text         | YES  |     | NULL                |                |
| tissue        | text         | YES  |     | NULL                |                |
| library       | text         | YES  |     | NULL                |                |
| accession     | varchar(255) | YES  |     | NULL                |                |
| nid           | varchar(255) | YES  |     | NULL                |                |
| chromosome    | varchar(255) | YES  |     | NULL                |                |
| cytoBand      | varchar(255) | YES  |     | NULL                |                |
| markers       | varchar(255) | YES  |     | NULL                |                |
| antibiotics   | varchar(255) | YES  |     | NULL                |                |
| locusLink     | int(11)      | YES  |     | 0                   |                |
| omim          | int(11)      | YES  |     | 0                   |                |
| startPosition | int(11)      | YES  |     | 0                   |                |
| endPosition   | int(11)      | YES  |     | 0                   |                |
+---------------+--------------+------+-----+---------------------+----------------+
ReporterList

+------------+-------------+------+-----+------------+----------------+
| Field      | Type        | Null | Key | Default    | Extra          |
+------------+-------------+------+-----+------------+----------------+
| id         | int(11)     |      | PRI | NULL       | auto_increment |
| name       | varchar(80) |      |     |            |                |
| descr      | text        |      |     |            |                |
| owner      | int(11)     |      |     | 0          |                |
| addedDate  | date        |      |     | 0000-00-00 |                |
| experiment | int(11)     |      | MUL | 0          |                |
| reporters  | int(11)     |      |     | 0          |                |
| removed    | tinyint(1)  |      |     | 3          |                |
+------------+-------------+------+-----+------------+----------------+
Sample

+-------------+-------------+------+-----+------------+----------------+
| Field       | Type        | Null | Key | Default    | Extra          |
+-------------+-------------+------+-----+------------+----------------+
| id          | int(11)     |      | PRI | NULL       | auto_increment |
| name        | varchar(80) |      | MUL |            |                |
| descr       | text        |      |     |            |                |
| tissue      | int(11)     |      |     | 0          |                |
| owner       | int(11)     |      |     | 0          |                |
| addedDate   | date        |      |     | 0000-00-00 |                |
| sampleDate  | date        |      |     | 0000-00-00 |                |
| removed     | tinyint(1)  |      |     | 0          |                |
| gid         | int(11)     |      |     | 0          |                |
| groupAccess | tinyint(1)  |      |     | 0          |                |
| worldAccess | tinyint(1)  |      |     | 0          |                |
+-------------+-------------+------+-----+------------+----------------+
SampleAnnotation

+----------------+---------+------+-----+---------+-------+
| Field          | Type    | Null | Key | Default | Extra |
+----------------+---------+------+-----+---------+-------+
| sample         | int(11) |      | PRI | 0       |       |
| annotationType | int(11) |      | PRI | 0       |       |
| annotation     | text    |      |     |         |       |
+----------------+---------+------+-----+---------+-------+
SampleAnnotationType

+--------------+-----------------------+------+-----+------------+----------------+
| Field        | Type                  | Null | Key | Default    | Extra          |
+--------------+-----------------------+------+-----+------------+----------------+
| id           | int(11)               |      | PRI | NULL       | auto_increment |
| name         | varchar(80)           |      | MUL |            |                |
| valueType    | enum('i','f','t','e') |      |     | i          |                |
| options      | text                  |      |     |            |                |
| defaultValue | text                  |      |     |            |                |
| descr        | text                  |      |     |            |                |
| owner        | int(11)               |      |     | 0          |                |
| addedDate    | date                  |      |     | 0000-00-00 |                |
| removed      | tinyint(1)            |      |     | 0          |                |
| gid          | int(11)               |      |     | 0          |                |
| groupAccess  | tinyint(1)            |      |     | 0          |                |
| worldAccess  | tinyint(1)            |      |     | 0          |                |
+--------------+-----------------------+------+-----+------------+----------------+
SampleTissue

+-----------+-------------+------+-----+------------+----------------+
| Field     | Type        | Null | Key | Default    | Extra          |
+-----------+-------------+------+-----+------------+----------------+
| id        | int(11)     |      | PRI | NULL       | auto_increment |
| parent    | int(11)     |      | MUL | 0          |                |
| name      | varchar(80) |      |     |            |                |
| descr     | text        |      |     |            |                |
| owner     | int(11)     |      |     | 0          |                |
| addedDate | date        |      |     | 0000-00-00 |                |
| removed   | tinyint(1)  |      |     | 0          |                |
+-----------+-------------+------+-----+------------+----------------+
SchemaVersion

+---------------+----------+------+-----+---------------------+-------+
| Field         | Type     | Null | Key | Default             | Extra |
+---------------+----------+------+-----+---------------------+-------+
| baseVersion   | tinytext |      |     |                     |       |
| schemaVersion | tinytext |      |     |                     |       |
| lastChanged   | datetime |      |     | 0000-00-00 00:00:00 |       |
+---------------+----------+------+-----+---------------------+-------+
Search

+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| id          | int(11)     |      | PRI | NULL    | auto_increment |
| sortField   | varchar(80) |      |     |         |                |
| sortDesc    | tinyint(1)  |      |     | 0       |                |
| currentPage | smallint(6) |      |     | 0       |                |
+-------------+-------------+------+-----+---------+----------------+
SearchCriterion

+--------------+-------------+------+-----+---------+----------------+
| Field        | Type        | Null | Key | Default | Extra          |
+--------------+-------------+------+-----+---------+----------------+
| search       | int(11)     |      | PRI | 0       |                |
| position     | smallint(6) |      | PRI | NULL    | auto_increment |
| field        | varchar(80) |      |     |         |                |
| op           | tinyint(4)  |      |     | 0       |                |
| searchString | text        |      |     |         |                |
+--------------+-------------+------+-----+---------+----------------+
Software

+-------------+-------------+------+-----+------------+----------------+
| Field       | Type        | Null | Key | Default    | Extra          |
+-------------+-------------+------+-----+------------+----------------+
| id          | int(11)     |      | PRI | NULL       | auto_increment |
| name        | varchar(80) |      | MUL |            |                |
| descr       | text        |      |     |            |                |
| owner       | int(11)     |      |     | 0          |                |
| addedDate   | date        |      |     | 0000-00-00 |                |
| version     | varchar(80) |      |     |            |                |
| removed     | tinyint(1)  |      |     | 0          |                |
| gid         | int(11)     |      |     | 0          |                |
| groupAccess | tinyint(1)  |      |     | 0          |                |
| worldAccess | tinyint(1)  |      |     | 0          |                |
+-------------+-------------+------+-----+------------+----------------+
TemplateBioAssayData

+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| bioAssay   | mediumint(9) |      | PRI | 0       |       |
| position   | mediumint(9) |      | PRI | 0       |       |
| reporter   | mediumint(9) |      |     | 0       |       |
| intensity1 | float        |      |     | 0       |       |
+------------+--------------+------+-----+---------+-------+
TemplateBioAssayExtraFloat

+-----------------+--------------+------+-----+---------+-------+
| Field           | Type         | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| bioAssay        | mediumint(9) |      | PRI | 0       |       |
| position        | mediumint(9) |      | PRI | 0       |       |
| extraDataColumn | smallint(6)  |      | PRI | 0       |       |
| extraValue      | float        | YES  |     | NULL    |       |
+-----------------+--------------+------+-----+---------+-------+
TemplateBioAssayExtraString

+-----------------+--------------+------+-----+---------+-------+
| Field           | Type         | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+-------+
| bioAssay        | mediumint(9) |      | PRI | 0       |       |
| position        | mediumint(9) |      | PRI | 0       |       |
| extraDataColumn | smallint(6)  |      | PRI | 0       |       |
| extraValue      | mediumtext   | YES  |     | NULL    |       |
+-----------------+--------------+------+-----+---------+-------+
TemplateBioAssaySetGene

+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| bioAssaySet | mediumint(9) |      | PRI | 0       |       |
| reporter    | mediumint(9) |      | PRI | 0       |       |
| cnt         | smallint(11) |      |     | 0       |       |
+-------------+--------------+------+-----+---------+-------+
TemplateBioAssaySetPosGene

+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| bioAssaySet | mediumint(9) |      | PRI | 0       |       |
| reporter    | mediumint(9) |      | PRI | 0       |       |
| position    | mediumint(9) |      | PRI | 0       |       |
| cnt         | smallint(11) |      |     | 0       |       |
+-------------+--------------+------+-----+---------+-------+
TemplateReporterListRow

+--------------+--------------+------+-----+---------+-------+
| Field        | Type         | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| reporterList | mediumint(9) |      | PRI | 0       |       |
| reporter     | mediumint(9) |      | PRI | 0       |       |
| score        | float        |      |     | 0       |       |
+--------------+--------------+------+-----+---------+-------+
Transformation

+-------------+-------------+------+-----+------------+----------------+
| Field       | Type        | Null | Key | Default    | Extra          |
+-------------+-------------+------+-----+------------+----------------+
| id          | int(11)     |      | PRI | NULL       | auto_increment |
| name        | varchar(80) |      |     |            |                |
| descr       | text        |      |     |            |                |
| owner       | int(11)     |      |     | 0          |                |
| addedDate   | date        |      |     | 0000-00-00 |                |
| bioAssaySet | int(11)     |      | MUL | 0          |                |
| isFilter    | tinyint(1)  |      |     | 0          |                |
| removed     | tinyint(1)  |      |     | 3          |                |
+-------------+-------------+------+-----+------------+----------------+
TransformationCollapse

+----------------+---------+------+-----+---------+-------+
| Field          | Type    | Null | Key | Default | Extra |
+----------------+---------+------+-----+---------+-------+
| owner          | int(11) |      | PRI | 0       |       |
| transformation | int(11) |      | PRI | 0       |       |
+----------------+---------+------+-----+---------+-------+
TransformationSearch

+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| item       | int(11)     |      | MUL | 0       |       |
| searchType | varchar(80) |      |     |         |       |
| search     | int(11)     |      | PRI | 0       |       |
+------------+-------------+------+-----+---------+-------+
Upload

+-------------+--------------+------+-----+---------------------+----------------+
| Field       | Type         | Null | Key | Default             | Extra          |
+-------------+--------------+------+-----+---------------------+----------------+
| id          | int(11)      |      | PRI | NULL                | auto_increment |
| owner       | int(11)      |      | MUL | 0                   |                |
| name        | varchar(255) | YES  |     | NULL                |                |
| fileSize    | int(11)      |      |     | 0                   |                |
| descr       | text         |      |     |                     |                |
| addedDate   | datetime     |      |     | 0000-00-00 00:00:00 |                |
| mimeType    | varchar(100) |      |     |                     |                |
| removed     | tinyint(1)   |      |     | 3                   |                |
| gid         | int(11)      |      |     | 0                   |                |
| groupAccess | tinyint(1)   |      |     | 0                   |                |
| worldAccess | tinyint(1)   |      |     | 0                   |                |
+-------------+--------------+------+-----+---------------------+----------------+
UserAccount

+----------------------+--------------+------+-----+------------+-------+
| Field                | Type         | Null | Key | Default    | Extra |
+----------------------+--------------+------+-----+------------+-------+
| userGroup            | int(11)      |      | PRI | 0          |       |
| email                | varchar(255) |      |     |            |       |
| address              | text         |      |     |            |       |
| phone                | varchar(60)  |      |     |            |       |
| fax                  | varchar(60)  |      |     |            |       |
| realName             | varchar(80)  |      |     |            |       |
| md5Pass              | varchar(40)  |      |     |            |       |
| activeUntil          | date         |      |     | 9999-12-31 |       |
| fileQuota            | double       |      |     | -1         |       |
| lastExperiment       | int(11)      |      |     | 0          |       |
| lastExploredSet      | int(11)      |      |     | 0          |       |
| lastPlateType        | int(11)      |      |     | 0          |       |
| lastPlateTypeCreated | int(11)      |      |     | 0          |       |
| defaultGid           | int(11)      |      |     | 0          |       |
| defaultGroupAccess   | tinyint(1)   |      |     | 0          |       |
| defaultWorldAccess   | tinyint(1)   |      |     | 0          |       |
+----------------------+--------------+------+-----+------------+-------+
UserGroup

Class: MigrateUser

+------------+-------------+------+-----+------------+----------------+
| Field      | Type        | Null | Key | Default    | Extra          |
+------------+-------------+------+-----+------------+----------------+
| id         | int(11)     |      | PRI | NULL       | auto_increment |
| name       | varchar(30) | YES  | MUL | NULL       |                |
| descr      | text        |      |     |            |                |
| owner      | int(11)     |      |     | 0          |                |
| addedDate  | date        |      |     | 0000-00-00 |                |
| removed    | tinyint(1)  |      |     | 0          |                |
| accessMask | int(11)     |      |     | 0          |                |
| isAccount  | tinyint(1)  |      |     | 0          |                |
+------------+-------------+------+-----+------------+----------------+
UserGroupParent

+------------+------------+------+-----+---------+-------+
| Field      | Type       | Null | Key | Default | Extra |
+------------+------------+------+-----+---------+-------+
| child      | int(11)    |      | PRI | 0       |       |
| parent     | int(11)    |      | PRI | 0       |       |
| isReviewer | tinyint(1) |      |     | 0       |       |
+------------+------------+------+-----+---------+-------+
UserSearch

+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| item       | int(11)     |      | MUL | 0       |       |
| searchType | varchar(80) |      |     |         |       |
| search     | int(11)     |      | PRI | 0       |       |
+------------+-------------+------+-----+---------+-------+
Well

+-----------------+------------------------------------+------+-----+---------+----------------+
| Field           | Type                               | Null | Key | Default | Extra          |
+-----------------+------------------------------------+------+-----+---------+----------------+
| id              | int(11)                            |      | PRI | NULL    | auto_increment |
| parent          | int(11)                            |      |     | 0       |                |
| plate           | mediumint(9)                       |      | MUL | 0       |                |
| x               | smallint(6)                        |      |     | 0       |                |
| y               | smallint(6)                        |      |     | 0       |                |
| probe           | int(11)                            |      | MUL | 0       |                |
| seqVerified     | enum('','good','bad','failed')     |      |     |         |                |
| bands           | enum('','good','missing','double') |      |     |         |                |
| bacterialGrowth | enum('','yes','no')                |      |     |         |                |
| comment         | text                               |      |     |         |                |
+-----------------+------------------------------------+------+-----+---------+----------------+
WellAncestor

+----------+-------------+------+-----+---------+-------+
| Field    | Type        | Null | Key | Default | Extra |
+----------+-------------+------+-----+---------+-------+
| well     | int(11)     |      | PRI | 0       |       |
| ancestor | int(11)     |      | PRI | 0       |       |
| depth    | smallint(6) |      |     | 0       |       |
+----------+-------------+------+-----+---------+-------+
Wizzzard

+----------------+-------------+------+-----+------------+----------------+
| Field          | Type        | Null | Key | Default    | Extra          |
+----------------+-------------+------+-----+------------+----------------+
| id             | int(11)     |      | PRI | NULL       | auto_increment |
| owner          | int(11)     |      |     | 0          |                |
| formatType     | varchar(40) |      | MUL |            |                |
| name           | varchar(80) |      |     |            |                |
| minCols        | smallint(6) |      |     | 0          |                |
| maxCols        | smallint(6) |      |     | 0          |                |
| dataHeader     | text        |      |     |            |                |
| typeHeader     | text        |      |     |            |                |
| typeHeaderLine | int(11)     |      |     | 0          |                |
| mapping        | mediumtext  |      |     |            |                |
| descr          | text        |      |     |            |                |
| addedDate      | date        |      |     | 0000-00-00 |                |
| removed        | tinyint(1)  |      |     | 0          |                |
| gid            | int(11)     |      |     | 0          |                |
| groupAccess    | tinyint(1)  |      |     | 0          |                |
| worldAccess    | tinyint(1)  |      |     | 0          |                |
| dataFooter     | text        | YES  |     | NULL       |                |
| fieldSeparator | varchar(10) |      |     | 	         |                |
| maxHeaderLine  | int(11)     |      |     | 120        |                |
+----------------+-------------+------+-----+------------+----------------+