Debian Codegraph @

modules/genetic/genetic.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 (9 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 'genotype'
35 -->
36
37 <tr class="LinkTableRow">
38 <td class="LinkTableCell"><a id="genotype-link" href="#genotype">genotype</a></td>
39 </tr>
40
41 <!--
42 End link to table 'genotype'
43 -->
44
45 <!--
46 Start link to table 'feature_genotype'
47 -->
48
49 <tr class="LinkTableRow">
50 <td class="LinkTableCell"><a id="feature_genotype-link" href="#feature_genotype">feature_genotype</a></td>
51 </tr>
52
53 <!--
54 End link to table 'feature_genotype'
55 -->
56
57 <!--
58 Start link to table 'environment'
59 -->
60
61 <tr class="LinkTableRow">
62 <td class="LinkTableCell"><a id="environment-link" href="#environment">environment</a></td>
63 </tr>
64
65 <!--
66 End link to table 'environment'
67 -->
68
69 <!--
70 Start link to table 'environment_cvterm'
71 -->
72
73 <tr class="LinkTableRow">
74 <td class="LinkTableCell"><a id="environment_cvterm-link" href="#environment_cvterm">environment_cvterm</a></td>
75 </tr>
76
77 <!--
78 End link to table 'environment_cvterm'
79 -->
80
81 <!--
82 Start link to table 'phenstatement'
83 -->
84
85 <tr class="LinkTableRow">
86 <td class="LinkTableCell"><a id="phenstatement-link" href="#phenstatement">phenstatement</a></td>
87 </tr>
88
89 <!--
90 End link to table 'phenstatement'
91 -->
92
93 <!--
94 Start link to table 'phendesc'
95 -->
96
97 <tr class="LinkTableRow">
98 <td class="LinkTableCell"><a id="phendesc-link" href="#phendesc">phendesc</a></td>
99 </tr>
100
101 <!--
102 End link to table 'phendesc'
103 -->
104
105 <!--
106 Start link to table 'phenotype_comparison'
107 -->
108
109 <tr class="LinkTableRow">
110 <td class="LinkTableCell"><a id="phenotype_comparison-link" href="#phenotype_comparison">phenotype_comparison</a></td>
111 </tr>
112
113 <!--
114 End link to table 'phenotype_comparison'
115 -->
116
117 <!--
118 Start link to table 'phenotype_comparison_cvterm'
119 -->
120
121 <tr class="LinkTableRow">
122 <td class="LinkTableCell"><a id="phenotype_comparison_cvterm-link" href="#phenotype_comparison_cvterm">phenotype_comparison_cvterm</a></td>
123 </tr>
124
125 <!--
126 End link to table 'phenotype_comparison_cvterm'
127 -->
128
129 <!--
130 Start link to table 'genotypeprop'
131 -->
132
133 <tr class="LinkTableRow">
134 <td class="LinkTableCell"><a id="genotypeprop-link" href="#genotypeprop">genotypeprop</a></td>
135 </tr>
136
137 <!--
138 End link to table 'genotypeprop'
139 -->
140
141 </table>
142
143 <!--
144 Starting table 'genotype'
145 -->
146
147 <a name="genotype" />
148
149 <table class="TableHeader" width="100%">
150 <tr class="TableHeaderRow">
151 <td class="TableHeaderCell"><h3>
152 genotype
153 </h3></td> <a name="genotype"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
154 </tr>
155 </table>
156
157 <b>
158 Comments:
159 </b>
160
161 <br />
162
163 <em>
164 <br />
165 $Id: genetic.sql,v 1.31 2008-08-25 19:53:14 scottcain Exp $ <br />
166 ========================================== <br />
167 Chado genetics module <br />
168 changes 2011-05-31 <br />
169 added type_id to genotype (can be null for backward compatibility) <br />
170 added genotypeprop table <br />
171 2006-04-11 <br />
172 split out phenotype tables into phenotype module <br />
173 redesigned 2003-10-28 <br />
174 changes 2003-11-10: <br />
175 incorporating suggestions to make everything a gcontext; use <br />
176 gcontext_relationship to make some gcontexts derivable from others. we <br />
177 would incorporate environment this way - just add the environment <br />
178 descriptors as properties of the child gcontext <br />
179 changes 2004-06 (Documented by DE: 10-MAR-2005): <br />
180 Many, including rename of gcontext to genotype, split <br />
181 phenstatement into phenstatement & phenotype, created environment <br />
182 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ <br />
183 ============ <br />
184 DEPENDENCIES <br />
185 ============ <br />
186 :import feature from sequence <br />
187 :import phenotype from phenotype <br />
188 :import cvterm from cv <br />
189 :import pub from pub <br />
190 :import dbxref from db <br />
191 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ <br />
192 ================================================ <br />
193 TABLE: genotype <br />
194 ================================================ <br />
195 Genetic context. A genotype is defined by a collection of features, mutations, balancers, deficiencies, haplotype blocks, or engineered constructs.
196 </em>
197
198 <table border="1">
199
200 <tr>
201 <th class="FieldHeader">
202 Field Name
203 </th>
204 <th class="FieldHeader">
205 Data Type
206 </th>
207 <th class="FieldHeader">
208 Size
209 </th>
210 <th class="FieldHeader">
211 Default Value
212 </th>
213 <th class="FieldHeader">
214 Other
215 </th>
216 <th class="FieldHeader">
217 Foreign Key
218 </th>
219 </tr>
220
221 <tr class="tr-odd">
222 <td class="FieldCellName"><a name="genotype-genotype_id">genotype_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>
223 </tr>
224
225 <tr class="tr-even">
226 <td class="FieldCellName"><a name="genotype-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">Optional alternative name for a genotype,
227 for display purposes. </td> <td class="FieldCellFK"></td>
228 </tr>
229
230 <tr class="tr-odd">
231 <td class="FieldCellName"><a name="genotype-uniquename">uniquename</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, The unique name for a genotype;
232 typically derived from the features making up the genotype. </td> <td class="FieldCellFK"></td>
233 </tr>
234
235 <tr class="tr-even">
236 <td class="FieldCellName"><a name="genotype-description">description</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
237 </tr>
238
239 <tr class="tr-odd">
240 <td class="FieldCellName"><a name="genotype-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>
241 </tr>
242
243 </table>
244
245 <h3>
246 Indices
247 </h3>
248
249 <table border="1">
250
251 <tr class="IndexRow">
252 <th>
253 Name
254 </th>
255 <th>
256 Fields
257 </th>
258 </tr>
259
260 <tr class="IndexCell">
261 <td>genotype_idx1</td><td>uniquename</td>
262 </tr>
263
264 <tr class="IndexCell">
265 <td>genotype_idx2</td><td>name</td>
266 </tr>
267
268 </table>
269
270 <h3>
271 Constraints
272 </h3>
273
274 <table border="1">
275
276 <tr class="IndexRow">
277 <th>
278 Type
279 </th>
280 <th>
281 Fields
282 </th>
283 </tr>
284
285 <tr class="IndexCell">
286 <td>NOT NULL</td><td>genotype_id</td>
287 </tr>
288
289 <tr class="IndexCell">
290 <td>NOT NULL</td><td>uniquename</td>
291 </tr>
292
293 <tr class="IndexCell">
294 <td>NOT NULL</td><td>type_id</td>
295 </tr>
296
297 <tr class="IndexCell">
298 <td>FOREIGN KEY</td><td>type_id</td>
299 </tr>
300
301 <tr class="IndexCell">
302 <td>UNIQUE</td><td>uniquename</td>
303 </tr>
304
305 </table>
306
307 <hr />
308
309 <!--
310 Starting table 'feature_genotype'
311 -->
312
313 <a name="feature_genotype" />
314
315 <table class="TableHeader" width="100%">
316 <tr class="TableHeaderRow">
317 <td class="TableHeaderCell"><h3>
318 feature_genotype
319 </h3></td> <a name="feature_genotype"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
320 </tr>
321 </table>
322
323 <b>
324 Comments:
325 </b>
326
327 <br />
328
329 <em>
330 <br />
331 =============================================== <br />
332 TABLE: feature_genotype <br />
333 ================================================ <br />
334 NULL
335 </em>
336
337 <table border="1">
338
339 <tr>
340 <th class="FieldHeader">
341 Field Name
342 </th>
343 <th class="FieldHeader">
344 Data Type
345 </th>
346 <th class="FieldHeader">
347 Size
348 </th>
349 <th class="FieldHeader">
350 Default Value
351 </th>
352 <th class="FieldHeader">
353 Other
354 </th>
355 <th class="FieldHeader">
356 Foreign Key
357 </th>
358 </tr>
359
360 <tr class="tr-odd">
361 <td class="FieldCellName"><a name="feature_genotype-feature_genotype_id">feature_genotype_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>
362 </tr>
363
364 <tr class="tr-even">
365 <td class="FieldCellName"><a name="feature_genotype-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>
366 </tr>
367
368 <tr class="tr-odd">
369 <td class="FieldCellName"><a name="feature_genotype-genotype_id">genotype_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="#genotype-genotype_id">genotype.genotype_id</a></td>
370 </tr>
371
372 <tr class="tr-even">
373 <td class="FieldCellName"><a name="feature_genotype-chromosome_id">chromosome_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, A feature of SO type "chromosome". </td> <td class="FieldCellFK"><a href="#feature-feature_id">feature.feature_id</a></td>
374 </tr>
375
376 <tr class="tr-odd">
377 <td class="FieldCellName"><a name="feature_genotype-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, rank can be used for
378 n-ploid organisms or to preserve order. </td> <td class="FieldCellFK"></td>
379 </tr>
380
381 <tr class="tr-even">
382 <td class="FieldCellName"><a name="feature_genotype-cgroup">cgroup</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, Spatially distinguishable
383 group. group can be used for distinguishing the chromosomal groups,
384 for example (RNAi products and so on can be treated as different
385 groups, as they do not fall on a particular chromosome). </td> <td class="FieldCellFK"></td>
386 </tr>
387
388 <tr class="tr-odd">
389 <td class="FieldCellName"><a name="feature_genotype-cvterm_id">cvterm_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>
390 </tr>
391
392 </table>
393
394 <h3>
395 Indices
396 </h3>
397
398 <table border="1">
399
400 <tr class="IndexRow">
401 <th>
402 Name
403 </th>
404 <th>
405 Fields
406 </th>
407 </tr>
408
409 <tr class="IndexCell">
410 <td>feature_genotype_idx1</td><td>feature_id</td>
411 </tr>
412
413 <tr class="IndexCell">
414 <td>feature_genotype_idx2</td><td>genotype_id</td>
415 </tr>
416
417 </table>
418
419 <h3>
420 Constraints
421 </h3>
422
423 <table border="1">
424
425 <tr class="IndexRow">
426 <th>
427 Type
428 </th>
429 <th>
430 Fields
431 </th>
432 </tr>
433
434 <tr class="IndexCell">
435 <td>NOT NULL</td><td>feature_genotype_id</td>
436 </tr>
437
438 <tr class="IndexCell">
439 <td>NOT NULL</td><td>feature_id</td>
440 </tr>
441
442 <tr class="IndexCell">
443 <td>FOREIGN KEY</td><td>feature_id</td>
444 </tr>
445
446 <tr class="IndexCell">
447 <td>NOT NULL</td><td>genotype_id</td>
448 </tr>
449
450 <tr class="IndexCell">
451 <td>FOREIGN KEY</td><td>genotype_id</td>
452 </tr>
453
454 <tr class="IndexCell">
455 <td>FOREIGN KEY</td><td>chromosome_id</td>
456 </tr>
457
458 <tr class="IndexCell">
459 <td>NOT NULL</td><td>rank</td>
460 </tr>
461
462 <tr class="IndexCell">
463 <td>NOT NULL</td><td>cgroup</td>
464 </tr>
465
466 <tr class="IndexCell">
467 <td>NOT NULL</td><td>cvterm_id</td>
468 </tr>
469
470 <tr class="IndexCell">
471 <td>FOREIGN KEY</td><td>cvterm_id</td>
472 </tr>
473
474 <tr class="IndexCell">
475 <td>UNIQUE</td><td>feature_id, genotype_id, cvterm_id, chromosome_id, rank, cgroup</td>
476 </tr>
477
478 </table>
479
480 <hr />
481
482 <!--
483 Starting table 'environment'
484 -->
485
486 <a name="environment" />
487
488 <table class="TableHeader" width="100%">
489 <tr class="TableHeaderRow">
490 <td class="TableHeaderCell"><h3>
491 environment
492 </h3></td> <a name="environment"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
493 </tr>
494 </table>
495
496 <b>
497 Comments:
498 </b>
499
500 <br />
501
502 <em>
503 <br />
504 ================================================ <br />
505 TABLE: environment <br />
506 ================================================ <br />
507 The environmental component of a phenotype description.
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="environment-environment_id">environment_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="environment-uniquename">uniquename</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>
539 </tr>
540
541 <tr class="tr-odd">
542 <td class="FieldCellName"><a name="environment-description">description</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
543 </tr>
544
545 </table>
546
547 <h3>
548 Indices
549 </h3>
550
551 <table border="1">
552
553 <tr class="IndexRow">
554 <th>
555 Name
556 </th>
557 <th>
558 Fields
559 </th>
560 </tr>
561
562 <tr class="IndexCell">
563 <td>environment_idx1</td><td>uniquename</td>
564 </tr>
565
566 </table>
567
568 <h3>
569 Constraints
570 </h3>
571
572 <table border="1">
573
574 <tr class="IndexRow">
575 <th>
576 Type
577 </th>
578 <th>
579 Fields
580 </th>
581 </tr>
582
583 <tr class="IndexCell">
584 <td>NOT NULL</td><td>environment_id</td>
585 </tr>
586
587 <tr class="IndexCell">
588 <td>NOT NULL</td><td>uniquename</td>
589 </tr>
590
591 <tr class="IndexCell">
592 <td>UNIQUE</td><td>uniquename</td>
593 </tr>
594
595 </table>
596
597 <hr />
598
599 <!--
600 Starting table 'environment_cvterm'
601 -->
602
603 <a name="environment_cvterm" />
604
605 <table class="TableHeader" width="100%">
606 <tr class="TableHeaderRow">
607 <td class="TableHeaderCell"><h3>
608 environment_cvterm
609 </h3></td> <a name="environment_cvterm"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
610 </tr>
611 </table>
612
613 <b>
614 Comments:
615 </b>
616
617 <br />
618
619 <em>
620 <br />
621 ================================================ <br />
622 TABLE: environment_cvterm <br />
623 ================================================ <br />
624 NULL
625 </em>
626
627 <table border="1">
628
629 <tr>
630 <th class="FieldHeader">
631 Field Name
632 </th>
633 <th class="FieldHeader">
634 Data Type
635 </th>
636 <th class="FieldHeader">
637 Size
638 </th>
639 <th class="FieldHeader">
640 Default Value
641 </th>
642 <th class="FieldHeader">
643 Other
644 </th>
645 <th class="FieldHeader">
646 Foreign Key
647 </th>
648 </tr>
649
650 <tr class="tr-odd">
651 <td class="FieldCellName"><a name="environment_cvterm-environment_cvterm_id">environment_cvterm_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>
652 </tr>
653
654 <tr class="tr-even">
655 <td class="FieldCellName"><a name="environment_cvterm-environment_id">environment_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="#environment-environment_id">environment.environment_id</a></td>
656 </tr>
657
658 <tr class="tr-odd">
659 <td class="FieldCellName"><a name="environment_cvterm-cvterm_id">cvterm_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>
660 </tr>
661
662 </table>
663
664 <h3>
665 Indices
666 </h3>
667
668 <table border="1">
669
670 <tr class="IndexRow">
671 <th>
672 Name
673 </th>
674 <th>
675 Fields
676 </th>
677 </tr>
678
679 <tr class="IndexCell">
680 <td>environment_cvterm_idx1</td><td>environment_id</td>
681 </tr>
682
683 <tr class="IndexCell">
684 <td>environment_cvterm_idx2</td><td>cvterm_id</td>
685 </tr>
686
687 </table>
688
689 <h3>
690 Constraints
691 </h3>
692
693 <table border="1">
694
695 <tr class="IndexRow">
696 <th>
697 Type
698 </th>
699 <th>
700 Fields
701 </th>
702 </tr>
703
704 <tr class="IndexCell">
705 <td>NOT NULL</td><td>environment_cvterm_id</td>
706 </tr>
707
708 <tr class="IndexCell">
709 <td>NOT NULL</td><td>environment_id</td>
710 </tr>
711
712 <tr class="IndexCell">
713 <td>FOREIGN KEY</td><td>environment_id</td>
714 </tr>
715
716 <tr class="IndexCell">
717 <td>NOT NULL</td><td>cvterm_id</td>
718 </tr>
719
720 <tr class="IndexCell">
721 <td>FOREIGN KEY</td><td>cvterm_id</td>
722 </tr>
723
724 <tr class="IndexCell">
725 <td>UNIQUE</td><td>environment_id, cvterm_id</td>
726 </tr>
727
728 </table>
729
730 <hr />
731
732 <!--
733 Starting table 'phenstatement'
734 -->
735
736 <a name="phenstatement" />
737
738 <table width="100%" class="TableHeader">
739 <tr class="TableHeaderRow">
740 <td class="TableHeaderCell"><h3>
741 phenstatement
742 </h3></td> <a name="phenstatement"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
743 </tr>
744 </table>
745
746 <b>
747 Comments:
748 </b>
749
750 <br />
751
752 <em>
753 <br />
754 ================================================ <br />
755 TABLE: phenstatement <br />
756 ================================================ <br />
757 Phenotypes are things like "larval lethal". Phenstatements are things like "dpp-1 is recessive larval lethal". So essentially phenstatement is a linking table expressing the relationship between genotype, environment, and phenotype.
758 </em>
759
760 <table border="1">
761
762 <tr>
763 <th class="FieldHeader">
764 Field Name
765 </th>
766 <th class="FieldHeader">
767 Data Type
768 </th>
769 <th class="FieldHeader">
770 Size
771 </th>
772 <th class="FieldHeader">
773 Default Value
774 </th>
775 <th class="FieldHeader">
776 Other
777 </th>
778 <th class="FieldHeader">
779 Foreign Key
780 </th>
781 </tr>
782
783 <tr class="tr-odd">
784 <td class="FieldCellName"><a name="phenstatement-phenstatement_id">phenstatement_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>
785 </tr>
786
787 <tr class="tr-even">
788 <td class="FieldCellName"><a name="phenstatement-genotype_id">genotype_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="#genotype-genotype_id">genotype.genotype_id</a></td>
789 </tr>
790
791 <tr class="tr-odd">
792 <td class="FieldCellName"><a name="phenstatement-environment_id">environment_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="#environment-environment_id">environment.environment_id</a></td>
793 </tr>
794
795 <tr class="tr-even">
796 <td class="FieldCellName"><a name="phenstatement-phenotype_id">phenotype_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="#phenotype-phenotype_id">phenotype.phenotype_id</a></td>
797 </tr>
798
799 <tr class="tr-odd">
800 <td class="FieldCellName"><a name="phenstatement-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>
801 </tr>
802
803 <tr class="tr-even">
804 <td class="FieldCellName"><a name="phenstatement-pub_id">pub_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="#pub-pub_id">pub.pub_id</a></td>
805 </tr>
806
807 </table>
808
809 <h3>
810 Indices
811 </h3>
812
813 <table border="1">
814
815 <tr class="IndexRow">
816 <th>
817 Name
818 </th>
819 <th>
820 Fields
821 </th>
822 </tr>
823
824 <tr class="IndexCell">
825 <td>phenstatement_idx1</td><td>genotype_id</td>
826 </tr>
827
828 <tr class="IndexCell">
829 <td>phenstatement_idx2</td><td>phenotype_id</td>
830 </tr>
831
832 </table>
833
834 <h3>
835 Constraints
836 </h3>
837
838 <table border="1">
839
840 <tr class="IndexRow">
841 <th>
842 Type
843 </th>
844 <th>
845 Fields
846 </th>
847 </tr>
848
849 <tr class="IndexCell">
850 <td>NOT NULL</td><td>phenstatement_id</td>
851 </tr>
852
853 <tr class="IndexCell">
854 <td>NOT NULL</td><td>genotype_id</td>
855 </tr>
856
857 <tr class="IndexCell">
858 <td>FOREIGN KEY</td><td>genotype_id</td>
859 </tr>
860
861 <tr class="IndexCell">
862 <td>NOT NULL</td><td>environment_id</td>
863 </tr>
864
865 <tr class="IndexCell">
866 <td>FOREIGN KEY</td><td>environment_id</td>
867 </tr>
868
869 <tr class="IndexCell">
870 <td>NOT NULL</td><td>phenotype_id</td>
871 </tr>
872
873 <tr class="IndexCell">
874 <td>FOREIGN KEY</td><td>phenotype_id</td>
875 </tr>
876
877 <tr class="IndexCell">
878 <td>NOT NULL</td><td>type_id</td>
879 </tr>
880
881 <tr class="IndexCell">
882 <td>FOREIGN KEY</td><td>type_id</td>
883 </tr>
884
885 <tr class="IndexCell">
886 <td>NOT NULL</td><td>pub_id</td>
887 </tr>
888
889 <tr class="IndexCell">
890 <td>FOREIGN KEY</td><td>pub_id</td>
891 </tr>
892
893 <tr class="IndexCell">
894 <td>UNIQUE</td><td>genotype_id, phenotype_id, environment_id, type_id, pub_id</td>
895 </tr>
896
897 </table>
898
899 <hr />
900
901 <!--
902 Starting table 'phendesc'
903 -->
904
905 <a name="phendesc" />
906
907 <table width="100%" class="TableHeader">
908 <tr class="TableHeaderRow">
909 <td class="TableHeaderCell"><h3>
910 phendesc
911 </h3></td> <a name="phendesc"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
912 </tr>
913 </table>
914
915 <b>
916 Comments:
917 </b>
918
919 <br />
920
921 <em>
922 <br />
923 ================================================ <br />
924 TABLE: phendesc <br />
925 ================================================ <br />
926 A summary of a _set_ of phenotypic statements for any one gcontext made in any one publication.
927 </em>
928
929 <table border="1">
930
931 <tr>
932 <th class="FieldHeader">
933 Field Name
934 </th>
935 <th class="FieldHeader">
936 Data Type
937 </th>
938 <th class="FieldHeader">
939 Size
940 </th>
941 <th class="FieldHeader">
942 Default Value
943 </th>
944 <th class="FieldHeader">
945 Other
946 </th>
947 <th class="FieldHeader">
948 Foreign Key
949 </th>
950 </tr>
951
952 <tr class="tr-odd">
953 <td class="FieldCellName"><a name="phendesc-phendesc_id">phendesc_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>
954 </tr>
955
956 <tr class="tr-even">
957 <td class="FieldCellName"><a name="phendesc-genotype_id">genotype_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="#genotype-genotype_id">genotype.genotype_id</a></td>
958 </tr>
959
960 <tr class="tr-odd">
961 <td class="FieldCellName"><a name="phendesc-environment_id">environment_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="#environment-environment_id">environment.environment_id</a></td>
962 </tr>
963
964 <tr class="tr-even">
965 <td class="FieldCellName"><a name="phendesc-description">description</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>
966 </tr>
967
968 <tr class="tr-odd">
969 <td class="FieldCellName"><a name="phendesc-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>
970 </tr>
971
972 <tr class="tr-even">
973 <td class="FieldCellName"><a name="phendesc-pub_id">pub_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="#pub-pub_id">pub.pub_id</a></td>
974 </tr>
975
976 </table>
977
978 <h3>
979 Indices
980 </h3>
981
982 <table border="1">
983
984 <tr class="IndexRow">
985 <th>
986 Name
987 </th>
988 <th>
989 Fields
990 </th>
991 </tr>
992
993 <tr class="IndexCell">
994 <td>phendesc_idx1</td><td>genotype_id</td>
995 </tr>
996
997 <tr class="IndexCell">
998 <td>phendesc_idx2</td><td>environment_id</td>
999 </tr>
1000
1001 <tr class="IndexCell">
1002 <td>phendesc_idx3</td><td>pub_id</td>
1003 </tr>
1004
1005 </table>
1006
1007 <h3>
1008 Constraints
1009 </h3>
1010
1011 <table border="1">
1012
1013 <tr class="IndexRow">
1014 <th>
1015 Type
1016 </th>
1017 <th>
1018 Fields
1019 </th>
1020 </tr>
1021
1022 <tr class="IndexCell">
1023 <td>NOT NULL</td><td>phendesc_id</td>
1024 </tr>
1025
1026 <tr class="IndexCell">
1027 <td>NOT NULL</td><td>genotype_id</td>
1028 </tr>
1029
1030 <tr class="IndexCell">
1031 <td>FOREIGN KEY</td><td>genotype_id</td>
1032 </tr>
1033
1034 <tr class="IndexCell">
1035 <td>NOT NULL</td><td>environment_id</td>
1036 </tr>
1037
1038 <tr class="IndexCell">
1039 <td>FOREIGN KEY</td><td>environment_id</td>
1040 </tr>
1041
1042 <tr class="IndexCell">
1043 <td>NOT NULL</td><td>description</td>
1044 </tr>
1045
1046 <tr class="IndexCell">
1047 <td>NOT NULL</td><td>type_id</td>
1048 </tr>
1049
1050 <tr class="IndexCell">
1051 <td>FOREIGN KEY</td><td>type_id</td>
1052 </tr>
1053
1054 <tr class="IndexCell">
1055 <td>NOT NULL</td><td>pub_id</td>
1056 </tr>
1057
1058 <tr class="IndexCell">
1059 <td>FOREIGN KEY</td><td>pub_id</td>
1060 </tr>
1061
1062 <tr class="IndexCell">
1063 <td>UNIQUE</td><td>genotype_id, environment_id, type_id, pub_id</td>
1064 </tr>
1065
1066 </table>
1067
1068 <hr />
1069
1070 <!--
1071 Starting table 'phenotype_comparison'
1072 -->
1073
1074 <a name="phenotype_comparison" />
1075
1076 <table class="TableHeader" width="100%">
1077 <tr class="TableHeaderRow">
1078 <td class="TableHeaderCell"><h3>
1079 phenotype_comparison
1080 </h3></td> <a name="phenotype_comparison"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1081 </tr>
1082 </table>
1083
1084 <b>
1085 Comments:
1086 </b>
1087
1088 <br />
1089
1090 <em>
1091 <br />
1092 ================================================ <br />
1093 TABLE: phenotype_comparison <br />
1094 ================================================ <br />
1095 Comparison of phenotypes e.g., genotype1/environment1/phenotype1 "non-suppressible" with respect to genotype2/environment2/phenotype2.
1096 </em>
1097
1098 <table border="1">
1099
1100 <tr>
1101 <th class="FieldHeader">
1102 Field Name
1103 </th>
1104 <th class="FieldHeader">
1105 Data Type
1106 </th>
1107 <th class="FieldHeader">
1108 Size
1109 </th>
1110 <th class="FieldHeader">
1111 Default Value
1112 </th>
1113 <th class="FieldHeader">
1114 Other
1115 </th>
1116 <th class="FieldHeader">
1117 Foreign Key
1118 </th>
1119 </tr>
1120
1121 <tr class="tr-odd">
1122 <td class="FieldCellName"><a name="phenotype_comparison-phenotype_comparison_id">phenotype_comparison_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>
1123 </tr>
1124
1125 <tr class="tr-even">
1126 <td class="FieldCellName"><a name="phenotype_comparison-genotype1_id">genotype1_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="#genotype-genotype_id">genotype.genotype_id</a></td>
1127 </tr>
1128
1129 <tr class="tr-odd">
1130 <td class="FieldCellName"><a name="phenotype_comparison-environment1_id">environment1_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="#environment-environment_id">environment.environment_id</a></td>
1131 </tr>
1132
1133 <tr class="tr-even">
1134 <td class="FieldCellName"><a name="phenotype_comparison-genotype2_id">genotype2_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="#genotype-genotype_id">genotype.genotype_id</a></td>
1135 </tr>
1136
1137 <tr class="tr-odd">
1138 <td class="FieldCellName"><a name="phenotype_comparison-environment2_id">environment2_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="#environment-environment_id">environment.environment_id</a></td>
1139 </tr>
1140
1141 <tr class="tr-even">
1142 <td class="FieldCellName"><a name="phenotype_comparison-phenotype1_id">phenotype1_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="#phenotype-phenotype_id">phenotype.phenotype_id</a></td>
1143 </tr>
1144
1145 <tr class="tr-odd">
1146 <td class="FieldCellName"><a name="phenotype_comparison-phenotype2_id">phenotype2_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="#phenotype-phenotype_id">phenotype.phenotype_id</a></td>
1147 </tr>
1148
1149 <tr class="tr-even">
1150 <td class="FieldCellName"><a name="phenotype_comparison-pub_id">pub_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="#pub-pub_id">pub.pub_id</a></td>
1151 </tr>
1152
1153 <tr class="tr-odd">
1154 <td class="FieldCellName"><a name="phenotype_comparison-organism_id">organism_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="#organism-organism_id">organism.organism_id</a></td>
1155 </tr>
1156
1157 </table>
1158
1159 <h3>
1160 Indices
1161 </h3>
1162
1163 <table border="1">
1164
1165 <tr class="IndexRow">
1166 <th>
1167 Name
1168 </th>
1169 <th>
1170 Fields
1171 </th>
1172 </tr>
1173
1174 <tr class="IndexCell">
1175 <td>phenotype_comparison_idx1</td><td>genotype1_id</td>
1176 </tr>
1177
1178 <tr class="IndexCell">
1179 <td>phenotype_comparison_idx2</td><td>genotype2_id</td>
1180 </tr>
1181
1182 <tr class="IndexCell">
1183 <td>phenotype_comparison_idx4</td><td>pub_id</td>
1184 </tr>
1185
1186 </table>
1187
1188 <h3>
1189 Constraints
1190 </h3>
1191
1192 <table border="1">
1193
1194 <tr class="IndexRow">
1195 <th>
1196 Type
1197 </th>
1198 <th>
1199 Fields
1200 </th>
1201 </tr>
1202
1203 <tr class="IndexCell">
1204 <td>NOT NULL</td><td>phenotype_comparison_id</td>
1205 </tr>
1206
1207 <tr class="IndexCell">
1208 <td>NOT NULL</td><td>genotype1_id</td>
1209 </tr>
1210
1211 <tr class="IndexCell">
1212 <td>FOREIGN KEY</td><td>genotype1_id</td>
1213 </tr>
1214
1215 <tr class="IndexCell">
1216 <td>NOT NULL</td><td>environment1_id</td>
1217 </tr>
1218
1219 <tr class="IndexCell">
1220 <td>FOREIGN KEY</td><td>environment1_id</td>
1221 </tr>
1222
1223 <tr class="IndexCell">
1224 <td>NOT NULL</td><td>genotype2_id</td>
1225 </tr>
1226
1227 <tr class="IndexCell">
1228 <td>FOREIGN KEY</td><td>genotype2_id</td>
1229 </tr>
1230
1231 <tr class="IndexCell">
1232 <td>NOT NULL</td><td>environment2_id</td>
1233 </tr>
1234
1235 <tr class="IndexCell">
1236 <td>FOREIGN KEY</td><td>environment2_id</td>
1237 </tr>
1238
1239 <tr class="IndexCell">
1240 <td>NOT NULL</td><td>phenotype1_id</td>
1241 </tr>
1242
1243 <tr class="IndexCell">
1244 <td>FOREIGN KEY</td><td>phenotype1_id</td>
1245 </tr>
1246
1247 <tr class="IndexCell">
1248 <td>FOREIGN KEY</td><td>phenotype2_id</td>
1249 </tr>
1250
1251 <tr class="IndexCell">
1252 <td>NOT NULL</td><td>pub_id</td>
1253 </tr>
1254
1255 <tr class="IndexCell">
1256 <td>FOREIGN KEY</td><td>pub_id</td>
1257 </tr>
1258
1259 <tr class="IndexCell">
1260 <td>NOT NULL</td><td>organism_id</td>
1261 </tr>
1262
1263 <tr class="IndexCell">
1264 <td>FOREIGN KEY</td><td>organism_id</td>
1265 </tr>
1266
1267 <tr class="IndexCell">
1268 <td>UNIQUE</td><td>genotype1_id, environment1_id, genotype2_id, environment2_id, phenotype1_id, pub_id</td>
1269 </tr>
1270
1271 </table>
1272
1273 <hr />
1274
1275 <!--
1276 Starting table 'phenotype_comparison_cvterm'
1277 -->
1278
1279 <a name="phenotype_comparison_cvterm" />
1280
1281 <table width="100%" class="TableHeader">
1282 <tr class="TableHeaderRow">
1283 <td class="TableHeaderCell"><h3>
1284 phenotype_comparison_cvterm
1285 </h3></td> <a name="phenotype_comparison_cvterm"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1286 </tr>
1287 </table>
1288
1289 <b>
1290 Comments:
1291 </b>
1292
1293 <br />
1294
1295 <em>
1296 <br />
1297 ================================================ <br />
1298 TABLE: phenotype_comparison_cvterm <br />
1299 ================================================
1300 </em>
1301
1302 <table border="1">
1303
1304 <tr>
1305 <th class="FieldHeader">
1306 Field Name
1307 </th>
1308 <th class="FieldHeader">
1309 Data Type
1310 </th>
1311 <th class="FieldHeader">
1312 Size
1313 </th>
1314 <th class="FieldHeader">
1315 Default Value
1316 </th>
1317 <th class="FieldHeader">
1318 Other
1319 </th>
1320 <th class="FieldHeader">
1321 Foreign Key
1322 </th>
1323 </tr>
1324
1325 <tr class="tr-odd">
1326 <td class="FieldCellName"><a name="phenotype_comparison_cvterm-phenotype_comparison_cvterm_id">phenotype_comparison_cvterm_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>
1327 </tr>
1328
1329 <tr class="tr-even">
1330 <td class="FieldCellName"><a name="phenotype_comparison_cvterm-phenotype_comparison_id">phenotype_comparison_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="#phenotype_comparison-phenotype_comparison_id">phenotype_comparison.phenotype_comparison_id</a></td>
1331 </tr>
1332
1333 <tr class="tr-odd">
1334 <td class="FieldCellName"><a name="phenotype_comparison_cvterm-cvterm_id">cvterm_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>
1335 </tr>
1336
1337 <tr class="tr-even">
1338 <td class="FieldCellName"><a name="phenotype_comparison_cvterm-pub_id">pub_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="#pub-pub_id">pub.pub_id</a></td>
1339 </tr>
1340
1341 <tr class="tr-odd">
1342 <td class="FieldCellName"><a name="phenotype_comparison_cvterm-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>
1343 </tr>
1344
1345 </table>
1346
1347 <h3>
1348 Indices
1349 </h3>
1350
1351 <table border="1">
1352
1353 <tr class="IndexRow">
1354 <th>
1355 Name
1356 </th>
1357 <th>
1358 Fields
1359 </th>
1360 </tr>
1361
1362 <tr class="IndexCell">
1363 <td>phenotype_comparison_cvterm_idx1</td><td>phenotype_comparison_id</td>
1364 </tr>
1365
1366 <tr class="IndexCell">
1367 <td>phenotype_comparison_cvterm_idx2</td><td>cvterm_id</td>
1368 </tr>
1369
1370 </table>
1371
1372 <h3>
1373 Constraints
1374 </h3>
1375
1376 <table border="1">
1377
1378 <tr class="IndexRow">
1379 <th>
1380 Type
1381 </th>
1382 <th>
1383 Fields
1384 </th>
1385 </tr>
1386
1387 <tr class="IndexCell">
1388 <td>NOT NULL</td><td>phenotype_comparison_cvterm_id</td>
1389 </tr>
1390
1391 <tr class="IndexCell">
1392 <td>NOT NULL</td><td>phenotype_comparison_id</td>
1393 </tr>
1394
1395 <tr class="IndexCell">
1396 <td>FOREIGN KEY</td><td>phenotype_comparison_id</td>
1397 </tr>
1398
1399 <tr class="IndexCell">
1400 <td>NOT NULL</td><td>cvterm_id</td>
1401 </tr>
1402
1403 <tr class="IndexCell">
1404 <td>FOREIGN KEY</td><td>cvterm_id</td>
1405 </tr>
1406
1407 <tr class="IndexCell">
1408 <td>NOT NULL</td><td>pub_id</td>
1409 </tr>
1410
1411 <tr class="IndexCell">
1412 <td>FOREIGN KEY</td><td>pub_id</td>
1413 </tr>
1414
1415 <tr class="IndexCell">
1416 <td>NOT NULL</td><td>rank</td>
1417 </tr>
1418
1419 <tr class="IndexCell">
1420 <td>UNIQUE</td><td>phenotype_comparison_id, cvterm_id</td>
1421 </tr>
1422
1423 </table>
1424
1425 <hr />
1426
1427 <!--
1428 Starting table 'genotypeprop'
1429 -->
1430
1431 <a name="genotypeprop" />
1432
1433 <table width="100%" class="TableHeader">
1434 <tr class="TableHeaderRow">
1435 <td class="TableHeaderCell"><h3>
1436 genotypeprop
1437 </h3></td> <a name="genotypeprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1438 </tr>
1439 </table>
1440
1441 <b>
1442 Comments:
1443 </b>
1444
1445 <br />
1446
1447 <em>
1448 <br />
1449 ================================================ <br />
1450 TABLE: genotypeprop <br />
1451 ================================================
1452 </em>
1453
1454 <table border="1">
1455
1456 <tr>
1457 <th class="FieldHeader">
1458 Field Name
1459 </th>
1460 <th class="FieldHeader">
1461 Data Type
1462 </th>
1463 <th class="FieldHeader">
1464 Size
1465 </th>
1466 <th class="FieldHeader">
1467 Default Value
1468 </th>
1469 <th class="FieldHeader">
1470 Other
1471 </th>
1472 <th class="FieldHeader">
1473 Foreign Key
1474 </th>
1475 </tr>
1476
1477 <tr class="tr-odd">
1478 <td class="FieldCellName"><a name="genotypeprop-genotypeprop_id">genotypeprop_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>
1479 </tr>
1480
1481 <tr class="tr-even">
1482 <td class="FieldCellName"><a name="genotypeprop-genotype_id">genotype_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="#genotype-genotype_id">genotype.genotype_id</a></td>
1483 </tr>
1484
1485 <tr class="tr-odd">
1486 <td class="FieldCellName"><a name="genotypeprop-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>
1487 </tr>
1488
1489 <tr class="tr-even">
1490 <td class="FieldCellName"><a name="genotypeprop-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>
1491 </tr>
1492
1493 <tr class="tr-odd">
1494 <td class="FieldCellName"><a name="genotypeprop-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>
1495 </tr>
1496
1497 </table>
1498
1499 <h3>
1500 Indices
1501 </h3>
1502
1503 <table border="1">
1504
1505 <tr class="IndexRow">
1506 <th>
1507 Name
1508 </th>
1509 <th>
1510 Fields
1511 </th>
1512 </tr>
1513
1514 <tr class="IndexCell">
1515 <td>genotypeprop_idx1</td><td>genotype_id</td>
1516 </tr>
1517
1518 <tr class="IndexCell">
1519 <td>genotypeprop_idx2</td><td>type_id</td>
1520 </tr>
1521
1522 </table>
1523
1524 <h3>
1525 Constraints
1526 </h3>
1527
1528 <table border="1">
1529
1530 <tr class="IndexRow">
1531 <th>
1532 Type
1533 </th>
1534 <th>
1535 Fields
1536 </th>
1537 </tr>
1538
1539 <tr class="IndexCell">
1540 <td>NOT NULL</td><td>genotypeprop_id</td>
1541 </tr>
1542
1543 <tr class="IndexCell">
1544 <td>NOT NULL</td><td>genotype_id</td>
1545 </tr>
1546
1547 <tr class="IndexCell">
1548 <td>FOREIGN KEY</td><td>genotype_id</td>
1549 </tr>
1550
1551 <tr class="IndexCell">
1552 <td>NOT NULL</td><td>type_id</td>
1553 </tr>
1554
1555 <tr class="IndexCell">
1556 <td>FOREIGN KEY</td><td>type_id</td>
1557 </tr>
1558
1559 <tr class="IndexCell">
1560 <td>NOT NULL</td><td>rank</td>
1561 </tr>
1562
1563 <tr class="IndexCell">
1564 <td>UNIQUE</td><td>genotype_id, type_id, rank</td>
1565 </tr>
1566
1567 </table>
1568
1569 <hr />
1570
1571 Created by <a href="http://sqlfairy.sourceforge.net">
1572 SQL::Translator 0.11020</a>
1573
1574 </body>
1575 </html>