Debian Codegraph @

modules/phylogeny/phylogeny.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 width="100%" class="LinkTable">
26
27 <tr>
28 <td class="LinkTableCell"><h2 class="LinkTableTitle">
29 Tables
30 </h2></td>
31 </tr>
32
33 <!--
34 Start link to table 'phylotree'
35 -->
36
37 <tr class="LinkTableRow">
38 <td class="LinkTableCell"><a id="phylotree-link" href="#phylotree">phylotree</a></td>
39 </tr>
40
41 <!--
42 End link to table 'phylotree'
43 -->
44
45 <!--
46 Start link to table 'phylotree_pub'
47 -->
48
49 <tr class="LinkTableRow">
50 <td class="LinkTableCell"><a id="phylotree_pub-link" href="#phylotree_pub">phylotree_pub</a></td>
51 </tr>
52
53 <!--
54 End link to table 'phylotree_pub'
55 -->
56
57 <!--
58 Start link to table 'phylotreeprop'
59 -->
60
61 <tr class="LinkTableRow">
62 <td class="LinkTableCell"><a id="phylotreeprop-link" href="#phylotreeprop">phylotreeprop</a></td>
63 </tr>
64
65 <!--
66 End link to table 'phylotreeprop'
67 -->
68
69 <!--
70 Start link to table 'phylonode'
71 -->
72
73 <tr class="LinkTableRow">
74 <td class="LinkTableCell"><a id="phylonode-link" href="#phylonode">phylonode</a></td>
75 </tr>
76
77 <!--
78 End link to table 'phylonode'
79 -->
80
81 <!--
82 Start link to table 'phylonode_dbxref'
83 -->
84
85 <tr class="LinkTableRow">
86 <td class="LinkTableCell"><a id="phylonode_dbxref-link" href="#phylonode_dbxref">phylonode_dbxref</a></td>
87 </tr>
88
89 <!--
90 End link to table 'phylonode_dbxref'
91 -->
92
93 <!--
94 Start link to table 'phylonode_pub'
95 -->
96
97 <tr class="LinkTableRow">
98 <td class="LinkTableCell"><a id="phylonode_pub-link" href="#phylonode_pub">phylonode_pub</a></td>
99 </tr>
100
101 <!--
102 End link to table 'phylonode_pub'
103 -->
104
105 <!--
106 Start link to table 'phylonode_organism'
107 -->
108
109 <tr class="LinkTableRow">
110 <td class="LinkTableCell"><a id="phylonode_organism-link" href="#phylonode_organism">phylonode_organism</a></td>
111 </tr>
112
113 <!--
114 End link to table 'phylonode_organism'
115 -->
116
117 <!--
118 Start link to table 'phylonodeprop'
119 -->
120
121 <tr class="LinkTableRow">
122 <td class="LinkTableCell"><a id="phylonodeprop-link" href="#phylonodeprop">phylonodeprop</a></td>
123 </tr>
124
125 <!--
126 End link to table 'phylonodeprop'
127 -->
128
129 <!--
130 Start link to table 'phylonode_relationship'
131 -->
132
133 <tr class="LinkTableRow">
134 <td class="LinkTableCell"><a id="phylonode_relationship-link" href="#phylonode_relationship">phylonode_relationship</a></td>
135 </tr>
136
137 <!--
138 End link to table 'phylonode_relationship'
139 -->
140
141 </table>
142
143 <!--
144 Starting table 'phylotree'
145 -->
146
147 <a name="phylotree" />
148
149 <table width="100%" class="TableHeader">
150 <tr class="TableHeaderRow">
151 <td class="TableHeaderCell"><h3>
152 phylotree
153 </h3></td> <a name="phylotree"> <td align="right" class="TableHeaderCell"><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: phylogeny.sql,v 1.11 2007-04-12 17:00:30 briano Exp $ <br />
166 ========================================== <br />
167 Chado phylogenetics module <br />
168 Richard Bruskiewich <br />
169 Chris Mungall <br />
170 Initial design: 2004-05-27 <br />
171 ============ <br />
172 DEPENDENCIES <br />
173 ============ <br />
174 :import feature from sequence <br />
175 :import cvterm from cv <br />
176 :import pub from pub <br />
177 :import organism from organism <br />
178 :import dbxref from db <br />
179 :import analysis from companalysis <br />
180 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ <br />
181 ================================================ <br />
182 TABLE: phylotree <br />
183 ================================================ <br />
184 Global anchor for phylogenetic tree.
185 </em>
186
187 <table border="1">
188
189 <tr>
190 <th class="FieldHeader">
191 Field Name
192 </th>
193 <th class="FieldHeader">
194 Data Type
195 </th>
196 <th class="FieldHeader">
197 Size
198 </th>
199 <th class="FieldHeader">
200 Default Value
201 </th>
202 <th class="FieldHeader">
203 Other
204 </th>
205 <th class="FieldHeader">
206 Foreign Key
207 </th>
208 </tr>
209
210 <tr class="tr-odd">
211 <td class="FieldCellName"><a name="phylotree-phylotree_id">phylotree_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
212 </tr>
213
214 <tr class="tr-even">
215 <td class="FieldCellName"><a name="phylotree-dbxref_id">dbxref_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="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
216 </tr>
217
218 <tr class="tr-odd">
219 <td class="FieldCellName"><a name="phylotree-name">name</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
220 </tr>
221
222 <tr class="tr-even">
223 <td class="FieldCellName"><a name="phylotree-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">Type: protein, nucleotide, taxonomy, for example. The type should be any SO type, or "taxonomy". </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
224 </tr>
225
226 <tr class="tr-odd">
227 <td class="FieldCellName"><a name="phylotree-analysis_id">analysis_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="#analysis-analysis_id">analysis.analysis_id</a></td>
228 </tr>
229
230 <tr class="tr-even">
231 <td class="FieldCellName"><a name="phylotree-comment">comment</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>
232 </tr>
233
234 </table>
235
236 <h3>
237 Indices
238 </h3>
239
240 <table border="1">
241
242 <tr class="IndexRow">
243 <th>
244 Name
245 </th>
246 <th>
247 Fields
248 </th>
249 </tr>
250
251 <tr class="IndexCell">
252 <td>phylotree_idx1</td><td>phylotree_id</td>
253 </tr>
254
255 </table>
256
257 <h3>
258 Constraints
259 </h3>
260
261 <table border="1">
262
263 <tr class="IndexRow">
264 <th>
265 Type
266 </th>
267 <th>
268 Fields
269 </th>
270 </tr>
271
272 <tr class="IndexCell">
273 <td>NOT NULL</td><td>phylotree_id</td>
274 </tr>
275
276 <tr class="IndexCell">
277 <td>NOT NULL</td><td>dbxref_id</td>
278 </tr>
279
280 <tr class="IndexCell">
281 <td>FOREIGN KEY</td><td>dbxref_id</td>
282 </tr>
283
284 <tr class="IndexCell">
285 <td>FOREIGN KEY</td><td>type_id</td>
286 </tr>
287
288 <tr class="IndexCell">
289 <td>FOREIGN KEY</td><td>analysis_id</td>
290 </tr>
291
292 <tr class="IndexCell">
293 <td>UNIQUE</td><td>phylotree_id</td>
294 </tr>
295
296 </table>
297
298 <hr />
299
300 <!--
301 Starting table 'phylotree_pub'
302 -->
303
304 <a name="phylotree_pub" />
305
306 <table width="100%" class="TableHeader">
307 <tr class="TableHeaderRow">
308 <td class="TableHeaderCell"><h3>
309 phylotree_pub
310 </h3></td> <a name="phylotree_pub"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
311 </tr>
312 </table>
313
314 <b>
315 Comments:
316 </b>
317
318 <br />
319
320 <em>
321 <br />
322 ================================================ <br />
323 TABLE: phylotree_pub <br />
324 ================================================ <br />
325 Tracks citations global to the tree e.g. multiple sequence alignment supporting tree construction.
326 </em>
327
328 <table border="1">
329
330 <tr>
331 <th class="FieldHeader">
332 Field Name
333 </th>
334 <th class="FieldHeader">
335 Data Type
336 </th>
337 <th class="FieldHeader">
338 Size
339 </th>
340 <th class="FieldHeader">
341 Default Value
342 </th>
343 <th class="FieldHeader">
344 Other
345 </th>
346 <th class="FieldHeader">
347 Foreign Key
348 </th>
349 </tr>
350
351 <tr class="tr-odd">
352 <td class="FieldCellName"><a name="phylotree_pub-phylotree_pub_id">phylotree_pub_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>
353 </tr>
354
355 <tr class="tr-even">
356 <td class="FieldCellName"><a name="phylotree_pub-phylotree_id">phylotree_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="#phylotree-phylotree_id">phylotree.phylotree_id</a></td>
357 </tr>
358
359 <tr class="tr-odd">
360 <td class="FieldCellName"><a name="phylotree_pub-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>
361 </tr>
362
363 </table>
364
365 <h3>
366 Indices
367 </h3>
368
369 <table border="1">
370
371 <tr class="IndexRow">
372 <th>
373 Name
374 </th>
375 <th>
376 Fields
377 </th>
378 </tr>
379
380 <tr class="IndexCell">
381 <td>phylotree_pub_idx1</td><td>phylotree_id</td>
382 </tr>
383
384 <tr class="IndexCell">
385 <td>phylotree_pub_idx2</td><td>pub_id</td>
386 </tr>
387
388 </table>
389
390 <h3>
391 Constraints
392 </h3>
393
394 <table border="1">
395
396 <tr class="IndexRow">
397 <th>
398 Type
399 </th>
400 <th>
401 Fields
402 </th>
403 </tr>
404
405 <tr class="IndexCell">
406 <td>NOT NULL</td><td>phylotree_pub_id</td>
407 </tr>
408
409 <tr class="IndexCell">
410 <td>NOT NULL</td><td>phylotree_id</td>
411 </tr>
412
413 <tr class="IndexCell">
414 <td>FOREIGN KEY</td><td>phylotree_id</td>
415 </tr>
416
417 <tr class="IndexCell">
418 <td>NOT NULL</td><td>pub_id</td>
419 </tr>
420
421 <tr class="IndexCell">
422 <td>FOREIGN KEY</td><td>pub_id</td>
423 </tr>
424
425 <tr class="IndexCell">
426 <td>UNIQUE</td><td>phylotree_id, pub_id</td>
427 </tr>
428
429 </table>
430
431 <hr />
432
433 <!--
434 Starting table 'phylotreeprop'
435 -->
436
437 <a name="phylotreeprop" />
438
439 <table class="TableHeader" width="100%">
440 <tr class="TableHeaderRow">
441 <td class="TableHeaderCell"><h3>
442 phylotreeprop
443 </h3></td> <a name="phylotreeprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
444 </tr>
445 </table>
446
447 <b>
448 Comments:
449 </b>
450
451 <br />
452
453 <em>
454 <br />
455 ================================================ <br />
456 TABLE: phylotreeprop <br />
457 ================================================ <br />
458 A phylotree can have any number of slot-value property
459 tags attached to it. This is an alternative to hardcoding a list of columns in the
460 relational schema, and is completely extensible.
461 </em>
462
463 <table border="1">
464
465 <tr>
466 <th class="FieldHeader">
467 Field Name
468 </th>
469 <th class="FieldHeader">
470 Data Type
471 </th>
472 <th class="FieldHeader">
473 Size
474 </th>
475 <th class="FieldHeader">
476 Default Value
477 </th>
478 <th class="FieldHeader">
479 Other
480 </th>
481 <th class="FieldHeader">
482 Foreign Key
483 </th>
484 </tr>
485
486 <tr class="tr-odd">
487 <td class="FieldCellName"><a name="phylotreeprop-phylotreeprop_id">phylotreeprop_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>
488 </tr>
489
490 <tr class="tr-even">
491 <td class="FieldCellName"><a name="phylotreeprop-phylotree_id">phylotree_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="#phylotree-phylotree_id">phylotree.phylotree_id</a></td>
492 </tr>
493
494 <tr class="tr-odd">
495 <td class="FieldCellName"><a name="phylotreeprop-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, The name of the property/slot is a cvterm.
496 The meaning of the property is defined in that cvterm. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
497 </tr>
498
499 <tr class="tr-even">
500 <td class="FieldCellName"><a name="phylotreeprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">The value of the property, represented as text.
501 Numeric values are converted to their text representation. This is less efficient than
502 using native database types, but is easier to query. </td> <td class="FieldCellFK"></td>
503 </tr>
504
505 <tr class="tr-odd">
506 <td class="FieldCellName"><a name="phylotreeprop-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, Property-Value ordering. Any
507 phylotree can have multiple values for any particular property type
508 these are ordered in a list using rank, counting from zero. For
509 properties that are single-valued rather than multi-valued, the
510 default 0 value should be used </td> <td class="FieldCellFK"></td>
511 </tr>
512
513 </table>
514
515 <h3>
516 Indices
517 </h3>
518
519 <table border="1">
520
521 <tr class="IndexRow">
522 <th>
523 Name
524 </th>
525 <th>
526 Fields
527 </th>
528 </tr>
529
530 <tr class="IndexCell">
531 <td>phylotreeprop_idx1</td><td>phylotree_id</td>
532 </tr>
533
534 <tr class="IndexCell">
535 <td>phylotreeprop_idx2</td><td>type_id</td>
536 </tr>
537
538 </table>
539
540 <h3>
541 Constraints
542 </h3>
543
544 <table border="1">
545
546 <tr class="IndexRow">
547 <th>
548 Type
549 </th>
550 <th>
551 Fields
552 </th>
553 </tr>
554
555 <tr class="IndexCell">
556 <td>NOT NULL</td><td>phylotreeprop_id</td>
557 </tr>
558
559 <tr class="IndexCell">
560 <td>NOT NULL</td><td>phylotree_id</td>
561 </tr>
562
563 <tr class="IndexCell">
564 <td>NOT NULL</td><td>type_id</td>
565 </tr>
566
567 <tr class="IndexCell">
568 <td>NOT NULL</td><td>rank</td>
569 </tr>
570
571 <tr class="IndexCell">
572 <td>FOREIGN KEY</td><td>phylotree_id</td>
573 </tr>
574
575 <tr class="IndexCell">
576 <td>FOREIGN KEY</td><td>type_id</td>
577 </tr>
578
579 <tr class="IndexCell">
580 <td>UNIQUE</td><td>phylotree_id, type_id, rank</td>
581 </tr>
582
583 </table>
584
585 <hr />
586
587 <!--
588 Starting table 'phylonode'
589 -->
590
591 <a name="phylonode" />
592
593 <table class="TableHeader" width="100%">
594 <tr class="TableHeaderRow">
595 <td class="TableHeaderCell"><h3>
596 phylonode
597 </h3></td> <a name="phylonode"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
598 </tr>
599 </table>
600
601 <b>
602 Comments:
603 </b>
604
605 <br />
606
607 <em>
608 <br />
609 For any one phylotree, multivalued
610 property-value pairs must be differentiated by rank. <br />
611 ================================================ <br />
612 TABLE: phylonode <br />
613 ================================================ <br />
614 Bootstrap float null. <br />
615 This is the most pervasive
616 element in the phylogeny module, cataloging the "phylonodes" of
617 tree graphs. Edges are implied by the parent_phylonode_id
618 reflexive closure. For all nodes in a nested set implementation the left and right index will be *between* the parents left and right indexes.
619 </em>
620
621 <table border="1">
622
623 <tr>
624 <th class="FieldHeader">
625 Field Name
626 </th>
627 <th class="FieldHeader">
628 Data Type
629 </th>
630 <th class="FieldHeader">
631 Size
632 </th>
633 <th class="FieldHeader">
634 Default Value
635 </th>
636 <th class="FieldHeader">
637 Other
638 </th>
639 <th class="FieldHeader">
640 Foreign Key
641 </th>
642 </tr>
643
644 <tr class="tr-odd">
645 <td class="FieldCellName"><a name="phylonode-phylonode_id">phylonode_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>
646 </tr>
647
648 <tr class="tr-even">
649 <td class="FieldCellName"><a name="phylonode-phylotree_id">phylotree_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="#phylotree-phylotree_id">phylotree.phylotree_id</a></td>
650 </tr>
651
652 <tr class="tr-odd">
653 <td class="FieldCellName"><a name="phylonode-parent_phylonode_id">parent_phylonode_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">Root phylonode can have null parent_phylonode_id value. </td> <td class="FieldCellFK"><a href="#phylonode-phylonode_id">phylonode.phylonode_id</a></td>
654 </tr>
655
656 <tr class="tr-even">
657 <td class="FieldCellName"><a name="phylonode-left_idx">left_idx</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
658 </tr>
659
660 <tr class="tr-odd">
661 <td class="FieldCellName"><a name="phylonode-right_idx">right_idx</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
662 </tr>
663
664 <tr class="tr-even">
665 <td class="FieldCellName"><a name="phylonode-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">Type: e.g. root, interior, leaf. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
666 </tr>
667
668 <tr class="tr-odd">
669 <td class="FieldCellName"><a name="phylonode-feature_id">feature_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">Phylonodes can have optional features attached to them e.g. a protein or nucleotide sequence usually attached to a leaf of the phylotree for non-leaf nodes, the feature may be a feature that is an instance of SO:match; this feature is the alignment of all leaf features beneath it. </td> <td class="FieldCellFK"><a href="#feature-feature_id">feature.feature_id</a></td>
670 </tr>
671
672 <tr class="tr-even">
673 <td class="FieldCellName"><a name="phylonode-label">label</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
674 </tr>
675
676 <tr class="tr-odd">
677 <td class="FieldCellName"><a name="phylonode-distance">distance</a></td> <td class="FieldCellType">float</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
678 </tr>
679
680 </table>
681
682 <h3>
683 Indices
684 </h3>
685
686 <table border="1">
687
688 <tr class="IndexRow">
689 <th>
690 Name
691 </th>
692 <th>
693 Fields
694 </th>
695 </tr>
696
697 <tr class="IndexCell">
698 <td>phylonode_parent_phylonode_id_idx</td><td>parent_phylonode_id</td>
699 </tr>
700
701 </table>
702
703 <h3>
704 Constraints
705 </h3>
706
707 <table border="1">
708
709 <tr class="IndexRow">
710 <th>
711 Type
712 </th>
713 <th>
714 Fields
715 </th>
716 </tr>
717
718 <tr class="IndexCell">
719 <td>NOT NULL</td><td>phylonode_id</td>
720 </tr>
721
722 <tr class="IndexCell">
723 <td>NOT NULL</td><td>phylotree_id</td>
724 </tr>
725
726 <tr class="IndexCell">
727 <td>FOREIGN KEY</td><td>phylotree_id</td>
728 </tr>
729
730 <tr class="IndexCell">
731 <td>FOREIGN KEY</td><td>parent_phylonode_id</td>
732 </tr>
733
734 <tr class="IndexCell">
735 <td>NOT NULL</td><td>left_idx</td>
736 </tr>
737
738 <tr class="IndexCell">
739 <td>NOT NULL</td><td>right_idx</td>
740 </tr>
741
742 <tr class="IndexCell">
743 <td>FOREIGN KEY</td><td>type_id</td>
744 </tr>
745
746 <tr class="IndexCell">
747 <td>FOREIGN KEY</td><td>feature_id</td>
748 </tr>
749
750 <tr class="IndexCell">
751 <td>UNIQUE</td><td>phylotree_id, left_idx</td>
752 </tr>
753
754 <tr class="IndexCell">
755 <td>UNIQUE</td><td>phylotree_id, right_idx</td>
756 </tr>
757
758 </table>
759
760 <hr />
761
762 <!--
763 Starting table 'phylonode_dbxref'
764 -->
765
766 <a name="phylonode_dbxref" />
767
768 <table width="100%" class="TableHeader">
769 <tr class="TableHeaderRow">
770 <td class="TableHeaderCell"><h3>
771 phylonode_dbxref
772 </h3></td> <a name="phylonode_dbxref"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
773 </tr>
774 </table>
775
776 <b>
777 Comments:
778 </b>
779
780 <br />
781
782 <em>
783 <br />
784 ================================================ <br />
785 TABLE: phylonode_dbxref <br />
786 ================================================ <br />
787 For example, for orthology, paralogy group identifiers; could also be used for NCBI taxonomy; for sequences, refer to phylonode_feature, feature associated dbxrefs.
788 </em>
789
790 <table border="1">
791
792 <tr>
793 <th class="FieldHeader">
794 Field Name
795 </th>
796 <th class="FieldHeader">
797 Data Type
798 </th>
799 <th class="FieldHeader">
800 Size
801 </th>
802 <th class="FieldHeader">
803 Default Value
804 </th>
805 <th class="FieldHeader">
806 Other
807 </th>
808 <th class="FieldHeader">
809 Foreign Key
810 </th>
811 </tr>
812
813 <tr class="tr-odd">
814 <td class="FieldCellName"><a name="phylonode_dbxref-phylonode_dbxref_id">phylonode_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>
815 </tr>
816
817 <tr class="tr-even">
818 <td class="FieldCellName"><a name="phylonode_dbxref-phylonode_id">phylonode_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="#phylonode-phylonode_id">phylonode.phylonode_id</a></td>
819 </tr>
820
821 <tr class="tr-odd">
822 <td class="FieldCellName"><a name="phylonode_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>
823 </tr>
824
825 </table>
826
827 <h3>
828 Indices
829 </h3>
830
831 <table border="1">
832
833 <tr class="IndexRow">
834 <th>
835 Name
836 </th>
837 <th>
838 Fields
839 </th>
840 </tr>
841
842 <tr class="IndexCell">
843 <td>phylonode_dbxref_idx1</td><td>phylonode_id</td>
844 </tr>
845
846 <tr class="IndexCell">
847 <td>phylonode_dbxref_idx2</td><td>dbxref_id</td>
848 </tr>
849
850 </table>
851
852 <h3>
853 Constraints
854 </h3>
855
856 <table border="1">
857
858 <tr class="IndexRow">
859 <th>
860 Type
861 </th>
862 <th>
863 Fields
864 </th>
865 </tr>
866
867 <tr class="IndexCell">
868 <td>NOT NULL</td><td>phylonode_dbxref_id</td>
869 </tr>
870
871 <tr class="IndexCell">
872 <td>NOT NULL</td><td>phylonode_id</td>
873 </tr>
874
875 <tr class="IndexCell">
876 <td>FOREIGN KEY</td><td>phylonode_id</td>
877 </tr>
878
879 <tr class="IndexCell">
880 <td>NOT NULL</td><td>dbxref_id</td>
881 </tr>
882
883 <tr class="IndexCell">
884 <td>FOREIGN KEY</td><td>dbxref_id</td>
885 </tr>
886
887 <tr class="IndexCell">
888 <td>UNIQUE</td><td>phylonode_id, dbxref_id</td>
889 </tr>
890
891 </table>
892
893 <hr />
894
895 <!--
896 Starting table 'phylonode_pub'
897 -->
898
899 <a name="phylonode_pub" />
900
901 <table class="TableHeader" width="100%">
902 <tr class="TableHeaderRow">
903 <td class="TableHeaderCell"><h3>
904 phylonode_pub
905 </h3></td> <a name="phylonode_pub"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
906 </tr>
907 </table>
908
909 <b>
910 Comments:
911 </b>
912
913 <br />
914
915 <em>
916 <br />
917 ================================================ <br />
918 TABLE: phylonode_pub <br />
919 ================================================
920 </em>
921
922 <table border="1">
923
924 <tr>
925 <th class="FieldHeader">
926 Field Name
927 </th>
928 <th class="FieldHeader">
929 Data Type
930 </th>
931 <th class="FieldHeader">
932 Size
933 </th>
934 <th class="FieldHeader">
935 Default Value
936 </th>
937 <th class="FieldHeader">
938 Other
939 </th>
940 <th class="FieldHeader">
941 Foreign Key
942 </th>
943 </tr>
944
945 <tr class="tr-odd">
946 <td class="FieldCellName"><a name="phylonode_pub-phylonode_pub_id">phylonode_pub_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>
947 </tr>
948
949 <tr class="tr-even">
950 <td class="FieldCellName"><a name="phylonode_pub-phylonode_id">phylonode_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="#phylonode-phylonode_id">phylonode.phylonode_id</a></td>
951 </tr>
952
953 <tr class="tr-odd">
954 <td class="FieldCellName"><a name="phylonode_pub-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>
955 </tr>
956
957 </table>
958
959 <h3>
960 Indices
961 </h3>
962
963 <table border="1">
964
965 <tr class="IndexRow">
966 <th>
967 Name
968 </th>
969 <th>
970 Fields
971 </th>
972 </tr>
973
974 <tr class="IndexCell">
975 <td>phylonode_pub_idx1</td><td>phylonode_id</td>
976 </tr>
977
978 <tr class="IndexCell">
979 <td>phylonode_pub_idx2</td><td>pub_id</td>
980 </tr>
981
982 </table>
983
984 <h3>
985 Constraints
986 </h3>
987
988 <table border="1">
989
990 <tr class="IndexRow">
991 <th>
992 Type
993 </th>
994 <th>
995 Fields
996 </th>
997 </tr>
998
999 <tr class="IndexCell">
1000 <td>NOT NULL</td><td>phylonode_pub_id</td>
1001 </tr>
1002
1003 <tr class="IndexCell">
1004 <td>NOT NULL</td><td>phylonode_id</td>
1005 </tr>
1006
1007 <tr class="IndexCell">
1008 <td>FOREIGN KEY</td><td>phylonode_id</td>
1009 </tr>
1010
1011 <tr class="IndexCell">
1012 <td>NOT NULL</td><td>pub_id</td>
1013 </tr>
1014
1015 <tr class="IndexCell">
1016 <td>FOREIGN KEY</td><td>pub_id</td>
1017 </tr>
1018
1019 <tr class="IndexCell">
1020 <td>UNIQUE</td><td>phylonode_id, pub_id</td>
1021 </tr>
1022
1023 </table>
1024
1025 <hr />
1026
1027 <!--
1028 Starting table 'phylonode_organism'
1029 -->
1030
1031 <a name="phylonode_organism" />
1032
1033 <table class="TableHeader" width="100%">
1034 <tr class="TableHeaderRow">
1035 <td class="TableHeaderCell"><h3>
1036 phylonode_organism
1037 </h3></td> <a name="phylonode_organism"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1038 </tr>
1039 </table>
1040
1041 <b>
1042 Comments:
1043 </b>
1044
1045 <br />
1046
1047 <em>
1048 <br />
1049 ================================================ <br />
1050 TABLE: phylonode_organism <br />
1051 ================================================ <br />
1052 This linking table should only be used for nodes in taxonomy trees; it provides a mapping between the node and an organism. One node can have zero or one organisms, one organism can have zero or more nodes (although typically it should only have one in the standard NCBI taxonomy tree).
1053 </em>
1054
1055 <table border="1">
1056
1057 <tr>
1058 <th class="FieldHeader">
1059 Field Name
1060 </th>
1061 <th class="FieldHeader">
1062 Data Type
1063 </th>
1064 <th class="FieldHeader">
1065 Size
1066 </th>
1067 <th class="FieldHeader">
1068 Default Value
1069 </th>
1070 <th class="FieldHeader">
1071 Other
1072 </th>
1073 <th class="FieldHeader">
1074 Foreign Key
1075 </th>
1076 </tr>
1077
1078 <tr class="tr-odd">
1079 <td class="FieldCellName"><a name="phylonode_organism-phylonode_organism_id">phylonode_organism_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>
1080 </tr>
1081
1082 <tr class="tr-even">
1083 <td class="FieldCellName"><a name="phylonode_organism-phylonode_id">phylonode_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, One phylonode cannot refer to >1 organism. </td> <td class="FieldCellFK"><a href="#phylonode-phylonode_id">phylonode.phylonode_id</a></td>
1084 </tr>
1085
1086 <tr class="tr-odd">
1087 <td class="FieldCellName"><a name="phylonode_organism-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>
1088 </tr>
1089
1090 </table>
1091
1092 <h3>
1093 Indices
1094 </h3>
1095
1096 <table border="1">
1097
1098 <tr class="IndexRow">
1099 <th>
1100 Name
1101 </th>
1102 <th>
1103 Fields
1104 </th>
1105 </tr>
1106
1107 <tr class="IndexCell">
1108 <td>phylonode_organism_idx1</td><td>phylonode_id</td>
1109 </tr>
1110
1111 <tr class="IndexCell">
1112 <td>phylonode_organism_idx2</td><td>organism_id</td>
1113 </tr>
1114
1115 </table>
1116
1117 <h3>
1118 Constraints
1119 </h3>
1120
1121 <table border="1">
1122
1123 <tr class="IndexRow">
1124 <th>
1125 Type
1126 </th>
1127 <th>
1128 Fields
1129 </th>
1130 </tr>
1131
1132 <tr class="IndexCell">
1133 <td>NOT NULL</td><td>phylonode_organism_id</td>
1134 </tr>
1135
1136 <tr class="IndexCell">
1137 <td>NOT NULL</td><td>phylonode_id</td>
1138 </tr>
1139
1140 <tr class="IndexCell">
1141 <td>FOREIGN KEY</td><td>phylonode_id</td>
1142 </tr>
1143
1144 <tr class="IndexCell">
1145 <td>NOT NULL</td><td>organism_id</td>
1146 </tr>
1147
1148 <tr class="IndexCell">
1149 <td>FOREIGN KEY</td><td>organism_id</td>
1150 </tr>
1151
1152 <tr class="IndexCell">
1153 <td>UNIQUE</td><td>phylonode_id</td>
1154 </tr>
1155
1156 </table>
1157
1158 <hr />
1159
1160 <!--
1161 Starting table 'phylonodeprop'
1162 -->
1163
1164 <a name="phylonodeprop" />
1165
1166 <table class="TableHeader" width="100%">
1167 <tr class="TableHeaderRow">
1168 <td class="TableHeaderCell"><h3>
1169 phylonodeprop
1170 </h3></td> <a name="phylonodeprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1171 </tr>
1172 </table>
1173
1174 <b>
1175 Comments:
1176 </b>
1177
1178 <br />
1179
1180 <em>
1181 <br />
1182 ================================================ <br />
1183 TABLE: phylonodeprop <br />
1184 ================================================
1185 </em>
1186
1187 <table border="1">
1188
1189 <tr>
1190 <th class="FieldHeader">
1191 Field Name
1192 </th>
1193 <th class="FieldHeader">
1194 Data Type
1195 </th>
1196 <th class="FieldHeader">
1197 Size
1198 </th>
1199 <th class="FieldHeader">
1200 Default Value
1201 </th>
1202 <th class="FieldHeader">
1203 Other
1204 </th>
1205 <th class="FieldHeader">
1206 Foreign Key
1207 </th>
1208 </tr>
1209
1210 <tr class="tr-odd">
1211 <td class="FieldCellName"><a name="phylonodeprop-phylonodeprop_id">phylonodeprop_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>
1212 </tr>
1213
1214 <tr class="tr-even">
1215 <td class="FieldCellName"><a name="phylonodeprop-phylonode_id">phylonode_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="#phylonode-phylonode_id">phylonode.phylonode_id</a></td>
1216 </tr>
1217
1218 <tr class="tr-odd">
1219 <td class="FieldCellName"><a name="phylonodeprop-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, type_id could designate phylonode hierarchy relationships, for example: species taxonomy (kingdom, order, family, genus, species), "ortholog/paralog", "fold/superfold", etc. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1220 </tr>
1221
1222 <tr class="tr-even">
1223 <td class="FieldCellName"><a name="phylonodeprop-value">value</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>
1224 </tr>
1225
1226 <tr class="tr-odd">
1227 <td class="FieldCellName"><a name="phylonodeprop-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, It is not clear how useful the rank concept is here, leave it in for now.</td> <td class="FieldCellFK"></td>
1228 </tr>
1229
1230 </table>
1231
1232 <h3>
1233 Indices
1234 </h3>
1235
1236 <table border="1">
1237
1238 <tr class="IndexRow">
1239 <th>
1240 Name
1241 </th>
1242 <th>
1243 Fields
1244 </th>
1245 </tr>
1246
1247 <tr class="IndexCell">
1248 <td>phylonodeprop_idx1</td><td>phylonode_id</td>
1249 </tr>
1250
1251 <tr class="IndexCell">
1252 <td>phylonodeprop_idx2</td><td>type_id</td>
1253 </tr>
1254
1255 </table>
1256
1257 <h3>
1258 Constraints
1259 </h3>
1260
1261 <table border="1">
1262
1263 <tr class="IndexRow">
1264 <th>
1265 Type
1266 </th>
1267 <th>
1268 Fields
1269 </th>
1270 </tr>
1271
1272 <tr class="IndexCell">
1273 <td>NOT NULL</td><td>phylonodeprop_id</td>
1274 </tr>
1275
1276 <tr class="IndexCell">
1277 <td>NOT NULL</td><td>phylonode_id</td>
1278 </tr>
1279
1280 <tr class="IndexCell">
1281 <td>FOREIGN KEY</td><td>phylonode_id</td>
1282 </tr>
1283
1284 <tr class="IndexCell">
1285 <td>NOT NULL</td><td>type_id</td>
1286 </tr>
1287
1288 <tr class="IndexCell">
1289 <td>FOREIGN KEY</td><td>type_id</td>
1290 </tr>
1291
1292 <tr class="IndexCell">
1293 <td>NOT NULL</td><td>value</td>
1294 </tr>
1295
1296 <tr class="IndexCell">
1297 <td>NOT NULL</td><td>rank</td>
1298 </tr>
1299
1300 <tr class="IndexCell">
1301 <td>UNIQUE</td><td>phylonode_id, type_id, value, rank</td>
1302 </tr>
1303
1304 </table>
1305
1306 <hr />
1307
1308 <!--
1309 Starting table 'phylonode_relationship'
1310 -->
1311
1312 <a name="phylonode_relationship" />
1313
1314 <table width="100%" class="TableHeader">
1315 <tr class="TableHeaderRow">
1316 <td class="TableHeaderCell"><h3>
1317 phylonode_relationship
1318 </h3></td> <a name="phylonode_relationship"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1319 </tr>
1320 </table>
1321
1322 <b>
1323 Comments:
1324 </b>
1325
1326 <br />
1327
1328 <em>
1329 <br />
1330 ================================================ <br />
1331 TABLE: phylonode_relationship <br />
1332 ================================================ <br />
1333 This is for
1334 relationships that are not strictly hierarchical; for example,
1335 horizontal gene transfer. Most phylogenetic trees are strictly
1336 hierarchical, nevertheless it is here for completeness.
1337 </em>
1338
1339 <table border="1">
1340
1341 <tr>
1342 <th class="FieldHeader">
1343 Field Name
1344 </th>
1345 <th class="FieldHeader">
1346 Data Type
1347 </th>
1348 <th class="FieldHeader">
1349 Size
1350 </th>
1351 <th class="FieldHeader">
1352 Default Value
1353 </th>
1354 <th class="FieldHeader">
1355 Other
1356 </th>
1357 <th class="FieldHeader">
1358 Foreign Key
1359 </th>
1360 </tr>
1361
1362 <tr class="tr-odd">
1363 <td class="FieldCellName"><a name="phylonode_relationship-phylonode_relationship_id">phylonode_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>
1364 </tr>
1365
1366 <tr class="tr-even">
1367 <td class="FieldCellName"><a name="phylonode_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="#phylonode-phylonode_id">phylonode.phylonode_id</a></td>
1368 </tr>
1369
1370 <tr class="tr-odd">
1371 <td class="FieldCellName"><a name="phylonode_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="#phylonode-phylonode_id">phylonode.phylonode_id</a></td>
1372 </tr>
1373
1374 <tr class="tr-even">
1375 <td class="FieldCellName"><a name="phylonode_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>
1376 </tr>
1377
1378 <tr class="tr-odd">
1379 <td class="FieldCellName"><a name="phylonode_relationship-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
1380 </tr>
1381
1382 <tr class="tr-even">
1383 <td class="FieldCellName"><a name="phylonode_relationship-phylotree_id">phylotree_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="#phylotree-phylotree_id">phylotree.phylotree_id</a></td>
1384 </tr>
1385
1386 </table>
1387
1388 <h3>
1389 Indices
1390 </h3>
1391
1392 <table border="1">
1393
1394 <tr class="IndexRow">
1395 <th>
1396 Name
1397 </th>
1398 <th>
1399 Fields
1400 </th>
1401 </tr>
1402
1403 <tr class="IndexCell">
1404 <td>phylonode_relationship_idx1</td><td>subject_id</td>
1405 </tr>
1406
1407 <tr class="IndexCell">
1408 <td>phylonode_relationship_idx2</td><td>object_id</td>
1409 </tr>
1410
1411 <tr class="IndexCell">
1412 <td>phylonode_relationship_idx3</td><td>type_id</td>
1413 </tr>
1414
1415 </table>
1416
1417 <h3>
1418 Constraints
1419 </h3>
1420
1421 <table border="1">
1422
1423 <tr class="IndexRow">
1424 <th>
1425 Type
1426 </th>
1427 <th>
1428 Fields
1429 </th>
1430 </tr>
1431
1432 <tr class="IndexCell">
1433 <td>NOT NULL</td><td>phylonode_relationship_id</td>
1434 </tr>
1435
1436 <tr class="IndexCell">
1437 <td>NOT NULL</td><td>subject_id</td>
1438 </tr>
1439
1440 <tr class="IndexCell">
1441 <td>FOREIGN KEY</td><td>subject_id</td>
1442 </tr>
1443
1444 <tr class="IndexCell">
1445 <td>NOT NULL</td><td>object_id</td>
1446 </tr>
1447
1448 <tr class="IndexCell">
1449 <td>FOREIGN KEY</td><td>object_id</td>
1450 </tr>
1451
1452 <tr class="IndexCell">
1453 <td>NOT NULL</td><td>type_id</td>
1454 </tr>
1455
1456 <tr class="IndexCell">
1457 <td>FOREIGN KEY</td><td>type_id</td>
1458 </tr>
1459
1460 <tr class="IndexCell">
1461 <td>NOT NULL</td><td>phylotree_id</td>
1462 </tr>
1463
1464 <tr class="IndexCell">
1465 <td>FOREIGN KEY</td><td>phylotree_id</td>
1466 </tr>
1467
1468 <tr class="IndexCell">
1469 <td>UNIQUE</td><td>subject_id, object_id, type_id</td>
1470 </tr>
1471
1472 </table>
1473
1474 <hr />
1475
1476 Created by <a href="http://sqlfairy.sourceforge.net">
1477 SQL::Translator 0.11020</a>
1478
1479 </body>
1480 </html>