Debian Codegraph @

modules/mage/mage.html

raw
1 <!DOCTYPE html
2 PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
3 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4 <html xmlns="http://www.w3.org/1999/xhtml" lang="en-US" xml:lang="en-US">
5 <head>
6 <title>Description of Schema</title>
7 <meta name="generator" content="SQL::Translator::Producer::HTML" />
8 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
9 </head>
10 <body>
11
12
13 <h1 class="SchemaDescription">
14 Description of Schema
15 </h1>
16
17 <hr />
18
19 <!--
20 Table listing (36 tables)
21 -->
22
23 <a name="top" />
24
25 <table class="LinkTable" width="100%">
26
27 <tr>
28 <td class="LinkTableCell"><h2 class="LinkTableTitle">
29 Tables
30 </h2></td>
31 </tr>
32
33 <!--
34 Start link to table 'mageml'
35 -->
36
37 <tr class="LinkTableRow">
38 <td class="LinkTableCell"><a id="mageml-link" href="#mageml">mageml</a></td>
39 </tr>
40
41 <!--
42 End link to table 'mageml'
43 -->
44
45 <!--
46 Start link to table 'magedocumentation'
47 -->
48
49 <tr class="LinkTableRow">
50 <td class="LinkTableCell"><a id="magedocumentation-link" href="#magedocumentation">magedocumentation</a></td>
51 </tr>
52
53 <!--
54 End link to table 'magedocumentation'
55 -->
56
57 <!--
58 Start link to table 'protocol'
59 -->
60
61 <tr class="LinkTableRow">
62 <td class="LinkTableCell"><a id="protocol-link" href="#protocol">protocol</a></td>
63 </tr>
64
65 <!--
66 End link to table 'protocol'
67 -->
68
69 <!--
70 Start link to table 'protocolparam'
71 -->
72
73 <tr class="LinkTableRow">
74 <td class="LinkTableCell"><a id="protocolparam-link" href="#protocolparam">protocolparam</a></td>
75 </tr>
76
77 <!--
78 End link to table 'protocolparam'
79 -->
80
81 <!--
82 Start link to table 'channel'
83 -->
84
85 <tr class="LinkTableRow">
86 <td class="LinkTableCell"><a id="channel-link" href="#channel">channel</a></td>
87 </tr>
88
89 <!--
90 End link to table 'channel'
91 -->
92
93 <!--
94 Start link to table 'arraydesign'
95 -->
96
97 <tr class="LinkTableRow">
98 <td class="LinkTableCell"><a id="arraydesign-link" href="#arraydesign">arraydesign</a></td>
99 </tr>
100
101 <!--
102 End link to table 'arraydesign'
103 -->
104
105 <!--
106 Start link to table 'arraydesignprop'
107 -->
108
109 <tr class="LinkTableRow">
110 <td class="LinkTableCell"><a id="arraydesignprop-link" href="#arraydesignprop">arraydesignprop</a></td>
111 </tr>
112
113 <!--
114 End link to table 'arraydesignprop'
115 -->
116
117 <!--
118 Start link to table 'assay'
119 -->
120
121 <tr class="LinkTableRow">
122 <td class="LinkTableCell"><a id="assay-link" href="#assay">assay</a></td>
123 </tr>
124
125 <!--
126 End link to table 'assay'
127 -->
128
129 <!--
130 Start link to table 'assayprop'
131 -->
132
133 <tr class="LinkTableRow">
134 <td class="LinkTableCell"><a id="assayprop-link" href="#assayprop">assayprop</a></td>
135 </tr>
136
137 <!--
138 End link to table 'assayprop'
139 -->
140
141 <!--
142 Start link to table 'assay_project'
143 -->
144
145 <tr class="LinkTableRow">
146 <td class="LinkTableCell"><a id="assay_project-link" href="#assay_project">assay_project</a></td>
147 </tr>
148
149 <!--
150 End link to table 'assay_project'
151 -->
152
153 <!--
154 Start link to table 'biomaterial'
155 -->
156
157 <tr class="LinkTableRow">
158 <td class="LinkTableCell"><a id="biomaterial-link" href="#biomaterial">biomaterial</a></td>
159 </tr>
160
161 <!--
162 End link to table 'biomaterial'
163 -->
164
165 <!--
166 Start link to table 'biomaterial_relationship'
167 -->
168
169 <tr class="LinkTableRow">
170 <td class="LinkTableCell"><a id="biomaterial_relationship-link" href="#biomaterial_relationship">biomaterial_relationship</a></td>
171 </tr>
172
173 <!--
174 End link to table 'biomaterial_relationship'
175 -->
176
177 <!--
178 Start link to table 'biomaterialprop'
179 -->
180
181 <tr class="LinkTableRow">
182 <td class="LinkTableCell"><a id="biomaterialprop-link" href="#biomaterialprop">biomaterialprop</a></td>
183 </tr>
184
185 <!--
186 End link to table 'biomaterialprop'
187 -->
188
189 <!--
190 Start link to table 'biomaterial_dbxref'
191 -->
192
193 <tr class="LinkTableRow">
194 <td class="LinkTableCell"><a id="biomaterial_dbxref-link" href="#biomaterial_dbxref">biomaterial_dbxref</a></td>
195 </tr>
196
197 <!--
198 End link to table 'biomaterial_dbxref'
199 -->
200
201 <!--
202 Start link to table 'treatment'
203 -->
204
205 <tr class="LinkTableRow">
206 <td class="LinkTableCell"><a id="treatment-link" href="#treatment">treatment</a></td>
207 </tr>
208
209 <!--
210 End link to table 'treatment'
211 -->
212
213 <!--
214 Start link to table 'biomaterial_treatment'
215 -->
216
217 <tr class="LinkTableRow">
218 <td class="LinkTableCell"><a id="biomaterial_treatment-link" href="#biomaterial_treatment">biomaterial_treatment</a></td>
219 </tr>
220
221 <!--
222 End link to table 'biomaterial_treatment'
223 -->
224
225 <!--
226 Start link to table 'assay_biomaterial'
227 -->
228
229 <tr class="LinkTableRow">
230 <td class="LinkTableCell"><a id="assay_biomaterial-link" href="#assay_biomaterial">assay_biomaterial</a></td>
231 </tr>
232
233 <!--
234 End link to table 'assay_biomaterial'
235 -->
236
237 <!--
238 Start link to table 'acquisition'
239 -->
240
241 <tr class="LinkTableRow">
242 <td class="LinkTableCell"><a id="acquisition-link" href="#acquisition">acquisition</a></td>
243 </tr>
244
245 <!--
246 End link to table 'acquisition'
247 -->
248
249 <!--
250 Start link to table 'acquisitionprop'
251 -->
252
253 <tr class="LinkTableRow">
254 <td class="LinkTableCell"><a id="acquisitionprop-link" href="#acquisitionprop">acquisitionprop</a></td>
255 </tr>
256
257 <!--
258 End link to table 'acquisitionprop'
259 -->
260
261 <!--
262 Start link to table 'acquisition_relationship'
263 -->
264
265 <tr class="LinkTableRow">
266 <td class="LinkTableCell"><a id="acquisition_relationship-link" href="#acquisition_relationship">acquisition_relationship</a></td>
267 </tr>
268
269 <!--
270 End link to table 'acquisition_relationship'
271 -->
272
273 <!--
274 Start link to table 'quantification'
275 -->
276
277 <tr class="LinkTableRow">
278 <td class="LinkTableCell"><a id="quantification-link" href="#quantification">quantification</a></td>
279 </tr>
280
281 <!--
282 End link to table 'quantification'
283 -->
284
285 <!--
286 Start link to table 'quantificationprop'
287 -->
288
289 <tr class="LinkTableRow">
290 <td class="LinkTableCell"><a id="quantificationprop-link" href="#quantificationprop">quantificationprop</a></td>
291 </tr>
292
293 <!--
294 End link to table 'quantificationprop'
295 -->
296
297 <!--
298 Start link to table 'quantification_relationship'
299 -->
300
301 <tr class="LinkTableRow">
302 <td class="LinkTableCell"><a id="quantification_relationship-link" href="#quantification_relationship">quantification_relationship</a></td>
303 </tr>
304
305 <!--
306 End link to table 'quantification_relationship'
307 -->
308
309 <!--
310 Start link to table 'control'
311 -->
312
313 <tr class="LinkTableRow">
314 <td class="LinkTableCell"><a id="control-link" href="#control">control</a></td>
315 </tr>
316
317 <!--
318 End link to table 'control'
319 -->
320
321 <!--
322 Start link to table 'element'
323 -->
324
325 <tr class="LinkTableRow">
326 <td class="LinkTableCell"><a id="element-link" href="#element">element</a></td>
327 </tr>
328
329 <!--
330 End link to table 'element'
331 -->
332
333 <!--
334 Start link to table 'elementresult'
335 -->
336
337 <tr class="LinkTableRow">
338 <td class="LinkTableCell"><a id="elementresult-link" href="#elementresult">elementresult</a></td>
339 </tr>
340
341 <!--
342 End link to table 'elementresult'
343 -->
344
345 <!--
346 Start link to table 'element_relationship'
347 -->
348
349 <tr class="LinkTableRow">
350 <td class="LinkTableCell"><a id="element_relationship-link" href="#element_relationship">element_relationship</a></td>
351 </tr>
352
353 <!--
354 End link to table 'element_relationship'
355 -->
356
357 <!--
358 Start link to table 'elementresult_relationship'
359 -->
360
361 <tr class="LinkTableRow">
362 <td class="LinkTableCell"><a id="elementresult_relationship-link" href="#elementresult_relationship">elementresult_relationship</a></td>
363 </tr>
364
365 <!--
366 End link to table 'elementresult_relationship'
367 -->
368
369 <!--
370 Start link to table 'study'
371 -->
372
373 <tr class="LinkTableRow">
374 <td class="LinkTableCell"><a id="study-link" href="#study">study</a></td>
375 </tr>
376
377 <!--
378 End link to table 'study'
379 -->
380
381 <!--
382 Start link to table 'study_assay'
383 -->
384
385 <tr class="LinkTableRow">
386 <td class="LinkTableCell"><a id="study_assay-link" href="#study_assay">study_assay</a></td>
387 </tr>
388
389 <!--
390 End link to table 'study_assay'
391 -->
392
393 <!--
394 Start link to table 'studydesign'
395 -->
396
397 <tr class="LinkTableRow">
398 <td class="LinkTableCell"><a id="studydesign-link" href="#studydesign">studydesign</a></td>
399 </tr>
400
401 <!--
402 End link to table 'studydesign'
403 -->
404
405 <!--
406 Start link to table 'studydesignprop'
407 -->
408
409 <tr class="LinkTableRow">
410 <td class="LinkTableCell"><a id="studydesignprop-link" href="#studydesignprop">studydesignprop</a></td>
411 </tr>
412
413 <!--
414 End link to table 'studydesignprop'
415 -->
416
417 <!--
418 Start link to table 'studyfactor'
419 -->
420
421 <tr class="LinkTableRow">
422 <td class="LinkTableCell"><a id="studyfactor-link" href="#studyfactor">studyfactor</a></td>
423 </tr>
424
425 <!--
426 End link to table 'studyfactor'
427 -->
428
429 <!--
430 Start link to table 'studyfactorvalue'
431 -->
432
433 <tr class="LinkTableRow">
434 <td class="LinkTableCell"><a id="studyfactorvalue-link" href="#studyfactorvalue">studyfactorvalue</a></td>
435 </tr>
436
437 <!--
438 End link to table 'studyfactorvalue'
439 -->
440
441 <!--
442 Start link to table 'studyprop'
443 -->
444
445 <tr class="LinkTableRow">
446 <td class="LinkTableCell"><a id="studyprop-link" href="#studyprop">studyprop</a></td>
447 </tr>
448
449 <!--
450 End link to table 'studyprop'
451 -->
452
453 <!--
454 Start link to table 'studyprop_feature'
455 -->
456
457 <tr class="LinkTableRow">
458 <td class="LinkTableCell"><a id="studyprop_feature-link" href="#studyprop_feature">studyprop_feature</a></td>
459 </tr>
460
461 <!--
462 End link to table 'studyprop_feature'
463 -->
464
465 </table>
466
467 <!--
468 Starting table 'mageml'
469 -->
470
471 <a name="mageml" />
472
473 <table width="100%" class="TableHeader">
474 <tr class="TableHeaderRow">
475 <td class="TableHeaderCell"><h3>
476 mageml
477 </h3></td> <a name="mageml"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
478 </tr>
479 </table>
480
481 <b>
482 Comments:
483 </b>
484
485 <br />
486
487 <em>
488 <br />
489 $Id: mage.sql,v 1.3 2008-03-19 18:32:51 scottcain Exp $ <br />
490 ========================================== <br />
491 Chado mage module <br />
492 ================================================================= <br />
493 Dependencies: <br />
494 :import feature from sequence <br />
495 :import cvterm from cv <br />
496 :import pub from pub <br />
497 :import organism from organism <br />
498 :import contact from contact <br />
499 :import dbxref from db <br />
500 :import tableinfo from general <br />
501 :import project from project <br />
502 :import analysis from companalysis <br />
503 ================================================================= <br />
504 ================================================ <br />
505 TABLE: mageml <br />
506 ================================================ <br />
507 This table is for storing extra bits of MAGEml in a denormalized form. More normalization would require many more tables.
508 </em>
509
510 <table border="1">
511
512 <tr>
513 <th class="FieldHeader">
514 Field Name
515 </th>
516 <th class="FieldHeader">
517 Data Type
518 </th>
519 <th class="FieldHeader">
520 Size
521 </th>
522 <th class="FieldHeader">
523 Default Value
524 </th>
525 <th class="FieldHeader">
526 Other
527 </th>
528 <th class="FieldHeader">
529 Foreign Key
530 </th>
531 </tr>
532
533 <tr class="tr-odd">
534 <td class="FieldCellName"><a name="mageml-mageml_id">mageml_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
535 </tr>
536
537 <tr class="tr-even">
538 <td class="FieldCellName"><a name="mageml-mage_package">mage_package</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
539 </tr>
540
541 <tr class="tr-odd">
542 <td class="FieldCellName"><a name="mageml-mage_ml">mage_ml</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
543 </tr>
544
545 </table>
546
547 <h3>
548 Constraints
549 </h3>
550
551 <table border="1">
552
553 <tr class="IndexRow">
554 <th>
555 Type
556 </th>
557 <th>
558 Fields
559 </th>
560 </tr>
561
562 <tr class="IndexCell">
563 <td>NOT NULL</td><td>mageml_id</td>
564 </tr>
565
566 <tr class="IndexCell">
567 <td>NOT NULL</td><td>mage_package</td>
568 </tr>
569
570 <tr class="IndexCell">
571 <td>NOT NULL</td><td>mage_ml</td>
572 </tr>
573
574 </table>
575
576 <hr />
577
578 <!--
579 Starting table 'magedocumentation'
580 -->
581
582 <a name="magedocumentation" />
583
584 <table class="TableHeader" width="100%">
585 <tr class="TableHeaderRow">
586 <td class="TableHeaderCell"><h3>
587 magedocumentation
588 </h3></td> <a name="magedocumentation"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
589 </tr>
590 </table>
591
592 <b>
593 Comments:
594 </b>
595
596 <br />
597
598 <em>
599 <br />
600 ================================================ <br />
601 TABLE: magedocumentation <br />
602 ================================================ <br />
603 NULL
604 </em>
605
606 <table border="1">
607
608 <tr>
609 <th class="FieldHeader">
610 Field Name
611 </th>
612 <th class="FieldHeader">
613 Data Type
614 </th>
615 <th class="FieldHeader">
616 Size
617 </th>
618 <th class="FieldHeader">
619 Default Value
620 </th>
621 <th class="FieldHeader">
622 Other
623 </th>
624 <th class="FieldHeader">
625 Foreign Key
626 </th>
627 </tr>
628
629 <tr class="tr-odd">
630 <td class="FieldCellName"><a name="magedocumentation-magedocumentation_id">magedocumentation_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
631 </tr>
632
633 <tr class="tr-even">
634 <td class="FieldCellName"><a name="magedocumentation-mageml_id">mageml_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#mageml-mageml_id">mageml.mageml_id</a></td>
635 </tr>
636
637 <tr class="tr-odd">
638 <td class="FieldCellName"><a name="magedocumentation-tableinfo_id">tableinfo_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#tableinfo-tableinfo_id">tableinfo.tableinfo_id</a></td>
639 </tr>
640
641 <tr class="tr-even">
642 <td class="FieldCellName"><a name="magedocumentation-row_id">row_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
643 </tr>
644
645 <tr class="tr-odd">
646 <td class="FieldCellName"><a name="magedocumentation-mageidentifier">mageidentifier</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
647 </tr>
648
649 </table>
650
651 <h3>
652 Indices
653 </h3>
654
655 <table border="1">
656
657 <tr class="IndexRow">
658 <th>
659 Name
660 </th>
661 <th>
662 Fields
663 </th>
664 </tr>
665
666 <tr class="IndexCell">
667 <td>magedocumentation_idx1</td><td>mageml_id</td>
668 </tr>
669
670 <tr class="IndexCell">
671 <td>magedocumentation_idx2</td><td>tableinfo_id</td>
672 </tr>
673
674 <tr class="IndexCell">
675 <td>magedocumentation_idx3</td><td>row_id</td>
676 </tr>
677
678 </table>
679
680 <h3>
681 Constraints
682 </h3>
683
684 <table border="1">
685
686 <tr class="IndexRow">
687 <th>
688 Type
689 </th>
690 <th>
691 Fields
692 </th>
693 </tr>
694
695 <tr class="IndexCell">
696 <td>NOT NULL</td><td>magedocumentation_id</td>
697 </tr>
698
699 <tr class="IndexCell">
700 <td>NOT NULL</td><td>mageml_id</td>
701 </tr>
702
703 <tr class="IndexCell">
704 <td>FOREIGN KEY</td><td>mageml_id</td>
705 </tr>
706
707 <tr class="IndexCell">
708 <td>NOT NULL</td><td>tableinfo_id</td>
709 </tr>
710
711 <tr class="IndexCell">
712 <td>FOREIGN KEY</td><td>tableinfo_id</td>
713 </tr>
714
715 <tr class="IndexCell">
716 <td>NOT NULL</td><td>row_id</td>
717 </tr>
718
719 <tr class="IndexCell">
720 <td>NOT NULL</td><td>mageidentifier</td>
721 </tr>
722
723 </table>
724
725 <hr />
726
727 <!--
728 Starting table 'protocol'
729 -->
730
731 <a name="protocol" />
732
733 <table width="100%" class="TableHeader">
734 <tr class="TableHeaderRow">
735 <td class="TableHeaderCell"><h3>
736 protocol
737 </h3></td> <a name="protocol"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
738 </tr>
739 </table>
740
741 <b>
742 Comments:
743 </b>
744
745 <br />
746
747 <em>
748 <br />
749 ================================================ <br />
750 TABLE: protocol <br />
751 ================================================ <br />
752 Procedural notes on how data was prepared and processed.
753 </em>
754
755 <table border="1">
756
757 <tr>
758 <th class="FieldHeader">
759 Field Name
760 </th>
761 <th class="FieldHeader">
762 Data Type
763 </th>
764 <th class="FieldHeader">
765 Size
766 </th>
767 <th class="FieldHeader">
768 Default Value
769 </th>
770 <th class="FieldHeader">
771 Other
772 </th>
773 <th class="FieldHeader">
774 Foreign Key
775 </th>
776 </tr>
777
778 <tr class="tr-odd">
779 <td class="FieldCellName"><a name="protocol-protocol_id">protocol_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
780 </tr>
781
782 <tr class="tr-even">
783 <td class="FieldCellName"><a name="protocol-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
784 </tr>
785
786 <tr class="tr-odd">
787 <td class="FieldCellName"><a name="protocol-pub_id">pub_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
788 </tr>
789
790 <tr class="tr-even">
791 <td class="FieldCellName"><a name="protocol-dbxref_id">dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
792 </tr>
793
794 <tr class="tr-odd">
795 <td class="FieldCellName"><a name="protocol-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
796 </tr>
797
798 <tr class="tr-even">
799 <td class="FieldCellName"><a name="protocol-uri">uri</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
800 </tr>
801
802 <tr class="tr-odd">
803 <td class="FieldCellName"><a name="protocol-protocoldescription">protocoldescription</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
804 </tr>
805
806 <tr class="tr-even">
807 <td class="FieldCellName"><a name="protocol-hardwaredescription">hardwaredescription</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
808 </tr>
809
810 <tr class="tr-odd">
811 <td class="FieldCellName"><a name="protocol-softwaredescription">softwaredescription</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
812 </tr>
813
814 </table>
815
816 <h3>
817 Indices
818 </h3>
819
820 <table border="1">
821
822 <tr class="IndexRow">
823 <th>
824 Name
825 </th>
826 <th>
827 Fields
828 </th>
829 </tr>
830
831 <tr class="IndexCell">
832 <td>protocol_idx1</td><td>type_id</td>
833 </tr>
834
835 <tr class="IndexCell">
836 <td>protocol_idx2</td><td>pub_id</td>
837 </tr>
838
839 <tr class="IndexCell">
840 <td>protocol_idx3</td><td>dbxref_id</td>
841 </tr>
842
843 </table>
844
845 <h3>
846 Constraints
847 </h3>
848
849 <table border="1">
850
851 <tr class="IndexRow">
852 <th>
853 Type
854 </th>
855 <th>
856 Fields
857 </th>
858 </tr>
859
860 <tr class="IndexCell">
861 <td>NOT NULL</td><td>protocol_id</td>
862 </tr>
863
864 <tr class="IndexCell">
865 <td>NOT NULL</td><td>type_id</td>
866 </tr>
867
868 <tr class="IndexCell">
869 <td>FOREIGN KEY</td><td>type_id</td>
870 </tr>
871
872 <tr class="IndexCell">
873 <td>FOREIGN KEY</td><td>pub_id</td>
874 </tr>
875
876 <tr class="IndexCell">
877 <td>FOREIGN KEY</td><td>dbxref_id</td>
878 </tr>
879
880 <tr class="IndexCell">
881 <td>NOT NULL</td><td>name</td>
882 </tr>
883
884 <tr class="IndexCell">
885 <td>UNIQUE</td><td>name</td>
886 </tr>
887
888 </table>
889
890 <hr />
891
892 <!--
893 Starting table 'protocolparam'
894 -->
895
896 <a name="protocolparam" />
897
898 <table class="TableHeader" width="100%">
899 <tr class="TableHeaderRow">
900 <td class="TableHeaderCell"><h3>
901 protocolparam
902 </h3></td> <a name="protocolparam"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
903 </tr>
904 </table>
905
906 <b>
907 Comments:
908 </b>
909
910 <br />
911
912 <em>
913 <br />
914 ================================================ <br />
915 TABLE: protocolparam <br />
916 ================================================ <br />
917 Parameters related to a
918 protocol. For example, if the protocol is a soak, this might include attributes of bath temperature and duration.
919 </em>
920
921 <table border="1">
922
923 <tr>
924 <th class="FieldHeader">
925 Field Name
926 </th>
927 <th class="FieldHeader">
928 Data Type
929 </th>
930 <th class="FieldHeader">
931 Size
932 </th>
933 <th class="FieldHeader">
934 Default Value
935 </th>
936 <th class="FieldHeader">
937 Other
938 </th>
939 <th class="FieldHeader">
940 Foreign Key
941 </th>
942 </tr>
943
944 <tr class="tr-odd">
945 <td class="FieldCellName"><a name="protocolparam-protocolparam_id">protocolparam_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
946 </tr>
947
948 <tr class="tr-even">
949 <td class="FieldCellName"><a name="protocolparam-protocol_id">protocol_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#protocol-protocol_id">protocol.protocol_id</a></td>
950 </tr>
951
952 <tr class="tr-odd">
953 <td class="FieldCellName"><a name="protocolparam-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
954 </tr>
955
956 <tr class="tr-even">
957 <td class="FieldCellName"><a name="protocolparam-datatype_id">datatype_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
958 </tr>
959
960 <tr class="tr-odd">
961 <td class="FieldCellName"><a name="protocolparam-unittype_id">unittype_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
962 </tr>
963
964 <tr class="tr-even">
965 <td class="FieldCellName"><a name="protocolparam-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
966 </tr>
967
968 <tr class="tr-odd">
969 <td class="FieldCellName"><a name="protocolparam-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
970 </tr>
971
972 </table>
973
974 <h3>
975 Indices
976 </h3>
977
978 <table border="1">
979
980 <tr class="IndexRow">
981 <th>
982 Name
983 </th>
984 <th>
985 Fields
986 </th>
987 </tr>
988
989 <tr class="IndexCell">
990 <td>protocolparam_idx1</td><td>protocol_id</td>
991 </tr>
992
993 <tr class="IndexCell">
994 <td>protocolparam_idx2</td><td>datatype_id</td>
995 </tr>
996
997 <tr class="IndexCell">
998 <td>protocolparam_idx3</td><td>unittype_id</td>
999 </tr>
1000
1001 </table>
1002
1003 <h3>
1004 Constraints
1005 </h3>
1006
1007 <table border="1">
1008
1009 <tr class="IndexRow">
1010 <th>
1011 Type
1012 </th>
1013 <th>
1014 Fields
1015 </th>
1016 </tr>
1017
1018 <tr class="IndexCell">
1019 <td>NOT NULL</td><td>protocolparam_id</td>
1020 </tr>
1021
1022 <tr class="IndexCell">
1023 <td>NOT NULL</td><td>protocol_id</td>
1024 </tr>
1025
1026 <tr class="IndexCell">
1027 <td>FOREIGN KEY</td><td>protocol_id</td>
1028 </tr>
1029
1030 <tr class="IndexCell">
1031 <td>NOT NULL</td><td>name</td>
1032 </tr>
1033
1034 <tr class="IndexCell">
1035 <td>FOREIGN KEY</td><td>datatype_id</td>
1036 </tr>
1037
1038 <tr class="IndexCell">
1039 <td>FOREIGN KEY</td><td>unittype_id</td>
1040 </tr>
1041
1042 <tr class="IndexCell">
1043 <td>NOT NULL</td><td>rank</td>
1044 </tr>
1045
1046 </table>
1047
1048 <hr />
1049
1050 <!--
1051 Starting table 'channel'
1052 -->
1053
1054 <a name="channel" />
1055
1056 <table class="TableHeader" width="100%">
1057 <tr class="TableHeaderRow">
1058 <td class="TableHeaderCell"><h3>
1059 channel
1060 </h3></td> <a name="channel"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1061 </tr>
1062 </table>
1063
1064 <b>
1065 Comments:
1066 </b>
1067
1068 <br />
1069
1070 <em>
1071 <br />
1072 ================================================ <br />
1073 TABLE: channel <br />
1074 ================================================ <br />
1075 Different array platforms can record signals from one or more channels (cDNA arrays typically use two CCD, but Affymetrix uses only one).
1076 </em>
1077
1078 <table border="1">
1079
1080 <tr>
1081 <th class="FieldHeader">
1082 Field Name
1083 </th>
1084 <th class="FieldHeader">
1085 Data Type
1086 </th>
1087 <th class="FieldHeader">
1088 Size
1089 </th>
1090 <th class="FieldHeader">
1091 Default Value
1092 </th>
1093 <th class="FieldHeader">
1094 Other
1095 </th>
1096 <th class="FieldHeader">
1097 Foreign Key
1098 </th>
1099 </tr>
1100
1101 <tr class="tr-odd">
1102 <td class="FieldCellName"><a name="channel-channel_id">channel_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
1103 </tr>
1104
1105 <tr class="tr-even">
1106 <td class="FieldCellName"><a name="channel-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
1107 </tr>
1108
1109 <tr class="tr-odd">
1110 <td class="FieldCellName"><a name="channel-definition">definition</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
1111 </tr>
1112
1113 </table>
1114
1115 <h3>
1116 Constraints
1117 </h3>
1118
1119 <table border="1">
1120
1121 <tr class="IndexRow">
1122 <th>
1123 Type
1124 </th>
1125 <th>
1126 Fields
1127 </th>
1128 </tr>
1129
1130 <tr class="IndexCell">
1131 <td>NOT NULL</td><td>channel_id</td>
1132 </tr>
1133
1134 <tr class="IndexCell">
1135 <td>NOT NULL</td><td>name</td>
1136 </tr>
1137
1138 <tr class="IndexCell">
1139 <td>NOT NULL</td><td>definition</td>
1140 </tr>
1141
1142 <tr class="IndexCell">
1143 <td>UNIQUE</td><td>name</td>
1144 </tr>
1145
1146 </table>
1147
1148 <hr />
1149
1150 <!--
1151 Starting table 'arraydesign'
1152 -->
1153
1154 <a name="arraydesign" />
1155
1156 <table class="TableHeader" width="100%">
1157 <tr class="TableHeaderRow">
1158 <td class="TableHeaderCell"><h3>
1159 arraydesign
1160 </h3></td> <a name="arraydesign"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1161 </tr>
1162 </table>
1163
1164 <b>
1165 Comments:
1166 </b>
1167
1168 <br />
1169
1170 <em>
1171 <br />
1172 ================================================ <br />
1173 TABLE: arraydesign <br />
1174 ================================================ <br />
1175 General properties about an array.
1176 An array is a template used to generate physical slides, etc. It
1177 contains layout information, as well as global array properties, such
1178 as material (glass, nylon) and spot dimensions (in rows/columns).
1179 </em>
1180
1181 <table border="1">
1182
1183 <tr>
1184 <th class="FieldHeader">
1185 Field Name
1186 </th>
1187 <th class="FieldHeader">
1188 Data Type
1189 </th>
1190 <th class="FieldHeader">
1191 Size
1192 </th>
1193 <th class="FieldHeader">
1194 Default Value
1195 </th>
1196 <th class="FieldHeader">
1197 Other
1198 </th>
1199 <th class="FieldHeader">
1200 Foreign Key
1201 </th>
1202 </tr>
1203
1204 <tr class="tr-odd">
1205 <td class="FieldCellName"><a name="arraydesign-arraydesign_id">arraydesign_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
1206 </tr>
1207
1208 <tr class="tr-even">
1209 <td class="FieldCellName"><a name="arraydesign-manufacturer_id">manufacturer_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#contact-contact_id">contact.contact_id</a></td>
1210 </tr>
1211
1212 <tr class="tr-odd">
1213 <td class="FieldCellName"><a name="arraydesign-platformtype_id">platformtype_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1214 </tr>
1215
1216 <tr class="tr-even">
1217 <td class="FieldCellName"><a name="arraydesign-substratetype_id">substratetype_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1218 </tr>
1219
1220 <tr class="tr-odd">
1221 <td class="FieldCellName"><a name="arraydesign-protocol_id">protocol_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#protocol-protocol_id">protocol.protocol_id</a></td>
1222 </tr>
1223
1224 <tr class="tr-even">
1225 <td class="FieldCellName"><a name="arraydesign-dbxref_id">dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
1226 </tr>
1227
1228 <tr class="tr-odd">
1229 <td class="FieldCellName"><a name="arraydesign-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
1230 </tr>
1231
1232 <tr class="tr-even">
1233 <td class="FieldCellName"><a name="arraydesign-version">version</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1234 </tr>
1235
1236 <tr class="tr-odd">
1237 <td class="FieldCellName"><a name="arraydesign-description">description</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1238 </tr>
1239
1240 <tr class="tr-even">
1241 <td class="FieldCellName"><a name="arraydesign-array_dimensions">array_dimensions</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1242 </tr>
1243
1244 <tr class="tr-odd">
1245 <td class="FieldCellName"><a name="arraydesign-element_dimensions">element_dimensions</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1246 </tr>
1247
1248 <tr class="tr-even">
1249 <td class="FieldCellName"><a name="arraydesign-num_of_elements">num_of_elements</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1250 </tr>
1251
1252 <tr class="tr-odd">
1253 <td class="FieldCellName"><a name="arraydesign-num_array_columns">num_array_columns</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1254 </tr>
1255
1256 <tr class="tr-even">
1257 <td class="FieldCellName"><a name="arraydesign-num_array_rows">num_array_rows</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1258 </tr>
1259
1260 <tr class="tr-odd">
1261 <td class="FieldCellName"><a name="arraydesign-num_grid_columns">num_grid_columns</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1262 </tr>
1263
1264 <tr class="tr-even">
1265 <td class="FieldCellName"><a name="arraydesign-num_grid_rows">num_grid_rows</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1266 </tr>
1267
1268 <tr class="tr-odd">
1269 <td class="FieldCellName"><a name="arraydesign-num_sub_columns">num_sub_columns</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1270 </tr>
1271
1272 <tr class="tr-even">
1273 <td class="FieldCellName"><a name="arraydesign-num_sub_rows">num_sub_rows</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1274 </tr>
1275
1276 </table>
1277
1278 <h3>
1279 Indices
1280 </h3>
1281
1282 <table border="1">
1283
1284 <tr class="IndexRow">
1285 <th>
1286 Name
1287 </th>
1288 <th>
1289 Fields
1290 </th>
1291 </tr>
1292
1293 <tr class="IndexCell">
1294 <td>arraydesign_idx1</td><td>manufacturer_id</td>
1295 </tr>
1296
1297 <tr class="IndexCell">
1298 <td>arraydesign_idx2</td><td>platformtype_id</td>
1299 </tr>
1300
1301 <tr class="IndexCell">
1302 <td>arraydesign_idx3</td><td>substratetype_id</td>
1303 </tr>
1304
1305 <tr class="IndexCell">
1306 <td>arraydesign_idx4</td><td>protocol_id</td>
1307 </tr>
1308
1309 <tr class="IndexCell">
1310 <td>arraydesign_idx5</td><td>dbxref_id</td>
1311 </tr>
1312
1313 </table>
1314
1315 <h3>
1316 Constraints
1317 </h3>
1318
1319 <table border="1">
1320
1321 <tr class="IndexRow">
1322 <th>
1323 Type
1324 </th>
1325 <th>
1326 Fields
1327 </th>
1328 </tr>
1329
1330 <tr class="IndexCell">
1331 <td>NOT NULL</td><td>arraydesign_id</td>
1332 </tr>
1333
1334 <tr class="IndexCell">
1335 <td>NOT NULL</td><td>manufacturer_id</td>
1336 </tr>
1337
1338 <tr class="IndexCell">
1339 <td>FOREIGN KEY</td><td>manufacturer_id</td>
1340 </tr>
1341
1342 <tr class="IndexCell">
1343 <td>NOT NULL</td><td>platformtype_id</td>
1344 </tr>
1345
1346 <tr class="IndexCell">
1347 <td>FOREIGN KEY</td><td>platformtype_id</td>
1348 </tr>
1349
1350 <tr class="IndexCell">
1351 <td>FOREIGN KEY</td><td>substratetype_id</td>
1352 </tr>
1353
1354 <tr class="IndexCell">
1355 <td>FOREIGN KEY</td><td>protocol_id</td>
1356 </tr>
1357
1358 <tr class="IndexCell">
1359 <td>FOREIGN KEY</td><td>dbxref_id</td>
1360 </tr>
1361
1362 <tr class="IndexCell">
1363 <td>NOT NULL</td><td>name</td>
1364 </tr>
1365
1366 <tr class="IndexCell">
1367 <td>UNIQUE</td><td>name</td>
1368 </tr>
1369
1370 </table>
1371
1372 <hr />
1373
1374 <!--
1375 Starting table 'arraydesignprop'
1376 -->
1377
1378 <a name="arraydesignprop" />
1379
1380 <table class="TableHeader" width="100%">
1381 <tr class="TableHeaderRow">
1382 <td class="TableHeaderCell"><h3>
1383 arraydesignprop
1384 </h3></td> <a name="arraydesignprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1385 </tr>
1386 </table>
1387
1388 <b>
1389 Comments:
1390 </b>
1391
1392 <br />
1393
1394 <em>
1395 <br />
1396 ================================================ <br />
1397 TABLE: arraydesignprop <br />
1398 ================================================ <br />
1399 Extra array design properties that are not accounted for in arraydesign.
1400 </em>
1401
1402 <table border="1">
1403
1404 <tr>
1405 <th class="FieldHeader">
1406 Field Name
1407 </th>
1408 <th class="FieldHeader">
1409 Data Type
1410 </th>
1411 <th class="FieldHeader">
1412 Size
1413 </th>
1414 <th class="FieldHeader">
1415 Default Value
1416 </th>
1417 <th class="FieldHeader">
1418 Other
1419 </th>
1420 <th class="FieldHeader">
1421 Foreign Key
1422 </th>
1423 </tr>
1424
1425 <tr class="tr-odd">
1426 <td class="FieldCellName"><a name="arraydesignprop-arraydesignprop_id">arraydesignprop_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
1427 </tr>
1428
1429 <tr class="tr-even">
1430 <td class="FieldCellName"><a name="arraydesignprop-arraydesign_id">arraydesign_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#arraydesign-arraydesign_id">arraydesign.arraydesign_id</a></td>
1431 </tr>
1432
1433 <tr class="tr-odd">
1434 <td class="FieldCellName"><a name="arraydesignprop-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1435 </tr>
1436
1437 <tr class="tr-even">
1438 <td class="FieldCellName"><a name="arraydesignprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1439 </tr>
1440
1441 <tr class="tr-odd">
1442 <td class="FieldCellName"><a name="arraydesignprop-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
1443 </tr>
1444
1445 </table>
1446
1447 <h3>
1448 Indices
1449 </h3>
1450
1451 <table border="1">
1452
1453 <tr class="IndexRow">
1454 <th>
1455 Name
1456 </th>
1457 <th>
1458 Fields
1459 </th>
1460 </tr>
1461
1462 <tr class="IndexCell">
1463 <td>arraydesignprop_idx1</td><td>arraydesign_id</td>
1464 </tr>
1465
1466 <tr class="IndexCell">
1467 <td>arraydesignprop_idx2</td><td>type_id</td>
1468 </tr>
1469
1470 </table>
1471
1472 <h3>
1473 Constraints
1474 </h3>
1475
1476 <table border="1">
1477
1478 <tr class="IndexRow">
1479 <th>
1480 Type
1481 </th>
1482 <th>
1483 Fields
1484 </th>
1485 </tr>
1486
1487 <tr class="IndexCell">
1488 <td>NOT NULL</td><td>arraydesignprop_id</td>
1489 </tr>
1490
1491 <tr class="IndexCell">
1492 <td>NOT NULL</td><td>arraydesign_id</td>
1493 </tr>
1494
1495 <tr class="IndexCell">
1496 <td>FOREIGN KEY</td><td>arraydesign_id</td>
1497 </tr>
1498
1499 <tr class="IndexCell">
1500 <td>NOT NULL</td><td>type_id</td>
1501 </tr>
1502
1503 <tr class="IndexCell">
1504 <td>FOREIGN KEY</td><td>type_id</td>
1505 </tr>
1506
1507 <tr class="IndexCell">
1508 <td>NOT NULL</td><td>rank</td>
1509 </tr>
1510
1511 <tr class="IndexCell">
1512 <td>UNIQUE</td><td>arraydesign_id, type_id, rank</td>
1513 </tr>
1514
1515 </table>
1516
1517 <hr />
1518
1519 <!--
1520 Starting table 'assay'
1521 -->
1522
1523 <a name="assay" />
1524
1525 <table width="100%" class="TableHeader">
1526 <tr class="TableHeaderRow">
1527 <td class="TableHeaderCell"><h3>
1528 assay
1529 </h3></td> <a name="assay"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1530 </tr>
1531 </table>
1532
1533 <b>
1534 Comments:
1535 </b>
1536
1537 <br />
1538
1539 <em>
1540 <br />
1541 ================================================ <br />
1542 TABLE: assay <br />
1543 ================================================ <br />
1544 An assay consists of a physical instance of
1545 an array, combined with the conditions used to create the array
1546 (protocols, technician information). The assay can be thought of as a hybridization.
1547 </em>
1548
1549 <table border="1">
1550
1551 <tr>
1552 <th class="FieldHeader">
1553 Field Name
1554 </th>
1555 <th class="FieldHeader">
1556 Data Type
1557 </th>
1558 <th class="FieldHeader">
1559 Size
1560 </th>
1561 <th class="FieldHeader">
1562 Default Value
1563 </th>
1564 <th class="FieldHeader">
1565 Other
1566 </th>
1567 <th class="FieldHeader">
1568 Foreign Key
1569 </th>
1570 </tr>
1571
1572 <tr class="tr-odd">
1573 <td class="FieldCellName"><a name="assay-assay_id">assay_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
1574 </tr>
1575
1576 <tr class="tr-even">
1577 <td class="FieldCellName"><a name="assay-arraydesign_id">arraydesign_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#arraydesign-arraydesign_id">arraydesign.arraydesign_id</a></td>
1578 </tr>
1579
1580 <tr class="tr-odd">
1581 <td class="FieldCellName"><a name="assay-protocol_id">protocol_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#protocol-protocol_id">protocol.protocol_id</a></td>
1582 </tr>
1583
1584 <tr class="tr-even">
1585 <td class="FieldCellName"><a name="assay-assaydate">assaydate</a></td> <td class="FieldCellType">timestamp</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">current_timestamp</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1586 </tr>
1587
1588 <tr class="tr-odd">
1589 <td class="FieldCellName"><a name="assay-arrayidentifier">arrayidentifier</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1590 </tr>
1591
1592 <tr class="tr-even">
1593 <td class="FieldCellName"><a name="assay-arraybatchidentifier">arraybatchidentifier</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1594 </tr>
1595
1596 <tr class="tr-odd">
1597 <td class="FieldCellName"><a name="assay-operator_id">operator_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#contact-contact_id">contact.contact_id</a></td>
1598 </tr>
1599
1600 <tr class="tr-even">
1601 <td class="FieldCellName"><a name="assay-dbxref_id">dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
1602 </tr>
1603
1604 <tr class="tr-odd">
1605 <td class="FieldCellName"><a name="assay-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">UNIQUE</td> <td class="FieldCellFK"></td>
1606 </tr>
1607
1608 <tr class="tr-even">
1609 <td class="FieldCellName"><a name="assay-description">description</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1610 </tr>
1611
1612 </table>
1613
1614 <h3>
1615 Indices
1616 </h3>
1617
1618 <table border="1">
1619
1620 <tr class="IndexRow">
1621 <th>
1622 Name
1623 </th>
1624 <th>
1625 Fields
1626 </th>
1627 </tr>
1628
1629 <tr class="IndexCell">
1630 <td>assay_idx1</td><td>arraydesign_id</td>
1631 </tr>
1632
1633 <tr class="IndexCell">
1634 <td>assay_idx2</td><td>protocol_id</td>
1635 </tr>
1636
1637 <tr class="IndexCell">
1638 <td>assay_idx3</td><td>operator_id</td>
1639 </tr>
1640
1641 <tr class="IndexCell">
1642 <td>assay_idx4</td><td>dbxref_id</td>
1643 </tr>
1644
1645 </table>
1646
1647 <h3>
1648 Constraints
1649 </h3>
1650
1651 <table border="1">
1652
1653 <tr class="IndexRow">
1654 <th>
1655 Type
1656 </th>
1657 <th>
1658 Fields
1659 </th>
1660 </tr>
1661
1662 <tr class="IndexCell">
1663 <td>NOT NULL</td><td>assay_id</td>
1664 </tr>
1665
1666 <tr class="IndexCell">
1667 <td>NOT NULL</td><td>arraydesign_id</td>
1668 </tr>
1669
1670 <tr class="IndexCell">
1671 <td>FOREIGN KEY</td><td>arraydesign_id</td>
1672 </tr>
1673
1674 <tr class="IndexCell">
1675 <td>FOREIGN KEY</td><td>protocol_id</td>
1676 </tr>
1677
1678 <tr class="IndexCell">
1679 <td>NOT NULL</td><td>operator_id</td>
1680 </tr>
1681
1682 <tr class="IndexCell">
1683 <td>FOREIGN KEY</td><td>operator_id</td>
1684 </tr>
1685
1686 <tr class="IndexCell">
1687 <td>FOREIGN KEY</td><td>dbxref_id</td>
1688 </tr>
1689
1690 <tr class="IndexCell">
1691 <td>UNIQUE</td><td>name</td>
1692 </tr>
1693
1694 </table>
1695
1696 <hr />
1697
1698 <!--
1699 Starting table 'assayprop'
1700 -->
1701
1702 <a name="assayprop" />
1703
1704 <table class="TableHeader" width="100%">
1705 <tr class="TableHeaderRow">
1706 <td class="TableHeaderCell"><h3>
1707 assayprop
1708 </h3></td> <a name="assayprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1709 </tr>
1710 </table>
1711
1712 <b>
1713 Comments:
1714 </b>
1715
1716 <br />
1717
1718 <em>
1719 <br />
1720 ================================================ <br />
1721 TABLE: assayprop <br />
1722 ================================================ <br />
1723 Extra assay properties that are not accounted for in assay.
1724 </em>
1725
1726 <table border="1">
1727
1728 <tr>
1729 <th class="FieldHeader">
1730 Field Name
1731 </th>
1732 <th class="FieldHeader">
1733 Data Type
1734 </th>
1735 <th class="FieldHeader">
1736 Size
1737 </th>
1738 <th class="FieldHeader">
1739 Default Value
1740 </th>
1741 <th class="FieldHeader">
1742 Other
1743 </th>
1744 <th class="FieldHeader">
1745 Foreign Key
1746 </th>
1747 </tr>
1748
1749 <tr class="tr-odd">
1750 <td class="FieldCellName"><a name="assayprop-assayprop_id">assayprop_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
1751 </tr>
1752
1753 <tr class="tr-even">
1754 <td class="FieldCellName"><a name="assayprop-assay_id">assay_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#assay-assay_id">assay.assay_id</a></td>
1755 </tr>
1756
1757 <tr class="tr-odd">
1758 <td class="FieldCellName"><a name="assayprop-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1759 </tr>
1760
1761 <tr class="tr-even">
1762 <td class="FieldCellName"><a name="assayprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1763 </tr>
1764
1765 <tr class="tr-odd">
1766 <td class="FieldCellName"><a name="assayprop-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
1767 </tr>
1768
1769 </table>
1770
1771 <h3>
1772 Indices
1773 </h3>
1774
1775 <table border="1">
1776
1777 <tr class="IndexRow">
1778 <th>
1779 Name
1780 </th>
1781 <th>
1782 Fields
1783 </th>
1784 </tr>
1785
1786 <tr class="IndexCell">
1787 <td>assayprop_idx1</td><td>assay_id</td>
1788 </tr>
1789
1790 <tr class="IndexCell">
1791 <td>assayprop_idx2</td><td>type_id</td>
1792 </tr>
1793
1794 </table>
1795
1796 <h3>
1797 Constraints
1798 </h3>
1799
1800 <table border="1">
1801
1802 <tr class="IndexRow">
1803 <th>
1804 Type
1805 </th>
1806 <th>
1807 Fields
1808 </th>
1809 </tr>
1810
1811 <tr class="IndexCell">
1812 <td>NOT NULL</td><td>assayprop_id</td>
1813 </tr>
1814
1815 <tr class="IndexCell">
1816 <td>NOT NULL</td><td>assay_id</td>
1817 </tr>
1818
1819 <tr class="IndexCell">
1820 <td>FOREIGN KEY</td><td>assay_id</td>
1821 </tr>
1822
1823 <tr class="IndexCell">
1824 <td>NOT NULL</td><td>type_id</td>
1825 </tr>
1826
1827 <tr class="IndexCell">
1828 <td>FOREIGN KEY</td><td>type_id</td>
1829 </tr>
1830
1831 <tr class="IndexCell">
1832 <td>NOT NULL</td><td>rank</td>
1833 </tr>
1834
1835 <tr class="IndexCell">
1836 <td>UNIQUE</td><td>assay_id, type_id, rank</td>
1837 </tr>
1838
1839 </table>
1840
1841 <hr />
1842
1843 <!--
1844 Starting table 'assay_project'
1845 -->
1846
1847 <a name="assay_project" />
1848
1849 <table class="TableHeader" width="100%">
1850 <tr class="TableHeaderRow">
1851 <td class="TableHeaderCell"><h3>
1852 assay_project
1853 </h3></td> <a name="assay_project"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1854 </tr>
1855 </table>
1856
1857 <b>
1858 Comments:
1859 </b>
1860
1861 <br />
1862
1863 <em>
1864 <br />
1865 ================================================ <br />
1866 TABLE: assay_project <br />
1867 ================================================ <br />
1868 Link assays to projects.
1869 </em>
1870
1871 <table border="1">
1872
1873 <tr>
1874 <th class="FieldHeader">
1875 Field Name
1876 </th>
1877 <th class="FieldHeader">
1878 Data Type
1879 </th>
1880 <th class="FieldHeader">
1881 Size
1882 </th>
1883 <th class="FieldHeader">
1884 Default Value
1885 </th>
1886 <th class="FieldHeader">
1887 Other
1888 </th>
1889 <th class="FieldHeader">
1890 Foreign Key
1891 </th>
1892 </tr>
1893
1894 <tr class="tr-odd">
1895 <td class="FieldCellName"><a name="assay_project-assay_project_id">assay_project_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
1896 </tr>
1897
1898 <tr class="tr-even">
1899 <td class="FieldCellName"><a name="assay_project-assay_id">assay_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#assay-assay_id">assay.assay_id</a></td>
1900 </tr>
1901
1902 <tr class="tr-odd">
1903 <td class="FieldCellName"><a name="assay_project-project_id">project_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#project-project_id">project.project_id</a></td>
1904 </tr>
1905
1906 </table>
1907
1908 <h3>
1909 Indices
1910 </h3>
1911
1912 <table border="1">
1913
1914 <tr class="IndexRow">
1915 <th>
1916 Name
1917 </th>
1918 <th>
1919 Fields
1920 </th>
1921 </tr>
1922
1923 <tr class="IndexCell">
1924 <td>assay_project_idx1</td><td>assay_id</td>
1925 </tr>
1926
1927 <tr class="IndexCell">
1928 <td>assay_project_idx2</td><td>project_id</td>
1929 </tr>
1930
1931 </table>
1932
1933 <h3>
1934 Constraints
1935 </h3>
1936
1937 <table border="1">
1938
1939 <tr class="IndexRow">
1940 <th>
1941 Type
1942 </th>
1943 <th>
1944 Fields
1945 </th>
1946 </tr>
1947
1948 <tr class="IndexCell">
1949 <td>NOT NULL</td><td>assay_project_id</td>
1950 </tr>
1951
1952 <tr class="IndexCell">
1953 <td>NOT NULL</td><td>assay_id</td>
1954 </tr>
1955
1956 <tr class="IndexCell">
1957 <td>FOREIGN KEY</td><td>assay_id</td>
1958 </tr>
1959
1960 <tr class="IndexCell">
1961 <td>NOT NULL</td><td>project_id</td>
1962 </tr>
1963
1964 <tr class="IndexCell">
1965 <td>FOREIGN KEY</td><td>project_id</td>
1966 </tr>
1967
1968 <tr class="IndexCell">
1969 <td>UNIQUE</td><td>assay_id, project_id</td>
1970 </tr>
1971
1972 </table>
1973
1974 <hr />
1975
1976 <!--
1977 Starting table 'biomaterial'
1978 -->
1979
1980 <a name="biomaterial" />
1981
1982 <table class="TableHeader" width="100%">
1983 <tr class="TableHeaderRow">
1984 <td class="TableHeaderCell"><h3>
1985 biomaterial
1986 </h3></td> <a name="biomaterial"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1987 </tr>
1988 </table>
1989
1990 <b>
1991 Comments:
1992 </b>
1993
1994 <br />
1995
1996 <em>
1997 <br />
1998 ================================================ <br />
1999 TABLE: biomaterial <br />
2000 ================================================ <br />
2001 A biomaterial represents the MAGE concept of BioSource, BioSample, and LabeledExtract. It is essentially some biological material (tissue, cells, serum) that may have been processed. Processed biomaterials should be traceable back to raw biomaterials via the biomaterialrelationship table.
2002 </em>
2003
2004 <table border="1">
2005
2006 <tr>
2007 <th class="FieldHeader">
2008 Field Name
2009 </th>
2010 <th class="FieldHeader">
2011 Data Type
2012 </th>
2013 <th class="FieldHeader">
2014 Size
2015 </th>
2016 <th class="FieldHeader">
2017 Default Value
2018 </th>
2019 <th class="FieldHeader">
2020 Other
2021 </th>
2022 <th class="FieldHeader">
2023 Foreign Key
2024 </th>
2025 </tr>
2026
2027 <tr class="tr-odd">
2028 <td class="FieldCellName"><a name="biomaterial-biomaterial_id">biomaterial_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
2029 </tr>
2030
2031 <tr class="tr-even">
2032 <td class="FieldCellName"><a name="biomaterial-taxon_id">taxon_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#organism-organism_id">organism.organism_id</a></td>
2033 </tr>
2034
2035 <tr class="tr-odd">
2036 <td class="FieldCellName"><a name="biomaterial-biosourceprovider_id">biosourceprovider_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#contact-contact_id">contact.contact_id</a></td>
2037 </tr>
2038
2039 <tr class="tr-even">
2040 <td class="FieldCellName"><a name="biomaterial-dbxref_id">dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
2041 </tr>
2042
2043 <tr class="tr-odd">
2044 <td class="FieldCellName"><a name="biomaterial-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">UNIQUE</td> <td class="FieldCellFK"></td>
2045 </tr>
2046
2047 <tr class="tr-even">
2048 <td class="FieldCellName"><a name="biomaterial-description">description</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
2049 </tr>
2050
2051 </table>
2052
2053 <h3>
2054 Indices
2055 </h3>
2056
2057 <table border="1">
2058
2059 <tr class="IndexRow">
2060 <th>
2061 Name
2062 </th>
2063 <th>
2064 Fields
2065 </th>
2066 </tr>
2067
2068 <tr class="IndexCell">
2069 <td>biomaterial_idx1</td><td>taxon_id</td>
2070 </tr>
2071
2072 <tr class="IndexCell">
2073 <td>biomaterial_idx2</td><td>biosourceprovider_id</td>
2074 </tr>
2075
2076 <tr class="IndexCell">
2077 <td>biomaterial_idx3</td><td>dbxref_id</td>
2078 </tr>
2079
2080 </table>
2081
2082 <h3>
2083 Constraints
2084 </h3>
2085
2086 <table border="1">
2087
2088 <tr class="IndexRow">
2089 <th>
2090 Type
2091 </th>
2092 <th>
2093 Fields
2094 </th>
2095 </tr>
2096
2097 <tr class="IndexCell">
2098 <td>NOT NULL</td><td>biomaterial_id</td>
2099 </tr>
2100
2101 <tr class="IndexCell">
2102 <td>FOREIGN KEY</td><td>taxon_id</td>
2103 </tr>
2104
2105 <tr class="IndexCell">
2106 <td>FOREIGN KEY</td><td>biosourceprovider_id</td>
2107 </tr>
2108
2109 <tr class="IndexCell">
2110 <td>FOREIGN KEY</td><td>dbxref_id</td>
2111 </tr>
2112
2113 <tr class="IndexCell">
2114 <td>UNIQUE</td><td>name</td>
2115 </tr>
2116
2117 </table>
2118
2119 <hr />
2120
2121 <!--
2122 Starting table 'biomaterial_relationship'
2123 -->
2124
2125 <a name="biomaterial_relationship" />
2126
2127 <table class="TableHeader" width="100%">
2128 <tr class="TableHeaderRow">
2129 <td class="TableHeaderCell"><h3>
2130 biomaterial_relationship
2131 </h3></td> <a name="biomaterial_relationship"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
2132 </tr>
2133 </table>
2134
2135 <b>
2136 Comments:
2137 </b>
2138
2139 <br />
2140
2141 <em>
2142 <br />
2143 ================================================ <br />
2144 TABLE: biomaterial_relationship <br />
2145 ================================================ <br />
2146 Relate biomaterials to one another. This is a way to track a series of treatments or material splits/merges, for instance.
2147 </em>
2148
2149 <table border="1">
2150
2151 <tr>
2152 <th class="FieldHeader">
2153 Field Name
2154 </th>
2155 <th class="FieldHeader">
2156 Data Type
2157 </th>
2158 <th class="FieldHeader">
2159 Size
2160 </th>
2161 <th class="FieldHeader">
2162 Default Value
2163 </th>
2164 <th class="FieldHeader">
2165 Other
2166 </th>
2167 <th class="FieldHeader">
2168 Foreign Key
2169 </th>
2170 </tr>
2171
2172 <tr class="tr-odd">
2173 <td class="FieldCellName"><a name="biomaterial_relationship-biomaterial_relationship_id">biomaterial_relationship_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
2174 </tr>
2175
2176 <tr class="tr-even">
2177 <td class="FieldCellName"><a name="biomaterial_relationship-subject_id">subject_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#biomaterial-biomaterial_id">biomaterial.biomaterial_id</a></td>
2178 </tr>
2179
2180 <tr class="tr-odd">
2181 <td class="FieldCellName"><a name="biomaterial_relationship-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
2182 </tr>
2183
2184 <tr class="tr-even">
2185 <td class="FieldCellName"><a name="biomaterial_relationship-object_id">object_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#biomaterial-biomaterial_id">biomaterial.biomaterial_id</a></td>
2186 </tr>
2187
2188 </table>
2189
2190 <h3>
2191 Indices
2192 </h3>
2193
2194 <table border="1">
2195
2196 <tr class="IndexRow">
2197 <th>
2198 Name
2199 </th>
2200 <th>
2201 Fields
2202 </th>
2203 </tr>
2204
2205 <tr class="IndexCell">
2206 <td>biomaterial_relationship_idx1</td><td>subject_id</td>
2207 </tr>
2208
2209 <tr class="IndexCell">
2210 <td>biomaterial_relationship_idx2</td><td>object_id</td>
2211 </tr>
2212
2213 <tr class="IndexCell">
2214 <td>biomaterial_relationship_idx3</td><td>type_id</td>
2215 </tr>
2216
2217 </table>
2218
2219 <h3>
2220 Constraints
2221 </h3>
2222
2223 <table border="1">
2224
2225 <tr class="IndexRow">
2226 <th>
2227 Type
2228 </th>
2229 <th>
2230 Fields
2231 </th>
2232 </tr>
2233
2234 <tr class="IndexCell">
2235 <td>NOT NULL</td><td>biomaterial_relationship_id</td>
2236 </tr>
2237
2238 <tr class="IndexCell">
2239 <td>NOT NULL</td><td>subject_id</td>
2240 </tr>
2241
2242 <tr class="IndexCell">
2243 <td>FOREIGN KEY</td><td>subject_id</td>
2244 </tr>
2245
2246 <tr class="IndexCell">
2247 <td>NOT NULL</td><td>type_id</td>
2248 </tr>
2249
2250 <tr class="IndexCell">
2251 <td>FOREIGN KEY</td><td>type_id</td>
2252 </tr>
2253
2254 <tr class="IndexCell">
2255 <td>NOT NULL</td><td>object_id</td>
2256 </tr>
2257
2258 <tr class="IndexCell">
2259 <td>FOREIGN KEY</td><td>object_id</td>
2260 </tr>
2261
2262 <tr class="IndexCell">
2263 <td>UNIQUE</td><td>subject_id, object_id, type_id</td>
2264 </tr>
2265
2266 </table>
2267
2268 <hr />
2269
2270 <!--
2271 Starting table 'biomaterialprop'
2272 -->
2273
2274 <a name="biomaterialprop" />
2275
2276 <table width="100%" class="TableHeader">
2277 <tr class="TableHeaderRow">
2278 <td class="TableHeaderCell"><h3>
2279 biomaterialprop
2280 </h3></td> <a name="biomaterialprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
2281 </tr>
2282 </table>
2283
2284 <b>
2285 Comments:
2286 </b>
2287
2288 <br />
2289
2290 <em>
2291 <br />
2292 ================================================ <br />
2293 TABLE: biomaterialprop <br />
2294 ================================================ <br />
2295 Extra biomaterial properties that are not accounted for in biomaterial.
2296 </em>
2297
2298 <table border="1">
2299
2300 <tr>
2301 <th class="FieldHeader">
2302 Field Name
2303 </th>
2304 <th class="FieldHeader">
2305 Data Type
2306 </th>
2307 <th class="FieldHeader">
2308 Size
2309 </th>
2310 <th class="FieldHeader">
2311 Default Value
2312 </th>
2313 <th class="FieldHeader">
2314 Other
2315 </th>
2316 <th class="FieldHeader">
2317 Foreign Key
2318 </th>
2319 </tr>
2320
2321 <tr class="tr-odd">
2322 <td class="FieldCellName"><a name="biomaterialprop-biomaterialprop_id">biomaterialprop_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
2323 </tr>
2324
2325 <tr class="tr-even">
2326 <td class="FieldCellName"><a name="biomaterialprop-biomaterial_id">biomaterial_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#biomaterial-biomaterial_id">biomaterial.biomaterial_id</a></td>
2327 </tr>
2328
2329 <tr class="tr-odd">
2330 <td class="FieldCellName"><a name="biomaterialprop-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
2331 </tr>
2332
2333 <tr class="tr-even">
2334 <td class="FieldCellName"><a name="biomaterialprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
2335 </tr>
2336
2337 <tr class="tr-odd">
2338 <td class="FieldCellName"><a name="biomaterialprop-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
2339 </tr>
2340
2341 </table>
2342
2343 <h3>
2344 Indices
2345 </h3>
2346
2347 <table border="1">
2348
2349 <tr class="IndexRow">
2350 <th>
2351 Name
2352 </th>
2353 <th>
2354 Fields
2355 </th>
2356 </tr>
2357
2358 <tr class="IndexCell">
2359 <td>biomaterialprop_idx1</td><td>biomaterial_id</td>
2360 </tr>
2361
2362 <tr class="IndexCell">
2363 <td>biomaterialprop_idx2</td><td>type_id</td>
2364 </tr>
2365
2366 </table>
2367
2368 <h3>
2369 Constraints
2370 </h3>
2371
2372 <table border="1">
2373
2374 <tr class="IndexRow">
2375 <th>
2376 Type
2377 </th>
2378 <th>
2379 Fields
2380 </th>
2381 </tr>
2382
2383 <tr class="IndexCell">
2384 <td>NOT NULL</td><td>biomaterialprop_id</td>
2385 </tr>
2386
2387 <tr class="IndexCell">
2388 <td>NOT NULL</td><td>biomaterial_id</td>
2389 </tr>
2390
2391 <tr class="IndexCell">
2392 <td>FOREIGN KEY</td><td>biomaterial_id</td>
2393 </tr>
2394
2395 <tr class="IndexCell">
2396 <td>NOT NULL</td><td>type_id</td>
2397 </tr>
2398
2399 <tr class="IndexCell">
2400 <td>FOREIGN KEY</td><td>type_id</td>
2401 </tr>
2402
2403 <tr class="IndexCell">
2404 <td>NOT NULL</td><td>rank</td>
2405 </tr>
2406
2407 <tr class="IndexCell">
2408 <td>UNIQUE</td><td>biomaterial_id, type_id, rank</td>
2409 </tr>
2410
2411 </table>
2412
2413 <hr />
2414
2415 <!--
2416 Starting table 'biomaterial_dbxref'
2417 -->
2418
2419 <a name="biomaterial_dbxref" />
2420
2421 <table width="100%" class="TableHeader">
2422 <tr class="TableHeaderRow">
2423 <td class="TableHeaderCell"><h3>
2424 biomaterial_dbxref
2425 </h3></td> <a name="biomaterial_dbxref"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
2426 </tr>
2427 </table>
2428
2429 <b>
2430 Comments:
2431 </b>
2432
2433 <br />
2434
2435 <em>
2436 <br />
2437 ================================================ <br />
2438 TABLE: biomaterial_dbxref <br />
2439 ================================================
2440 </em>
2441
2442 <table border="1">
2443
2444 <tr>
2445 <th class="FieldHeader">
2446 Field Name
2447 </th>
2448 <th class="FieldHeader">
2449 Data Type
2450 </th>
2451 <th class="FieldHeader">
2452 Size
2453 </th>
2454 <th class="FieldHeader">
2455 Default Value
2456 </th>
2457 <th class="FieldHeader">
2458 Other
2459 </th>
2460 <th class="FieldHeader">
2461 Foreign Key
2462 </th>
2463 </tr>
2464
2465 <tr class="tr-odd">
2466 <td class="FieldCellName"><a name="biomaterial_dbxref-biomaterial_dbxref_id">biomaterial_dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
2467 </tr>
2468
2469 <tr class="tr-even">
2470 <td class="FieldCellName"><a name="biomaterial_dbxref-biomaterial_id">biomaterial_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#biomaterial-biomaterial_id">biomaterial.biomaterial_id</a></td>
2471 </tr>
2472
2473 <tr class="tr-odd">
2474 <td class="FieldCellName"><a name="biomaterial_dbxref-dbxref_id">dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
2475 </tr>
2476
2477 </table>
2478
2479 <h3>
2480 Indices
2481 </h3>
2482
2483 <table border="1">
2484
2485 <tr class="IndexRow">
2486 <th>
2487 Name
2488 </th>
2489 <th>
2490 Fields
2491 </th>
2492 </tr>
2493
2494 <tr class="IndexCell">
2495 <td>biomaterial_dbxref_idx1</td><td>biomaterial_id</td>
2496 </tr>
2497
2498 <tr class="IndexCell">
2499 <td>biomaterial_dbxref_idx2</td><td>dbxref_id</td>
2500 </tr>
2501
2502 </table>
2503
2504 <h3>
2505 Constraints
2506 </h3>
2507
2508 <table border="1">
2509
2510 <tr class="IndexRow">
2511 <th>
2512 Type
2513 </th>
2514 <th>
2515 Fields
2516 </th>
2517 </tr>
2518
2519 <tr class="IndexCell">
2520 <td>NOT NULL</td><td>biomaterial_dbxref_id</td>
2521 </tr>
2522
2523 <tr class="IndexCell">
2524 <td>NOT NULL</td><td>biomaterial_id</td>
2525 </tr>
2526
2527 <tr class="IndexCell">
2528 <td>FOREIGN KEY</td><td>biomaterial_id</td>
2529 </tr>
2530
2531 <tr class="IndexCell">
2532 <td>NOT NULL</td><td>dbxref_id</td>
2533 </tr>
2534
2535 <tr class="IndexCell">
2536 <td>FOREIGN KEY</td><td>dbxref_id</td>
2537 </tr>
2538
2539 <tr class="IndexCell">
2540 <td>UNIQUE</td><td>biomaterial_id, dbxref_id</td>
2541 </tr>
2542
2543 </table>
2544
2545 <hr />
2546
2547 <!--
2548 Starting table 'treatment'
2549 -->
2550
2551 <a name="treatment" />
2552
2553 <table width="100%" class="TableHeader">
2554 <tr class="TableHeaderRow">
2555 <td class="TableHeaderCell"><h3>
2556 treatment
2557 </h3></td> <a name="treatment"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
2558 </tr>
2559 </table>
2560
2561 <b>
2562 Comments:
2563 </b>
2564
2565 <br />
2566
2567 <em>
2568 <br />
2569 ================================================ <br />
2570 TABLE: treatment <br />
2571 ================================================ <br />
2572 A biomaterial may undergo multiple
2573 treatments. Examples of treatments: apoxia, fluorophore and biotin labeling.
2574 </em>
2575
2576 <table border="1">
2577
2578 <tr>
2579 <th class="FieldHeader">
2580 Field Name
2581 </th>
2582 <th class="FieldHeader">
2583 Data Type
2584 </th>
2585 <th class="FieldHeader">
2586 Size
2587 </th>
2588 <th class="FieldHeader">
2589 Default Value
2590 </th>
2591 <th class="FieldHeader">
2592 Other
2593 </th>
2594 <th class="FieldHeader">
2595 Foreign Key
2596 </th>
2597 </tr>
2598
2599 <tr class="tr-odd">
2600 <td class="FieldCellName"><a name="treatment-treatment_id">treatment_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
2601 </tr>
2602
2603 <tr class="tr-even">
2604 <td class="FieldCellName"><a name="treatment-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
2605 </tr>
2606
2607 <tr class="tr-odd">
2608 <td class="FieldCellName"><a name="treatment-biomaterial_id">biomaterial_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#biomaterial-biomaterial_id">biomaterial.biomaterial_id</a></td>
2609 </tr>
2610
2611 <tr class="tr-even">
2612 <td class="FieldCellName"><a name="treatment-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
2613 </tr>
2614
2615 <tr class="tr-odd">
2616 <td class="FieldCellName"><a name="treatment-protocol_id">protocol_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#protocol-protocol_id">protocol.protocol_id</a></td>
2617 </tr>
2618
2619 <tr class="tr-even">
2620 <td class="FieldCellName"><a name="treatment-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
2621 </tr>
2622
2623 </table>
2624
2625 <h3>
2626 Indices
2627 </h3>
2628
2629 <table border="1">
2630
2631 <tr class="IndexRow">
2632 <th>
2633 Name
2634 </th>
2635 <th>
2636 Fields
2637 </th>
2638 </tr>
2639
2640 <tr class="IndexCell">
2641 <td>treatment_idx1</td><td>biomaterial_id</td>
2642 </tr>
2643
2644 <tr class="IndexCell">
2645 <td>treatment_idx2</td><td>type_id</td>
2646 </tr>
2647
2648 <tr class="IndexCell">
2649 <td>treatment_idx3</td><td>protocol_id</td>
2650 </tr>
2651
2652 </table>
2653
2654 <h3>
2655 Constraints
2656 </h3>
2657
2658 <table border="1">
2659
2660 <tr class="IndexRow">
2661 <th>
2662 Type
2663 </th>
2664 <th>
2665 Fields
2666 </th>
2667 </tr>
2668
2669 <tr class="IndexCell">
2670 <td>NOT NULL</td><td>treatment_id</td>
2671 </tr>
2672
2673 <tr class="IndexCell">
2674 <td>NOT NULL</td><td>rank</td>
2675 </tr>
2676
2677 <tr class="IndexCell">
2678 <td>NOT NULL</td><td>biomaterial_id</td>
2679 </tr>
2680
2681 <tr class="IndexCell">
2682 <td>FOREIGN KEY</td><td>biomaterial_id</td>
2683 </tr>
2684
2685 <tr class="IndexCell">
2686 <td>NOT NULL</td><td>type_id</td>
2687 </tr>
2688
2689 <tr class="IndexCell">
2690 <td>FOREIGN KEY</td><td>type_id</td>
2691 </tr>
2692
2693 <tr class="IndexCell">
2694 <td>FOREIGN KEY</td><td>protocol_id</td>
2695 </tr>
2696
2697 </table>
2698
2699 <hr />
2700
2701 <!--
2702 Starting table 'biomaterial_treatment'
2703 -->
2704
2705 <a name="biomaterial_treatment" />
2706
2707 <table class="TableHeader" width="100%">
2708 <tr class="TableHeaderRow">
2709 <td class="TableHeaderCell"><h3>
2710 biomaterial_treatment
2711 </h3></td> <a name="biomaterial_treatment"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
2712 </tr>
2713 </table>
2714
2715 <b>
2716 Comments:
2717 </b>
2718
2719 <br />
2720
2721 <em>
2722 <br />
2723 ================================================ <br />
2724 TABLE: biomaterial_treatment <br />
2725 ================================================ <br />
2726 Link biomaterials to treatments. Treatments have an order of operations (rank), and associated measurements (unittype_id, value).
2727 </em>
2728
2729 <table border="1">
2730
2731 <tr>
2732 <th class="FieldHeader">
2733 Field Name
2734 </th>
2735 <th class="FieldHeader">
2736 Data Type
2737 </th>
2738 <th class="FieldHeader">
2739 Size
2740 </th>
2741 <th class="FieldHeader">
2742 Default Value
2743 </th>
2744 <th class="FieldHeader">
2745 Other
2746 </th>
2747 <th class="FieldHeader">
2748 Foreign Key
2749 </th>
2750 </tr>
2751
2752 <tr class="tr-odd">
2753 <td class="FieldCellName"><a name="biomaterial_treatment-biomaterial_treatment_id">biomaterial_treatment_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
2754 </tr>
2755
2756 <tr class="tr-even">
2757 <td class="FieldCellName"><a name="biomaterial_treatment-biomaterial_id">biomaterial_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#biomaterial-biomaterial_id">biomaterial.biomaterial_id</a></td>
2758 </tr>
2759
2760 <tr class="tr-odd">
2761 <td class="FieldCellName"><a name="biomaterial_treatment-treatment_id">treatment_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#treatment-treatment_id">treatment.treatment_id</a></td>
2762 </tr>
2763
2764 <tr class="tr-even">
2765 <td class="FieldCellName"><a name="biomaterial_treatment-unittype_id">unittype_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
2766 </tr>
2767
2768 <tr class="tr-odd">
2769 <td class="FieldCellName"><a name="biomaterial_treatment-value">value</a></td> <td class="FieldCellType">float</td> <td class="FieldCellSize">15</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
2770 </tr>
2771
2772 <tr class="tr-even">
2773 <td class="FieldCellName"><a name="biomaterial_treatment-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
2774 </tr>
2775
2776 </table>
2777
2778 <h3>
2779 Indices
2780 </h3>
2781
2782 <table border="1">
2783
2784 <tr class="IndexRow">
2785 <th>
2786 Name
2787 </th>
2788 <th>
2789 Fields
2790 </th>
2791 </tr>
2792
2793 <tr class="IndexCell">
2794 <td>biomaterial_treatment_idx1</td><td>biomaterial_id</td>
2795 </tr>
2796
2797 <tr class="IndexCell">
2798 <td>biomaterial_treatment_idx2</td><td>treatment_id</td>
2799 </tr>
2800
2801 <tr class="IndexCell">
2802 <td>biomaterial_treatment_idx3</td><td>unittype_id</td>
2803 </tr>
2804
2805 </table>
2806
2807 <h3>
2808 Constraints
2809 </h3>
2810
2811 <table border="1">
2812
2813 <tr class="IndexRow">
2814 <th>
2815 Type
2816 </th>
2817 <th>
2818 Fields
2819 </th>
2820 </tr>
2821
2822 <tr class="IndexCell">
2823 <td>NOT NULL</td><td>biomaterial_treatment_id</td>
2824 </tr>
2825
2826 <tr class="IndexCell">
2827 <td>NOT NULL</td><td>biomaterial_id</td>
2828 </tr>
2829
2830 <tr class="IndexCell">
2831 <td>FOREIGN KEY</td><td>biomaterial_id</td>
2832 </tr>
2833
2834 <tr class="IndexCell">
2835 <td>NOT NULL</td><td>treatment_id</td>
2836 </tr>
2837
2838 <tr class="IndexCell">
2839 <td>FOREIGN KEY</td><td>treatment_id</td>
2840 </tr>
2841
2842 <tr class="IndexCell">
2843 <td>FOREIGN KEY</td><td>unittype_id</td>
2844 </tr>
2845
2846 <tr class="IndexCell">
2847 <td>NOT NULL</td><td>rank</td>
2848 </tr>
2849
2850 <tr class="IndexCell">
2851 <td>UNIQUE</td><td>biomaterial_id, treatment_id</td>
2852 </tr>
2853
2854 </table>
2855
2856 <hr />
2857
2858 <!--
2859 Starting table 'assay_biomaterial'
2860 -->
2861
2862 <a name="assay_biomaterial" />
2863
2864 <table width="100%" class="TableHeader">
2865 <tr class="TableHeaderRow">
2866 <td class="TableHeaderCell"><h3>
2867 assay_biomaterial
2868 </h3></td> <a name="assay_biomaterial"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
2869 </tr>
2870 </table>
2871
2872 <b>
2873 Comments:
2874 </b>
2875
2876 <br />
2877
2878 <em>
2879 <br />
2880 ================================================ <br />
2881 TABLE: assay_biomaterial <br />
2882 ================================================ <br />
2883 A biomaterial can be hybridized many times (technical replicates), or combined with other biomaterials in a single hybridization (for two-channel arrays).
2884 </em>
2885
2886 <table border="1">
2887
2888 <tr>
2889 <th class="FieldHeader">
2890 Field Name
2891 </th>
2892 <th class="FieldHeader">
2893 Data Type
2894 </th>
2895 <th class="FieldHeader">
2896 Size
2897 </th>
2898 <th class="FieldHeader">
2899 Default Value
2900 </th>
2901 <th class="FieldHeader">
2902 Other
2903 </th>
2904 <th class="FieldHeader">
2905 Foreign Key
2906 </th>
2907 </tr>
2908
2909 <tr class="tr-odd">
2910 <td class="FieldCellName"><a name="assay_biomaterial-assay_biomaterial_id">assay_biomaterial_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
2911 </tr>
2912
2913 <tr class="tr-even">
2914 <td class="FieldCellName"><a name="assay_biomaterial-assay_id">assay_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#assay-assay_id">assay.assay_id</a></td>
2915 </tr>
2916
2917 <tr class="tr-odd">
2918 <td class="FieldCellName"><a name="assay_biomaterial-biomaterial_id">biomaterial_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#biomaterial-biomaterial_id">biomaterial.biomaterial_id</a></td>
2919 </tr>
2920
2921 <tr class="tr-even">
2922 <td class="FieldCellName"><a name="assay_biomaterial-channel_id">channel_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">UNIQUE</td> <td class="FieldCellFK"><a href="#channel-channel_id">channel.channel_id</a></td>
2923 </tr>
2924
2925 <tr class="tr-odd">
2926 <td class="FieldCellName"><a name="assay_biomaterial-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
2927 </tr>
2928
2929 </table>
2930
2931 <h3>
2932 Indices
2933 </h3>
2934
2935 <table border="1">
2936
2937 <tr class="IndexRow">
2938 <th>
2939 Name
2940 </th>
2941 <th>
2942 Fields
2943 </th>
2944 </tr>
2945
2946 <tr class="IndexCell">
2947 <td>assay_biomaterial_idx1</td><td>assay_id</td>
2948 </tr>
2949
2950 <tr class="IndexCell">
2951 <td>assay_biomaterial_idx2</td><td>biomaterial_id</td>
2952 </tr>
2953
2954 <tr class="IndexCell">
2955 <td>assay_biomaterial_idx3</td><td>channel_id</td>
2956 </tr>
2957
2958 </table>
2959
2960 <h3>
2961 Constraints
2962 </h3>
2963
2964 <table border="1">
2965
2966 <tr class="IndexRow">
2967 <th>
2968 Type
2969 </th>
2970 <th>
2971 Fields
2972 </th>
2973 </tr>
2974
2975 <tr class="IndexCell">
2976 <td>NOT NULL</td><td>assay_biomaterial_id</td>
2977 </tr>
2978
2979 <tr class="IndexCell">
2980 <td>NOT NULL</td><td>assay_id</td>
2981 </tr>
2982
2983 <tr class="IndexCell">
2984 <td>FOREIGN KEY</td><td>assay_id</td>
2985 </tr>
2986
2987 <tr class="IndexCell">
2988 <td>NOT NULL</td><td>biomaterial_id</td>
2989 </tr>
2990
2991 <tr class="IndexCell">
2992 <td>FOREIGN KEY</td><td>biomaterial_id</td>
2993 </tr>
2994
2995 <tr class="IndexCell">
2996 <td>FOREIGN KEY</td><td>channel_id</td>
2997 </tr>
2998
2999 <tr class="IndexCell">
3000 <td>NOT NULL</td><td>rank</td>
3001 </tr>
3002
3003 <tr class="IndexCell">
3004 <td>UNIQUE</td><td>assay_id, biomaterial_id, channel_id, rank</td>
3005 </tr>
3006
3007 </table>
3008
3009 <hr />
3010
3011 <!--
3012 Starting table 'acquisition'
3013 -->
3014
3015 <a name="acquisition" />
3016
3017 <table class="TableHeader" width="100%">
3018 <tr class="TableHeaderRow">
3019 <td class="TableHeaderCell"><h3>
3020 acquisition
3021 </h3></td> <a name="acquisition"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
3022 </tr>
3023 </table>
3024
3025 <b>
3026 Comments:
3027 </b>
3028
3029 <br />
3030
3031 <em>
3032 <br />
3033 ================================================ <br />
3034 TABLE: acquisition <br />
3035 ================================================ <br />
3036 This represents the scanning of hybridized material. The output of this process is typically a digital image of an array.
3037 </em>
3038
3039 <table border="1">
3040
3041 <tr>
3042 <th class="FieldHeader">
3043 Field Name
3044 </th>
3045 <th class="FieldHeader">
3046 Data Type
3047 </th>
3048 <th class="FieldHeader">
3049 Size
3050 </th>
3051 <th class="FieldHeader">
3052 Default Value
3053 </th>
3054 <th class="FieldHeader">
3055 Other
3056 </th>
3057 <th class="FieldHeader">
3058 Foreign Key
3059 </th>
3060 </tr>
3061
3062 <tr class="tr-odd">
3063 <td class="FieldCellName"><a name="acquisition-acquisition_id">acquisition_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
3064 </tr>
3065
3066 <tr class="tr-even">
3067 <td class="FieldCellName"><a name="acquisition-assay_id">assay_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#assay-assay_id">assay.assay_id</a></td>
3068 </tr>
3069
3070 <tr class="tr-odd">
3071 <td class="FieldCellName"><a name="acquisition-protocol_id">protocol_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#protocol-protocol_id">protocol.protocol_id</a></td>
3072 </tr>
3073
3074 <tr class="tr-even">
3075 <td class="FieldCellName"><a name="acquisition-channel_id">channel_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#channel-channel_id">channel.channel_id</a></td>
3076 </tr>
3077
3078 <tr class="tr-odd">
3079 <td class="FieldCellName"><a name="acquisition-acquisitiondate">acquisitiondate</a></td> <td class="FieldCellType">timestamp</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">current_timestamp</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
3080 </tr>
3081
3082 <tr class="tr-even">
3083 <td class="FieldCellName"><a name="acquisition-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">UNIQUE</td> <td class="FieldCellFK"></td>
3084 </tr>
3085
3086 <tr class="tr-odd">
3087 <td class="FieldCellName"><a name="acquisition-uri">uri</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
3088 </tr>
3089
3090 </table>
3091
3092 <h3>
3093 Indices
3094 </h3>
3095
3096 <table border="1">
3097
3098 <tr class="IndexRow">
3099 <th>
3100 Name
3101 </th>
3102 <th>
3103 Fields
3104 </th>
3105 </tr>
3106
3107 <tr class="IndexCell">
3108 <td>acquisition_idx1</td><td>assay_id</td>
3109 </tr>
3110
3111 <tr class="IndexCell">
3112 <td>acquisition_idx2</td><td>protocol_id</td>
3113 </tr>
3114
3115 <tr class="IndexCell">
3116 <td>acquisition_idx3</td><td>channel_id</td>
3117 </tr>
3118
3119 </table>
3120
3121 <h3>
3122 Constraints
3123 </h3>
3124
3125 <table border="1">
3126
3127 <tr class="IndexRow">
3128 <th>
3129 Type
3130 </th>
3131 <th>
3132 Fields
3133 </th>
3134 </tr>
3135
3136 <tr class="IndexCell">
3137 <td>NOT NULL</td><td>acquisition_id</td>
3138 </tr>
3139
3140 <tr class="IndexCell">
3141 <td>NOT NULL</td><td>assay_id</td>
3142 </tr>
3143
3144 <tr class="IndexCell">
3145 <td>FOREIGN KEY</td><td>assay_id</td>
3146 </tr>
3147
3148 <tr class="IndexCell">
3149 <td>FOREIGN KEY</td><td>protocol_id</td>
3150 </tr>
3151
3152 <tr class="IndexCell">
3153 <td>FOREIGN KEY</td><td>channel_id</td>
3154 </tr>
3155
3156 <tr class="IndexCell">
3157 <td>UNIQUE</td><td>name</td>
3158 </tr>
3159
3160 </table>
3161
3162 <hr />
3163
3164 <!--
3165 Starting table 'acquisitionprop'
3166 -->
3167
3168 <a name="acquisitionprop" />
3169
3170 <table width="100%" class="TableHeader">
3171 <tr class="TableHeaderRow">
3172 <td class="TableHeaderCell"><h3>
3173 acquisitionprop
3174 </h3></td> <a name="acquisitionprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
3175 </tr>
3176 </table>
3177
3178 <b>
3179 Comments:
3180 </b>
3181
3182 <br />
3183
3184 <em>
3185 <br />
3186 ================================================ <br />
3187 TABLE: acquisitionprop <br />
3188 ================================================ <br />
3189 Parameters associated with image acquisition.
3190 </em>
3191
3192 <table border="1">
3193
3194 <tr>
3195 <th class="FieldHeader">
3196 Field Name
3197 </th>
3198 <th class="FieldHeader">
3199 Data Type
3200 </th>
3201 <th class="FieldHeader">
3202 Size
3203 </th>
3204 <th class="FieldHeader">
3205 Default Value
3206 </th>
3207 <th class="FieldHeader">
3208 Other
3209 </th>
3210 <th class="FieldHeader">
3211 Foreign Key
3212 </th>
3213 </tr>
3214
3215 <tr class="tr-odd">
3216 <td class="FieldCellName"><a name="acquisitionprop-acquisitionprop_id">acquisitionprop_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
3217 </tr>
3218
3219 <tr class="tr-even">
3220 <td class="FieldCellName"><a name="acquisitionprop-acquisition_id">acquisition_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#acquisition-acquisition_id">acquisition.acquisition_id</a></td>
3221 </tr>
3222
3223 <tr class="tr-odd">
3224 <td class="FieldCellName"><a name="acquisitionprop-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
3225 </tr>
3226
3227 <tr class="tr-even">
3228 <td class="FieldCellName"><a name="acquisitionprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
3229 </tr>
3230
3231 <tr class="tr-odd">
3232 <td class="FieldCellName"><a name="acquisitionprop-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
3233 </tr>
3234
3235 </table>
3236
3237 <h3>
3238 Indices
3239 </h3>
3240
3241 <table border="1">
3242
3243 <tr class="IndexRow">
3244 <th>
3245 Name
3246 </th>
3247 <th>
3248 Fields
3249 </th>
3250 </tr>
3251
3252 <tr class="IndexCell">
3253 <td>acquisitionprop_idx1</td><td>acquisition_id</td>
3254 </tr>
3255
3256 <tr class="IndexCell">
3257 <td>acquisitionprop_idx2</td><td>type_id</td>
3258 </tr>
3259
3260 </table>
3261
3262 <h3>
3263 Constraints
3264 </h3>
3265
3266 <table border="1">
3267
3268 <tr class="IndexRow">
3269 <th>
3270 Type
3271 </th>
3272 <th>
3273 Fields
3274 </th>
3275 </tr>
3276
3277 <tr class="IndexCell">
3278 <td>NOT NULL</td><td>acquisitionprop_id</td>
3279 </tr>
3280
3281 <tr class="IndexCell">
3282 <td>NOT NULL</td><td>acquisition_id</td>
3283 </tr>
3284
3285 <tr class="IndexCell">
3286 <td>FOREIGN KEY</td><td>acquisition_id</td>
3287 </tr>
3288
3289 <tr class="IndexCell">
3290 <td>NOT NULL</td><td>type_id</td>
3291 </tr>
3292
3293 <tr class="IndexCell">
3294 <td>FOREIGN KEY</td><td>type_id</td>
3295 </tr>
3296
3297 <tr class="IndexCell">
3298 <td>NOT NULL</td><td>rank</td>
3299 </tr>
3300
3301 <tr class="IndexCell">
3302 <td>UNIQUE</td><td>acquisition_id, type_id, rank</td>
3303 </tr>
3304
3305 </table>
3306
3307 <hr />
3308
3309 <!--
3310 Starting table 'acquisition_relationship'
3311 -->
3312
3313 <a name="acquisition_relationship" />
3314
3315 <table class="TableHeader" width="100%">
3316 <tr class="TableHeaderRow">
3317 <td class="TableHeaderCell"><h3>
3318 acquisition_relationship
3319 </h3></td> <a name="acquisition_relationship"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
3320 </tr>
3321 </table>
3322
3323 <b>
3324 Comments:
3325 </b>
3326
3327 <br />
3328
3329 <em>
3330 <br />
3331 ================================================ <br />
3332 TABLE: acquisition_relationship <br />
3333 ================================================ <br />
3334 Multiple monochrome images may be merged to form a multi-color image. Red-green images of 2-channel hybridizations are an example of this.
3335 </em>
3336
3337 <table border="1">
3338
3339 <tr>
3340 <th class="FieldHeader">
3341 Field Name
3342 </th>
3343 <th class="FieldHeader">
3344 Data Type
3345 </th>
3346 <th class="FieldHeader">
3347 Size
3348 </th>
3349 <th class="FieldHeader">
3350 Default Value
3351 </th>
3352 <th class="FieldHeader">
3353 Other
3354 </th>
3355 <th class="FieldHeader">
3356 Foreign Key
3357 </th>
3358 </tr>
3359
3360 <tr class="tr-odd">
3361 <td class="FieldCellName"><a name="acquisition_relationship-acquisition_relationship_id">acquisition_relationship_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
3362 </tr>
3363
3364 <tr class="tr-even">
3365 <td class="FieldCellName"><a name="acquisition_relationship-subject_id">subject_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#acquisition-acquisition_id">acquisition.acquisition_id</a></td>
3366 </tr>
3367
3368 <tr class="tr-odd">
3369 <td class="FieldCellName"><a name="acquisition_relationship-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
3370 </tr>
3371
3372 <tr class="tr-even">
3373 <td class="FieldCellName"><a name="acquisition_relationship-object_id">object_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#acquisition-acquisition_id">acquisition.acquisition_id</a></td>
3374 </tr>
3375
3376 <tr class="tr-odd">
3377 <td class="FieldCellName"><a name="acquisition_relationship-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
3378 </tr>
3379
3380 <tr class="tr-even">
3381 <td class="FieldCellName"><a name="acquisition_relationship-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
3382 </tr>
3383
3384 </table>
3385
3386 <h3>
3387 Indices
3388 </h3>
3389
3390 <table border="1">
3391
3392 <tr class="IndexRow">
3393 <th>
3394 Name
3395 </th>
3396 <th>
3397 Fields
3398 </th>
3399 </tr>
3400
3401 <tr class="IndexCell">
3402 <td>acquisition_relationship_idx1</td><td>subject_id</td>
3403 </tr>
3404
3405 <tr class="IndexCell">
3406 <td>acquisition_relationship_idx2</td><td>type_id</td>
3407 </tr>
3408
3409 <tr class="IndexCell">
3410 <td>acquisition_relationship_idx3</td><td>object_id</td>
3411 </tr>
3412
3413 </table>
3414
3415 <h3>
3416 Constraints
3417 </h3>
3418
3419 <table border="1">
3420
3421 <tr class="IndexRow">
3422 <th>
3423 Type
3424 </th>
3425 <th>
3426 Fields
3427 </th>
3428 </tr>
3429
3430 <tr class="IndexCell">
3431 <td>NOT NULL</td><td>acquisition_relationship_id</td>
3432 </tr>
3433
3434 <tr class="IndexCell">
3435 <td>NOT NULL</td><td>subject_id</td>
3436 </tr>
3437
3438 <tr class="IndexCell">
3439 <td>FOREIGN KEY</td><td>subject_id</td>
3440 </tr>
3441
3442 <tr class="IndexCell">
3443 <td>NOT NULL</td><td>type_id</td>
3444 </tr>
3445
3446 <tr class="IndexCell">
3447 <td>FOREIGN KEY</td><td>type_id</td>
3448 </tr>
3449
3450 <tr class="IndexCell">
3451 <td>NOT NULL</td><td>object_id</td>
3452 </tr>
3453
3454 <tr class="IndexCell">
3455 <td>FOREIGN KEY</td><td>object_id</td>
3456 </tr>
3457
3458 <tr class="IndexCell">
3459 <td>NOT NULL</td><td>rank</td>
3460 </tr>
3461
3462 <tr class="IndexCell">
3463 <td>UNIQUE</td><td>subject_id, object_id, type_id, rank</td>
3464 </tr>
3465
3466 </table>
3467
3468 <hr />
3469
3470 <!--
3471 Starting table 'quantification'
3472 -->
3473
3474 <a name="quantification" />
3475
3476 <table class="TableHeader" width="100%">
3477 <tr class="TableHeaderRow">
3478 <td class="TableHeaderCell"><h3>
3479 quantification
3480 </h3></td> <a name="quantification"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
3481 </tr>
3482 </table>
3483
3484 <b>
3485 Comments:
3486 </b>
3487
3488 <br />
3489
3490 <em>
3491 <br />
3492 ================================================ <br />
3493 TABLE: quantification <br />
3494 ================================================ <br />
3495 Quantification is the transformation of an image acquisition to numeric data. This typically involves statistical procedures.
3496 </em>
3497
3498 <table border="1">
3499
3500 <tr>
3501 <th class="FieldHeader">
3502 Field Name
3503 </th>
3504 <th class="FieldHeader">
3505 Data Type
3506 </th>
3507 <th class="FieldHeader">
3508 Size
3509 </th>
3510 <th class="FieldHeader">
3511 Default Value
3512 </th>
3513 <th class="FieldHeader">
3514 Other
3515 </th>
3516 <th class="FieldHeader">
3517 Foreign Key
3518 </th>
3519 </tr>
3520
3521 <tr class="tr-odd">
3522 <td class="FieldCellName"><a name="quantification-quantification_id">quantification_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
3523 </tr>
3524
3525 <tr class="tr-even">
3526 <td class="FieldCellName"><a name="quantification-acquisition_id">acquisition_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#acquisition-acquisition_id">acquisition.acquisition_id</a></td>
3527 </tr>
3528
3529 <tr class="tr-odd">
3530 <td class="FieldCellName"><a name="quantification-operator_id">operator_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#contact-contact_id">contact.contact_id</a></td>
3531 </tr>
3532
3533 <tr class="tr-even">
3534 <td class="FieldCellName"><a name="quantification-protocol_id">protocol_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#protocol-protocol_id">protocol.protocol_id</a></td>
3535 </tr>
3536
3537 <tr class="tr-odd">
3538 <td class="FieldCellName"><a name="quantification-analysis_id">analysis_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#analysis-analysis_id">analysis.analysis_id</a></td>
3539 </tr>
3540
3541 <tr class="tr-even">
3542 <td class="FieldCellName"><a name="quantification-quantificationdate">quantificationdate</a></td> <td class="FieldCellType">timestamp</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">current_timestamp</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
3543 </tr>
3544
3545 <tr class="tr-odd">
3546 <td class="FieldCellName"><a name="quantification-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">UNIQUE</td> <td class="FieldCellFK"></td>
3547 </tr>
3548
3549 <tr class="tr-even">
3550 <td class="FieldCellName"><a name="quantification-uri">uri</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
3551 </tr>
3552
3553 </table>
3554
3555 <h3>
3556 Indices
3557 </h3>
3558
3559 <table border="1">
3560
3561 <tr class="IndexRow">
3562 <th>
3563 Name
3564 </th>
3565 <th>
3566 Fields
3567 </th>
3568 </tr>
3569
3570 <tr class="IndexCell">
3571 <td>quantification_idx1</td><td>acquisition_id</td>
3572 </tr>
3573
3574 <tr class="IndexCell">
3575 <td>quantification_idx2</td><td>operator_id</td>
3576 </tr>
3577
3578 <tr class="IndexCell">
3579 <td>quantification_idx3</td><td>protocol_id</td>
3580 </tr>
3581
3582 <tr class="IndexCell">
3583 <td>quantification_idx4</td><td>analysis_id</td>
3584 </tr>
3585
3586 </table>
3587
3588 <h3>
3589 Constraints
3590 </h3>
3591
3592 <table border="1">
3593
3594 <tr class="IndexRow">
3595 <th>
3596 Type
3597 </th>
3598 <th>
3599 Fields
3600 </th>
3601 </tr>
3602
3603 <tr class="IndexCell">
3604 <td>NOT NULL</td><td>quantification_id</td>
3605 </tr>
3606
3607 <tr class="IndexCell">
3608 <td>NOT NULL</td><td>acquisition_id</td>
3609 </tr>
3610
3611 <tr class="IndexCell">
3612 <td>FOREIGN KEY</td><td>acquisition_id</td>
3613 </tr>
3614
3615 <tr class="IndexCell">
3616 <td>FOREIGN KEY</td><td>operator_id</td>
3617 </tr>
3618
3619 <tr class="IndexCell">
3620 <td>FOREIGN KEY</td><td>protocol_id</td>
3621 </tr>
3622
3623 <tr class="IndexCell">
3624 <td>NOT NULL</td><td>analysis_id</td>
3625 </tr>
3626
3627 <tr class="IndexCell">
3628 <td>FOREIGN KEY</td><td>analysis_id</td>
3629 </tr>
3630
3631 <tr class="IndexCell">
3632 <td>UNIQUE</td><td>name, analysis_id</td>
3633 </tr>
3634
3635 </table>
3636
3637 <hr />
3638
3639 <!--
3640 Starting table 'quantificationprop'
3641 -->
3642
3643 <a name="quantificationprop" />
3644
3645 <table class="TableHeader" width="100%">
3646 <tr class="TableHeaderRow">
3647 <td class="TableHeaderCell"><h3>
3648 quantificationprop
3649 </h3></td> <a name="quantificationprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
3650 </tr>
3651 </table>
3652
3653 <b>
3654 Comments:
3655 </b>
3656
3657 <br />
3658
3659 <em>
3660 <br />
3661 ================================================ <br />
3662 TABLE: quantificationprop <br />
3663 ================================================ <br />
3664 Extra quantification properties that are not accounted for in quantification.
3665 </em>
3666
3667 <table border="1">
3668
3669 <tr>
3670 <th class="FieldHeader">
3671 Field Name
3672 </th>
3673 <th class="FieldHeader">
3674 Data Type
3675 </th>
3676 <th class="FieldHeader">
3677 Size
3678 </th>
3679 <th class="FieldHeader">
3680 Default Value
3681 </th>
3682 <th class="FieldHeader">
3683 Other
3684 </th>
3685 <th class="FieldHeader">
3686 Foreign Key
3687 </th>
3688 </tr>
3689
3690 <tr class="tr-odd">
3691 <td class="FieldCellName"><a name="quantificationprop-quantificationprop_id">quantificationprop_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
3692 </tr>
3693
3694 <tr class="tr-even">
3695 <td class="FieldCellName"><a name="quantificationprop-quantification_id">quantification_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#quantification-quantification_id">quantification.quantification_id</a></td>
3696 </tr>
3697
3698 <tr class="tr-odd">
3699 <td class="FieldCellName"><a name="quantificationprop-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
3700 </tr>
3701
3702 <tr class="tr-even">
3703 <td class="FieldCellName"><a name="quantificationprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
3704 </tr>
3705
3706 <tr class="tr-odd">
3707 <td class="FieldCellName"><a name="quantificationprop-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
3708 </tr>
3709
3710 </table>
3711
3712 <h3>
3713 Indices
3714 </h3>
3715
3716 <table border="1">
3717
3718 <tr class="IndexRow">
3719 <th>
3720 Name
3721 </th>
3722 <th>
3723 Fields
3724 </th>
3725 </tr>
3726
3727 <tr class="IndexCell">
3728 <td>quantificationprop_idx1</td><td>quantification_id</td>
3729 </tr>
3730
3731 <tr class="IndexCell">
3732 <td>quantificationprop_idx2</td><td>type_id</td>
3733 </tr>
3734
3735 </table>
3736
3737 <h3>
3738 Constraints
3739 </h3>
3740
3741 <table border="1">
3742
3743 <tr class="IndexRow">
3744 <th>
3745 Type
3746 </th>
3747 <th>
3748 Fields
3749 </th>
3750 </tr>
3751
3752 <tr class="IndexCell">
3753 <td>NOT NULL</td><td>quantificationprop_id</td>
3754 </tr>
3755
3756 <tr class="IndexCell">
3757 <td>NOT NULL</td><td>quantification_id</td>
3758 </tr>
3759
3760 <tr class="IndexCell">
3761 <td>FOREIGN KEY</td><td>quantification_id</td>
3762 </tr>
3763
3764 <tr class="IndexCell">
3765 <td>NOT NULL</td><td>type_id</td>
3766 </tr>
3767
3768 <tr class="IndexCell">
3769 <td>FOREIGN KEY</td><td>type_id</td>
3770 </tr>
3771
3772 <tr class="IndexCell">
3773 <td>NOT NULL</td><td>rank</td>
3774 </tr>
3775
3776 <tr class="IndexCell">
3777 <td>UNIQUE</td><td>quantification_id, type_id, rank</td>
3778 </tr>
3779
3780 </table>
3781
3782 <hr />
3783
3784 <!--
3785 Starting table 'quantification_relationship'
3786 -->
3787
3788 <a name="quantification_relationship" />
3789
3790 <table class="TableHeader" width="100%">
3791 <tr class="TableHeaderRow">
3792 <td class="TableHeaderCell"><h3>
3793 quantification_relationship
3794 </h3></td> <a name="quantification_relationship"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
3795 </tr>
3796 </table>
3797
3798 <b>
3799 Comments:
3800 </b>
3801
3802 <br />
3803
3804 <em>
3805 <br />
3806 ================================================ <br />
3807 TABLE: quantification_relationship <br />
3808 ================================================ <br />
3809 There may be multiple rounds of quantification, this allows us to keep an audit trail of what values went where.
3810 </em>
3811
3812 <table border="1">
3813
3814 <tr>
3815 <th class="FieldHeader">
3816 Field Name
3817 </th>
3818 <th class="FieldHeader">
3819 Data Type
3820 </th>
3821 <th class="FieldHeader">
3822 Size
3823 </th>
3824 <th class="FieldHeader">
3825 Default Value
3826 </th>
3827 <th class="FieldHeader">
3828 Other
3829 </th>
3830 <th class="FieldHeader">
3831 Foreign Key
3832 </th>
3833 </tr>
3834
3835 <tr class="tr-odd">
3836 <td class="FieldCellName"><a name="quantification_relationship-quantification_relationship_id">quantification_relationship_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
3837 </tr>
3838
3839 <tr class="tr-even">
3840 <td class="FieldCellName"><a name="quantification_relationship-subject_id">subject_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#quantification-quantification_id">quantification.quantification_id</a></td>
3841 </tr>
3842
3843 <tr class="tr-odd">
3844 <td class="FieldCellName"><a name="quantification_relationship-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
3845 </tr>
3846
3847 <tr class="tr-even">
3848 <td class="FieldCellName"><a name="quantification_relationship-object_id">object_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#quantification-quantification_id">quantification.quantification_id</a></td>
3849 </tr>
3850
3851 </table>
3852
3853 <h3>
3854 Indices
3855 </h3>
3856
3857 <table border="1">
3858
3859 <tr class="IndexRow">
3860 <th>
3861 Name
3862 </th>
3863 <th>
3864 Fields
3865 </th>
3866 </tr>
3867
3868 <tr class="IndexCell">
3869 <td>quantification_relationship_idx1</td><td>subject_id</td>
3870 </tr>
3871
3872 <tr class="IndexCell">
3873 <td>quantification_relationship_idx2</td><td>type_id</td>
3874 </tr>
3875
3876 <tr class="IndexCell">
3877 <td>quantification_relationship_idx3</td><td>object_id</td>
3878 </tr>
3879
3880 </table>
3881
3882 <h3>
3883 Constraints
3884 </h3>
3885
3886 <table border="1">
3887
3888 <tr class="IndexRow">
3889 <th>
3890 Type
3891 </th>
3892 <th>
3893 Fields
3894 </th>
3895 </tr>
3896
3897 <tr class="IndexCell">
3898 <td>NOT NULL</td><td>quantification_relationship_id</td>
3899 </tr>
3900
3901 <tr class="IndexCell">
3902 <td>NOT NULL</td><td>subject_id</td>
3903 </tr>
3904
3905 <tr class="IndexCell">
3906 <td>FOREIGN KEY</td><td>subject_id</td>
3907 </tr>
3908
3909 <tr class="IndexCell">
3910 <td>NOT NULL</td><td>type_id</td>
3911 </tr>
3912
3913 <tr class="IndexCell">
3914 <td>FOREIGN KEY</td><td>type_id</td>
3915 </tr>
3916
3917 <tr class="IndexCell">
3918 <td>NOT NULL</td><td>object_id</td>
3919 </tr>
3920
3921 <tr class="IndexCell">
3922 <td>FOREIGN KEY</td><td>object_id</td>
3923 </tr>
3924
3925 <tr class="IndexCell">
3926 <td>UNIQUE</td><td>subject_id, object_id, type_id</td>
3927 </tr>
3928
3929 </table>
3930
3931 <hr />
3932
3933 <!--
3934 Starting table 'control'
3935 -->
3936
3937 <a name="control" />
3938
3939 <table class="TableHeader" width="100%">
3940 <tr class="TableHeaderRow">
3941 <td class="TableHeaderCell"><h3>
3942 control
3943 </h3></td> <a name="control"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
3944 </tr>
3945 </table>
3946
3947 <b>
3948 Comments:
3949 </b>
3950
3951 <br />
3952
3953 <em>
3954 <br />
3955 ================================================ <br />
3956 TABLE: control <br />
3957 ================================================ <br />
3958 NULL
3959 </em>
3960
3961 <table border="1">
3962
3963 <tr>
3964 <th class="FieldHeader">
3965 Field Name
3966 </th>
3967 <th class="FieldHeader">
3968 Data Type
3969 </th>
3970 <th class="FieldHeader">
3971 Size
3972 </th>
3973 <th class="FieldHeader">
3974 Default Value
3975 </th>
3976 <th class="FieldHeader">
3977 Other
3978 </th>
3979 <th class="FieldHeader">
3980 Foreign Key
3981 </th>
3982 </tr>
3983
3984 <tr class="tr-odd">
3985 <td class="FieldCellName"><a name="control-control_id">control_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
3986 </tr>
3987
3988 <tr class="tr-even">
3989 <td class="FieldCellName"><a name="control-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
3990 </tr>
3991
3992 <tr class="tr-odd">
3993 <td class="FieldCellName"><a name="control-assay_id">assay_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#assay-assay_id">assay.assay_id</a></td>
3994 </tr>
3995
3996 <tr class="tr-even">
3997 <td class="FieldCellName"><a name="control-tableinfo_id">tableinfo_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#tableinfo-tableinfo_id">tableinfo.tableinfo_id</a></td>
3998 </tr>
3999
4000 <tr class="tr-odd">
4001 <td class="FieldCellName"><a name="control-row_id">row_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
4002 </tr>
4003
4004 <tr class="tr-even">
4005 <td class="FieldCellName"><a name="control-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
4006 </tr>
4007
4008 <tr class="tr-odd">
4009 <td class="FieldCellName"><a name="control-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
4010 </tr>
4011
4012 <tr class="tr-even">
4013 <td class="FieldCellName"><a name="control-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
4014 </tr>
4015
4016 </table>
4017
4018 <h3>
4019 Indices
4020 </h3>
4021
4022 <table border="1">
4023
4024 <tr class="IndexRow">
4025 <th>
4026 Name
4027 </th>
4028 <th>
4029 Fields
4030 </th>
4031 </tr>
4032
4033 <tr class="IndexCell">
4034 <td>control_idx1</td><td>type_id</td>
4035 </tr>
4036
4037 <tr class="IndexCell">
4038 <td>control_idx2</td><td>assay_id</td>
4039 </tr>
4040
4041 <tr class="IndexCell">
4042 <td>control_idx3</td><td>tableinfo_id</td>
4043 </tr>
4044
4045 <tr class="IndexCell">
4046 <td>control_idx4</td><td>row_id</td>
4047 </tr>
4048
4049 </table>
4050
4051 <h3>
4052 Constraints
4053 </h3>
4054
4055 <table border="1">
4056
4057 <tr class="IndexRow">
4058 <th>
4059 Type
4060 </th>
4061 <th>
4062 Fields
4063 </th>
4064 </tr>
4065
4066 <tr class="IndexCell">
4067 <td>NOT NULL</td><td>control_id</td>
4068 </tr>
4069
4070 <tr class="IndexCell">
4071 <td>NOT NULL</td><td>type_id</td>
4072 </tr>
4073
4074 <tr class="IndexCell">
4075 <td>FOREIGN KEY</td><td>type_id</td>
4076 </tr>
4077
4078 <tr class="IndexCell">
4079 <td>NOT NULL</td><td>assay_id</td>
4080 </tr>
4081
4082 <tr class="IndexCell">
4083 <td>FOREIGN KEY</td><td>assay_id</td>
4084 </tr>
4085
4086 <tr class="IndexCell">
4087 <td>NOT NULL</td><td>tableinfo_id</td>
4088 </tr>
4089
4090 <tr class="IndexCell">
4091 <td>FOREIGN KEY</td><td>tableinfo_id</td>
4092 </tr>
4093
4094 <tr class="IndexCell">
4095 <td>NOT NULL</td><td>row_id</td>
4096 </tr>
4097
4098 <tr class="IndexCell">
4099 <td>NOT NULL</td><td>rank</td>
4100 </tr>
4101
4102 </table>
4103
4104 <hr />
4105
4106 <!--
4107 Starting table 'element'
4108 -->
4109
4110 <a name="element" />
4111
4112 <table width="100%" class="TableHeader">
4113 <tr class="TableHeaderRow">
4114 <td class="TableHeaderCell"><h3>
4115 element
4116 </h3></td> <a name="element"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
4117 </tr>
4118 </table>
4119
4120 <b>
4121 Comments:
4122 </b>
4123
4124 <br />
4125
4126 <em>
4127 <br />
4128 ================================================ <br />
4129 TABLE: element <br />
4130 ================================================ <br />
4131 Represents a feature of the array. This is typically a region of the array coated or bound to DNA.
4132 </em>
4133
4134 <table border="1">
4135
4136 <tr>
4137 <th class="FieldHeader">
4138 Field Name
4139 </th>
4140 <th class="FieldHeader">
4141 Data Type
4142 </th>
4143 <th class="FieldHeader">
4144 Size
4145 </th>
4146 <th class="FieldHeader">
4147 Default Value
4148 </th>
4149 <th class="FieldHeader">
4150 Other
4151 </th>
4152 <th class="FieldHeader">
4153 Foreign Key
4154 </th>
4155 </tr>
4156
4157 <tr class="tr-odd">
4158 <td class="FieldCellName"><a name="element-element_id">element_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
4159 </tr>
4160
4161 <tr class="tr-even">
4162 <td class="FieldCellName"><a name="element-feature_id">feature_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">UNIQUE</td> <td class="FieldCellFK"><a href="#feature-feature_id">feature.feature_id</a></td>
4163 </tr>
4164
4165 <tr class="tr-odd">
4166 <td class="FieldCellName"><a name="element-arraydesign_id">arraydesign_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#arraydesign-arraydesign_id">arraydesign.arraydesign_id</a></td>
4167 </tr>
4168
4169 <tr class="tr-even">
4170 <td class="FieldCellName"><a name="element-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
4171 </tr>
4172
4173 <tr class="tr-odd">
4174 <td class="FieldCellName"><a name="element-dbxref_id">dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
4175 </tr>
4176
4177 </table>
4178
4179 <h3>
4180 Indices
4181 </h3>
4182
4183 <table border="1">
4184
4185 <tr class="IndexRow">
4186 <th>
4187 Name
4188 </th>
4189 <th>
4190 Fields
4191 </th>
4192 </tr>
4193
4194 <tr class="IndexCell">
4195 <td>element_idx1</td><td>feature_id</td>
4196 </tr>
4197
4198 <tr class="IndexCell">
4199 <td>element_idx2</td><td>arraydesign_id</td>
4200 </tr>
4201
4202 <tr class="IndexCell">
4203 <td>element_idx3</td><td>type_id</td>
4204 </tr>
4205
4206 <tr class="IndexCell">
4207 <td>element_idx4</td><td>dbxref_id</td>
4208 </tr>
4209
4210 </table>
4211
4212 <h3>
4213 Constraints
4214 </h3>
4215
4216 <table border="1">
4217
4218 <tr class="IndexRow">
4219 <th>
4220 Type
4221 </th>
4222 <th>
4223 Fields
4224 </th>
4225 </tr>
4226
4227 <tr class="IndexCell">
4228 <td>NOT NULL</td><td>element_id</td>
4229 </tr>
4230
4231 <tr class="IndexCell">
4232 <td>FOREIGN KEY</td><td>feature_id</td>
4233 </tr>
4234
4235 <tr class="IndexCell">
4236 <td>NOT NULL</td><td>arraydesign_id</td>
4237 </tr>
4238
4239 <tr class="IndexCell">
4240 <td>FOREIGN KEY</td><td>arraydesign_id</td>
4241 </tr>
4242
4243 <tr class="IndexCell">
4244 <td>FOREIGN KEY</td><td>type_id</td>
4245 </tr>
4246
4247 <tr class="IndexCell">
4248 <td>FOREIGN KEY</td><td>dbxref_id</td>
4249 </tr>
4250
4251 <tr class="IndexCell">
4252 <td>UNIQUE</td><td>feature_id, arraydesign_id</td>
4253 </tr>
4254
4255 </table>
4256
4257 <hr />
4258
4259 <!--
4260 Starting table 'elementresult'
4261 -->
4262
4263 <a name="elementresult" />
4264
4265 <table class="TableHeader" width="100%">
4266 <tr class="TableHeaderRow">
4267 <td class="TableHeaderCell"><h3>
4268 elementresult
4269 </h3></td> <a name="elementresult"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
4270 </tr>
4271 </table>
4272
4273 <b>
4274 Comments:
4275 </b>
4276
4277 <br />
4278
4279 <em>
4280 <br />
4281 ================================================ <br />
4282 TABLE: element_result <br />
4283 ================================================ <br />
4284 An element on an array produces a measurement when hybridized to a biomaterial (traceable through quantification_id). This is the base data from which tables that actually contain data inherit.
4285 </em>
4286
4287 <table border="1">
4288
4289 <tr>
4290 <th class="FieldHeader">
4291 Field Name
4292 </th>
4293 <th class="FieldHeader">
4294 Data Type
4295 </th>
4296 <th class="FieldHeader">
4297 Size
4298 </th>
4299 <th class="FieldHeader">
4300 Default Value
4301 </th>
4302 <th class="FieldHeader">
4303 Other
4304 </th>
4305 <th class="FieldHeader">
4306 Foreign Key
4307 </th>
4308 </tr>
4309
4310 <tr class="tr-odd">
4311 <td class="FieldCellName"><a name="elementresult-elementresult_id">elementresult_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
4312 </tr>
4313
4314 <tr class="tr-even">
4315 <td class="FieldCellName"><a name="elementresult-element_id">element_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#element-element_id">element.element_id</a></td>
4316 </tr>
4317
4318 <tr class="tr-odd">
4319 <td class="FieldCellName"><a name="elementresult-quantification_id">quantification_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#quantification-quantification_id">quantification.quantification_id</a></td>
4320 </tr>
4321
4322 <tr class="tr-even">
4323 <td class="FieldCellName"><a name="elementresult-signal">signal</a></td> <td class="FieldCellType">float</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
4324 </tr>
4325
4326 </table>
4327
4328 <h3>
4329 Indices
4330 </h3>
4331
4332 <table border="1">
4333
4334 <tr class="IndexRow">
4335 <th>
4336 Name
4337 </th>
4338 <th>
4339 Fields
4340 </th>
4341 </tr>
4342
4343 <tr class="IndexCell">
4344 <td>elementresult_idx1</td><td>element_id</td>
4345 </tr>
4346
4347 <tr class="IndexCell">
4348 <td>elementresult_idx2</td><td>quantification_id</td>
4349 </tr>
4350
4351 <tr class="IndexCell">
4352 <td>elementresult_idx3</td><td>signal</td>
4353 </tr>
4354
4355 </table>
4356
4357 <h3>
4358 Constraints
4359 </h3>
4360
4361 <table border="1">
4362
4363 <tr class="IndexRow">
4364 <th>
4365 Type
4366 </th>
4367 <th>
4368 Fields
4369 </th>
4370 </tr>
4371
4372 <tr class="IndexCell">
4373 <td>NOT NULL</td><td>elementresult_id</td>
4374 </tr>
4375
4376 <tr class="IndexCell">
4377 <td>NOT NULL</td><td>element_id</td>
4378 </tr>
4379
4380 <tr class="IndexCell">
4381 <td>FOREIGN KEY</td><td>element_id</td>
4382 </tr>
4383
4384 <tr class="IndexCell">
4385 <td>NOT NULL</td><td>quantification_id</td>
4386 </tr>
4387
4388 <tr class="IndexCell">
4389 <td>FOREIGN KEY</td><td>quantification_id</td>
4390 </tr>
4391
4392 <tr class="IndexCell">
4393 <td>NOT NULL</td><td>signal</td>
4394 </tr>
4395
4396 <tr class="IndexCell">
4397 <td>UNIQUE</td><td>element_id, quantification_id</td>
4398 </tr>
4399
4400 </table>
4401
4402 <hr />
4403
4404 <!--
4405 Starting table 'element_relationship'
4406 -->
4407
4408 <a name="element_relationship" />
4409
4410 <table class="TableHeader" width="100%">
4411 <tr class="TableHeaderRow">
4412 <td class="TableHeaderCell"><h3>
4413 element_relationship
4414 </h3></td> <a name="element_relationship"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
4415 </tr>
4416 </table>
4417
4418 <b>
4419 Comments:
4420 </b>
4421
4422 <br />
4423
4424 <em>
4425 <br />
4426 ================================================ <br />
4427 TABLE: element_relationship <br />
4428 ================================================ <br />
4429 Sometimes we want to combine measurements from multiple elements to get a composite value. Affymetrix combines many probes to form a probeset measurement, for instance.
4430 </em>
4431
4432 <table border="1">
4433
4434 <tr>
4435 <th class="FieldHeader">
4436 Field Name
4437 </th>
4438 <th class="FieldHeader">
4439 Data Type
4440 </th>
4441 <th class="FieldHeader">
4442 Size
4443 </th>
4444 <th class="FieldHeader">
4445 Default Value
4446 </th>
4447 <th class="FieldHeader">
4448 Other
4449 </th>
4450 <th class="FieldHeader">
4451 Foreign Key
4452 </th>
4453 </tr>
4454
4455 <tr class="tr-odd">
4456 <td class="FieldCellName"><a name="element_relationship-element_relationship_id">element_relationship_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
4457 </tr>
4458
4459 <tr class="tr-even">
4460 <td class="FieldCellName"><a name="element_relationship-subject_id">subject_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#element-element_id">element.element_id</a></td>
4461 </tr>
4462
4463 <tr class="tr-odd">
4464 <td class="FieldCellName"><a name="element_relationship-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
4465 </tr>
4466
4467 <tr class="tr-even">
4468 <td class="FieldCellName"><a name="element_relationship-object_id">object_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#element-element_id">element.element_id</a></td>
4469 </tr>
4470
4471 <tr class="tr-odd">
4472 <td class="FieldCellName"><a name="element_relationship-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
4473 </tr>
4474
4475 <tr class="tr-even">
4476 <td class="FieldCellName"><a name="element_relationship-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
4477 </tr>
4478
4479 </table>
4480
4481 <h3>
4482 Indices
4483 </h3>
4484
4485 <table border="1">
4486
4487 <tr class="IndexRow">
4488 <th>
4489 Name
4490 </th>
4491 <th>
4492 Fields
4493 </th>
4494 </tr>
4495
4496 <tr class="IndexCell">
4497 <td>element_relationship_idx1</td><td>subject_id</td>
4498 </tr>
4499
4500 <tr class="IndexCell">
4501 <td>element_relationship_idx2</td><td>type_id</td>
4502 </tr>
4503
4504 <tr class="IndexCell">
4505 <td>element_relationship_idx3</td><td>object_id</td>
4506 </tr>
4507
4508 <tr class="IndexCell">
4509 <td>element_relationship_idx4</td><td>value</td>
4510 </tr>
4511
4512 </table>
4513
4514 <h3>
4515 Constraints
4516 </h3>
4517
4518 <table border="1">
4519
4520 <tr class="IndexRow">
4521 <th>
4522 Type
4523 </th>
4524 <th>
4525 Fields
4526 </th>
4527 </tr>
4528
4529 <tr class="IndexCell">
4530 <td>NOT NULL</td><td>element_relationship_id</td>
4531 </tr>
4532
4533 <tr class="IndexCell">
4534 <td>NOT NULL</td><td>subject_id</td>
4535 </tr>
4536
4537 <tr class="IndexCell">
4538 <td>FOREIGN KEY</td><td>subject_id</td>
4539 </tr>
4540
4541 <tr class="IndexCell">
4542 <td>NOT NULL</td><td>type_id</td>
4543 </tr>
4544
4545 <tr class="IndexCell">
4546 <td>FOREIGN KEY</td><td>type_id</td>
4547 </tr>
4548
4549 <tr class="IndexCell">
4550 <td>NOT NULL</td><td>object_id</td>
4551 </tr>
4552
4553 <tr class="IndexCell">
4554 <td>FOREIGN KEY</td><td>object_id</td>
4555 </tr>
4556
4557 <tr class="IndexCell">
4558 <td>NOT NULL</td><td>rank</td>
4559 </tr>
4560
4561 <tr class="IndexCell">
4562 <td>UNIQUE</td><td>subject_id, object_id, type_id, rank</td>
4563 </tr>
4564
4565 </table>
4566
4567 <hr />
4568
4569 <!--
4570 Starting table 'elementresult_relationship'
4571 -->
4572
4573 <a name="elementresult_relationship" />
4574
4575 <table width="100%" class="TableHeader">
4576 <tr class="TableHeaderRow">
4577 <td class="TableHeaderCell"><h3>
4578 elementresult_relationship
4579 </h3></td> <a name="elementresult_relationship"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
4580 </tr>
4581 </table>
4582
4583 <b>
4584 Comments:
4585 </b>
4586
4587 <br />
4588
4589 <em>
4590 <br />
4591 ================================================ <br />
4592 TABLE: elementresult_relationship <br />
4593 ================================================ <br />
4594 Sometimes we want to combine measurements from multiple elements to get a composite value. Affymetrix combines many probes to form a probeset measurement, for instance.
4595 </em>
4596
4597 <table border="1">
4598
4599 <tr>
4600 <th class="FieldHeader">
4601 Field Name
4602 </th>
4603 <th class="FieldHeader">
4604 Data Type
4605 </th>
4606 <th class="FieldHeader">
4607 Size
4608 </th>
4609 <th class="FieldHeader">
4610 Default Value
4611 </th>
4612 <th class="FieldHeader">
4613 Other
4614 </th>
4615 <th class="FieldHeader">
4616 Foreign Key
4617 </th>
4618 </tr>
4619
4620 <tr class="tr-odd">
4621 <td class="FieldCellName"><a name="elementresult_relationship-elementresult_relationship_id">elementresult_relationship_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
4622 </tr>
4623
4624 <tr class="tr-even">
4625 <td class="FieldCellName"><a name="elementresult_relationship-subject_id">subject_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#elementresult-elementresult_id">elementresult.elementresult_id</a></td>
4626 </tr>
4627
4628 <tr class="tr-odd">
4629 <td class="FieldCellName"><a name="elementresult_relationship-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
4630 </tr>
4631
4632 <tr class="tr-even">
4633 <td class="FieldCellName"><a name="elementresult_relationship-object_id">object_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#elementresult-elementresult_id">elementresult.elementresult_id</a></td>
4634 </tr>
4635
4636 <tr class="tr-odd">
4637 <td class="FieldCellName"><a name="elementresult_relationship-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
4638 </tr>
4639
4640 <tr class="tr-even">
4641 <td class="FieldCellName"><a name="elementresult_relationship-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
4642 </tr>
4643
4644 </table>
4645
4646 <h3>
4647 Indices
4648 </h3>
4649
4650 <table border="1">
4651
4652 <tr class="IndexRow">
4653 <th>
4654 Name
4655 </th>
4656 <th>
4657 Fields
4658 </th>
4659 </tr>
4660
4661 <tr class="IndexCell">
4662 <td>elementresult_relationship_idx1</td><td>subject_id</td>
4663 </tr>
4664
4665 <tr class="IndexCell">
4666 <td>elementresult_relationship_idx2</td><td>type_id</td>
4667 </tr>
4668
4669 <tr class="IndexCell">
4670 <td>elementresult_relationship_idx3</td><td>object_id</td>
4671 </tr>
4672
4673 <tr class="IndexCell">
4674 <td>elementresult_relationship_idx4</td><td>value</td>
4675 </tr>
4676
4677 </table>
4678
4679 <h3>
4680 Constraints
4681 </h3>
4682
4683 <table border="1">
4684
4685 <tr class="IndexRow">
4686 <th>
4687 Type
4688 </th>
4689 <th>
4690 Fields
4691 </th>
4692 </tr>
4693
4694 <tr class="IndexCell">
4695 <td>NOT NULL</td><td>elementresult_relationship_id</td>
4696 </tr>
4697
4698 <tr class="IndexCell">
4699 <td>NOT NULL</td><td>subject_id</td>
4700 </tr>
4701
4702 <tr class="IndexCell">
4703 <td>FOREIGN KEY</td><td>subject_id</td>
4704 </tr>
4705
4706 <tr class="IndexCell">
4707 <td>NOT NULL</td><td>type_id</td>
4708 </tr>
4709
4710 <tr class="IndexCell">
4711 <td>FOREIGN KEY</td><td>type_id</td>
4712 </tr>
4713
4714 <tr class="IndexCell">
4715 <td>NOT NULL</td><td>object_id</td>
4716 </tr>
4717
4718 <tr class="IndexCell">
4719 <td>FOREIGN KEY</td><td>object_id</td>
4720 </tr>
4721
4722 <tr class="IndexCell">
4723 <td>NOT NULL</td><td>rank</td>
4724 </tr>
4725
4726 <tr class="IndexCell">
4727 <td>UNIQUE</td><td>subject_id, object_id, type_id, rank</td>
4728 </tr>
4729
4730 </table>
4731
4732 <hr />
4733
4734 <!--
4735 Starting table 'study'
4736 -->
4737
4738 <a name="study" />
4739
4740 <table class="TableHeader" width="100%">
4741 <tr class="TableHeaderRow">
4742 <td class="TableHeaderCell"><h3>
4743 study
4744 </h3></td> <a name="study"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
4745 </tr>
4746 </table>
4747
4748 <b>
4749 Comments:
4750 </b>
4751
4752 <br />
4753
4754 <em>
4755 <br />
4756 ================================================ <br />
4757 TABLE: study <br />
4758 ================================================ <br />
4759 NULL
4760 </em>
4761
4762 <table border="1">
4763
4764 <tr>
4765 <th class="FieldHeader">
4766 Field Name
4767 </th>
4768 <th class="FieldHeader">
4769 Data Type
4770 </th>
4771 <th class="FieldHeader">
4772 Size
4773 </th>
4774 <th class="FieldHeader">
4775 Default Value
4776 </th>
4777 <th class="FieldHeader">
4778 Other
4779 </th>
4780 <th class="FieldHeader">
4781 Foreign Key
4782 </th>
4783 </tr>
4784
4785 <tr class="tr-odd">
4786 <td class="FieldCellName"><a name="study-study_id">study_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
4787 </tr>
4788
4789 <tr class="tr-even">
4790 <td class="FieldCellName"><a name="study-contact_id">contact_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#contact-contact_id">contact.contact_id</a></td>
4791 </tr>
4792
4793 <tr class="tr-odd">
4794 <td class="FieldCellName"><a name="study-pub_id">pub_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
4795 </tr>
4796
4797 <tr class="tr-even">
4798 <td class="FieldCellName"><a name="study-dbxref_id">dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
4799 </tr>
4800
4801 <tr class="tr-odd">
4802 <td class="FieldCellName"><a name="study-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
4803 </tr>
4804
4805 <tr class="tr-even">
4806 <td class="FieldCellName"><a name="study-description">description</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
4807 </tr>
4808
4809 </table>
4810
4811 <h3>
4812 Indices
4813 </h3>
4814
4815 <table border="1">
4816
4817 <tr class="IndexRow">
4818 <th>
4819 Name
4820 </th>
4821 <th>
4822 Fields
4823 </th>
4824 </tr>
4825
4826 <tr class="IndexCell">
4827 <td>study_idx1</td><td>contact_id</td>
4828 </tr>
4829
4830 <tr class="IndexCell">
4831 <td>study_idx2</td><td>pub_id</td>
4832 </tr>
4833
4834 <tr class="IndexCell">
4835 <td>study_idx3</td><td>dbxref_id</td>
4836 </tr>
4837
4838 </table>
4839
4840 <h3>
4841 Constraints
4842 </h3>
4843
4844 <table border="1">
4845
4846 <tr class="IndexRow">
4847 <th>
4848 Type
4849 </th>
4850 <th>
4851 Fields
4852 </th>
4853 </tr>
4854
4855 <tr class="IndexCell">
4856 <td>NOT NULL</td><td>study_id</td>
4857 </tr>
4858
4859 <tr class="IndexCell">
4860 <td>NOT NULL</td><td>contact_id</td>
4861 </tr>
4862
4863 <tr class="IndexCell">
4864 <td>FOREIGN KEY</td><td>contact_id</td>
4865 </tr>
4866
4867 <tr class="IndexCell">
4868 <td>FOREIGN KEY</td><td>pub_id</td>
4869 </tr>
4870
4871 <tr class="IndexCell">
4872 <td>FOREIGN KEY</td><td>dbxref_id</td>
4873 </tr>
4874
4875 <tr class="IndexCell">
4876 <td>NOT NULL</td><td>name</td>
4877 </tr>
4878
4879 <tr class="IndexCell">
4880 <td>UNIQUE</td><td>name</td>
4881 </tr>
4882
4883 </table>
4884
4885 <hr />
4886
4887 <!--
4888 Starting table 'study_assay'
4889 -->
4890
4891 <a name="study_assay" />
4892
4893 <table width="100%" class="TableHeader">
4894 <tr class="TableHeaderRow">
4895 <td class="TableHeaderCell"><h3>
4896 study_assay
4897 </h3></td> <a name="study_assay"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
4898 </tr>
4899 </table>
4900
4901 <b>
4902 Comments:
4903 </b>
4904
4905 <br />
4906
4907 <em>
4908 <br />
4909 ================================================ <br />
4910 TABLE: study_assay <br />
4911 ================================================ <br />
4912 NULL
4913 </em>
4914
4915 <table border="1">
4916
4917 <tr>
4918 <th class="FieldHeader">
4919 Field Name
4920 </th>
4921 <th class="FieldHeader">
4922 Data Type
4923 </th>
4924 <th class="FieldHeader">
4925 Size
4926 </th>
4927 <th class="FieldHeader">
4928 Default Value
4929 </th>
4930 <th class="FieldHeader">
4931 Other
4932 </th>
4933 <th class="FieldHeader">
4934 Foreign Key
4935 </th>
4936 </tr>
4937
4938 <tr class="tr-odd">
4939 <td class="FieldCellName"><a name="study_assay-study_assay_id">study_assay_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
4940 </tr>
4941
4942 <tr class="tr-even">
4943 <td class="FieldCellName"><a name="study_assay-study_id">study_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#study-study_id">study.study_id</a></td>
4944 </tr>
4945
4946 <tr class="tr-odd">
4947 <td class="FieldCellName"><a name="study_assay-assay_id">assay_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#assay-assay_id">assay.assay_id</a></td>
4948 </tr>
4949
4950 </table>
4951
4952 <h3>
4953 Indices
4954 </h3>
4955
4956 <table border="1">
4957
4958 <tr class="IndexRow">
4959 <th>
4960 Name
4961 </th>
4962 <th>
4963 Fields
4964 </th>
4965 </tr>
4966
4967 <tr class="IndexCell">
4968 <td>study_assay_idx1</td><td>study_id</td>
4969 </tr>
4970
4971 <tr class="IndexCell">
4972 <td>study_assay_idx2</td><td>assay_id</td>
4973 </tr>
4974
4975 </table>
4976
4977 <h3>
4978 Constraints
4979 </h3>
4980
4981 <table border="1">
4982
4983 <tr class="IndexRow">
4984 <th>
4985 Type
4986 </th>
4987 <th>
4988 Fields
4989 </th>
4990 </tr>
4991
4992 <tr class="IndexCell">
4993 <td>NOT NULL</td><td>study_assay_id</td>
4994 </tr>
4995
4996 <tr class="IndexCell">
4997 <td>NOT NULL</td><td>study_id</td>
4998 </tr>
4999
5000 <tr class="IndexCell">
5001 <td>FOREIGN KEY</td><td>study_id</td>
5002 </tr>
5003
5004 <tr class="IndexCell">
5005 <td>NOT NULL</td><td>assay_id</td>
5006 </tr>
5007
5008 <tr class="IndexCell">
5009 <td>FOREIGN KEY</td><td>assay_id</td>
5010 </tr>
5011
5012 <tr class="IndexCell">
5013 <td>UNIQUE</td><td>study_id, assay_id</td>
5014 </tr>
5015
5016 </table>
5017
5018 <hr />
5019
5020 <!--
5021 Starting table 'studydesign'
5022 -->
5023
5024 <a name="studydesign" />
5025
5026 <table class="TableHeader" width="100%">
5027 <tr class="TableHeaderRow">
5028 <td class="TableHeaderCell"><h3>
5029 studydesign
5030 </h3></td> <a name="studydesign"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
5031 </tr>
5032 </table>
5033
5034 <b>
5035 Comments:
5036 </b>
5037
5038 <br />
5039
5040 <em>
5041 <br />
5042 ================================================ <br />
5043 TABLE: studydesign <br />
5044 ================================================ <br />
5045 NULL
5046 </em>
5047
5048 <table border="1">
5049
5050 <tr>
5051 <th class="FieldHeader">
5052 Field Name
5053 </th>
5054 <th class="FieldHeader">
5055 Data Type
5056 </th>
5057 <th class="FieldHeader">
5058 Size
5059 </th>
5060 <th class="FieldHeader">
5061 Default Value
5062 </th>
5063 <th class="FieldHeader">
5064 Other
5065 </th>
5066 <th class="FieldHeader">
5067 Foreign Key
5068 </th>
5069 </tr>
5070
5071 <tr class="tr-odd">
5072 <td class="FieldCellName"><a name="studydesign-studydesign_id">studydesign_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
5073 </tr>
5074
5075 <tr class="tr-even">
5076 <td class="FieldCellName"><a name="studydesign-study_id">study_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#study-study_id">study.study_id</a></td>
5077 </tr>
5078
5079 <tr class="tr-odd">
5080 <td class="FieldCellName"><a name="studydesign-description">description</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
5081 </tr>
5082
5083 </table>
5084
5085 <h3>
5086 Indices
5087 </h3>
5088
5089 <table border="1">
5090
5091 <tr class="IndexRow">
5092 <th>
5093 Name
5094 </th>
5095 <th>
5096 Fields
5097 </th>
5098 </tr>
5099
5100 <tr class="IndexCell">
5101 <td>studydesign_idx1</td><td>study_id</td>
5102 </tr>
5103
5104 </table>
5105
5106 <h3>
5107 Constraints
5108 </h3>
5109
5110 <table border="1">
5111
5112 <tr class="IndexRow">
5113 <th>
5114 Type
5115 </th>
5116 <th>
5117 Fields
5118 </th>
5119 </tr>
5120
5121 <tr class="IndexCell">
5122 <td>NOT NULL</td><td>studydesign_id</td>
5123 </tr>
5124
5125 <tr class="IndexCell">
5126 <td>NOT NULL</td><td>study_id</td>
5127 </tr>
5128
5129 <tr class="IndexCell">
5130 <td>FOREIGN KEY</td><td>study_id</td>
5131 </tr>
5132
5133 </table>
5134
5135 <hr />
5136
5137 <!--
5138 Starting table 'studydesignprop'
5139 -->
5140
5141 <a name="studydesignprop" />
5142
5143 <table width="100%" class="TableHeader">
5144 <tr class="TableHeaderRow">
5145 <td class="TableHeaderCell"><h3>
5146 studydesignprop
5147 </h3></td> <a name="studydesignprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
5148 </tr>
5149 </table>
5150
5151 <b>
5152 Comments:
5153 </b>
5154
5155 <br />
5156
5157 <em>
5158 <br />
5159 ================================================ <br />
5160 TABLE: studydesignprop <br />
5161 ================================================ <br />
5162 NULL
5163 </em>
5164
5165 <table border="1">
5166
5167 <tr>
5168 <th class="FieldHeader">
5169 Field Name
5170 </th>
5171 <th class="FieldHeader">
5172 Data Type
5173 </th>
5174 <th class="FieldHeader">
5175 Size
5176 </th>
5177 <th class="FieldHeader">
5178 Default Value
5179 </th>
5180 <th class="FieldHeader">
5181 Other
5182 </th>
5183 <th class="FieldHeader">
5184 Foreign Key
5185 </th>
5186 </tr>
5187
5188 <tr class="tr-odd">
5189 <td class="FieldCellName"><a name="studydesignprop-studydesignprop_id">studydesignprop_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
5190 </tr>
5191
5192 <tr class="tr-even">
5193 <td class="FieldCellName"><a name="studydesignprop-studydesign_id">studydesign_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#studydesign-studydesign_id">studydesign.studydesign_id</a></td>
5194 </tr>
5195
5196 <tr class="tr-odd">
5197 <td class="FieldCellName"><a name="studydesignprop-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
5198 </tr>
5199
5200 <tr class="tr-even">
5201 <td class="FieldCellName"><a name="studydesignprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
5202 </tr>
5203
5204 <tr class="tr-odd">
5205 <td class="FieldCellName"><a name="studydesignprop-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
5206 </tr>
5207
5208 </table>
5209
5210 <h3>
5211 Indices
5212 </h3>
5213
5214 <table border="1">
5215
5216 <tr class="IndexRow">
5217 <th>
5218 Name
5219 </th>
5220 <th>
5221 Fields
5222 </th>
5223 </tr>
5224
5225 <tr class="IndexCell">
5226 <td>studydesignprop_idx1</td><td>studydesign_id</td>
5227 </tr>
5228
5229 <tr class="IndexCell">
5230 <td>studydesignprop_idx2</td><td>type_id</td>
5231 </tr>
5232
5233 </table>
5234
5235 <h3>
5236 Constraints
5237 </h3>
5238
5239 <table border="1">
5240
5241 <tr class="IndexRow">
5242 <th>
5243 Type
5244 </th>
5245 <th>
5246 Fields
5247 </th>
5248 </tr>
5249
5250 <tr class="IndexCell">
5251 <td>NOT NULL</td><td>studydesignprop_id</td>
5252 </tr>
5253
5254 <tr class="IndexCell">
5255 <td>NOT NULL</td><td>studydesign_id</td>
5256 </tr>
5257
5258 <tr class="IndexCell">
5259 <td>FOREIGN KEY</td><td>studydesign_id</td>
5260 </tr>
5261
5262 <tr class="IndexCell">
5263 <td>NOT NULL</td><td>type_id</td>
5264 </tr>
5265
5266 <tr class="IndexCell">
5267 <td>FOREIGN KEY</td><td>type_id</td>
5268 </tr>
5269
5270 <tr class="IndexCell">
5271 <td>NOT NULL</td><td>rank</td>
5272 </tr>
5273
5274 <tr class="IndexCell">
5275 <td>UNIQUE</td><td>studydesign_id, type_id, rank</td>
5276 </tr>
5277
5278 </table>
5279
5280 <hr />
5281
5282 <!--
5283 Starting table 'studyfactor'
5284 -->
5285
5286 <a name="studyfactor" />
5287
5288 <table width="100%" class="TableHeader">
5289 <tr class="TableHeaderRow">
5290 <td class="TableHeaderCell"><h3>
5291 studyfactor
5292 </h3></td> <a name="studyfactor"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
5293 </tr>
5294 </table>
5295
5296 <b>
5297 Comments:
5298 </b>
5299
5300 <br />
5301
5302 <em>
5303 <br />
5304 ================================================ <br />
5305 TABLE: studyfactor <br />
5306 ================================================ <br />
5307 NULL
5308 </em>
5309
5310 <table border="1">
5311
5312 <tr>
5313 <th class="FieldHeader">
5314 Field Name
5315 </th>
5316 <th class="FieldHeader">
5317 Data Type
5318 </th>
5319 <th class="FieldHeader">
5320 Size
5321 </th>
5322 <th class="FieldHeader">
5323 Default Value
5324 </th>
5325 <th class="FieldHeader">
5326 Other
5327 </th>
5328 <th class="FieldHeader">
5329 Foreign Key
5330 </th>
5331 </tr>
5332
5333 <tr class="tr-odd">
5334 <td class="FieldCellName"><a name="studyfactor-studyfactor_id">studyfactor_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
5335 </tr>
5336
5337 <tr class="tr-even">
5338 <td class="FieldCellName"><a name="studyfactor-studydesign_id">studydesign_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#studydesign-studydesign_id">studydesign.studydesign_id</a></td>
5339 </tr>
5340
5341 <tr class="tr-odd">
5342 <td class="FieldCellName"><a name="studyfactor-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
5343 </tr>
5344
5345 <tr class="tr-even">
5346 <td class="FieldCellName"><a name="studyfactor-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
5347 </tr>
5348
5349 <tr class="tr-odd">
5350 <td class="FieldCellName"><a name="studyfactor-description">description</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
5351 </tr>
5352
5353 </table>
5354
5355 <h3>
5356 Indices
5357 </h3>
5358
5359 <table border="1">
5360
5361 <tr class="IndexRow">
5362 <th>
5363 Name
5364 </th>
5365 <th>
5366 Fields
5367 </th>
5368 </tr>
5369
5370 <tr class="IndexCell">
5371 <td>studyfactor_idx1</td><td>studydesign_id</td>
5372 </tr>
5373
5374 <tr class="IndexCell">
5375 <td>studyfactor_idx2</td><td>type_id</td>
5376 </tr>
5377
5378 </table>
5379
5380 <h3>
5381 Constraints
5382 </h3>
5383
5384 <table border="1">
5385
5386 <tr class="IndexRow">
5387 <th>
5388 Type
5389 </th>
5390 <th>
5391 Fields
5392 </th>
5393 </tr>
5394
5395 <tr class="IndexCell">
5396 <td>NOT NULL</td><td>studyfactor_id</td>
5397 </tr>
5398
5399 <tr class="IndexCell">
5400 <td>NOT NULL</td><td>studydesign_id</td>
5401 </tr>
5402
5403 <tr class="IndexCell">
5404 <td>FOREIGN KEY</td><td>studydesign_id</td>
5405 </tr>
5406
5407 <tr class="IndexCell">
5408 <td>FOREIGN KEY</td><td>type_id</td>
5409 </tr>
5410
5411 <tr class="IndexCell">
5412 <td>NOT NULL</td><td>name</td>
5413 </tr>
5414
5415 </table>
5416
5417 <hr />
5418
5419 <!--
5420 Starting table 'studyfactorvalue'
5421 -->
5422
5423 <a name="studyfactorvalue" />
5424
5425 <table width="100%" class="TableHeader">
5426 <tr class="TableHeaderRow">
5427 <td class="TableHeaderCell"><h3>
5428 studyfactorvalue
5429 </h3></td> <a name="studyfactorvalue"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
5430 </tr>
5431 </table>
5432
5433 <b>
5434 Comments:
5435 </b>
5436
5437 <br />
5438
5439 <em>
5440 <br />
5441 ================================================ <br />
5442 TABLE: studyfactorvalue <br />
5443 ================================================ <br />
5444 NULL
5445 </em>
5446
5447 <table border="1">
5448
5449 <tr>
5450 <th class="FieldHeader">
5451 Field Name
5452 </th>
5453 <th class="FieldHeader">
5454 Data Type
5455 </th>
5456 <th class="FieldHeader">
5457 Size
5458 </th>
5459 <th class="FieldHeader">
5460 Default Value
5461 </th>
5462 <th class="FieldHeader">
5463 Other
5464 </th>
5465 <th class="FieldHeader">
5466 Foreign Key
5467 </th>
5468 </tr>
5469
5470 <tr class="tr-odd">
5471 <td class="FieldCellName"><a name="studyfactorvalue-studyfactorvalue_id">studyfactorvalue_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
5472 </tr>
5473
5474 <tr class="tr-even">
5475 <td class="FieldCellName"><a name="studyfactorvalue-studyfactor_id">studyfactor_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#studyfactor-studyfactor_id">studyfactor.studyfactor_id</a></td>
5476 </tr>
5477
5478 <tr class="tr-odd">
5479 <td class="FieldCellName"><a name="studyfactorvalue-assay_id">assay_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#assay-assay_id">assay.assay_id</a></td>
5480 </tr>
5481
5482 <tr class="tr-even">
5483 <td class="FieldCellName"><a name="studyfactorvalue-factorvalue">factorvalue</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
5484 </tr>
5485
5486 <tr class="tr-odd">
5487 <td class="FieldCellName"><a name="studyfactorvalue-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
5488 </tr>
5489
5490 <tr class="tr-even">
5491 <td class="FieldCellName"><a name="studyfactorvalue-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
5492 </tr>
5493
5494 </table>
5495
5496 <h3>
5497 Indices
5498 </h3>
5499
5500 <table border="1">
5501
5502 <tr class="IndexRow">
5503 <th>
5504 Name
5505 </th>
5506 <th>
5507 Fields
5508 </th>
5509 </tr>
5510
5511 <tr class="IndexCell">
5512 <td>studyfactorvalue_idx1</td><td>studyfactor_id</td>
5513 </tr>
5514
5515 <tr class="IndexCell">
5516 <td>studyfactorvalue_idx2</td><td>assay_id</td>
5517 </tr>
5518
5519 </table>
5520
5521 <h3>
5522 Constraints
5523 </h3>
5524
5525 <table border="1">
5526
5527 <tr class="IndexRow">
5528 <th>
5529 Type
5530 </th>
5531 <th>
5532 Fields
5533 </th>
5534 </tr>
5535
5536 <tr class="IndexCell">
5537 <td>NOT NULL</td><td>studyfactorvalue_id</td>
5538 </tr>
5539
5540 <tr class="IndexCell">
5541 <td>NOT NULL</td><td>studyfactor_id</td>
5542 </tr>
5543
5544 <tr class="IndexCell">
5545 <td>FOREIGN KEY</td><td>studyfactor_id</td>
5546 </tr>
5547
5548 <tr class="IndexCell">
5549 <td>NOT NULL</td><td>assay_id</td>
5550 </tr>
5551
5552 <tr class="IndexCell">
5553 <td>FOREIGN KEY</td><td>assay_id</td>
5554 </tr>
5555
5556 <tr class="IndexCell">
5557 <td>NOT NULL</td><td>rank</td>
5558 </tr>
5559
5560 </table>
5561
5562 <hr />
5563
5564 <!--
5565 Starting table 'studyprop'
5566 -->
5567
5568 <a name="studyprop" />
5569
5570 <table width="100%" class="TableHeader">
5571 <tr class="TableHeaderRow">
5572 <td class="TableHeaderCell"><h3>
5573 studyprop
5574 </h3></td> <a name="studyprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
5575 </tr>
5576 </table>
5577
5578 <b>
5579 Comments:
5580 </b>
5581
5582 <br />
5583
5584 <em>
5585 <br />
5586 studyprop and studyprop_feature added for Kara Dolinski's group <br />
5587 Here is her description of it: <br />
5588 Both of the tables are used for our YFGdb project <br />
5589 (http://yfgdb.princeton.edu/), which uses chado. <br />
5590 Here is how we use those tables, using the following example: <br />
5591 http://yfgdb.princeton.edu/cgi-bin/display.cgi?db=pmid&amp;id=15575969 <br />
5592 The above data set is represented as a row in the STUDY table. We have <br />
5593 lots of attributes that we want to store about each STUDY (status, etc) <br />
5594 and in the official schema, the only prop table we could use was the <br />
5595 STUDYDESIGN_PROP table. This forced us to go through the STUDYDESIGN <br />
5596 table when we often have no real data to store in that table (small <br />
5597 percent of our collection use MAGE-ML unfortunately, and even fewer <br />
5598 provide all the data in the MAGE model, of which STUDYDESIGN is a vestige). <br />
5599 So, we created a STUDYPROP table. I'd think this table would be <br />
5600 generally useful to people storing various types of data sets via the <br />
5601 STUDY table. <br />
5602 The other new table is STUDYPROP_FEATURE. This basically allows us to <br />
5603 group features together per study. For example, we can store microarray <br />
5604 clustering results by saying that the STUDYPROP type is 'cluster' (via <br />
5605 type_id -> CVTERM of course), the value is 'cluster id 123', and then <br />
5606 that cluster would be associated with all the features that are in that <br />
5607 cluster via STUDYPROP_FEATURE. Adding type_id to STUDYPROP_FEATURE is <br />
5608 fine by us! <br />
5609 studyprop
5610 </em>
5611
5612 <table border="1">
5613
5614 <tr>
5615 <th class="FieldHeader">
5616 Field Name
5617 </th>
5618 <th class="FieldHeader">
5619 Data Type
5620 </th>
5621 <th class="FieldHeader">
5622 Size
5623 </th>
5624 <th class="FieldHeader">
5625 Default Value
5626 </th>
5627 <th class="FieldHeader">
5628 Other
5629 </th>
5630 <th class="FieldHeader">
5631 Foreign Key
5632 </th>
5633 </tr>
5634
5635 <tr class="tr-odd">
5636 <td class="FieldCellName"><a name="studyprop-studyprop_id">studyprop_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
5637 </tr>
5638
5639 <tr class="tr-even">
5640 <td class="FieldCellName"><a name="studyprop-study_id">study_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#study-study_id">study.study_id</a></td>
5641 </tr>
5642
5643 <tr class="tr-odd">
5644 <td class="FieldCellName"><a name="studyprop-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
5645 </tr>
5646
5647 <tr class="tr-even">
5648 <td class="FieldCellName"><a name="studyprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
5649 </tr>
5650
5651 <tr class="tr-odd">
5652 <td class="FieldCellName"><a name="studyprop-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
5653 </tr>
5654
5655 </table>
5656
5657 <h3>
5658 Indices
5659 </h3>
5660
5661 <table border="1">
5662
5663 <tr class="IndexRow">
5664 <th>
5665 Name
5666 </th>
5667 <th>
5668 Fields
5669 </th>
5670 </tr>
5671
5672 <tr class="IndexCell">
5673 <td>studyprop_idx1</td><td>study_id</td>
5674 </tr>
5675
5676 <tr class="IndexCell">
5677 <td>studyprop_idx2</td><td>type_id</td>
5678 </tr>
5679
5680 </table>
5681
5682 <h3>
5683 Constraints
5684 </h3>
5685
5686 <table border="1">
5687
5688 <tr class="IndexRow">
5689 <th>
5690 Type
5691 </th>
5692 <th>
5693 Fields
5694 </th>
5695 </tr>
5696
5697 <tr class="IndexCell">
5698 <td>NOT NULL</td><td>studyprop_id</td>
5699 </tr>
5700
5701 <tr class="IndexCell">
5702 <td>NOT NULL</td><td>study_id</td>
5703 </tr>
5704
5705 <tr class="IndexCell">
5706 <td>FOREIGN KEY</td><td>study_id</td>
5707 </tr>
5708
5709 <tr class="IndexCell">
5710 <td>NOT NULL</td><td>type_id</td>
5711 </tr>
5712
5713 <tr class="IndexCell">
5714 <td>FOREIGN KEY</td><td>type_id</td>
5715 </tr>
5716
5717 <tr class="IndexCell">
5718 <td>NOT NULL</td><td>rank</td>
5719 </tr>
5720
5721 <tr class="IndexCell">
5722 <td>UNIQUE</td><td>study_id, type_id, rank</td>
5723 </tr>
5724
5725 </table>
5726
5727 <hr />
5728
5729 <!--
5730 Starting table 'studyprop_feature'
5731 -->
5732
5733 <a name="studyprop_feature" />
5734
5735 <table class="TableHeader" width="100%">
5736 <tr class="TableHeaderRow">
5737 <td class="TableHeaderCell"><h3>
5738 studyprop_feature
5739 </h3></td> <a name="studyprop_feature"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
5740 </tr>
5741 </table>
5742
5743 <b>
5744 Comments:
5745 </b>
5746
5747 <br />
5748
5749 <em>
5750 <br />
5751 studyprop_feature
5752 </em>
5753
5754 <table border="1">
5755
5756 <tr>
5757 <th class="FieldHeader">
5758 Field Name
5759 </th>
5760 <th class="FieldHeader">
5761 Data Type
5762 </th>
5763 <th class="FieldHeader">
5764 Size
5765 </th>
5766 <th class="FieldHeader">
5767 Default Value
5768 </th>
5769 <th class="FieldHeader">
5770 Other
5771 </th>
5772 <th class="FieldHeader">
5773 Foreign Key
5774 </th>
5775 </tr>
5776
5777 <tr class="tr-odd">
5778 <td class="FieldCellName"><a name="studyprop_feature-studyprop_feature_id">studyprop_feature_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
5779 </tr>
5780
5781 <tr class="tr-even">
5782 <td class="FieldCellName"><a name="studyprop_feature-studyprop_id">studyprop_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#studyprop-studyprop_id">studyprop.studyprop_id</a></td>
5783 </tr>
5784
5785 <tr class="tr-odd">
5786 <td class="FieldCellName"><a name="studyprop_feature-feature_id">feature_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#feature-feature_id">feature.feature_id</a></td>
5787 </tr>
5788
5789 <tr class="tr-even">
5790 <td class="FieldCellName"><a name="studyprop_feature-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
5791 </tr>
5792
5793 </table>
5794
5795 <h3>
5796 Indices
5797 </h3>
5798
5799 <table border="1">
5800
5801 <tr class="IndexRow">
5802 <th>
5803 Name
5804 </th>
5805 <th>
5806 Fields
5807 </th>
5808 </tr>
5809
5810 <tr class="IndexCell">
5811 <td>studyprop_feature_idx1</td><td>studyprop_id</td>
5812 </tr>
5813
5814 <tr class="IndexCell">
5815 <td>studyprop_feature_idx2</td><td>feature_id</td>
5816 </tr>
5817
5818 </table>
5819
5820 <h3>
5821 Constraints
5822 </h3>
5823
5824 <table border="1">
5825
5826 <tr class="IndexRow">
5827 <th>
5828 Type
5829 </th>
5830 <th>
5831 Fields
5832 </th>
5833 </tr>
5834
5835 <tr class="IndexCell">
5836 <td>NOT NULL</td><td>studyprop_feature_id</td>
5837 </tr>
5838
5839 <tr class="IndexCell">
5840 <td>NOT NULL</td><td>studyprop_id</td>
5841 </tr>
5842
5843 <tr class="IndexCell">
5844 <td>FOREIGN KEY</td><td>studyprop_id</td>
5845 </tr>
5846
5847 <tr class="IndexCell">
5848 <td>NOT NULL</td><td>feature_id</td>
5849 </tr>
5850
5851 <tr class="IndexCell">
5852 <td>FOREIGN KEY</td><td>feature_id</td>
5853 </tr>
5854
5855 <tr class="IndexCell">
5856 <td>FOREIGN KEY</td><td>type_id</td>
5857 </tr>
5858
5859 <tr class="IndexCell">
5860 <td>UNIQUE</td><td>studyprop_id, feature_id</td>
5861 </tr>
5862
5863 </table>
5864
5865 <hr />
5866
5867 Created by <a href="http://sqlfairy.sourceforge.net">
5868 SQL::Translator 0.11020</a>
5869
5870 </body>
5871 </html>