Context Navigation

base1Tables.html @ 4394

Visit:

Last change on this file since 4394 was 3679, checked in by Jari Häkkinen, 16 years ago
Changing the pesky "a (ä) character to a.
Property svn:eol-style set to `native` Property svn:keywords set to `Id Date`
File size: 82.9 KB

Line
1	<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
2	<!--
3	$Id: base1Tables.html 3679 2007-08-17 07:18:29Z jari $
4
5	Copyright (C) 2005 Gregory Vincic
6	Copyright (C) 2006 Jari Hakkinen
7
8	This file is part of BASE - BioArray Software Environment.
9	Available at http://base.thep.lu.se/
10
11	BASE is free software; you can redistribute it and/or
12	modify it under the terms of the GNU General Public License
13	as published by the Free Software Foundation; either version 2
14	of the License, or (at your option) any later version.
15
16	BASE is distributed in the hope that it will be useful,
17	but WITHOUT ANY WARRANTY; without even the implied warranty of
18	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
19	GNU General Public License for more details.
20
21	You should have received a copy of the GNU General Public License
22	along with this program; if not, write to the Free Software
23	Foundation, Inc., 59 Temple Place - Suite 330,
24	Boston, MA 02111-1307, USA.
25	-->
26	<html>
27	<head>
28	<title>BASE - Migration tool specifications</title>
29	<link rel=stylesheet type="text/css" href="../../styles.css">
30	<style type="text/css">
31	body {
32	width: auto;
33	font-family: auto;
34	font-size: 1em;
35	}
36
37	td {
38	width: 30%;
39	}
40
41	table {
42	margin-left: 20px;
43	}
44	</style>
45	</head>
46	<body>
47	<div class="navigation">
48	<a href="../../index.html">BASE</a>
49	<img src="../../next.gif">
50	<a href="index.html">Migration tool specifications</a>
51	<img src="../../next.gif">
52	Base1 Tables
53	</div>
54
55
56
57	<a name="top">
58	<h1>Base1 Tables</h1>
59	</a>
60
61
62	<table>
63	<tr>
64
65	<td valign="top">
66	<a href="#ArrayBatch">ArrayBatch</a><br/>
67	<a href="#ArrayBlock">ArrayBlock</a><br/>
68	<a href="#ArraySlide">ArraySlide</a><br/>
69	<a href="#ArrayType">ArrayType</a><br/>
70	<a href="#ArrayTypePlate">ArrayTypePlate</a><br/>
71	<a href="#BaseControl">BaseControl</a><br/>
72	<a href="#BaseFileSection">BaseFileSection</a><br/>
73	<a href="#BioAssay">BioAssay</a><br/>
74	<a href="#BioAssayOrigin">BioAssayOrigin</a><br/>
75	<a href="#BioAssayParent">BioAssayParent</a><br/>
76	<a href="#BioAssaySample">BioAssaySample</a><br/>
77	<a href="#BioAssaySet">BioAssaySet</a><br/>
78	<a href="#BioAssaySetExplore">BioAssaySetExplore</a><br/>
79	<a href="#BioAssaySetExtraColumn">BioAssaySetExtraColumn</a><br/>
80	<a href="#BioAssaySetSearch">BioAssaySetSearch</a><br/>
81	<a href="#ComputationServer">ComputationServer</a><br/>
82	<a href="#Cookie">Cookie</a><br/>
83	<a href="#EventLog">EventLog</a><br/>
84	<a href="#Experiment">Experiment</a><br/>
85	<a href="#ExperimentExplore">ExperimentExplore</a><br/>
86	<a href="#ExperimentRawBioAssay">ExperimentRawBioAssay</a><br/>
87	<a href="#ExtraDataColumn">ExtraDataColumn</a><br/>
88	<a href="#Extract">Extract</a><br/>
89	<a href="#Feature">Feature</a><br/>
90	<a href="#Hardware">Hardware</a><br/>
91	<a href="#Hybridization">Hybridization</a><br/>
92	<a href="#HybridizedLabeled">HybridizedLabeled</a><br/>
93	</td><td valign="top">
94	<a href="#Image">Image</a><br/>
95	<a href="#ImageAcquisition">ImageAcquisition</a><br/>
96	<a href="#Item">Item</a><br/>
97	<a href="#Job">Job</a><br/>
98	<a href="#JobFile">JobFile</a><br/>
99	<a href="#JobFileSection">JobFileSection</a><br/>
100	<a href="#JobSetting">JobSetting</a><br/>
101	<a href="#Label">Label</a><br/>
102	<a href="#LabeledExtract">LabeledExtract</a><br/>
103	<a href="#News">News</a><br/>
104	<a href="#Plate">Plate</a><br/>
105	<a href="#PlateEvent">PlateEvent</a><br/>
106	<a href="#PlateEventType">PlateEventType</a><br/>
107	<a href="#PlateParent">PlateParent</a><br/>
108	<a href="#PlateType">PlateType</a><br/>
109	<a href="#Preset">Preset</a><br/>
110	<a href="#Probe">Probe</a><br/>
111	<a href="#Program">Program</a><br/>
112	<a href="#ProgramParameter">ProgramParameter</a><br/>
113	<a href="#ProgramServer">ProgramServer</a><br/>
114	<a href="#Protocol">Protocol</a><br/>
115	<a href="#ProtocolType">ProtocolType</a><br/>
116	<a href="#RawBioAssay">RawBioAssay</a><br/>
117	<a href="#RawBioAssayData">RawBioAssayData</a><br/>
118	<a href="#RawBioAssayHeader">RawBioAssayHeader</a><br/>
119	<a href="#Reporter">Reporter</a><br/>
120	<a href="#ReporterList">ReporterList</a><br/>
121	</td><td valign="top">
122	<a href="#Sample">Sample</a><br/>
123	<a href="#SampleAnnotation">SampleAnnotation</a><br/>
124	<a href="#SampleAnnotationType">SampleAnnotationType</a><br/>
125	<a href="#SampleTissue">SampleTissue</a><br/>
126	<a href="#SchemaVersion">SchemaVersion</a><br/>
127	<a href="#Search">Search</a><br/>
128	<a href="#SearchCriterion">SearchCriterion</a><br/>
129	<a href="#Software">Software</a><br/>
130	<a href="#TemplateBioAssayData">TemplateBioAssayData</a><br/>
131	<a href="#TemplateBioAssayExtraFloat">TemplateBioAssayExtraFloat</a><br/>
132	<a href="#TemplateBioAssayExtraString">TemplateBioAssayExtraString</a><br/>
133	<a href="#TemplateBioAssaySetGene">TemplateBioAssaySetGene</a><br/>
134	<a href="#TemplateBioAssaySetPosGene">TemplateBioAssaySetPosGene</a><br/>
135	<a href="#TemplateReporterListRow">TemplateReporterListRow</a><br/>
136	<a href="#Transformation">Transformation</a><br/>
137	<a href="#TransformationCollapse">TransformationCollapse</a><br/>
138	<a href="#TransformationSearch">TransformationSearch</a><br/>
139	<a href="#Upload">Upload</a><br/>
140	<a href="#UserAccount">UserAccount</a><br/>
141	<a href="#UserGroup">UserGroup</a><br/>
142	<a href="#UserGroupParent">UserGroupParent</a><br/>
143	<a href="#UserSearch">UserSearch</a><br/>
144	<a href="#Well">Well</a><br/>
145	<a href="#WellAncestor">WellAncestor</a><br/>
146	<a href="#Wizzzard">Wizzzard</a><br/>
147
148	</td>
149
150	</tr>
151	</table>
152
153
154	<br clear="all"/>
155	<hr/>
156
157
158
159	<a name="ArrayBatch"/>
160	<a href="#top">ArrayBatch</a>
161	<p></p>
162	<pre class="code">+----------------+--------------+------+-----+---------------------+----------------+
163	\| Field \| Type \| Null \| Key \| Default \| Extra \|
164	+----------------+--------------+------+-----+---------------------+----------------+
165	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
166	\| arrayType \| int(11) \| \| MUL \| 0 \| \|
167	\| descr \| text \| \| \| \| \|
168	\| printStartDate \| datetime \| \| \| 0000-00-00 00:00:00 \| \|
169	\| printEndDate \| datetime \| \| \| 0000-00-00 00:00:00 \| \|
170	\| owner \| int(11) \| \| \| 0 \| \|
171	\| name \| varchar(80) \| \| MUL \| \| \|
172	\| addedDate \| date \| \| \| 0000-00-00 \| \|
173	\| surfaceType \| varchar(255) \| \| \| \| \|
174	\| protocol \| int(11) \| \| \| 0 \| \|
175	\| notes \| text \| \| \| \| \|
176	\| removed \| tinyint(1) \| \| \| 0 \| \|
177	\| gid \| int(11) \| \| \| 0 \| \|
178	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
179	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
180	+----------------+--------------+------+-----+---------------------+----------------+</pre>
181
182
183	<a name="ArrayBlock"/>
184	<a href="#top">ArrayBlock</a>
185	<p></p>
186	<pre class="code">+-----------------+-------------+------+-----+---------+-------+
187	\| Field \| Type \| Null \| Key \| Default \| Extra \|
188	+-----------------+-------------+------+-----+---------+-------+
189	\| arrayType \| int(11) \| \| PRI \| 0 \| \|
190	\| blockNum \| smallint(6) \| \| PRI \| 0 \| \|
191	\| xOrigin \| float \| \| \| 0 \| \|
192	\| yOrigin \| float \| \| \| 0 \| \|
193	\| featureDiameter \| float \| \| \| 0 \| \|
194	\| xFeatures \| float \| \| \| 0 \| \|
195	\| xSpacing \| float \| \| \| 0 \| \|
196	\| yFeatures \| float \| \| \| 0 \| \|
197	\| ySpacing \| float \| \| \| 0 \| \|
198	\| metaRow \| smallint(6) \| \| \| 0 \| \|
199	\| metaColumn \| smallint(6) \| \| \| 0 \| \|
200	+-----------------+-------------+------+-----+---------+-------+</pre>
201
202
203	<a name="ArraySlide"/>
204	<a href="#top">ArraySlide</a>
205	<p></p>
206	<pre class="code">+---------------+-------------+------+-----+------------+----------------+
207	\| Field \| Type \| Null \| Key \| Default \| Extra \|
208	+---------------+-------------+------+-----+------------+----------------+
209	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
210	\| batch \| int(11) \| \| MUL \| 0 \| \|
211	\| orderNumber \| smallint(6) \| \| \| 0 \| \|
212	\| name \| varchar(80) \| YES \| MUL \| NULL \| \|
213	\| destroyed \| tinyint(1) \| \| \| 0 \| \|
214	\| hybridization \| int(11) \| YES \| MUL \| NULL \| \|
215	\| descr \| text \| \| \| \| \|
216	\| owner \| int(11) \| \| \| 0 \| \|
217	\| addedDate \| date \| \| \| 0000-00-00 \| \|
218	\| removed \| tinyint(1) \| \| \| 0 \| \|
219	\| gid \| int(11) \| \| \| 0 \| \|
220	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
221	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
222	+---------------+-------------+------+-----+------------+----------------+</pre>
223
224
225	<a name="ArrayType"/>
226	<a href="#top">ArrayType</a>
227	<p></p>
228	<pre class="code">+---------------+--------------+------+-----+------------+----------------+
229	\| Field \| Type \| Null \| Key \| Default \| Extra \|
230	+---------------+--------------+------+-----+------------+----------------+
231	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
232	\| owner \| int(11) \| \| \| 0 \| \|
233	\| name \| varchar(80) \| \| MUL \| \| \|
234	\| platform \| varchar(255) \| \| \| \| \|
235	\| protocol \| int(11) \| \| \| 0 \| \|
236	\| descr \| text \| \| \| \| \|
237	\| addedDate \| date \| \| \| 0000-00-00 \| \|
238	\| printed \| tinyint(1) \| \| \| 0 \| \|
239	\| printMapName \| varchar(255) \| \| \| \| \|
240	\| removed \| tinyint(1) \| \| \| 0 \| \|
241	\| gid \| int(11) \| \| \| 0 \| \|
242	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
243	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
244	\| featureLock \| smallint(6) \| \| \| 0 \| \|
245	\| featureCount \| int(11) \| \| \| 0 \| \|
246	\| blankFeatures \| int(11) \| \| \| 0 \| \|
247	+---------------+--------------+------+-----+------------+----------------+</pre>
248
249
250	<a name="ArrayTypePlate"/>
251	<a href="#top">ArrayTypePlate</a>
252	<p></p>
253	<pre class="code">+-----------+-------------+------+-----+---------+-------+
254	\| Field \| Type \| Null \| Key \| Default \| Extra \|
255	+-----------+-------------+------+-----+---------+-------+
256	\| arrayType \| int(11) \| \| PRI \| 0 \| \|
257	\| plate \| int(11) \| \| \| 0 \| \|
258	\| position \| smallint(6) \| \| PRI \| 0 \| \|
259	+-----------+-------------+------+-----+---------+-------+</pre>
260
261
262	<a name="BaseControl"/>
263	<a href="#top">BaseControl</a>
264	<p></p>
265	<pre class="code">+----------------------+------------+------+-----+---------------------+-------+
266	\| Field \| Type \| Null \| Key \| Default \| Extra \|
267	+----------------------+------------+------+-----+---------------------+-------+
268	\| startTime \| datetime \| \| \| 0000-00-00 00:00:00 \| \|
269	\| shutDown \| tinyint(4) \| \| \| 0 \| \|
270	\| pendingTransactions \| int(11) \| \| \| 0 \| \|
271	\| finishedTransactions \| int(11) \| \| \| 0 \| \|
272	\| startedScripts \| int(11) \| \| \| 0 \| \|
273	+----------------------+------------+------+-----+---------------------+-------+</pre>
274
275
276	<a name="BaseFileSection"/>
277	<a href="#top">BaseFileSection</a>
278	<p></p>
279	<pre class="code">+-------+--------------+------+-----+---------+----------------+
280	\| Field \| Type \| Null \| Key \| Default \| Extra \|
281	+-------+--------------+------+-----+---------+----------------+
282	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
283	\| name \| varchar(255) \| \| UNI \| \| \|
284	+-------+--------------+------+-----+---------+----------------+</pre>
285
286
287	<a name="BioAssay"/>
288	<a href="#top">BioAssay</a>
289	<p></p>
290	<pre class="code">+-------------+--------------+------+-----+------------+----------------+
291	\| Field \| Type \| Null \| Key \| Default \| Extra \|
292	+-------------+--------------+------+-----+------------+----------------+
293	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
294	\| name \| varchar(80) \| \| \| \| \|
295	\| descr \| text \| \| \| \| \|
296	\| owner \| int(11) \| \| \| 0 \| \|
297	\| addedDate \| date \| \| \| 0000-00-00 \| \|
298	\| bioAssaySet \| int(11) \| \| MUL \| 0 \| \|
299	\| experiment \| int(11) \| \| \| 0 \| \|
300	\| spots \| mediumint(9) \| \| \| 0 \| \|
301	\| removed \| tinyint(1) \| \| \| 3 \| \|
302	\| channels \| tinyint(4) \| \| \| 2 \| \|
303	+-------------+--------------+------+-----+------------+----------------+</pre>
304
305
306	<a name="BioAssayOrigin"/>
307	<a href="#top">BioAssayOrigin</a>
308	<p></p>
309	<pre class="code">+-------------+-------------+------+-----+---------+----------------+
310	\| Field \| Type \| Null \| Key \| Default \| Extra \|
311	+-------------+-------------+------+-----+---------+----------------+
312	\| bioAssay \| int(11) \| \| PRI \| 0 \| \|
313	\| rawBioAssay \| int(11) \| \| MUL \| 0 \| \|
314	\| position \| smallint(6) \| \| PRI \| NULL \| auto_increment \|
315	+-------------+-------------+------+-----+---------+----------------+</pre>
316
317
318	<a name="BioAssayParent"/>
319	<a href="#top">BioAssayParent</a>
320	<p></p>
321	<pre class="code">+----------+-------------+------+-----+---------+----------------+
322	\| Field \| Type \| Null \| Key \| Default \| Extra \|
323	+----------+-------------+------+-----+---------+----------------+
324	\| bioAssay \| int(11) \| \| PRI \| 0 \| \|
325	\| parent \| int(11) \| \| MUL \| 0 \| \|
326	\| position \| smallint(6) \| \| PRI \| NULL \| auto_increment \|
327	+----------+-------------+------+-----+---------+----------------+</pre>
328
329
330	<a name="BioAssaySample"/>
331	<a href="#top">BioAssaySample</a>
332	<p></p>
333	<pre class="code">+----------+------------+------+-----+---------+-------+
334	\| Field \| Type \| Null \| Key \| Default \| Extra \|
335	+----------+------------+------+-----+---------+-------+
336	\| bioAssay \| int(11) \| \| PRI \| 0 \| \|
337	\| sample \| int(11) \| \| \| 0 \| \|
338	\| channel \| tinyint(4) \| \| PRI \| 0 \| \|
339	+----------+------------+------+-----+---------+-------+</pre>
340
341
342	<a name="BioAssaySet"/>
343	<a href="#top">BioAssaySet</a>
344	<p></p>
345	<pre class="code">+------------------+--------------+------+-----+------------+----------------+
346	\| Field \| Type \| Null \| Key \| Default \| Extra \|
347	+------------------+--------------+------+-----+------------+----------------+
348	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
349	\| name \| varchar(80) \| \| MUL \| \| \|
350	\| descr \| text \| \| \| \| \|
351	\| owner \| int(11) \| \| \| 0 \| \|
352	\| addedDate \| date \| \| \| 0000-00-00 \| \|
353	\| experiment \| int(11) \| \| MUL \| 0 \| \|
354	\| transformation \| int(11) \| \| MUL \| 0 \| \|
355	\| assayCount \| smallint(6) \| \| \| 0 \| \|
356	\| spotCount \| int(11) \| \| \| 0 \| \|
357	\| geneCount \| mediumint(9) \| \| \| 0 \| \|
358	\| removed \| tinyint(1) \| \| \| 3 \| \|
359	\| intensityMeasure \| varchar(80) \| YES \| \| NULL \| \|
360	\| hasExtraColumns \| tinyint(1) \| \| \| 0 \| \|
361	+------------------+--------------+------+-----+------------+----------------+</pre>
362
363
364	<a name="BioAssaySetExplore"/>
365	<a href="#top">BioAssaySetExplore</a>
366	<p></p>
367	<pre class="code">+----------------+--------------+------+-----+---------+-------+
368	\| Field \| Type \| Null \| Key \| Default \| Extra \|
369	+----------------+--------------+------+-----+---------+-------+
370	\| bioAssaySet \| int(11) \| \| PRI \| 0 \| \|
371	\| userGroup \| int(11) \| \| PRI \| 0 \| \|
372	\| hits \| int(11) \| \| \| 0 \| \|
373	\| page \| int(11) \| \| \| 0 \| \|
374	\| reporter \| mediumint(9) \| \| \| 0 \| \|
375	\| subPage \| smallint(6) \| \| \| 1 \| \|
376	\| annotationType \| int(11) \| \| \| 0 \| \|
377	\| exploreMode \| tinyint(1) \| \| \| 0 \| \|
378	\| showBackend \| tinyint(1) \| \| \| 0 \| \|
379	\| spotSize \| tinyint(4) \| \| \| 0 \| \|
380	\| rawLevel \| tinyint(1) \| \| \| 3 \| \|
381	+----------------+--------------+------+-----+---------+-------+</pre>
382
383
384	<a name="BioAssaySetExtraColumn"/>
385	<a href="#top">BioAssaySetExtraColumn</a>
386	<p></p>
387	<pre class="code">+-----------------+------------+------+-----+---------+----------------+
388	\| Field \| Type \| Null \| Key \| Default \| Extra \|
389	+-----------------+------------+------+-----+---------+----------------+
390	\| bioAssaySet \| int(11) \| \| PRI \| 0 \| \|
391	\| extraDataColumn \| int(11) \| \| \| 0 \| \|
392	\| position \| tinyint(4) \| \| PRI \| NULL \| auto_increment \|
393	+-----------------+------------+------+-----+---------+----------------+</pre>
394
395
396	<a name="BioAssaySetSearch"/>
397	<a href="#top">BioAssaySetSearch</a>
398	<p></p>
399	<pre class="code">+-------------+-------------+------+-----+---------+-------+
400	\| Field \| Type \| Null \| Key \| Default \| Extra \|
401	+-------------+-------------+------+-----+---------+-------+
402	\| bioAssaySet \| int(11) \| \| MUL \| 0 \| \|
403	\| userGroup \| int(11) \| \| \| 0 \| \|
404	\| searchType \| varchar(80) \| \| \| \| \|
405	\| search \| int(11) \| \| PRI \| 0 \| \|
406	+-------------+-------------+------+-----+---------+-------+</pre>
407
408
409	<a name="ComputationServer"/>
410	<a href="#top">ComputationServer</a>
411	<p></p>
412	<pre class="code">+---------------+--------------+------+-----+------------+----------------+
413	\| Field \| Type \| Null \| Key \| Default \| Extra \|
414	+---------------+--------------+------+-----+------------+----------------+
415	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
416	\| name \| varchar(80) \| \| \| \| \|
417	\| descr \| text \| \| \| \| \|
418	\| owner \| int(11) \| \| \| 0 \| \|
419	\| addedDate \| date \| \| \| 0000-00-00 \| \|
420	\| removed \| tinyint(1) \| \| \| 3 \| \|
421	\| gid \| int(11) \| \| \| 0 \| \|
422	\| groupAccess \| tinyint(4) \| \| \| 0 \| \|
423	\| worldAccess \| tinyint(4) \| \| \| 0 \| \|
424	\| serverType \| tinyint(4) \| \| \| 0 \| \|
425	\| userHost \| varchar(255) \| \| \| \| \|
426	\| remoteRootDir \| varchar(255) \| \| \| \| \|
427	\| remoteDataDir \| varchar(255) \| \| \| \| \|
428	\| localUrl \| varchar(255) \| \| \| \| \|
429	\| maxJobs \| int(11) \| \| \| 0 \| \|
430	\| minTime \| int(11) \| \| \| 60 \| \|
431	\| maxTime \| int(11) \| \| \| 86400 \| \|
432	\| jobSlots \| smallint(6) \| \| \| 3 \| \|
433	\| infSlots \| smallint(6) \| \| \| 1 \| \|
434	\| totalRam \| double \| \| \| 268435000 \| \|
435	+---------------+--------------+------+-----+------------+----------------+</pre>
436
437
438	<a name="Cookie"/>
439	<a href="#top">Cookie</a>
440	<p></p>
441	<pre class="code">+--------------+-------------+------+-----+---------------------+-------+
442	\| Field \| Type \| Null \| Key \| Default \| Extra \|
443	+--------------+-------------+------+-----+---------------------+-------+
444	\| cookie \| varchar(40) \| \| PRI \| \| \|
445	\| owner \| int(11) \| \| \| 0 \| \|
446	\| lastSeen \| datetime \| \| MUL \| 0000-00-00 00:00:00 \| \|
447	\| IP \| tinytext \| \| \| \| \|
448	\| loginDate \| datetime \| \| \| 0000-00-00 00:00:00 \| \|
449	\| lastActivity \| datetime \| \| \| 0000-00-00 00:00:00 \| \|
450	+--------------+-------------+------+-----+---------------------+-------+</pre>
451
452
453	<a name="EventLog"/>
454	<a href="#top">EventLog</a>
455	<p></p>
456	<pre class="code">+-------------+--------------+------+-----+---------------------+----------------+
457	\| Field \| Type \| Null \| Key \| Default \| Extra \|
458	+-------------+--------------+------+-----+---------------------+----------------+
459	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
460	\| name \| varchar(255) \| \| \| \| \|
461	\| descr \| text \| \| \| \| \|
462	\| owner \| int(11) \| \| \| 0 \| \|
463	\| addedDate \| datetime \| \| MUL \| 0000-00-00 00:00:00 \| \|
464	\| removed \| tinyint(1) \| \| \| 0 \| \|
465	\| gid \| int(11) \| \| \| 0 \| \|
466	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
467	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
468	\| eventType \| smallint(6) \| \| \| 0 \| \|
469	\| linkInfo \| varchar(255) \| \| \| \| \|
470	+-------------+--------------+------+-----+---------------------+----------------+</pre>
471
472
473	<a name="Experiment"/>
474	<a href="#top">Experiment</a>
475	<p></p>
476	<pre class="code">+-------------------+--------------+------+-----+------------+----------------+
477	\| Field \| Type \| Null \| Key \| Default \| Extra \|
478	+-------------------+--------------+------+-----+------------+----------------+
479	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
480	\| name \| varchar(80) \| \| \| \| \|
481	\| descr \| text \| \| \| \| \|
482	\| owner \| int(11) \| \| \| 0 \| \|
483	\| addedDate \| date \| \| \| 0000-00-00 \| \|
484	\| authors \| text \| \| \| \| \|
485	\| affiliations \| text \| \| \| \| \|
486	\| experimentType \| varchar(255) \| \| \| \| \|
487	\| experimentDesign \| text \| \| \| \| \|
488	\| publication \| text \| \| \| \| \|
489	\| abstract \| text \| \| \| \| \|
490	\| pubMedId \| varchar(80) \| \| \| \| \|
491	\| publicationDate \| date \| \| \| 0000-00-00 \| \|
492	\| removed \| tinyint(1) \| \| \| 3 \| \|
493	\| gid \| int(11) \| \| \| 0 \| \|
494	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
495	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
496	\| channels \| tinyint(4) \| \| \| 2 \| \|
497	\| hasMageml \| smallint(1) \| \| \| 0 \| \|
498	\| extraColumnTables \| int(11) \| \| \| 0 \| \|
499	+-------------------+--------------+------+-----+------------+----------------+</pre>
500
501
502	<a name="ExperimentExplore"/>
503	<a href="#top">ExperimentExplore</a>
504	<p></p>
505	<pre class="code">+-----------------------+------------+------+-----+---------+-------+
506	\| Field \| Type \| Null \| Key \| Default \| Extra \|
507	+-----------------------+------------+------+-----+---------+-------+
508	\| experiment \| int(11) \| \| PRI \| 0 \| \|
509	\| userGroup \| int(11) \| \| PRI \| 0 \| \|
510	\| shownTab \| tinyint(4) \| \| \| 0 \| \|
511	\| currentTransformation \| int(11) \| \| \| 0 \| \|
512	\| currentSet \| int(11) \| \| \| 0 \| \|
513	+-----------------------+------------+------+-----+---------+-------+</pre>
514
515
516	<a name="ExperimentRawBioAssay"/>
517	<a href="#top">ExperimentRawBioAssay</a>
518	<p></p>
519	<pre class="code">+-------------+---------+------+-----+---------+-------+
520	\| Field \| Type \| Null \| Key \| Default \| Extra \|
521	+-------------+---------+------+-----+---------+-------+
522	\| experiment \| int(11) \| \| PRI \| 0 \| \|
523	\| rawBioAssay \| int(11) \| \| PRI \| 0 \| \|
524	+-------------+---------+------+-----+---------+-------+</pre>
525
526
527	<a name="ExtraDataColumn"/>
528	<a href="#top">ExtraDataColumn</a>
529	<p></p>
530	<pre class="code">+-----------+-------------+------+-----+---------+----------------+
531	\| Field \| Type \| Null \| Key \| Default \| Extra \|
532	+-----------+-------------+------+-----+---------+----------------+
533	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
534	\| name \| varchar(80) \| \| MUL \| \| \|
535	\| valueType \| tinyint(4) \| \| \| 0 \| \|
536	+-----------+-------------+------+-----+---------+----------------+</pre>
537
538
539	<a name="Extract"/>
540	<a href="#top">Extract</a>
541	<p></p>
542	<pre class="code">+----------------+-------------+------+-----+------------+----------------+
543	\| Field \| Type \| Null \| Key \| Default \| Extra \|
544	+----------------+-------------+------+-----+------------+----------------+
545	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
546	\| protocol \| int(11) \| \| \| 0 \| \|
547	\| extractionDate \| date \| \| \| 0000-00-00 \| \|
548	\| sample \| int(11) \| \| MUL \| 0 \| \|
549	\| name \| varchar(80) \| \| MUL \| \| \|
550	\| descr \| text \| \| \| \| \|
551	\| quantity \| float \| \| \| 0 \| \|
552	\| quantityLeft \| float \| YES \| \| NULL \| \|
553	\| owner \| int(11) \| \| \| 0 \| \|
554	\| addedDate \| date \| \| \| 0000-00-00 \| \|
555	\| removed \| tinyint(1) \| \| \| 0 \| \|
556	\| gid \| int(11) \| \| \| 0 \| \|
557	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
558	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
559	+----------------+-------------+------+-----+------------+----------------+</pre>
560
561
562	<a name="Feature"/>
563	<a href="#top">Feature</a>
564	<p></p>
565	<pre class="code">+-----------+--------------+------+-----+---------+----------------+
566	\| Field \| Type \| Null \| Key \| Default \| Extra \|
567	+-----------+--------------+------+-----+---------+----------------+
568	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
569	\| arrayType \| int(11) \| \| MUL \| 0 \| \|
570	\| block \| smallint(6) \| \| \| 0 \| \|
571	\| x \| smallint(6) \| \| \| 0 \| \|
572	\| y \| smallint(6) \| \| \| 0 \| \|
573	\| position \| mediumint(9) \| \| \| 0 \| \|
574	\| reporter \| mediumint(9) \| \| \| 0 \| \|
575	\| well \| int(11) \| YES \| \| NULL \| \|
576	+-----------+--------------+------+-----+---------+----------------+</pre>
577
578
579	<a name="Hardware"/>
580	<a href="#top">Hardware</a>
581	<p></p>
582	<pre class="code">+-------------+-------------+------+-----+------------+----------------+
583	\| Field \| Type \| Null \| Key \| Default \| Extra \|
584	+-------------+-------------+------+-----+------------+----------------+
585	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
586	\| name \| varchar(80) \| \| MUL \| \| \|
587	\| descr \| text \| \| \| \| \|
588	\| owner \| int(11) \| \| \| 0 \| \|
589	\| addedDate \| date \| \| \| 0000-00-00 \| \|
590	\| version \| varchar(80) \| \| \| \| \|
591	\| removed \| tinyint(1) \| \| \| 0 \| \|
592	\| gid \| int(11) \| \| \| 0 \| \|
593	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
594	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
595	+-------------+-------------+------+-----+------------+----------------+</pre>
596
597
598	<a name="Hybridization"/>
599	<a href="#top">Hybridization</a>
600	<p></p>
601	<pre class="code">+-------------------+-------------+------+-----+------------+----------------+
602	\| Field \| Type \| Null \| Key \| Default \| Extra \|
603	+-------------------+-------------+------+-----+------------+----------------+
604	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
605	\| owner \| int(11) \| \| \| 0 \| \|
606	\| name \| varchar(80) \| \| MUL \| \| \|
607	\| descr \| text \| \| \| \| \|
608	\| addedDate \| date \| \| \| 0000-00-00 \| \|
609	\| hybridizationDate \| date \| \| \| 0000-00-00 \| \|
610	\| protocol \| int(11) \| \| \| 0 \| \|
611	\| removed \| tinyint(1) \| \| \| 0 \| \|
612	\| gid \| int(11) \| \| \| 0 \| \|
613	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
614	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
615	+-------------------+-------------+------+-----+------------+----------------+</pre>
616
617
618	<a name="HybridizedLabeled"/>
619	<a href="#top">HybridizedLabeled</a>
620	<p></p>
621	<pre class="code">+---------------+------------+------+-----+---------+-------+
622	\| Field \| Type \| Null \| Key \| Default \| Extra \|
623	+---------------+------------+------+-----+---------+-------+
624	\| hybridization \| int(11) \| \| PRI \| 0 \| \|
625	\| channel \| tinyint(4) \| \| PRI \| 0 \| \|
626	\| labeled \| int(11) \| \| MUL \| 0 \| \|
627	\| quantity \| float \| \| \| 0 \| \|
628	+---------------+------------+------+-----+---------+-------+</pre>
629
630
631	<a name="Image"/>
632	<a href="#top">Image</a>
633	<p></p>
634	<pre class="code">+------------------+--------------+------+-----+------------+----------------+
635	\| Field \| Type \| Null \| Key \| Default \| Extra \|
636	+------------------+--------------+------+-----+------------+----------------+
637	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
638	\| name \| varchar(255) \| \| \| \| \|
639	\| descr \| text \| \| \| \| \|
640	\| owner \| int(11) \| \| \| 0 \| \|
641	\| addedDate \| date \| \| \| 0000-00-00 \| \|
642	\| imageAcquisition \| int(11) \| \| MUL \| 0 \| \|
643	\| channels \| tinyint(4) \| \| \| 0 \| \|
644	\| useForJpeg \| tinyint(1) \| \| \| 0 \| \|
645	\| fileSize \| int(11) \| \| \| 0 \| \|
646	\| removed \| tinyint(1) \| \| \| 0 \| \|
647	+------------------+--------------+------+-----+------------+----------------+</pre>
648
649
650	<a name="ImageAcquisition"/>
651	<a href="#top">ImageAcquisition</a>
652	<p></p>
653	<pre class="code">+---------------+-------------+------+-----+------------+----------------+
654	\| Field \| Type \| Null \| Key \| Default \| Extra \|
655	+---------------+-------------+------+-----+------------+----------------+
656	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
657	\| name \| varchar(80) \| \| \| \| \|
658	\| descr \| text \| \| \| \| \|
659	\| owner \| int(11) \| \| \| 0 \| \|
660	\| addedDate \| date \| \| \| 0000-00-00 \| \|
661	\| hybridization \| int(11) \| \| MUL \| 0 \| \|
662	\| scanDate \| date \| \| \| 0000-00-00 \| \|
663	\| scanner \| int(11) \| \| \| 0 \| \|
664	\| removed \| tinyint(1) \| \| \| 0 \| \|
665	\| gid \| int(11) \| \| \| 0 \| \|
666	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
667	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
668	+---------------+-------------+------+-----+------------+----------------+</pre>
669
670
671	<a name="Item"/>
672	<a href="#top">Item</a>
673	<p></p>
674	<pre class="code">+-------------+-------------+------+-----+------------+----------------+
675	\| Field \| Type \| Null \| Key \| Default \| Extra \|
676	+-------------+-------------+------+-----+------------+----------------+
677	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
678	\| name \| varchar(80) \| \| \| \| \|
679	\| descr \| text \| \| \| \| \|
680	\| owner \| int(11) \| \| \| 0 \| \|
681	\| addedDate \| date \| \| \| 0000-00-00 \| \|
682	\| removed \| tinyint(1) \| \| \| 0 \| \|
683	\| gid \| int(11) \| \| \| 0 \| \|
684	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
685	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
686	+-------------+-------------+------+-----+------------+----------------+</pre>
687
688
689	<a name="Job"/>
690	<a href="#top">Job</a>
691	<p></p>
692	<pre class="code">+-------------------+---------------+------+-----+---------------------+-------+
693	\| Field \| Type \| Null \| Key \| Default \| Extra \|
694	+-------------------+---------------+------+-----+---------------------+-------+
695	\| submitTime \| datetime \| \| \| 0000-00-00 00:00:00 \| \|
696	\| handlerTime \| datetime \| \| \| 0000-00-00 00:00:00 \| \|
697	\| startTime \| datetime \| \| MUL \| 0000-00-00 00:00:00 \| \|
698	\| endTime \| datetime \| \| \| 0000-00-00 00:00:00 \| \|
699	\| doneTime \| datetime \| \| \| 0000-00-00 00:00:00 \| \|
700	\| program \| int(11) \| \| \| 0 \| \|
701	\| resultText \| mediumtext \| \| \| \| \|
702	\| transformation \| int(11) \| \| PRI \| 0 \| \|
703	\| duration \| decimal(10,2) \| \| \| -1.00 \| \|
704	\| cpuTime \| decimal(10,2) \| \| \| -1.00 \| \|
705	\| exportCpuTime \| decimal(10,2) \| \| \| -1.00 \| \|
706	\| handlerCpuTime \| decimal(10,2) \| \| \| -1.00 \| \|
707	\| controlSha1 \| varchar(42) \| YES \| MUL \| NULL \| \|
708	\| curStatus \| tinyint(4) \| \| MUL \| 0 \| \|
709	\| computationServer \| int(11) \| YES \| \| NULL \| \|
710	\| handlerPid \| int(11) \| YES \| \| NULL \| \|
711	\| estimatedTime \| int(11) \| \| \| 60 \| \|
712	\| maxCpu \| int(11) \| \| \| -1 \| \|
713	\| maxRam \| double \| \| \| 67108864 \| \|
714	\| matrixSize \| double \| \| \| -1 \| \|
715	\| queuePosition \| int(11) \| YES \| MUL \| NULL \| \|
716	+-------------------+---------------+------+-----+---------------------+-------+</pre>
717
718
719	<a name="JobFile"/>
720	<a href="#top">JobFile</a>
721	<p></p>
722	<pre class="code">+----------------+--------------+------+-----+---------+----------------+
723	\| Field \| Type \| Null \| Key \| Default \| Extra \|
724	+----------------+--------------+------+-----+---------+----------------+
725	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
726	\| transformation \| int(11) \| \| MUL \| 0 \| \|
727	\| name \| varchar(255) \| \| \| \| \|
728	\| fileSize \| int(11) \| \| \| 0 \| \|
729	+----------------+--------------+------+-----+---------+----------------+</pre>
730
731
732	<a name="JobFileSection"/>
733	<a href="#top">JobFileSection</a>
734	<p></p>
735	<pre class="code">+--------------+-------------+------+-----+---------+-------+
736	\| Field \| Type \| Null \| Key \| Default \| Extra \|
737	+--------------+-------------+------+-----+---------+-------+
738	\| jobFile \| int(11) \| \| PRI \| 0 \| \|
739	\| fileSection \| int(11) \| \| PRI \| 0 \| \|
740	\| sectionCount \| smallint(6) \| \| \| 0 \| \|
741	+--------------+-------------+------+-----+---------+-------+</pre>
742
743
744	<a name="JobSetting"/>
745	<a href="#top">JobSetting</a>
746	<p></p>
747	<pre class="code">+----------------+------------+------+-----+---------+-------+
748	\| Field \| Type \| Null \| Key \| Default \| Extra \|
749	+----------------+------------+------+-----+---------+-------+
750	\| transformation \| int(11) \| \| PRI \| 0 \| \|
751	\| position \| tinyint(4) \| \| PRI \| 0 \| \|
752	\| setting \| text \| \| \| \| \|
753	+----------------+------------+------+-----+---------+-------+</pre>
754
755
756	<a name="Label"/>
757	<a href="#top">Label</a>
758	<p></p>
759	<pre class="code">+-------------+-------------+------+-----+------------+----------------+
760	\| Field \| Type \| Null \| Key \| Default \| Extra \|
761	+-------------+-------------+------+-----+------------+----------------+
762	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
763	\| name \| varchar(80) \| \| MUL \| \| \|
764	\| descr \| text \| \| \| \| \|
765	\| owner \| int(11) \| \| \| 0 \| \|
766	\| addedDate \| date \| \| \| 0000-00-00 \| \|
767	\| removed \| tinyint(1) \| \| \| 0 \| \|
768	\| gid \| int(11) \| \| \| 0 \| \|
769	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
770	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
771	+-------------+-------------+------+-----+------------+----------------+</pre>
772
773
774	<a name="LabeledExtract"/>
775	<a href="#top">LabeledExtract</a>
776	<p></p>
777	<pre class="code">+--------------+-------------+------+-----+------------+----------------+
778	\| Field \| Type \| Null \| Key \| Default \| Extra \|
779	+--------------+-------------+------+-----+------------+----------------+
780	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
781	\| owner \| int(11) \| \| \| 0 \| \|
782	\| name \| varchar(80) \| \| MUL \| \| \|
783	\| descr \| text \| \| \| \| \|
784	\| addedDate \| date \| \| \| 0000-00-00 \| \|
785	\| extract \| int(11) \| \| MUL \| 0 \| \|
786	\| protocol \| int(11) \| \| \| 0 \| \|
787	\| labelingDate \| date \| \| \| 0000-00-00 \| \|
788	\| quantity \| float \| \| \| 0 \| \|
789	\| quantityLeft \| float \| YES \| \| NULL \| \|
790	\| removed \| tinyint(1) \| \| \| 0 \| \|
791	\| gid \| int(11) \| \| \| 0 \| \|
792	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
793	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
794	\| label \| int(11) \| \| \| 0 \| \|
795	+--------------+-------------+------+-----+------------+----------------+</pre>
796
797
798	<a name="News"/>
799	<a href="#top">News</a>
800	<p></p>
801	<pre class="code">+-----------+--------------+------+-----+---------------------+----------------+
802	\| Field \| Type \| Null \| Key \| Default \| Extra \|
803	+-----------+--------------+------+-----+---------------------+----------------+
804	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
805	\| name \| varchar(255) \| \| \| \| \|
806	\| descr \| text \| \| \| \| \|
807	\| owner \| int(11) \| \| \| 0 \| \|
808	\| addedDate \| datetime \| \| MUL \| 0000-00-00 00:00:00 \| \|
809	\| removed \| tinyint(1) \| \| \| 0 \| \|
810	+-----------+--------------+------+-----+---------------------+----------------+</pre>
811
812
813	<a name="Plate"/>
814	<a href="#top">Plate</a>
815	<p></p>
816	<pre class="code">+-------------+--------------+------+-----+------------+----------------+
817	\| Field \| Type \| Null \| Key \| Default \| Extra \|
818	+-------------+--------------+------+-----+------------+----------------+
819	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
820	\| plateType \| int(11) \| \| \| 0 \| \|
821	\| name \| varchar(255) \| YES \| MUL \| NULL \| \|
822	\| descr \| text \| \| \| \| \|
823	\| owner \| int(11) \| \| \| 0 \| \|
824	\| addedDate \| date \| \| \| 0000-00-00 \| \|
825	\| destroyed \| tinyint(1) \| \| \| 0 \| \|
826	\| barcode \| varchar(255) \| YES \| MUL \| NULL \| \|
827	\| wizzzard \| int(11) \| \| \| 0 \| \|
828	\| removed \| tinyint(1) \| \| \| 3 \| \|
829	\| gid \| int(11) \| \| \| 0 \| \|
830	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
831	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
832	+-------------+--------------+------+-----+------------+----------------+</pre>
833
834
835	<a name="PlateEvent"/>
836	<a href="#top">PlateEvent</a>
837	<p></p>
838	<pre class="code">+-----------+---------+------+-----+------------+-------+
839	\| Field \| Type \| Null \| Key \| Default \| Extra \|
840	+-----------+---------+------+-----+------------+-------+
841	\| plate \| int(11) \| \| PRI \| 0 \| \|
842	\| etype \| int(11) \| \| PRI \| 0 \| \|
843	\| eventDate \| date \| \| MUL \| 0000-00-00 \| \|
844	\| protocol \| int(11) \| \| \| 0 \| \|
845	+-----------+---------+------+-----+------------+-------+</pre>
846
847
848	<a name="PlateEventType"/>
849	<a href="#top">PlateEventType</a>
850	<p></p>
851	<pre class="code">+--------------+-------------+------+-----+------------+----------------+
852	\| Field \| Type \| Null \| Key \| Default \| Extra \|
853	+--------------+-------------+------+-----+------------+----------------+
854	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
855	\| name \| varchar(80) \| \| \| \| \|
856	\| plateType \| int(11) \| \| MUL \| 0 \| \|
857	\| protocolType \| int(11) \| \| \| 0 \| \|
858	\| descr \| text \| \| \| \| \|
859	\| addedDate \| date \| \| \| 0000-00-00 \| \|
860	\| owner \| int(11) \| \| \| 0 \| \|
861	\| removed \| tinyint(1) \| \| \| 0 \| \|
862	+--------------+-------------+------+-----+------------+----------------+</pre>
863
864
865	<a name="PlateParent"/>
866	<a href="#top">PlateParent</a>
867	<p></p>
868	<pre class="code">+----------+------------+------+-----+---------+-------+
869	\| Field \| Type \| Null \| Key \| Default \| Extra \|
870	+----------+------------+------+-----+---------+-------+
871	\| parent \| int(11) \| \| MUL \| 0 \| \|
872	\| plate \| int(11) \| \| MUL \| 0 \| \|
873	\| position \| tinyint(4) \| \| \| 0 \| \|
874	+----------+------------+------+-----+---------+-------+</pre>
875
876
877	<a name="PlateType"/>
878	<a href="#top">PlateType</a>
879	<p></p>
880	<pre class="code">+----------------+-------------+------+-----+------------+----------------+
881	\| Field \| Type \| Null \| Key \| Default \| Extra \|
882	+----------------+-------------+------+-----+------------+----------------+
883	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
884	\| name \| varchar(80) \| \| MUL \| \| \|
885	\| descr \| text \| \| \| \| \|
886	\| owner \| int(11) \| \| \| 0 \| \|
887	\| addedDate \| date \| \| \| 0000-00-00 \| \|
888	\| wells \| smallint(6) \| \| \| 0 \| \|
889	\| hasGrowth \| tinyint(1) \| \| \| 0 \| \|
890	\| hasSeqVerified \| tinyint(1) \| \| \| 0 \| \|
891	\| hasBands \| tinyint(1) \| \| \| 0 \| \|
892	\| hasComment \| tinyint(1) \| \| \| 0 \| \|
893	\| namePrefix \| varchar(40) \| \| \| \| \|
894	\| parentSuffix \| tinyint(1) \| \| \| 0 \| \|
895	\| removed \| tinyint(1) \| \| \| 0 \| \|
896	\| gid \| int(11) \| \| \| 0 \| \|
897	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
898	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
899	+----------------+-------------+------+-----+------------+----------------+</pre>
900
901
902	<a name="Preset"/>
903	<a href="#top">Preset</a>
904	<p></p>
905	<pre class="code">+-------------+---------------+------+-----+---------+-------+
906	\| Field \| Type \| Null \| Key \| Default \| Extra \|
907	+-------------+---------------+------+-----+---------+-------+
908	\| search \| int(11) \| \| PRI \| 0 \| \|
909	\| searchType \| varchar(80) \| \| \| \| \|
910	\| owner \| int(11) \| \| MUL \| 0 \| \|
911	\| name \| varchar(80) \| \| \| \| \|
912	\| lastTouched \| timestamp(14) \| YES \| \| NULL \| \|
913	+-------------+---------------+------+-----+---------+-------+</pre>
914
915
916	<a name="Probe"/>
917	<a href="#top">Probe</a>
918	<p></p>
919	<pre class="code">+----------+--------------+------+-----+---------+----------------+
920	\| Field \| Type \| Null \| Key \| Default \| Extra \|
921	+----------+--------------+------+-----+---------+----------------+
922	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
923	\| reporter \| mediumint(9) \| \| \| 0 \| \|
924	+----------+--------------+------+-----+---------+----------------+</pre>
925
926
927	<a name="Program"/>
928	<a href="#top">Program</a>
929	<p></p>
930	<pre class="code">+---------------+--------------+------+-----+------------+----------------+
931	\| Field \| Type \| Null \| Key \| Default \| Extra \|
932	+---------------+--------------+------+-----+------------+----------------+
933	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
934	\| execName \| varchar(255) \| \| \| \| \|
935	\| descr \| text \| \| \| \| \|
936	\| addedDate \| date \| \| \| 0000-00-00 \| \|
937	\| owner \| int(11) \| \| \| 0 \| \|
938	\| name \| varchar(80) \| \| MUL \| \| \|
939	\| usedColumns \| text \| \| \| \| \|
940	\| usedFields \| text \| \| \| \| \|
941	\| onServer \| tinyint(1) \| \| \| 0 \| \|
942	\| geneAverages \| tinyint(1) \| \| \| 0 \| \|
943	\| serialFormat \| tinyint(1) \| \| \| 0 \| \|
944	\| url \| varchar(255) \| \| \| \| \|
945	\| removed \| tinyint(1) \| \| \| 0 \| \|
946	\| gid \| int(11) \| \| \| 0 \| \|
947	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
948	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
949	\| minChannels \| tinyint(4) \| \| \| 2 \| \|
950	\| leaveStdin \| tinyint(1) \| \| \| 0 \| \|
951	\| leaveStdout \| tinyint(1) \| \| \| 0 \| \|
952	\| maxChannels \| smallint(6) \| \| \| 0 \| \|
953	\| uniqueName \| varchar(255) \| \| \| \| \|
954	\| versionNumber \| varchar(20) \| \| \| \| \|
955	\| estimatedTime \| int(11) \| \| \| 3600 \| \|
956	\| defaultMaxRam \| double \| \| \| 134218000 \| \|
957	+---------------+--------------+------+-----+------------+----------------+</pre>
958
959
960	<a name="ProgramParameter"/>
961	<a href="#top">ProgramParameter</a>
962	<p></p>
963	<pre class="code">+--------------+-----------------------------------+------+-----+---------+----------------+
964	\| Field \| Type \| Null \| Key \| Default \| Extra \|
965	+--------------+-----------------------------------+------+-----+---------+----------------+
966	\| program \| int(11) \| \| PRI \| 0 \| \|
967	\| position \| smallint(6) \| \| PRI \| NULL \| auto_increment \|
968	\| name \| varchar(80) \| \| \| \| \|
969	\| commonName \| varchar(80) \| \| \| \| \|
970	\| valueType \| enum('i','f','t','a','n','h','e') \| \| \| i \| \|
971	\| options \| text \| \| \| \| \|
972	\| defaultValue \| text \| \| \| \| \|
973	\| enumOptions \| text \| \| \| \| \|
974	\| removed \| smallint(1) \| \| \| 0 \| \|
975	+--------------+-----------------------------------+------+-----+---------+----------------+</pre>
976
977
978	<a name="ProgramServer"/>
979	<a href="#top">ProgramServer</a>
980	<p></p>
981	<pre class="code">+-------------------+---------+------+-----+---------+-------+
982	\| Field \| Type \| Null \| Key \| Default \| Extra \|
983	+-------------------+---------+------+-----+---------+-------+
984	\| program \| int(11) \| \| PRI \| 0 \| \|
985	\| computationServer \| int(11) \| \| PRI \| 0 \| \|
986	+-------------------+---------+------+-----+---------+-------+</pre>
987
988
989	<a name="Protocol"/>
990	<a href="#top">Protocol</a>
991	<p></p>
992	<pre class="code">+--------------+--------------+------+-----+------------+----------------+
993	\| Field \| Type \| Null \| Key \| Default \| Extra \|
994	+--------------+--------------+------+-----+------------+----------------+
995	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
996	\| protocolType \| int(11) \| \| MUL \| 0 \| \|
997	\| name \| varchar(80) \| \| \| \| \|
998	\| descr \| text \| \| \| \| \|
999	\| owner \| int(11) \| \| \| 0 \| \|
1000	\| addedDate \| date \| \| \| 0000-00-00 \| \|
1001	\| removed \| tinyint(1) \| \| \| 0 \| \|
1002	\| gid \| int(11) \| \| \| 0 \| \|
1003	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
1004	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
1005	\| fileSize \| int(11) \| \| \| 0 \| \|
1006	\| filename \| varchar(255) \| YES \| \| NULL \| \|
1007	+--------------+--------------+------+-----+------------+----------------+</pre>
1008
1009
1010	<a name="ProtocolType"/>
1011	<a href="#top">ProtocolType</a>
1012	<p></p>
1013	<pre class="code">+-------+-------------+------+-----+---------+----------------+
1014	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1015	+-------+-------------+------+-----+---------+----------------+
1016	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
1017	\| name \| varchar(80) \| \| UNI \| \| \|
1018	+-------+-------------+------+-----+---------+----------------+</pre>
1019
1020
1021	<a name="RawBioAssay"/>
1022	<a href="#top">RawBioAssay</a>
1023	<p></p>
1024	<pre class="code">+------------------+--------------+------+-----+------------+----------------+
1025	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1026	+------------------+--------------+------+-----+------------+----------------+
1027	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
1028	\| name \| varchar(80) \| \| \| \| \|
1029	\| descr \| text \| \| \| \| \|
1030	\| owner \| int(11) \| \| \| 0 \| \|
1031	\| addedDate \| date \| \| \| 0000-00-00 \| \|
1032	\| imageAcquisition \| int(11) \| \| MUL \| 0 \| \|
1033	\| featureDate \| date \| \| \| 0000-00-00 \| \|
1034	\| featureSoftware \| int(11) \| \| \| 0 \| \|
1035	\| filename \| varchar(255) \| \| \| \| \|
1036	\| spots \| mediumint(9) \| \| \| 0 \| \|
1037	\| hasSpotImages \| tinyint(1) \| \| \| 0 \| \|
1038	\| spotImagePixels \| smallint(6) \| \| \| 15 \| \|
1039	\| spotImageOffsetX \| float \| \| \| 0 \| \|
1040	\| spotImageOffsetY \| float \| \| \| 0 \| \|
1041	\| spotImageScale \| float \| \| \| 1 \| \|
1042	\| wizzzard \| int(11) \| \| \| 0 \| \|
1043	\| removed \| tinyint(1) \| \| \| 3 \| \|
1044	\| gid \| int(11) \| \| \| 0 \| \|
1045	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
1046	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
1047	\| arrayType \| int(11) \| YES \| \| NULL \| \|
1048	\| positionMode \| tinyint(4) \| \| \| 0 \| \|
1049	+------------------+--------------+------+-----+------------+----------------+</pre>
1050
1051
1052	<a name="RawBioAssayData"/>
1053	<a href="#top">RawBioAssayData</a>
1054	<p></p>
1055	<pre class="code">+-------------+--------------+------+-----+---------+-------+
1056	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1057	+-------------+--------------+------+-----+---------+-------+
1058	\| rawBioAssay \| mediumint(9) \| \| PRI \| 0 \| \|
1059	\| position \| mediumint(9) \| \| PRI \| 0 \| \|
1060	\| element \| mediumint(9) \| \| \| 0 \| \|
1061	\| reporter \| mediumint(9) \| \| \| 0 \| \|
1062	\| block \| smallint(6) \| YES \| \| NULL \| \|
1063	\| numCol \| tinyint(4) \| YES \| \| NULL \| \|
1064	\| numRow \| tinyint(4) \| YES \| \| NULL \| \|
1065	\| x \| float \| \| \| 0 \| \|
1066	\| y \| float \| \| \| 0 \| \|
1067	\| dia \| float \| YES \| \| NULL \| \|
1068	\| FCh1Median \| float \| YES \| \| NULL \| \|
1069	\| FCh1Mean \| float \| YES \| \| NULL \| \|
1070	\| FCh1SD \| float \| YES \| \| NULL \| \|
1071	\| BCh1Median \| float \| YES \| \| NULL \| \|
1072	\| BCh1Mean \| float \| YES \| \| NULL \| \|
1073	\| BCh1SD \| float \| YES \| \| NULL \| \|
1074	\| percCh1SD1 \| tinyint(4) \| YES \| \| NULL \| \|
1075	\| percCh1SD2 \| tinyint(4) \| YES \| \| NULL \| \|
1076	\| percCh1Sat \| tinyint(4) \| YES \| \| NULL \| \|
1077	\| FCh2Median \| float \| YES \| \| NULL \| \|
1078	\| FCh2Mean \| float \| YES \| \| NULL \| \|
1079	\| FCh2SD \| float \| YES \| \| NULL \| \|
1080	\| BCh2Median \| float \| YES \| \| NULL \| \|
1081	\| BCh2Mean \| float \| YES \| \| NULL \| \|
1082	\| BCh2SD \| float \| YES \| \| NULL \| \|
1083	\| percCh2SD1 \| tinyint(4) \| YES \| \| NULL \| \|
1084	\| percCh2SD2 \| tinyint(4) \| YES \| \| NULL \| \|
1085	\| percCh2Sat \| tinyint(4) \| YES \| \| NULL \| \|
1086	\| ratiosSD \| float \| YES \| \| NULL \| \|
1087	\| rgnRatio \| float \| YES \| \| NULL \| \|
1088	\| rgnR2 \| float \| YES \| \| NULL \| \|
1089	\| FPixels \| smallint(6) \| YES \| \| NULL \| \|
1090	\| BPixels \| smallint(6) \| YES \| \| NULL \| \|
1091	\| flags \| tinyint(4) \| YES \| \| NULL \| \|
1092	\| MValue \| float \| YES \| \| NULL \| \|
1093	\| CV \| float \| YES \| \| NULL \| \|
1094	+-------------+--------------+------+-----+---------+-------+</pre>
1095
1096
1097	<a name="RawBioAssayHeader"/>
1098	<a href="#top">RawBioAssayHeader</a>
1099	<p></p>
1100	<pre class="code">+-------------+------------+------+-----+---------+-------+
1101	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1102	+-------------+------------+------+-----+---------+-------+
1103	\| rawBioAssay \| int(11) \| \| PRI \| 0 \| \|
1104	\| fileHeader \| mediumtext \| \| \| \| \|
1105	+-------------+------------+------+-----+---------+-------+</pre>
1106
1107
1108	<a name="Reporter"/>
1109	<a href="#top">Reporter</a>
1110	<p></p>
1111	<pre class="code">+---------------+--------------+------+-----+---------------------+----------------+
1112	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1113	+---------------+--------------+------+-----+---------------------+----------------+
1114	\| id \| mediumint(9) \| \| PRI \| NULL \| auto_increment \|
1115	\| reporterId \| varchar(255) \| \| UNI \| \| \|
1116	\| species \| varchar(255) \| \| \| \| \|
1117	\| clusterId \| int(11) \| \| \| 0 \| \|
1118	\| geneName \| varchar(255) \| \| MUL \| \| \|
1119	\| geneSymbol \| varchar(255) \| \| \| \| \|
1120	\| lastUpdate \| datetime \| \| \| 0000-00-00 00:00:00 \| \|
1121	\| length \| int(11) \| YES \| \| 0 \| \|
1122	\| sequence \| text \| YES \| \| NULL \| \|
1123	\| vector \| text \| YES \| \| NULL \| \|
1124	\| tissue \| text \| YES \| \| NULL \| \|
1125	\| library \| text \| YES \| \| NULL \| \|
1126	\| accession \| varchar(255) \| YES \| \| NULL \| \|
1127	\| nid \| varchar(255) \| YES \| \| NULL \| \|
1128	\| chromosome \| varchar(255) \| YES \| \| NULL \| \|
1129	\| cytoBand \| varchar(255) \| YES \| \| NULL \| \|
1130	\| markers \| varchar(255) \| YES \| \| NULL \| \|
1131	\| antibiotics \| varchar(255) \| YES \| \| NULL \| \|
1132	\| locusLink \| int(11) \| YES \| \| 0 \| \|
1133	\| omim \| int(11) \| YES \| \| 0 \| \|
1134	\| startPosition \| int(11) \| YES \| \| 0 \| \|
1135	\| endPosition \| int(11) \| YES \| \| 0 \| \|
1136	+---------------+--------------+------+-----+---------------------+----------------+</pre>
1137
1138
1139	<a name="ReporterList"/>
1140	<a href="#top">ReporterList</a>
1141	<p></p>
1142	<pre class="code">+------------+-------------+------+-----+------------+----------------+
1143	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1144	+------------+-------------+------+-----+------------+----------------+
1145	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
1146	\| name \| varchar(80) \| \| \| \| \|
1147	\| descr \| text \| \| \| \| \|
1148	\| owner \| int(11) \| \| \| 0 \| \|
1149	\| addedDate \| date \| \| \| 0000-00-00 \| \|
1150	\| experiment \| int(11) \| \| MUL \| 0 \| \|
1151	\| reporters \| int(11) \| \| \| 0 \| \|
1152	\| removed \| tinyint(1) \| \| \| 3 \| \|
1153	+------------+-------------+------+-----+------------+----------------+</pre>
1154
1155
1156	<a name="Sample"/>
1157	<a href="#top">Sample</a>
1158	<p></p>
1159	<pre class="code">+-------------+-------------+------+-----+------------+----------------+
1160	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1161	+-------------+-------------+------+-----+------------+----------------+
1162	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
1163	\| name \| varchar(80) \| \| MUL \| \| \|
1164	\| descr \| text \| \| \| \| \|
1165	\| tissue \| int(11) \| \| \| 0 \| \|
1166	\| owner \| int(11) \| \| \| 0 \| \|
1167	\| addedDate \| date \| \| \| 0000-00-00 \| \|
1168	\| sampleDate \| date \| \| \| 0000-00-00 \| \|
1169	\| removed \| tinyint(1) \| \| \| 0 \| \|
1170	\| gid \| int(11) \| \| \| 0 \| \|
1171	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
1172	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
1173	+-------------+-------------+------+-----+------------+----------------+</pre>
1174
1175
1176	<a name="SampleAnnotation"/>
1177	<a href="#top">SampleAnnotation</a>
1178	<p></p>
1179	<pre class="code">+----------------+---------+------+-----+---------+-------+
1180	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1181	+----------------+---------+------+-----+---------+-------+
1182	\| sample \| int(11) \| \| PRI \| 0 \| \|
1183	\| annotationType \| int(11) \| \| PRI \| 0 \| \|
1184	\| annotation \| text \| \| \| \| \|
1185	+----------------+---------+------+-----+---------+-------+</pre>
1186
1187
1188	<a name="SampleAnnotationType"/>
1189	<a href="#top">SampleAnnotationType</a>
1190	<p></p>
1191	<pre class="code">+--------------+-----------------------+------+-----+------------+----------------+
1192	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1193	+--------------+-----------------------+------+-----+------------+----------------+
1194	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
1195	\| name \| varchar(80) \| \| MUL \| \| \|
1196	\| valueType \| enum('i','f','t','e') \| \| \| i \| \|
1197	\| options \| text \| \| \| \| \|
1198	\| defaultValue \| text \| \| \| \| \|
1199	\| descr \| text \| \| \| \| \|
1200	\| owner \| int(11) \| \| \| 0 \| \|
1201	\| addedDate \| date \| \| \| 0000-00-00 \| \|
1202	\| removed \| tinyint(1) \| \| \| 0 \| \|
1203	\| gid \| int(11) \| \| \| 0 \| \|
1204	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
1205	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
1206	+--------------+-----------------------+------+-----+------------+----------------+</pre>
1207
1208
1209	<a name="SampleTissue"/>
1210	<a href="#top">SampleTissue</a>
1211	<p></p>
1212	<pre class="code">+-----------+-------------+------+-----+------------+----------------+
1213	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1214	+-----------+-------------+------+-----+------------+----------------+
1215	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
1216	\| parent \| int(11) \| \| MUL \| 0 \| \|
1217	\| name \| varchar(80) \| \| \| \| \|
1218	\| descr \| text \| \| \| \| \|
1219	\| owner \| int(11) \| \| \| 0 \| \|
1220	\| addedDate \| date \| \| \| 0000-00-00 \| \|
1221	\| removed \| tinyint(1) \| \| \| 0 \| \|
1222	+-----------+-------------+------+-----+------------+----------------+</pre>
1223
1224
1225	<a name="SchemaVersion"/>
1226	<a href="#top">SchemaVersion</a>
1227	<p></p>
1228	<pre class="code">+---------------+----------+------+-----+---------------------+-------+
1229	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1230	+---------------+----------+------+-----+---------------------+-------+
1231	\| baseVersion \| tinytext \| \| \| \| \|
1232	\| schemaVersion \| tinytext \| \| \| \| \|
1233	\| lastChanged \| datetime \| \| \| 0000-00-00 00:00:00 \| \|
1234	+---------------+----------+------+-----+---------------------+-------+</pre>
1235
1236
1237	<a name="Search"/>
1238	<a href="#top">Search</a>
1239	<p></p>
1240	<pre class="code">+-------------+-------------+------+-----+---------+----------------+
1241	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1242	+-------------+-------------+------+-----+---------+----------------+
1243	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
1244	\| sortField \| varchar(80) \| \| \| \| \|
1245	\| sortDesc \| tinyint(1) \| \| \| 0 \| \|
1246	\| currentPage \| smallint(6) \| \| \| 0 \| \|
1247	+-------------+-------------+------+-----+---------+----------------+</pre>
1248
1249
1250	<a name="SearchCriterion"/>
1251	<a href="#top">SearchCriterion</a>
1252	<p></p>
1253	<pre class="code">+--------------+-------------+------+-----+---------+----------------+
1254	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1255	+--------------+-------------+------+-----+---------+----------------+
1256	\| search \| int(11) \| \| PRI \| 0 \| \|
1257	\| position \| smallint(6) \| \| PRI \| NULL \| auto_increment \|
1258	\| field \| varchar(80) \| \| \| \| \|
1259	\| op \| tinyint(4) \| \| \| 0 \| \|
1260	\| searchString \| text \| \| \| \| \|
1261	+--------------+-------------+------+-----+---------+----------------+</pre>
1262
1263
1264	<a name="Software"/>
1265	<a href="#top">Software</a>
1266	<p></p>
1267	<pre class="code">+-------------+-------------+------+-----+------------+----------------+
1268	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1269	+-------------+-------------+------+-----+------------+----------------+
1270	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
1271	\| name \| varchar(80) \| \| MUL \| \| \|
1272	\| descr \| text \| \| \| \| \|
1273	\| owner \| int(11) \| \| \| 0 \| \|
1274	\| addedDate \| date \| \| \| 0000-00-00 \| \|
1275	\| version \| varchar(80) \| \| \| \| \|
1276	\| removed \| tinyint(1) \| \| \| 0 \| \|
1277	\| gid \| int(11) \| \| \| 0 \| \|
1278	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
1279	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
1280	+-------------+-------------+------+-----+------------+----------------+</pre>
1281
1282
1283	<a name="TemplateBioAssayData"/>
1284	<a href="#top">TemplateBioAssayData</a>
1285	<p></p>
1286	<pre class="code">+------------+--------------+------+-----+---------+-------+
1287	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1288	+------------+--------------+------+-----+---------+-------+
1289	\| bioAssay \| mediumint(9) \| \| PRI \| 0 \| \|
1290	\| position \| mediumint(9) \| \| PRI \| 0 \| \|
1291	\| reporter \| mediumint(9) \| \| \| 0 \| \|
1292	\| intensity1 \| float \| \| \| 0 \| \|
1293	+------------+--------------+------+-----+---------+-------+</pre>
1294
1295
1296	<a name="TemplateBioAssayExtraFloat"/>
1297	<a href="#top">TemplateBioAssayExtraFloat</a>
1298	<p></p>
1299	<pre class="code">+-----------------+--------------+------+-----+---------+-------+
1300	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1301	+-----------------+--------------+------+-----+---------+-------+
1302	\| bioAssay \| mediumint(9) \| \| PRI \| 0 \| \|
1303	\| position \| mediumint(9) \| \| PRI \| 0 \| \|
1304	\| extraDataColumn \| smallint(6) \| \| PRI \| 0 \| \|
1305	\| extraValue \| float \| YES \| \| NULL \| \|
1306	+-----------------+--------------+------+-----+---------+-------+</pre>
1307
1308
1309	<a name="TemplateBioAssayExtraString"/>
1310	<a href="#top">TemplateBioAssayExtraString</a>
1311	<p></p>
1312	<pre class="code">+-----------------+--------------+------+-----+---------+-------+
1313	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1314	+-----------------+--------------+------+-----+---------+-------+
1315	\| bioAssay \| mediumint(9) \| \| PRI \| 0 \| \|
1316	\| position \| mediumint(9) \| \| PRI \| 0 \| \|
1317	\| extraDataColumn \| smallint(6) \| \| PRI \| 0 \| \|
1318	\| extraValue \| mediumtext \| YES \| \| NULL \| \|
1319	+-----------------+--------------+------+-----+---------+-------+</pre>
1320
1321
1322	<a name="TemplateBioAssaySetGene"/>
1323	<a href="#top">TemplateBioAssaySetGene</a>
1324	<p></p>
1325	<pre class="code">+-------------+--------------+------+-----+---------+-------+
1326	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1327	+-------------+--------------+------+-----+---------+-------+
1328	\| bioAssaySet \| mediumint(9) \| \| PRI \| 0 \| \|
1329	\| reporter \| mediumint(9) \| \| PRI \| 0 \| \|
1330	\| cnt \| smallint(11) \| \| \| 0 \| \|
1331	+-------------+--------------+------+-----+---------+-------+</pre>
1332
1333
1334	<a name="TemplateBioAssaySetPosGene"/>
1335	<a href="#top">TemplateBioAssaySetPosGene</a>
1336	<p></p>
1337	<pre class="code">+-------------+--------------+------+-----+---------+-------+
1338	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1339	+-------------+--------------+------+-----+---------+-------+
1340	\| bioAssaySet \| mediumint(9) \| \| PRI \| 0 \| \|
1341	\| reporter \| mediumint(9) \| \| PRI \| 0 \| \|
1342	\| position \| mediumint(9) \| \| PRI \| 0 \| \|
1343	\| cnt \| smallint(11) \| \| \| 0 \| \|
1344	+-------------+--------------+------+-----+---------+-------+</pre>
1345
1346
1347	<a name="TemplateReporterListRow"/>
1348	<a href="#top">TemplateReporterListRow</a>
1349	<p></p>
1350	<pre class="code">+--------------+--------------+------+-----+---------+-------+
1351	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1352	+--------------+--------------+------+-----+---------+-------+
1353	\| reporterList \| mediumint(9) \| \| PRI \| 0 \| \|
1354	\| reporter \| mediumint(9) \| \| PRI \| 0 \| \|
1355	\| score \| float \| \| \| 0 \| \|
1356	+--------------+--------------+------+-----+---------+-------+</pre>
1357
1358
1359	<a name="Transformation"/>
1360	<a href="#top">Transformation</a>
1361	<p></p>
1362	<pre class="code">+-------------+-------------+------+-----+------------+----------------+
1363	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1364	+-------------+-------------+------+-----+------------+----------------+
1365	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
1366	\| name \| varchar(80) \| \| \| \| \|
1367	\| descr \| text \| \| \| \| \|
1368	\| owner \| int(11) \| \| \| 0 \| \|
1369	\| addedDate \| date \| \| \| 0000-00-00 \| \|
1370	\| bioAssaySet \| int(11) \| \| MUL \| 0 \| \|
1371	\| isFilter \| tinyint(1) \| \| \| 0 \| \|
1372	\| removed \| tinyint(1) \| \| \| 3 \| \|
1373	+-------------+-------------+------+-----+------------+----------------+</pre>
1374
1375
1376	<a name="TransformationCollapse"/>
1377	<a href="#top">TransformationCollapse</a>
1378	<p></p>
1379	<pre class="code">+----------------+---------+------+-----+---------+-------+
1380	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1381	+----------------+---------+------+-----+---------+-------+
1382	\| owner \| int(11) \| \| PRI \| 0 \| \|
1383	\| transformation \| int(11) \| \| PRI \| 0 \| \|
1384	+----------------+---------+------+-----+---------+-------+</pre>
1385
1386
1387	<a name="TransformationSearch"/>
1388	<a href="#top">TransformationSearch</a>
1389	<p></p>
1390	<pre class="code">+------------+-------------+------+-----+---------+-------+
1391	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1392	+------------+-------------+------+-----+---------+-------+
1393	\| item \| int(11) \| \| MUL \| 0 \| \|
1394	\| searchType \| varchar(80) \| \| \| \| \|
1395	\| search \| int(11) \| \| PRI \| 0 \| \|
1396	+------------+-------------+------+-----+---------+-------+</pre>
1397
1398
1399	<a name="Upload"/>
1400	<a href="#top">Upload</a>
1401	<p></p>
1402	<pre class="code">+-------------+--------------+------+-----+---------------------+----------------+
1403	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1404	+-------------+--------------+------+-----+---------------------+----------------+
1405	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
1406	\| owner \| int(11) \| \| MUL \| 0 \| \|
1407	\| name \| varchar(255) \| YES \| \| NULL \| \|
1408	\| fileSize \| int(11) \| \| \| 0 \| \|
1409	\| descr \| text \| \| \| \| \|
1410	\| addedDate \| datetime \| \| \| 0000-00-00 00:00:00 \| \|
1411	\| mimeType \| varchar(100) \| \| \| \| \|
1412	\| removed \| tinyint(1) \| \| \| 3 \| \|
1413	\| gid \| int(11) \| \| \| 0 \| \|
1414	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
1415	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
1416	+-------------+--------------+------+-----+---------------------+----------------+</pre>
1417
1418
1419	<a name="UserAccount"/>
1420	<a href="#top">UserAccount</a>
1421	<p></p>
1422	<pre class="code">+----------------------+--------------+------+-----+------------+-------+
1423	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1424	+----------------------+--------------+------+-----+------------+-------+
1425	\| userGroup \| int(11) \| \| PRI \| 0 \| \|
1426	\| email \| varchar(255) \| \| \| \| \|
1427	\| address \| text \| \| \| \| \|
1428	\| phone \| varchar(60) \| \| \| \| \|
1429	\| fax \| varchar(60) \| \| \| \| \|
1430	\| realName \| varchar(80) \| \| \| \| \|
1431	\| md5Pass \| varchar(40) \| \| \| \| \|
1432	\| activeUntil \| date \| \| \| 9999-12-31 \| \|
1433	\| fileQuota \| double \| \| \| -1 \| \|
1434	\| lastExperiment \| int(11) \| \| \| 0 \| \|
1435	\| lastExploredSet \| int(11) \| \| \| 0 \| \|
1436	\| lastPlateType \| int(11) \| \| \| 0 \| \|
1437	\| lastPlateTypeCreated \| int(11) \| \| \| 0 \| \|
1438	\| defaultGid \| int(11) \| \| \| 0 \| \|
1439	\| defaultGroupAccess \| tinyint(1) \| \| \| 0 \| \|
1440	\| defaultWorldAccess \| tinyint(1) \| \| \| 0 \| \|
1441	+----------------------+--------------+------+-----+------------+-------+</pre>
1442
1443
1444	<a name="UserGroup"/>
1445	<a href="#top">UserGroup</a>
1446	<p></p>
1447	<p>Class: MigrateUser</p>
1448	<pre class="code">+------------+-------------+------+-----+------------+----------------+
1449	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1450	+------------+-------------+------+-----+------------+----------------+
1451	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
1452	\| name \| varchar(30) \| YES \| MUL \| NULL \| \|
1453	\| descr \| text \| \| \| \| \|
1454	\| owner \| int(11) \| \| \| 0 \| \|
1455	\| addedDate \| date \| \| \| 0000-00-00 \| \|
1456	\| removed \| tinyint(1) \| \| \| 0 \| \|
1457	\| accessMask \| int(11) \| \| \| 0 \| \|
1458	\| isAccount \| tinyint(1) \| \| \| 0 \| \|
1459	+------------+-------------+------+-----+------------+----------------+</pre>
1460
1461
1462	<a name="UserGroupParent"/>
1463	<a href="#top">UserGroupParent</a>
1464	<p></p>
1465	<pre class="code">+------------+------------+------+-----+---------+-------+
1466	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1467	+------------+------------+------+-----+---------+-------+
1468	\| child \| int(11) \| \| PRI \| 0 \| \|
1469	\| parent \| int(11) \| \| PRI \| 0 \| \|
1470	\| isReviewer \| tinyint(1) \| \| \| 0 \| \|
1471	+------------+------------+------+-----+---------+-------+</pre>
1472
1473
1474	<a name="UserSearch"/>
1475	<a href="#top">UserSearch</a>
1476	<p></p>
1477	<pre class="code">+------------+-------------+------+-----+---------+-------+
1478	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1479	+------------+-------------+------+-----+---------+-------+
1480	\| item \| int(11) \| \| MUL \| 0 \| \|
1481	\| searchType \| varchar(80) \| \| \| \| \|
1482	\| search \| int(11) \| \| PRI \| 0 \| \|
1483	+------------+-------------+------+-----+---------+-------+</pre>
1484
1485
1486	<a name="Well"/>
1487	<a href="#top">Well</a>
1488	<p></p>
1489	<pre class="code">+-----------------+------------------------------------+------+-----+---------+----------------+
1490	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1491	+-----------------+------------------------------------+------+-----+---------+----------------+
1492	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
1493	\| parent \| int(11) \| \| \| 0 \| \|
1494	\| plate \| mediumint(9) \| \| MUL \| 0 \| \|
1495	\| x \| smallint(6) \| \| \| 0 \| \|
1496	\| y \| smallint(6) \| \| \| 0 \| \|
1497	\| probe \| int(11) \| \| MUL \| 0 \| \|
1498	\| seqVerified \| enum('','good','bad','failed') \| \| \| \| \|
1499	\| bands \| enum('','good','missing','double') \| \| \| \| \|
1500	\| bacterialGrowth \| enum('','yes','no') \| \| \| \| \|
1501	\| comment \| text \| \| \| \| \|
1502	+-----------------+------------------------------------+------+-----+---------+----------------+</pre>
1503
1504
1505	<a name="WellAncestor"/>
1506	<a href="#top">WellAncestor</a>
1507	<p></p>
1508	<pre class="code">+----------+-------------+------+-----+---------+-------+
1509	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1510	+----------+-------------+------+-----+---------+-------+
1511	\| well \| int(11) \| \| PRI \| 0 \| \|
1512	\| ancestor \| int(11) \| \| PRI \| 0 \| \|
1513	\| depth \| smallint(6) \| \| \| 0 \| \|
1514	+----------+-------------+------+-----+---------+-------+</pre>
1515
1516
1517	<a name="Wizzzard"/>
1518	<a href="#top">Wizzzard</a>
1519	<p></p>
1520	<pre class="code">+----------------+-------------+------+-----+------------+----------------+
1521	\| Field \| Type \| Null \| Key \| Default \| Extra \|
1522	+----------------+-------------+------+-----+------------+----------------+
1523	\| id \| int(11) \| \| PRI \| NULL \| auto_increment \|
1524	\| owner \| int(11) \| \| \| 0 \| \|
1525	\| formatType \| varchar(40) \| \| MUL \| \| \|
1526	\| name \| varchar(80) \| \| \| \| \|
1527	\| minCols \| smallint(6) \| \| \| 0 \| \|
1528	\| maxCols \| smallint(6) \| \| \| 0 \| \|
1529	\| dataHeader \| text \| \| \| \| \|
1530	\| typeHeader \| text \| \| \| \| \|
1531	\| typeHeaderLine \| int(11) \| \| \| 0 \| \|
1532	\| mapping \| mediumtext \| \| \| \| \|
1533	\| descr \| text \| \| \| \| \|
1534	\| addedDate \| date \| \| \| 0000-00-00 \| \|
1535	\| removed \| tinyint(1) \| \| \| 0 \| \|
1536	\| gid \| int(11) \| \| \| 0 \| \|
1537	\| groupAccess \| tinyint(1) \| \| \| 0 \| \|
1538	\| worldAccess \| tinyint(1) \| \| \| 0 \| \|
1539	\| dataFooter \| text \| YES \| \| NULL \| \|
1540	\| fieldSeparator \| varchar(10) \| \| \| \| \|
1541	\| maxHeaderLine \| int(11) \| \| \| 120 \| \|
1542	+----------------+-------------+------+-----+------------+----------------+</pre>
1543
1544
1545
1546
1547
1548
1549
1550	</body>
1551	</html>

Note: See TracBrowser for help on using the repository browser.

Context Navigation

source: trunk/doc/historical/specifications/migration/base1Tables.html @ 4394

Download in other formats: