Debian Codegraph @

modules/sequence/sequence.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 (19 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 'feature'
35 -->
36
37 <tr class="LinkTableRow">
38 <td class="LinkTableCell"><a id="feature-link" href="#feature">feature</a></td>
39 </tr>
40
41 <!--
42 End link to table 'feature'
43 -->
44
45 <!--
46 Start link to table 'featureloc'
47 -->
48
49 <tr class="LinkTableRow">
50 <td class="LinkTableCell"><a id="featureloc-link" href="#featureloc">featureloc</a></td>
51 </tr>
52
53 <!--
54 End link to table 'featureloc'
55 -->
56
57 <!--
58 Start link to table 'featureloc_pub'
59 -->
60
61 <tr class="LinkTableRow">
62 <td class="LinkTableCell"><a id="featureloc_pub-link" href="#featureloc_pub">featureloc_pub</a></td>
63 </tr>
64
65 <!--
66 End link to table 'featureloc_pub'
67 -->
68
69 <!--
70 Start link to table 'feature_pub'
71 -->
72
73 <tr class="LinkTableRow">
74 <td class="LinkTableCell"><a id="feature_pub-link" href="#feature_pub">feature_pub</a></td>
75 </tr>
76
77 <!--
78 End link to table 'feature_pub'
79 -->
80
81 <!--
82 Start link to table 'feature_pubprop'
83 -->
84
85 <tr class="LinkTableRow">
86 <td class="LinkTableCell"><a id="feature_pubprop-link" href="#feature_pubprop">feature_pubprop</a></td>
87 </tr>
88
89 <!--
90 End link to table 'feature_pubprop'
91 -->
92
93 <!--
94 Start link to table 'featureprop'
95 -->
96
97 <tr class="LinkTableRow">
98 <td class="LinkTableCell"><a id="featureprop-link" href="#featureprop">featureprop</a></td>
99 </tr>
100
101 <!--
102 End link to table 'featureprop'
103 -->
104
105 <!--
106 Start link to table 'featureprop_pub'
107 -->
108
109 <tr class="LinkTableRow">
110 <td class="LinkTableCell"><a id="featureprop_pub-link" href="#featureprop_pub">featureprop_pub</a></td>
111 </tr>
112
113 <!--
114 End link to table 'featureprop_pub'
115 -->
116
117 <!--
118 Start link to table 'feature_dbxref'
119 -->
120
121 <tr class="LinkTableRow">
122 <td class="LinkTableCell"><a id="feature_dbxref-link" href="#feature_dbxref">feature_dbxref</a></td>
123 </tr>
124
125 <!--
126 End link to table 'feature_dbxref'
127 -->
128
129 <!--
130 Start link to table 'feature_relationship'
131 -->
132
133 <tr class="LinkTableRow">
134 <td class="LinkTableCell"><a id="feature_relationship-link" href="#feature_relationship">feature_relationship</a></td>
135 </tr>
136
137 <!--
138 End link to table 'feature_relationship'
139 -->
140
141 <!--
142 Start link to table 'feature_relationship_pub'
143 -->
144
145 <tr class="LinkTableRow">
146 <td class="LinkTableCell"><a id="feature_relationship_pub-link" href="#feature_relationship_pub">feature_relationship_pub</a></td>
147 </tr>
148
149 <!--
150 End link to table 'feature_relationship_pub'
151 -->
152
153 <!--
154 Start link to table 'feature_relationshipprop'
155 -->
156
157 <tr class="LinkTableRow">
158 <td class="LinkTableCell"><a id="feature_relationshipprop-link" href="#feature_relationshipprop">feature_relationshipprop</a></td>
159 </tr>
160
161 <!--
162 End link to table 'feature_relationshipprop'
163 -->
164
165 <!--
166 Start link to table 'feature_relationshipprop_pub'
167 -->
168
169 <tr class="LinkTableRow">
170 <td class="LinkTableCell"><a id="feature_relationshipprop_pub-link" href="#feature_relationshipprop_pub">feature_relationshipprop_pub</a></td>
171 </tr>
172
173 <!--
174 End link to table 'feature_relationshipprop_pub'
175 -->
176
177 <!--
178 Start link to table 'feature_cvterm'
179 -->
180
181 <tr class="LinkTableRow">
182 <td class="LinkTableCell"><a id="feature_cvterm-link" href="#feature_cvterm">feature_cvterm</a></td>
183 </tr>
184
185 <!--
186 End link to table 'feature_cvterm'
187 -->
188
189 <!--
190 Start link to table 'feature_cvtermprop'
191 -->
192
193 <tr class="LinkTableRow">
194 <td class="LinkTableCell"><a id="feature_cvtermprop-link" href="#feature_cvtermprop">feature_cvtermprop</a></td>
195 </tr>
196
197 <!--
198 End link to table 'feature_cvtermprop'
199 -->
200
201 <!--
202 Start link to table 'feature_cvterm_dbxref'
203 -->
204
205 <tr class="LinkTableRow">
206 <td class="LinkTableCell"><a id="feature_cvterm_dbxref-link" href="#feature_cvterm_dbxref">feature_cvterm_dbxref</a></td>
207 </tr>
208
209 <!--
210 End link to table 'feature_cvterm_dbxref'
211 -->
212
213 <!--
214 Start link to table 'feature_cvterm_pub'
215 -->
216
217 <tr class="LinkTableRow">
218 <td class="LinkTableCell"><a id="feature_cvterm_pub-link" href="#feature_cvterm_pub">feature_cvterm_pub</a></td>
219 </tr>
220
221 <!--
222 End link to table 'feature_cvterm_pub'
223 -->
224
225 <!--
226 Start link to table 'synonym'
227 -->
228
229 <tr class="LinkTableRow">
230 <td class="LinkTableCell"><a id="synonym-link" href="#synonym">synonym</a></td>
231 </tr>
232
233 <!--
234 End link to table 'synonym'
235 -->
236
237 <!--
238 Start link to table 'feature_synonym'
239 -->
240
241 <tr class="LinkTableRow">
242 <td class="LinkTableCell"><a id="feature_synonym-link" href="#feature_synonym">feature_synonym</a></td>
243 </tr>
244
245 <!--
246 End link to table 'feature_synonym'
247 -->
248
249 <!--
250 Start link to table 'feature_contact'
251 -->
252
253 <tr class="LinkTableRow">
254 <td class="LinkTableCell"><a id="feature_contact-link" href="#feature_contact">feature_contact</a></td>
255 </tr>
256
257 <!--
258 End link to table 'feature_contact'
259 -->
260
261 </table>
262
263 <!--
264 Starting table 'feature'
265 -->
266
267 <a name="feature" />
268
269 <table width="100%" class="TableHeader">
270 <tr class="TableHeaderRow">
271 <td class="TableHeaderCell"><h3>
272 feature
273 </h3></td> <a name="feature"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
274 </tr>
275 </table>
276
277 <b>
278 Comments:
279 </b>
280
281 <br />
282
283 <em>
284 <br />
285 $Id: sequence.sql,v 1.69 2009-05-14 02:44:23 scottcain Exp $ <br />
286 ========================================== <br />
287 Chado sequence module <br />
288 ================================================================= <br />
289 Dependencies: <br />
290 :import cvterm from cv <br />
291 :import pub from pub <br />
292 :import organism from organism <br />
293 :import dbxref from db <br />
294 :import contact from contact <br />
295 ================================================================= <br />
296 ================================================ <br />
297 TABLE: feature <br />
298 ================================================ <br />
299 A feature is a biological sequence or a
300 section of a biological sequence, or a collection of such
301 sections. Examples include genes, exons, transcripts, regulatory
302 regions, polypeptides, protein domains, chromosome sequences, sequence
303 variations, cross-genome match regions such as hits and HSPs and so
304 on; see the Sequence Ontology for more. The combination of
305 organism_id, uniquename and type_id should be unique.
306 </em>
307
308 <table border="1">
309
310 <tr>
311 <th class="FieldHeader">
312 Field Name
313 </th>
314 <th class="FieldHeader">
315 Data Type
316 </th>
317 <th class="FieldHeader">
318 Size
319 </th>
320 <th class="FieldHeader">
321 Default Value
322 </th>
323 <th class="FieldHeader">
324 Other
325 </th>
326 <th class="FieldHeader">
327 Foreign Key
328 </th>
329 </tr>
330
331 <tr class="tr-odd">
332 <td class="FieldCellName"><a name="feature-feature_id">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>
333 </tr>
334
335 <tr class="tr-even">
336 <td class="FieldCellName"><a name="feature-dbxref_id">dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">An optional primary public stable
337 identifier for this feature. Secondary identifiers and external
338 dbxrefs go in the table feature_dbxref. </td> <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
339 </tr>
340
341 <tr class="tr-odd">
342 <td class="FieldCellName"><a name="feature-organism_id">organism_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, The organism to which this feature
343 belongs. This column is mandatory. </td> <td class="FieldCellFK"><a href="#organism-organism_id">organism.organism_id</a></td>
344 </tr>
345
346 <tr class="tr-even">
347 <td class="FieldCellName"><a name="feature-name">name</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">The optional human-readable common name for
348 a feature, for display purposes. </td> <td class="FieldCellFK"></td>
349 </tr>
350
351 <tr class="tr-odd">
352 <td class="FieldCellName"><a name="feature-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 feature; may
353 not be necessarily be particularly human-readable, although this is
354 preferred. This name must be unique for this type of feature within
355 this organism. </td> <td class="FieldCellFK"></td>
356 </tr>
357
358 <tr class="tr-even">
359 <td class="FieldCellName"><a name="feature-residues">residues</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">A sequence of alphabetic characters
360 representing biological residues (nucleic acids, amino acids). This
361 column does not need to be manifested for all features; it is optional
362 for features such as exons where the residues can be derived from the
363 featureloc. It is recommended that the value for this column be
364 manifested for features which may may non-contiguous sublocations (e.g.
365 transcripts), since derivation at query time is non-trivial. For
366 expressed sequence, the DNA sequence should be used rather than the
367 RNA sequence. The default storage method for the residues column is
368 EXTERNAL, which will store it uncompressed to make substring operations
369 faster. </td> <td class="FieldCellFK"></td>
370 </tr>
371
372 <tr class="tr-odd">
373 <td class="FieldCellName"><a name="feature-seqlen">seqlen</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">The length of the residue feature. See
374 column:residues. This column is partially redundant with the residues
375 column, and also with featureloc. This column is required because the
376 location may be unknown and the residue sequence may not be
377 manifested, yet it may be desirable to store and query the length of
378 the feature. The seqlen should always be manifested where the length
379 of the sequence is known. </td> <td class="FieldCellFK"></td>
380 </tr>
381
382 <tr class="tr-even">
383 <td class="FieldCellName"><a name="feature-md5checksum">md5checksum</a></td> <td class="FieldCellType">char</td> <td class="FieldCellSize">32</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">The 32-character checksum of the sequence,
384 calculated using the MD5 algorithm. This is practically guaranteed to
385 be unique for any feature. This column thus acts as a unique
386 identifier on the mathematical sequence. </td> <td class="FieldCellFK"></td>
387 </tr>
388
389 <tr class="tr-odd">
390 <td class="FieldCellName"><a name="feature-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, A required reference to a table:cvterm
391 giving the feature type. This will typically be a Sequence Ontology
392 identifier. This column is thus used to subclass the feature table. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
393 </tr>
394
395 <tr class="tr-even">
396 <td class="FieldCellName"><a name="feature-is_analysis">is_analysis</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">false</td> <td class="FieldCellOther">NOT NULL, Boolean indicating whether this
397 feature is annotated or the result of an automated analysis. Analysis
398 results also use the companalysis module. Note that the dividing line
399 between analysis and annotation may be fuzzy, this should be determined on
400 a per-project basis in a consistent manner. One requirement is that
401 there should only be one non-analysis version of each wild-type gene
402 feature in a genome, whereas the same gene feature can be predicted
403 multiple times in different analyses. </td> <td class="FieldCellFK"></td>
404 </tr>
405
406 <tr class="tr-odd">
407 <td class="FieldCellName"><a name="feature-is_obsolete">is_obsolete</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">false</td> <td class="FieldCellOther">NOT NULL, Boolean indicating whether this
408 feature has been obsoleted. Some chado instances may choose to simply
409 remove the feature altogether, others may choose to keep an obsolete
410 row in the table. </td> <td class="FieldCellFK"></td>
411 </tr>
412
413 <tr class="tr-even">
414 <td class="FieldCellName"><a name="feature-timeaccessioned">timeaccessioned</a></td> <td class="FieldCellType">timestamp</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">current_timestamp</td> <td class="FieldCellOther">NOT NULL, For handling object
415 accession or modification timestamps (as opposed to database auditing data,
416 handled elsewhere). The expectation is that these fields would be
417 available to software interacting with chado. </td> <td class="FieldCellFK"></td>
418 </tr>
419
420 <tr class="tr-odd">
421 <td class="FieldCellName"><a name="feature-timelastmodified">timelastmodified</a></td> <td class="FieldCellType">timestamp</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">current_timestamp</td> <td class="FieldCellOther">NOT NULL, For handling object
422 accession or modification timestamps (as opposed to database auditing data,
423 handled elsewhere). The expectation is that these fields would be
424 available to software interacting with chado. </td> <td class="FieldCellFK"></td>
425 </tr>
426
427 </table>
428
429 <h3>
430 Indices
431 </h3>
432
433 <table border="1">
434
435 <tr class="IndexRow">
436 <th>
437 Name
438 </th>
439 <th>
440 Fields
441 </th>
442 </tr>
443
444 <tr class="IndexCell">
445 <td>feature_name_ind1</td><td>name</td>
446 </tr>
447
448 <tr class="IndexCell">
449 <td>feature_idx1</td><td>dbxref_id</td>
450 </tr>
451
452 <tr class="IndexCell">
453 <td>feature_idx2</td><td>organism_id</td>
454 </tr>
455
456 <tr class="IndexCell">
457 <td>feature_idx3</td><td>type_id</td>
458 </tr>
459
460 <tr class="IndexCell">
461 <td>feature_idx4</td><td>uniquename</td>
462 </tr>
463
464 </table>
465
466 <h3>
467 Constraints
468 </h3>
469
470 <table border="1">
471
472 <tr class="IndexRow">
473 <th>
474 Type
475 </th>
476 <th>
477 Fields
478 </th>
479 </tr>
480
481 <tr class="IndexCell">
482 <td>NOT NULL</td><td>feature_id</td>
483 </tr>
484
485 <tr class="IndexCell">
486 <td>FOREIGN KEY</td><td>dbxref_id</td>
487 </tr>
488
489 <tr class="IndexCell">
490 <td>NOT NULL</td><td>organism_id</td>
491 </tr>
492
493 <tr class="IndexCell">
494 <td>FOREIGN KEY</td><td>organism_id</td>
495 </tr>
496
497 <tr class="IndexCell">
498 <td>NOT NULL</td><td>uniquename</td>
499 </tr>
500
501 <tr class="IndexCell">
502 <td>NOT NULL</td><td>type_id</td>
503 </tr>
504
505 <tr class="IndexCell">
506 <td>FOREIGN KEY</td><td>type_id</td>
507 </tr>
508
509 <tr class="IndexCell">
510 <td>NOT NULL</td><td>is_analysis</td>
511 </tr>
512
513 <tr class="IndexCell">
514 <td>NOT NULL</td><td>is_obsolete</td>
515 </tr>
516
517 <tr class="IndexCell">
518 <td>NOT NULL</td><td>timeaccessioned</td>
519 </tr>
520
521 <tr class="IndexCell">
522 <td>NOT NULL</td><td>timelastmodified</td>
523 </tr>
524
525 <tr class="IndexCell">
526 <td>UNIQUE</td><td>organism_id, uniquename, type_id</td>
527 </tr>
528
529 </table>
530
531 <hr />
532
533 <!--
534 Starting table 'featureloc'
535 -->
536
537 <a name="featureloc" />
538
539 <table width="100%" class="TableHeader">
540 <tr class="TableHeaderRow">
541 <td class="TableHeaderCell"><h3>
542 featureloc
543 </h3></td> <a name="featureloc"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
544 </tr>
545 </table>
546
547 <b>
548 Comments:
549 </b>
550
551 <br />
552
553 <em>
554 <br />
555 COMMENT ON INDEX feature_c1 IS 'Any feature can be globally identified <br />
556 by the combination of organism, uniquename and feature type'; <br />
557 ================================================ <br />
558 TABLE: featureloc <br />
559 ================================================ <br />
560 The location of a feature relative to
561 another feature. Important: interbase coordinates are used. This is
562 vital as it allows us to represent zero-length features e.g. splice
563 sites, insertion points without an awkward fuzzy system. Features
564 typically have exactly ONE location, but this need not be the
565 case. Some features may not be localized (e.g. a gene that has been
566 characterized genetically but no sequence or molecular information is
567 available). Note on multiple locations: Each feature can have 0 or
568 more locations. Multiple locations do NOT indicate non-contiguous
569 locations (if a feature such as a transcript has a non-contiguous
570 location, then the subfeatures such as exons should always be
571 manifested). Instead, multiple featurelocs for a feature designate
572 alternate locations or grouped locations; for instance, a feature
573 designating a blast hit or hsp will have two locations, one on the
574 query feature, one on the subject feature. Features representing
575 sequence variation could have alternate locations instantiated on a
576 feature on the mutant strain. The column:rank is used to
577 differentiate these different locations. Reflexive locations should
578 never be stored - this is for -proper- (i.e. non-self) locations only; nothing should be located relative to itself.
579 </em>
580
581 <table border="1">
582
583 <tr>
584 <th class="FieldHeader">
585 Field Name
586 </th>
587 <th class="FieldHeader">
588 Data Type
589 </th>
590 <th class="FieldHeader">
591 Size
592 </th>
593 <th class="FieldHeader">
594 Default Value
595 </th>
596 <th class="FieldHeader">
597 Other
598 </th>
599 <th class="FieldHeader">
600 Foreign Key
601 </th>
602 </tr>
603
604 <tr class="tr-odd">
605 <td class="FieldCellName"><a name="featureloc-featureloc_id">featureloc_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>
606 </tr>
607
608 <tr class="tr-even">
609 <td class="FieldCellName"><a name="featureloc-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, The feature that is being located. Any feature can have zero or more featurelocs. </td> <td class="FieldCellFK"><a href="#feature-feature_id">feature.feature_id</a></td>
610 </tr>
611
612 <tr class="tr-odd">
613 <td class="FieldCellName"><a name="featureloc-srcfeature_id">srcfeature_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">The source feature which this location is relative to. Every location is relative to another feature (however, this column is nullable, because the srcfeature may not be known). All locations are -proper- that is, nothing should be located relative to itself. No cycles are allowed in the featureloc graph. </td> <td class="FieldCellFK"><a href="#feature-feature_id">feature.feature_id</a></td>
614 </tr>
615
616 <tr class="tr-even">
617 <td class="FieldCellName"><a name="featureloc-fmin">fmin</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">The leftmost/minimal boundary in the linear range represented by the featureloc. Sometimes (e.g. in Bioperl) this is called -start- although this is confusing because it does not necessarily represent the 5-prime coordinate. Important: This is space-based (interbase) coordinates, counting from zero. To convert this to the leftmost position in a base-oriented system (eg GFF, Bioperl), add 1 to fmin. </td> <td class="FieldCellFK"></td>
618 </tr>
619
620 <tr class="tr-odd">
621 <td class="FieldCellName"><a name="featureloc-is_fmin_partial">is_fmin_partial</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">false</td> <td class="FieldCellOther">NOT NULL, This is typically
622 false, but may be true if the value for column:fmin is inaccurate or
623 the leftmost part of the range is unknown/unbounded. </td> <td class="FieldCellFK"></td>
624 </tr>
625
626 <tr class="tr-even">
627 <td class="FieldCellName"><a name="featureloc-fmax">fmax</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">The rightmost/maximal boundary in the linear range represented by the featureloc. Sometimes (e.g. in bioperl) this is called -end- although this is confusing because it does not necessarily represent the 3-prime coordinate. Important: This is space-based (interbase) coordinates, counting from zero. No conversion is required to go from fmax to the rightmost coordinate in a base-oriented system that counts from 1 (e.g. GFF, Bioperl). </td> <td class="FieldCellFK"></td>
628 </tr>
629
630 <tr class="tr-odd">
631 <td class="FieldCellName"><a name="featureloc-is_fmax_partial">is_fmax_partial</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">false</td> <td class="FieldCellOther">NOT NULL, This is typically
632 false, but may be true if the value for column:fmax is inaccurate or
633 the rightmost part of the range is unknown/unbounded. </td> <td class="FieldCellFK"></td>
634 </tr>
635
636 <tr class="tr-even">
637 <td class="FieldCellName"><a name="featureloc-strand">strand</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">5</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">The orientation/directionality of the
638 location. Should be 0, -1 or +1. </td> <td class="FieldCellFK"></td>
639 </tr>
640
641 <tr class="tr-odd">
642 <td class="FieldCellName"><a name="featureloc-phase">phase</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">Phase of translation with
643 respect to srcfeature_id.
644 Values are 0, 1, 2. It may not be possible to manifest this column for
645 some features such as exons, because the phase is dependant on the
646 spliceform (the same exon can appear in multiple spliceforms). This column is mostly useful for predicted exons and CDSs. </td> <td class="FieldCellFK"></td>
647 </tr>
648
649 <tr class="tr-even">
650 <td class="FieldCellName"><a name="featureloc-residue_info">residue_info</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">Alternative residues,
651 when these differ from feature.residues. For instance, a SNP feature
652 located on a wild and mutant protein would have different alternative residues.
653 for alignment/similarity features, the alternative residues is used to
654 represent the alignment string (CIGAR format). Note on variation
655 features; even if we do not want to instantiate a mutant
656 chromosome/contig feature, we can still represent a SNP etc with 2
657 locations, one (rank 0) on the genome, the other (rank 1) would have
658 most fields null, except for alternative residues. </td> <td class="FieldCellFK"></td>
659 </tr>
660
661 <tr class="tr-odd">
662 <td class="FieldCellName"><a name="featureloc-locgroup">locgroup</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL, This is used to manifest redundant,
663 derivable extra locations for a feature. The default locgroup=0 is
664 used for the DIRECT location of a feature. Important: most Chado users may
665 never use featurelocs WITH logroup > 0. Transitively derived locations
666 are indicated with locgroup > 0. For example, the position of an exon on
667 a BAC and in global chromosome coordinates. This column is used to
668 differentiate these groupings of locations. The default locgroup 0
669 is used for the main or primary location, from which the others can be
670 derived via coordinate transformations. Another example of redundant
671 locations is storing ORF coordinates relative to both transcript and
672 genome. Redundant locations open the possibility of the database
673 getting into inconsistent states; this schema gives us the flexibility
674 of both warehouse instantiations with redundant locations (easier for
675 querying) and management instantiations with no redundant
676 locations. An example of using both locgroup and rank: imagine a
677 feature indicating a conserved region between the chromosomes of two
678 different species. We may want to keep redundant locations on both
679 contigs and chromosomes. We would thus have 4 locations for the single
680 conserved region feature - two distinct locgroups (contig level and
681 chromosome level) and two distinct ranks (for the two species). </td> <td class="FieldCellFK"></td>
682 </tr>
683
684 <tr class="tr-even">
685 <td class="FieldCellName"><a name="featureloc-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, Used when a feature has >1
686 location, otherwise the default rank 0 is used. Some features (e.g.
687 blast hits and HSPs) have two locations - one on the query and one on
688 the subject. Rank is used to differentiate these. Rank=0 is always
689 used for the query, Rank=1 for the subject. For multiple alignments,
690 assignment of rank is arbitrary. Rank is also used for
691 sequence_variant features, such as SNPs. Rank=0 indicates the wildtype
692 (or baseline) feature, Rank=1 indicates the mutant (or compared) feature. </td> <td class="FieldCellFK"></td>
693 </tr>
694
695 </table>
696
697 <h3>
698 Indices
699 </h3>
700
701 <table border="1">
702
703 <tr class="IndexRow">
704 <th>
705 Name
706 </th>
707 <th>
708 Fields
709 </th>
710 </tr>
711
712 <tr class="IndexCell">
713 <td>featureloc_idx1</td><td>feature_id</td>
714 </tr>
715
716 <tr class="IndexCell">
717 <td>featureloc_idx2</td><td>srcfeature_id</td>
718 </tr>
719
720 <tr class="IndexCell">
721 <td>featureloc_idx3</td><td>srcfeature_id, fmin, fmax</td>
722 </tr>
723
724 </table>
725
726 <h3>
727 Constraints
728 </h3>
729
730 <table border="1">
731
732 <tr class="IndexRow">
733 <th>
734 Type
735 </th>
736 <th>
737 Fields
738 </th>
739 </tr>
740
741 <tr class="IndexCell">
742 <td>NOT NULL</td><td>featureloc_id</td>
743 </tr>
744
745 <tr class="IndexCell">
746 <td>NOT NULL</td><td>feature_id</td>
747 </tr>
748
749 <tr class="IndexCell">
750 <td>FOREIGN KEY</td><td>feature_id</td>
751 </tr>
752
753 <tr class="IndexCell">
754 <td>FOREIGN KEY</td><td>srcfeature_id</td>
755 </tr>
756
757 <tr class="IndexCell">
758 <td>NOT NULL</td><td>is_fmin_partial</td>
759 </tr>
760
761 <tr class="IndexCell">
762 <td>NOT NULL</td><td>is_fmax_partial</td>
763 </tr>
764
765 <tr class="IndexCell">
766 <td>NOT NULL</td><td>locgroup</td>
767 </tr>
768
769 <tr class="IndexCell">
770 <td>NOT NULL</td><td>rank</td>
771 </tr>
772
773 <tr class="IndexCell">
774 <td>UNIQUE</td><td>feature_id, locgroup, rank</td>
775 </tr>
776
777 <tr class="IndexCell">
778 <td>CHECK</td><td></td>
779 </tr>
780
781 </table>
782
783 <hr />
784
785 <!--
786 Starting table 'featureloc_pub'
787 -->
788
789 <a name="featureloc_pub" />
790
791 <table class="TableHeader" width="100%">
792 <tr class="TableHeaderRow">
793 <td class="TableHeaderCell"><h3>
794 featureloc_pub
795 </h3></td> <a name="featureloc_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
796 </tr>
797 </table>
798
799 <b>
800 Comments:
801 </b>
802
803 <br />
804
805 <em>
806 <br />
807 COMMENT ON INDEX featureloc_c1 IS 'locgroup and rank serve to uniquely <br />
808 partition locations for any one feature'; <br />
809 ================================================ <br />
810 TABLE: featureloc_pub <br />
811 ================================================ <br />
812 Provenance of featureloc. Linking table between featurelocs and publications that mention them.
813 </em>
814
815 <table border="1">
816
817 <tr>
818 <th class="FieldHeader">
819 Field Name
820 </th>
821 <th class="FieldHeader">
822 Data Type
823 </th>
824 <th class="FieldHeader">
825 Size
826 </th>
827 <th class="FieldHeader">
828 Default Value
829 </th>
830 <th class="FieldHeader">
831 Other
832 </th>
833 <th class="FieldHeader">
834 Foreign Key
835 </th>
836 </tr>
837
838 <tr class="tr-odd">
839 <td class="FieldCellName"><a name="featureloc_pub-featureloc_pub_id">featureloc_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>
840 </tr>
841
842 <tr class="tr-even">
843 <td class="FieldCellName"><a name="featureloc_pub-featureloc_id">featureloc_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="#featureloc-featureloc_id">featureloc.featureloc_id</a></td>
844 </tr>
845
846 <tr class="tr-odd">
847 <td class="FieldCellName"><a name="featureloc_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>
848 </tr>
849
850 </table>
851
852 <h3>
853 Indices
854 </h3>
855
856 <table border="1">
857
858 <tr class="IndexRow">
859 <th>
860 Name
861 </th>
862 <th>
863 Fields
864 </th>
865 </tr>
866
867 <tr class="IndexCell">
868 <td>featureloc_pub_idx1</td><td>featureloc_id</td>
869 </tr>
870
871 <tr class="IndexCell">
872 <td>featureloc_pub_idx2</td><td>pub_id</td>
873 </tr>
874
875 </table>
876
877 <h3>
878 Constraints
879 </h3>
880
881 <table border="1">
882
883 <tr class="IndexRow">
884 <th>
885 Type
886 </th>
887 <th>
888 Fields
889 </th>
890 </tr>
891
892 <tr class="IndexCell">
893 <td>NOT NULL</td><td>featureloc_pub_id</td>
894 </tr>
895
896 <tr class="IndexCell">
897 <td>NOT NULL</td><td>featureloc_id</td>
898 </tr>
899
900 <tr class="IndexCell">
901 <td>FOREIGN KEY</td><td>featureloc_id</td>
902 </tr>
903
904 <tr class="IndexCell">
905 <td>NOT NULL</td><td>pub_id</td>
906 </tr>
907
908 <tr class="IndexCell">
909 <td>FOREIGN KEY</td><td>pub_id</td>
910 </tr>
911
912 <tr class="IndexCell">
913 <td>UNIQUE</td><td>featureloc_id, pub_id</td>
914 </tr>
915
916 </table>
917
918 <hr />
919
920 <!--
921 Starting table 'feature_pub'
922 -->
923
924 <a name="feature_pub" />
925
926 <table width="100%" class="TableHeader">
927 <tr class="TableHeaderRow">
928 <td class="TableHeaderCell"><h3>
929 feature_pub
930 </h3></td> <a name="feature_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
931 </tr>
932 </table>
933
934 <b>
935 Comments:
936 </b>
937
938 <br />
939
940 <em>
941 <br />
942 ================================================ <br />
943 TABLE: feature_pub <br />
944 ================================================ <br />
945 Provenance. Linking table between features and publications that mention them.
946 </em>
947
948 <table border="1">
949
950 <tr>
951 <th class="FieldHeader">
952 Field Name
953 </th>
954 <th class="FieldHeader">
955 Data Type
956 </th>
957 <th class="FieldHeader">
958 Size
959 </th>
960 <th class="FieldHeader">
961 Default Value
962 </th>
963 <th class="FieldHeader">
964 Other
965 </th>
966 <th class="FieldHeader">
967 Foreign Key
968 </th>
969 </tr>
970
971 <tr class="tr-odd">
972 <td class="FieldCellName"><a name="feature_pub-feature_pub_id">feature_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>
973 </tr>
974
975 <tr class="tr-even">
976 <td class="FieldCellName"><a name="feature_pub-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>
977 </tr>
978
979 <tr class="tr-odd">
980 <td class="FieldCellName"><a name="feature_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>
981 </tr>
982
983 </table>
984
985 <h3>
986 Indices
987 </h3>
988
989 <table border="1">
990
991 <tr class="IndexRow">
992 <th>
993 Name
994 </th>
995 <th>
996 Fields
997 </th>
998 </tr>
999
1000 <tr class="IndexCell">
1001 <td>feature_pub_idx1</td><td>feature_id</td>
1002 </tr>
1003
1004 <tr class="IndexCell">
1005 <td>feature_pub_idx2</td><td>pub_id</td>
1006 </tr>
1007
1008 </table>
1009
1010 <h3>
1011 Constraints
1012 </h3>
1013
1014 <table border="1">
1015
1016 <tr class="IndexRow">
1017 <th>
1018 Type
1019 </th>
1020 <th>
1021 Fields
1022 </th>
1023 </tr>
1024
1025 <tr class="IndexCell">
1026 <td>NOT NULL</td><td>feature_pub_id</td>
1027 </tr>
1028
1029 <tr class="IndexCell">
1030 <td>NOT NULL</td><td>feature_id</td>
1031 </tr>
1032
1033 <tr class="IndexCell">
1034 <td>FOREIGN KEY</td><td>feature_id</td>
1035 </tr>
1036
1037 <tr class="IndexCell">
1038 <td>NOT NULL</td><td>pub_id</td>
1039 </tr>
1040
1041 <tr class="IndexCell">
1042 <td>FOREIGN KEY</td><td>pub_id</td>
1043 </tr>
1044
1045 <tr class="IndexCell">
1046 <td>UNIQUE</td><td>feature_id, pub_id</td>
1047 </tr>
1048
1049 </table>
1050
1051 <hr />
1052
1053 <!--
1054 Starting table 'feature_pubprop'
1055 -->
1056
1057 <a name="feature_pubprop" />
1058
1059 <table width="100%" class="TableHeader">
1060 <tr class="TableHeaderRow">
1061 <td class="TableHeaderCell"><h3>
1062 feature_pubprop
1063 </h3></td> <a name="feature_pubprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1064 </tr>
1065 </table>
1066
1067 <b>
1068 Comments:
1069 </b>
1070
1071 <br />
1072
1073 <em>
1074 <br />
1075 ================================================ <br />
1076 TABLE: feature_pubprop <br />
1077 ================================================ <br />
1078 Property or attribute of a feature_pub link.
1079 </em>
1080
1081 <table border="1">
1082
1083 <tr>
1084 <th class="FieldHeader">
1085 Field Name
1086 </th>
1087 <th class="FieldHeader">
1088 Data Type
1089 </th>
1090 <th class="FieldHeader">
1091 Size
1092 </th>
1093 <th class="FieldHeader">
1094 Default Value
1095 </th>
1096 <th class="FieldHeader">
1097 Other
1098 </th>
1099 <th class="FieldHeader">
1100 Foreign Key
1101 </th>
1102 </tr>
1103
1104 <tr class="tr-odd">
1105 <td class="FieldCellName"><a name="feature_pubprop-feature_pubprop_id">feature_pubprop_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>
1106 </tr>
1107
1108 <tr class="tr-even">
1109 <td class="FieldCellName"><a name="feature_pubprop-feature_pub_id">feature_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="#feature_pub-feature_pub_id">feature_pub.feature_pub_id</a></td>
1110 </tr>
1111
1112 <tr class="tr-odd">
1113 <td class="FieldCellName"><a name="feature_pubprop-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>
1114 </tr>
1115
1116 <tr class="tr-even">
1117 <td class="FieldCellName"><a name="feature_pubprop-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>
1118 </tr>
1119
1120 <tr class="tr-odd">
1121 <td class="FieldCellName"><a name="feature_pubprop-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>
1122 </tr>
1123
1124 </table>
1125
1126 <h3>
1127 Indices
1128 </h3>
1129
1130 <table border="1">
1131
1132 <tr class="IndexRow">
1133 <th>
1134 Name
1135 </th>
1136 <th>
1137 Fields
1138 </th>
1139 </tr>
1140
1141 <tr class="IndexCell">
1142 <td>feature_pubprop_idx1</td><td>feature_pub_id</td>
1143 </tr>
1144
1145 </table>
1146
1147 <h3>
1148 Constraints
1149 </h3>
1150
1151 <table border="1">
1152
1153 <tr class="IndexRow">
1154 <th>
1155 Type
1156 </th>
1157 <th>
1158 Fields
1159 </th>
1160 </tr>
1161
1162 <tr class="IndexCell">
1163 <td>NOT NULL</td><td>feature_pubprop_id</td>
1164 </tr>
1165
1166 <tr class="IndexCell">
1167 <td>NOT NULL</td><td>feature_pub_id</td>
1168 </tr>
1169
1170 <tr class="IndexCell">
1171 <td>FOREIGN KEY</td><td>feature_pub_id</td>
1172 </tr>
1173
1174 <tr class="IndexCell">
1175 <td>NOT NULL</td><td>type_id</td>
1176 </tr>
1177
1178 <tr class="IndexCell">
1179 <td>FOREIGN KEY</td><td>type_id</td>
1180 </tr>
1181
1182 <tr class="IndexCell">
1183 <td>NOT NULL</td><td>rank</td>
1184 </tr>
1185
1186 <tr class="IndexCell">
1187 <td>UNIQUE</td><td>feature_pub_id, type_id, rank</td>
1188 </tr>
1189
1190 </table>
1191
1192 <hr />
1193
1194 <!--
1195 Starting table 'featureprop'
1196 -->
1197
1198 <a name="featureprop" />
1199
1200 <table class="TableHeader" width="100%">
1201 <tr class="TableHeaderRow">
1202 <td class="TableHeaderCell"><h3>
1203 featureprop
1204 </h3></td> <a name="featureprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1205 </tr>
1206 </table>
1207
1208 <b>
1209 Comments:
1210 </b>
1211
1212 <br />
1213
1214 <em>
1215 <br />
1216 ================================================ <br />
1217 TABLE: featureprop <br />
1218 ================================================ <br />
1219 A feature can have any number of slot-value property tags attached to it. This is an alternative to hardcoding a list of columns in the relational schema, and is completely extensible.
1220 </em>
1221
1222 <table border="1">
1223
1224 <tr>
1225 <th class="FieldHeader">
1226 Field Name
1227 </th>
1228 <th class="FieldHeader">
1229 Data Type
1230 </th>
1231 <th class="FieldHeader">
1232 Size
1233 </th>
1234 <th class="FieldHeader">
1235 Default Value
1236 </th>
1237 <th class="FieldHeader">
1238 Other
1239 </th>
1240 <th class="FieldHeader">
1241 Foreign Key
1242 </th>
1243 </tr>
1244
1245 <tr class="tr-odd">
1246 <td class="FieldCellName"><a name="featureprop-featureprop_id">featureprop_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>
1247 </tr>
1248
1249 <tr class="tr-even">
1250 <td class="FieldCellName"><a name="featureprop-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>
1251 </tr>
1252
1253 <tr class="tr-odd">
1254 <td class="FieldCellName"><a name="featureprop-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
1255 property/slot is a cvterm. The meaning of the property is defined in
1256 that cvterm. Certain property types will only apply to certain feature
1257 types (e.g. the anticodon property will only apply to tRNA features) ;
1258 the types here come from the sequence feature property ontology. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1259 </tr>
1260
1261 <tr class="tr-even">
1262 <td class="FieldCellName"><a name="featureprop-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. Numeric values are converted to their text representation. This is less efficient than using native database types, but is easier to query. </td> <td class="FieldCellFK"></td>
1263 </tr>
1264
1265 <tr class="tr-odd">
1266 <td class="FieldCellName"><a name="featureprop-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
1267 feature can have multiple values for any particular property type -
1268 these are ordered in a list using rank, counting from zero. For
1269 properties that are single-valued rather than multi-valued, the
1270 default 0 value should be used </td> <td class="FieldCellFK"></td>
1271 </tr>
1272
1273 </table>
1274
1275 <h3>
1276 Indices
1277 </h3>
1278
1279 <table border="1">
1280
1281 <tr class="IndexRow">
1282 <th>
1283 Name
1284 </th>
1285 <th>
1286 Fields
1287 </th>
1288 </tr>
1289
1290 <tr class="IndexCell">
1291 <td>featureprop_idx1</td><td>feature_id</td>
1292 </tr>
1293
1294 <tr class="IndexCell">
1295 <td>featureprop_idx2</td><td>type_id</td>
1296 </tr>
1297
1298 </table>
1299
1300 <h3>
1301 Constraints
1302 </h3>
1303
1304 <table border="1">
1305
1306 <tr class="IndexRow">
1307 <th>
1308 Type
1309 </th>
1310 <th>
1311 Fields
1312 </th>
1313 </tr>
1314
1315 <tr class="IndexCell">
1316 <td>NOT NULL</td><td>featureprop_id</td>
1317 </tr>
1318
1319 <tr class="IndexCell">
1320 <td>NOT NULL</td><td>feature_id</td>
1321 </tr>
1322
1323 <tr class="IndexCell">
1324 <td>FOREIGN KEY</td><td>feature_id</td>
1325 </tr>
1326
1327 <tr class="IndexCell">
1328 <td>NOT NULL</td><td>type_id</td>
1329 </tr>
1330
1331 <tr class="IndexCell">
1332 <td>FOREIGN KEY</td><td>type_id</td>
1333 </tr>
1334
1335 <tr class="IndexCell">
1336 <td>NOT NULL</td><td>rank</td>
1337 </tr>
1338
1339 <tr class="IndexCell">
1340 <td>UNIQUE</td><td>feature_id, type_id, rank</td>
1341 </tr>
1342
1343 </table>
1344
1345 <hr />
1346
1347 <!--
1348 Starting table 'featureprop_pub'
1349 -->
1350
1351 <a name="featureprop_pub" />
1352
1353 <table class="TableHeader" width="100%">
1354 <tr class="TableHeaderRow">
1355 <td class="TableHeaderCell"><h3>
1356 featureprop_pub
1357 </h3></td> <a name="featureprop_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1358 </tr>
1359 </table>
1360
1361 <b>
1362 Comments:
1363 </b>
1364
1365 <br />
1366
1367 <em>
1368 <br />
1369 For any one feature, multivalued
1370 property-value pairs must be differentiated by rank. <br />
1371 ================================================ <br />
1372 TABLE: featureprop_pub <br />
1373 ================================================ <br />
1374 Provenance. Any featureprop assignment can optionally be supported by a publication.
1375 </em>
1376
1377 <table border="1">
1378
1379 <tr>
1380 <th class="FieldHeader">
1381 Field Name
1382 </th>
1383 <th class="FieldHeader">
1384 Data Type
1385 </th>
1386 <th class="FieldHeader">
1387 Size
1388 </th>
1389 <th class="FieldHeader">
1390 Default Value
1391 </th>
1392 <th class="FieldHeader">
1393 Other
1394 </th>
1395 <th class="FieldHeader">
1396 Foreign Key
1397 </th>
1398 </tr>
1399
1400 <tr class="tr-odd">
1401 <td class="FieldCellName"><a name="featureprop_pub-featureprop_pub_id">featureprop_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>
1402 </tr>
1403
1404 <tr class="tr-even">
1405 <td class="FieldCellName"><a name="featureprop_pub-featureprop_id">featureprop_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="#featureprop-featureprop_id">featureprop.featureprop_id</a></td>
1406 </tr>
1407
1408 <tr class="tr-odd">
1409 <td class="FieldCellName"><a name="featureprop_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>
1410 </tr>
1411
1412 </table>
1413
1414 <h3>
1415 Indices
1416 </h3>
1417
1418 <table border="1">
1419
1420 <tr class="IndexRow">
1421 <th>
1422 Name
1423 </th>
1424 <th>
1425 Fields
1426 </th>
1427 </tr>
1428
1429 <tr class="IndexCell">
1430 <td>featureprop_pub_idx1</td><td>featureprop_id</td>
1431 </tr>
1432
1433 <tr class="IndexCell">
1434 <td>featureprop_pub_idx2</td><td>pub_id</td>
1435 </tr>
1436
1437 </table>
1438
1439 <h3>
1440 Constraints
1441 </h3>
1442
1443 <table border="1">
1444
1445 <tr class="IndexRow">
1446 <th>
1447 Type
1448 </th>
1449 <th>
1450 Fields
1451 </th>
1452 </tr>
1453
1454 <tr class="IndexCell">
1455 <td>NOT NULL</td><td>featureprop_pub_id</td>
1456 </tr>
1457
1458 <tr class="IndexCell">
1459 <td>NOT NULL</td><td>featureprop_id</td>
1460 </tr>
1461
1462 <tr class="IndexCell">
1463 <td>FOREIGN KEY</td><td>featureprop_id</td>
1464 </tr>
1465
1466 <tr class="IndexCell">
1467 <td>NOT NULL</td><td>pub_id</td>
1468 </tr>
1469
1470 <tr class="IndexCell">
1471 <td>FOREIGN KEY</td><td>pub_id</td>
1472 </tr>
1473
1474 <tr class="IndexCell">
1475 <td>UNIQUE</td><td>featureprop_id, pub_id</td>
1476 </tr>
1477
1478 </table>
1479
1480 <hr />
1481
1482 <!--
1483 Starting table 'feature_dbxref'
1484 -->
1485
1486 <a name="feature_dbxref" />
1487
1488 <table class="TableHeader" width="100%">
1489 <tr class="TableHeaderRow">
1490 <td class="TableHeaderCell"><h3>
1491 feature_dbxref
1492 </h3></td> <a name="feature_dbxref"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1493 </tr>
1494 </table>
1495
1496 <b>
1497 Comments:
1498 </b>
1499
1500 <br />
1501
1502 <em>
1503 <br />
1504 ================================================ <br />
1505 TABLE: feature_dbxref <br />
1506 ================================================ <br />
1507 Links a feature to dbxrefs. This is for secondary identifiers; primary identifiers should use feature.dbxref_id.
1508 </em>
1509
1510 <table border="1">
1511
1512 <tr>
1513 <th class="FieldHeader">
1514 Field Name
1515 </th>
1516 <th class="FieldHeader">
1517 Data Type
1518 </th>
1519 <th class="FieldHeader">
1520 Size
1521 </th>
1522 <th class="FieldHeader">
1523 Default Value
1524 </th>
1525 <th class="FieldHeader">
1526 Other
1527 </th>
1528 <th class="FieldHeader">
1529 Foreign Key
1530 </th>
1531 </tr>
1532
1533 <tr class="tr-odd">
1534 <td class="FieldCellName"><a name="feature_dbxref-feature_dbxref_id">feature_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>
1535 </tr>
1536
1537 <tr class="tr-even">
1538 <td class="FieldCellName"><a name="feature_dbxref-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>
1539 </tr>
1540
1541 <tr class="tr-odd">
1542 <td class="FieldCellName"><a name="feature_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>
1543 </tr>
1544
1545 <tr class="tr-even">
1546 <td class="FieldCellName"><a name="feature_dbxref-is_current">is_current</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">true</td> <td class="FieldCellOther">NOT NULL, True if this secondary dbxref is the most up to date accession in the corresponding db. Retired accessions should set this field to false </td> <td class="FieldCellFK"></td>
1547 </tr>
1548
1549 </table>
1550
1551 <h3>
1552 Indices
1553 </h3>
1554
1555 <table border="1">
1556
1557 <tr class="IndexRow">
1558 <th>
1559 Name
1560 </th>
1561 <th>
1562 Fields
1563 </th>
1564 </tr>
1565
1566 <tr class="IndexCell">
1567 <td>feature_dbxref_idx1</td><td>feature_id</td>
1568 </tr>
1569
1570 <tr class="IndexCell">
1571 <td>feature_dbxref_idx2</td><td>dbxref_id</td>
1572 </tr>
1573
1574 </table>
1575
1576 <h3>
1577 Constraints
1578 </h3>
1579
1580 <table border="1">
1581
1582 <tr class="IndexRow">
1583 <th>
1584 Type
1585 </th>
1586 <th>
1587 Fields
1588 </th>
1589 </tr>
1590
1591 <tr class="IndexCell">
1592 <td>NOT NULL</td><td>feature_dbxref_id</td>
1593 </tr>
1594
1595 <tr class="IndexCell">
1596 <td>NOT NULL</td><td>feature_id</td>
1597 </tr>
1598
1599 <tr class="IndexCell">
1600 <td>FOREIGN KEY</td><td>feature_id</td>
1601 </tr>
1602
1603 <tr class="IndexCell">
1604 <td>NOT NULL</td><td>dbxref_id</td>
1605 </tr>
1606
1607 <tr class="IndexCell">
1608 <td>FOREIGN KEY</td><td>dbxref_id</td>
1609 </tr>
1610
1611 <tr class="IndexCell">
1612 <td>NOT NULL</td><td>is_current</td>
1613 </tr>
1614
1615 <tr class="IndexCell">
1616 <td>UNIQUE</td><td>feature_id, dbxref_id</td>
1617 </tr>
1618
1619 </table>
1620
1621 <hr />
1622
1623 <!--
1624 Starting table 'feature_relationship'
1625 -->
1626
1627 <a name="feature_relationship" />
1628
1629 <table class="TableHeader" width="100%">
1630 <tr class="TableHeaderRow">
1631 <td class="TableHeaderCell"><h3>
1632 feature_relationship
1633 </h3></td> <a name="feature_relationship"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1634 </tr>
1635 </table>
1636
1637 <b>
1638 Comments:
1639 </b>
1640
1641 <br />
1642
1643 <em>
1644 <br />
1645 ================================================ <br />
1646 TABLE: feature_relationship <br />
1647 ================================================ <br />
1648 Features can be arranged in
1649 graphs, e.g. "exon part_of transcript part_of gene"; If type is
1650 thought of as a verb, the each arc or edge makes a statement
1651 [Subject Verb Object]. The object can also be thought of as parent
1652 (containing feature), and subject as child (contained feature or
1653 subfeature). We include the relationship rank/order, because even
1654 though most of the time we can order things implicitly by sequence
1655 coordinates, we can not always do this - e.g. transpliced genes. It is also
1656 useful for quickly getting implicit introns.
1657 </em>
1658
1659 <table border="1">
1660
1661 <tr>
1662 <th class="FieldHeader">
1663 Field Name
1664 </th>
1665 <th class="FieldHeader">
1666 Data Type
1667 </th>
1668 <th class="FieldHeader">
1669 Size
1670 </th>
1671 <th class="FieldHeader">
1672 Default Value
1673 </th>
1674 <th class="FieldHeader">
1675 Other
1676 </th>
1677 <th class="FieldHeader">
1678 Foreign Key
1679 </th>
1680 </tr>
1681
1682 <tr class="tr-odd">
1683 <td class="FieldCellName"><a name="feature_relationship-feature_relationship_id">feature_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>
1684 </tr>
1685
1686 <tr class="tr-even">
1687 <td class="FieldCellName"><a name="feature_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, The subject of the subj-predicate-obj sentence. This is typically the subfeature. </td> <td class="FieldCellFK"><a href="#feature-feature_id">feature.feature_id</a></td>
1688 </tr>
1689
1690 <tr class="tr-odd">
1691 <td class="FieldCellName"><a name="feature_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, The object of the subj-predicate-obj sentence. This is typically the container feature. </td> <td class="FieldCellFK"><a href="#feature-feature_id">feature.feature_id</a></td>
1692 </tr>
1693
1694 <tr class="tr-even">
1695 <td class="FieldCellName"><a name="feature_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, Relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed. The most common relationship type is OBO_REL:part_of. Valid relationship types are constrained by the Sequence Ontology. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1696 </tr>
1697
1698 <tr class="tr-odd">
1699 <td class="FieldCellName"><a name="feature_relationship-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">Additional notes or comments. </td> <td class="FieldCellFK"></td>
1700 </tr>
1701
1702 <tr class="tr-even">
1703 <td class="FieldCellName"><a name="feature_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, The ordering of subject features with respect to the object feature may be important (for example, exon ordering on a transcript - not always derivable if you take trans spliced genes into consideration). Rank is used to order these; starts from zero. </td> <td class="FieldCellFK"></td>
1704 </tr>
1705
1706 </table>
1707
1708 <h3>
1709 Indices
1710 </h3>
1711
1712 <table border="1">
1713
1714 <tr class="IndexRow">
1715 <th>
1716 Name
1717 </th>
1718 <th>
1719 Fields
1720 </th>
1721 </tr>
1722
1723 <tr class="IndexCell">
1724 <td>feature_relationship_idx1</td><td>subject_id</td>
1725 </tr>
1726
1727 <tr class="IndexCell">
1728 <td>feature_relationship_idx2</td><td>object_id</td>
1729 </tr>
1730
1731 <tr class="IndexCell">
1732 <td>feature_relationship_idx3</td><td>type_id</td>
1733 </tr>
1734
1735 </table>
1736
1737 <h3>
1738 Constraints
1739 </h3>
1740
1741 <table border="1">
1742
1743 <tr class="IndexRow">
1744 <th>
1745 Type
1746 </th>
1747 <th>
1748 Fields
1749 </th>
1750 </tr>
1751
1752 <tr class="IndexCell">
1753 <td>NOT NULL</td><td>feature_relationship_id</td>
1754 </tr>
1755
1756 <tr class="IndexCell">
1757 <td>NOT NULL</td><td>subject_id</td>
1758 </tr>
1759
1760 <tr class="IndexCell">
1761 <td>FOREIGN KEY</td><td>subject_id</td>
1762 </tr>
1763
1764 <tr class="IndexCell">
1765 <td>NOT NULL</td><td>object_id</td>
1766 </tr>
1767
1768 <tr class="IndexCell">
1769 <td>FOREIGN KEY</td><td>object_id</td>
1770 </tr>
1771
1772 <tr class="IndexCell">
1773 <td>NOT NULL</td><td>type_id</td>
1774 </tr>
1775
1776 <tr class="IndexCell">
1777 <td>FOREIGN KEY</td><td>type_id</td>
1778 </tr>
1779
1780 <tr class="IndexCell">
1781 <td>NOT NULL</td><td>rank</td>
1782 </tr>
1783
1784 <tr class="IndexCell">
1785 <td>UNIQUE</td><td>subject_id, object_id, type_id, rank</td>
1786 </tr>
1787
1788 </table>
1789
1790 <hr />
1791
1792 <!--
1793 Starting table 'feature_relationship_pub'
1794 -->
1795
1796 <a name="feature_relationship_pub" />
1797
1798 <table class="TableHeader" width="100%">
1799 <tr class="TableHeaderRow">
1800 <td class="TableHeaderCell"><h3>
1801 feature_relationship_pub
1802 </h3></td> <a name="feature_relationship_pub"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1803 </tr>
1804 </table>
1805
1806 <b>
1807 Comments:
1808 </b>
1809
1810 <br />
1811
1812 <em>
1813 <br />
1814 ================================================ <br />
1815 TABLE: feature_relationship_pub <br />
1816 ================================================ <br />
1817 Provenance. Attach optional evidence to a feature_relationship in the form of a publication.
1818 </em>
1819
1820 <table border="1">
1821
1822 <tr>
1823 <th class="FieldHeader">
1824 Field Name
1825 </th>
1826 <th class="FieldHeader">
1827 Data Type
1828 </th>
1829 <th class="FieldHeader">
1830 Size
1831 </th>
1832 <th class="FieldHeader">
1833 Default Value
1834 </th>
1835 <th class="FieldHeader">
1836 Other
1837 </th>
1838 <th class="FieldHeader">
1839 Foreign Key
1840 </th>
1841 </tr>
1842
1843 <tr class="tr-odd">
1844 <td class="FieldCellName"><a name="feature_relationship_pub-feature_relationship_pub_id">feature_relationship_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>
1845 </tr>
1846
1847 <tr class="tr-even">
1848 <td class="FieldCellName"><a name="feature_relationship_pub-feature_relationship_id">feature_relationship_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_relationship-feature_relationship_id">feature_relationship.feature_relationship_id</a></td>
1849 </tr>
1850
1851 <tr class="tr-odd">
1852 <td class="FieldCellName"><a name="feature_relationship_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>
1853 </tr>
1854
1855 </table>
1856
1857 <h3>
1858 Indices
1859 </h3>
1860
1861 <table border="1">
1862
1863 <tr class="IndexRow">
1864 <th>
1865 Name
1866 </th>
1867 <th>
1868 Fields
1869 </th>
1870 </tr>
1871
1872 <tr class="IndexCell">
1873 <td>feature_relationship_pub_idx1</td><td>feature_relationship_id</td>
1874 </tr>
1875
1876 <tr class="IndexCell">
1877 <td>feature_relationship_pub_idx2</td><td>pub_id</td>
1878 </tr>
1879
1880 </table>
1881
1882 <h3>
1883 Constraints
1884 </h3>
1885
1886 <table border="1">
1887
1888 <tr class="IndexRow">
1889 <th>
1890 Type
1891 </th>
1892 <th>
1893 Fields
1894 </th>
1895 </tr>
1896
1897 <tr class="IndexCell">
1898 <td>NOT NULL</td><td>feature_relationship_pub_id</td>
1899 </tr>
1900
1901 <tr class="IndexCell">
1902 <td>NOT NULL</td><td>feature_relationship_id</td>
1903 </tr>
1904
1905 <tr class="IndexCell">
1906 <td>FOREIGN KEY</td><td>feature_relationship_id</td>
1907 </tr>
1908
1909 <tr class="IndexCell">
1910 <td>NOT NULL</td><td>pub_id</td>
1911 </tr>
1912
1913 <tr class="IndexCell">
1914 <td>FOREIGN KEY</td><td>pub_id</td>
1915 </tr>
1916
1917 <tr class="IndexCell">
1918 <td>UNIQUE</td><td>feature_relationship_id, pub_id</td>
1919 </tr>
1920
1921 </table>
1922
1923 <hr />
1924
1925 <!--
1926 Starting table 'feature_relationshipprop'
1927 -->
1928
1929 <a name="feature_relationshipprop" />
1930
1931 <table class="TableHeader" width="100%">
1932 <tr class="TableHeaderRow">
1933 <td class="TableHeaderCell"><h3>
1934 feature_relationshipprop
1935 </h3></td> <a name="feature_relationshipprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1936 </tr>
1937 </table>
1938
1939 <b>
1940 Comments:
1941 </b>
1942
1943 <br />
1944
1945 <em>
1946 <br />
1947 ================================================ <br />
1948 TABLE: feature_relationshipprop <br />
1949 ================================================ <br />
1950 Extensible properties
1951 for feature_relationships. Analagous structure to featureprop. This
1952 table is largely optional and not used with a high frequency. Typical
1953 scenarios may be if one wishes to attach additional data to a
1954 feature_relationship - for example to say that the
1955 feature_relationship is only true in certain contexts.
1956 </em>
1957
1958 <table border="1">
1959
1960 <tr>
1961 <th class="FieldHeader">
1962 Field Name
1963 </th>
1964 <th class="FieldHeader">
1965 Data Type
1966 </th>
1967 <th class="FieldHeader">
1968 Size
1969 </th>
1970 <th class="FieldHeader">
1971 Default Value
1972 </th>
1973 <th class="FieldHeader">
1974 Other
1975 </th>
1976 <th class="FieldHeader">
1977 Foreign Key
1978 </th>
1979 </tr>
1980
1981 <tr class="tr-odd">
1982 <td class="FieldCellName"><a name="feature_relationshipprop-feature_relationshipprop_id">feature_relationshipprop_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>
1983 </tr>
1984
1985 <tr class="tr-even">
1986 <td class="FieldCellName"><a name="feature_relationshipprop-feature_relationship_id">feature_relationship_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_relationship-feature_relationship_id">feature_relationship.feature_relationship_id</a></td>
1987 </tr>
1988
1989 <tr class="tr-odd">
1990 <td class="FieldCellName"><a name="feature_relationshipprop-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
1991 property/slot is a cvterm. The meaning of the property is defined in
1992 that cvterm. Currently there is no standard ontology for
1993 feature_relationship property types. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1994 </tr>
1995
1996 <tr class="tr-even">
1997 <td class="FieldCellName"><a name="feature_relationshipprop-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
1998 property, represented as text. Numeric values are converted to their
1999 text representation. This is less efficient than using native database
2000 types, but is easier to query. </td> <td class="FieldCellFK"></td>
2001 </tr>
2002
2003 <tr class="tr-odd">
2004 <td class="FieldCellName"><a name="feature_relationshipprop-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
2005 ordering. Any feature_relationship can have multiple values for any particular
2006 property type - these are ordered in a list using rank, counting from
2007 zero. For properties that are single-valued rather than multi-valued,
2008 the default 0 value should be used. </td> <td class="FieldCellFK"></td>
2009 </tr>
2010
2011 </table>
2012
2013 <h3>
2014 Indices
2015 </h3>
2016
2017 <table border="1">
2018
2019 <tr class="IndexRow">
2020 <th>
2021 Name
2022 </th>
2023 <th>
2024 Fields
2025 </th>
2026 </tr>
2027
2028 <tr class="IndexCell">
2029 <td>feature_relationshipprop_idx1</td><td>feature_relationship_id</td>
2030 </tr>
2031
2032 <tr class="IndexCell">
2033 <td>feature_relationshipprop_idx2</td><td>type_id</td>
2034 </tr>
2035
2036 </table>
2037
2038 <h3>
2039 Constraints
2040 </h3>
2041
2042 <table border="1">
2043
2044 <tr class="IndexRow">
2045 <th>
2046 Type
2047 </th>
2048 <th>
2049 Fields
2050 </th>
2051 </tr>
2052
2053 <tr class="IndexCell">
2054 <td>NOT NULL</td><td>feature_relationshipprop_id</td>
2055 </tr>
2056
2057 <tr class="IndexCell">
2058 <td>NOT NULL</td><td>feature_relationship_id</td>
2059 </tr>
2060
2061 <tr class="IndexCell">
2062 <td>FOREIGN KEY</td><td>feature_relationship_id</td>
2063 </tr>
2064
2065 <tr class="IndexCell">
2066 <td>NOT NULL</td><td>type_id</td>
2067 </tr>
2068
2069 <tr class="IndexCell">
2070 <td>FOREIGN KEY</td><td>type_id</td>
2071 </tr>
2072
2073 <tr class="IndexCell">
2074 <td>NOT NULL</td><td>rank</td>
2075 </tr>
2076
2077 <tr class="IndexCell">
2078 <td>UNIQUE</td><td>feature_relationship_id, type_id, rank</td>
2079 </tr>
2080
2081 </table>
2082
2083 <hr />
2084
2085 <!--
2086 Starting table 'feature_relationshipprop_pub'
2087 -->
2088
2089 <a name="feature_relationshipprop_pub" />
2090
2091 <table class="TableHeader" width="100%">
2092 <tr class="TableHeaderRow">
2093 <td class="TableHeaderCell"><h3>
2094 feature_relationshipprop_pub
2095 </h3></td> <a name="feature_relationshipprop_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
2096 </tr>
2097 </table>
2098
2099 <b>
2100 Comments:
2101 </b>
2102
2103 <br />
2104
2105 <em>
2106 <br />
2107 ================================================ <br />
2108 TABLE: feature_relationshipprop_pub <br />
2109 ================================================ <br />
2110 Provenance for feature_relationshipprop.
2111 </em>
2112
2113 <table border="1">
2114
2115 <tr>
2116 <th class="FieldHeader">
2117 Field Name
2118 </th>
2119 <th class="FieldHeader">
2120 Data Type
2121 </th>
2122 <th class="FieldHeader">
2123 Size
2124 </th>
2125 <th class="FieldHeader">
2126 Default Value
2127 </th>
2128 <th class="FieldHeader">
2129 Other
2130 </th>
2131 <th class="FieldHeader">
2132 Foreign Key
2133 </th>
2134 </tr>
2135
2136 <tr class="tr-odd">
2137 <td class="FieldCellName"><a name="feature_relationshipprop_pub-feature_relationshipprop_pub_id">feature_relationshipprop_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>
2138 </tr>
2139
2140 <tr class="tr-even">
2141 <td class="FieldCellName"><a name="feature_relationshipprop_pub-feature_relationshipprop_id">feature_relationshipprop_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_relationshipprop-feature_relationshipprop_id">feature_relationshipprop.feature_relationshipprop_id</a></td>
2142 </tr>
2143
2144 <tr class="tr-odd">
2145 <td class="FieldCellName"><a name="feature_relationshipprop_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>
2146 </tr>
2147
2148 </table>
2149
2150 <h3>
2151 Indices
2152 </h3>
2153
2154 <table border="1">
2155
2156 <tr class="IndexRow">
2157 <th>
2158 Name
2159 </th>
2160 <th>
2161 Fields
2162 </th>
2163 </tr>
2164
2165 <tr class="IndexCell">
2166 <td>feature_relationshipprop_pub_idx1</td><td>feature_relationshipprop_id</td>
2167 </tr>
2168
2169 <tr class="IndexCell">
2170 <td>feature_relationshipprop_pub_idx2</td><td>pub_id</td>
2171 </tr>
2172
2173 </table>
2174
2175 <h3>
2176 Constraints
2177 </h3>
2178
2179 <table border="1">
2180
2181 <tr class="IndexRow">
2182 <th>
2183 Type
2184 </th>
2185 <th>
2186 Fields
2187 </th>
2188 </tr>
2189
2190 <tr class="IndexCell">
2191 <td>NOT NULL</td><td>feature_relationshipprop_pub_id</td>
2192 </tr>
2193
2194 <tr class="IndexCell">
2195 <td>NOT NULL</td><td>feature_relationshipprop_id</td>
2196 </tr>
2197
2198 <tr class="IndexCell">
2199 <td>FOREIGN KEY</td><td>feature_relationshipprop_id</td>
2200 </tr>
2201
2202 <tr class="IndexCell">
2203 <td>NOT NULL</td><td>pub_id</td>
2204 </tr>
2205
2206 <tr class="IndexCell">
2207 <td>FOREIGN KEY</td><td>pub_id</td>
2208 </tr>
2209
2210 <tr class="IndexCell">
2211 <td>UNIQUE</td><td>feature_relationshipprop_id, pub_id</td>
2212 </tr>
2213
2214 </table>
2215
2216 <hr />
2217
2218 <!--
2219 Starting table 'feature_cvterm'
2220 -->
2221
2222 <a name="feature_cvterm" />
2223
2224 <table width="100%" class="TableHeader">
2225 <tr class="TableHeaderRow">
2226 <td class="TableHeaderCell"><h3>
2227 feature_cvterm
2228 </h3></td> <a name="feature_cvterm"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
2229 </tr>
2230 </table>
2231
2232 <b>
2233 Comments:
2234 </b>
2235
2236 <br />
2237
2238 <em>
2239 <br />
2240 ================================================ <br />
2241 TABLE: feature_cvterm <br />
2242 ================================================ <br />
2243 Associate a term from a cv with a feature, for example, GO annotation.
2244 </em>
2245
2246 <table border="1">
2247
2248 <tr>
2249 <th class="FieldHeader">
2250 Field Name
2251 </th>
2252 <th class="FieldHeader">
2253 Data Type
2254 </th>
2255 <th class="FieldHeader">
2256 Size
2257 </th>
2258 <th class="FieldHeader">
2259 Default Value
2260 </th>
2261 <th class="FieldHeader">
2262 Other
2263 </th>
2264 <th class="FieldHeader">
2265 Foreign Key
2266 </th>
2267 </tr>
2268
2269 <tr class="tr-odd">
2270 <td class="FieldCellName"><a name="feature_cvterm-feature_cvterm_id">feature_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>
2271 </tr>
2272
2273 <tr class="tr-even">
2274 <td class="FieldCellName"><a name="feature_cvterm-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>
2275 </tr>
2276
2277 <tr class="tr-odd">
2278 <td class="FieldCellName"><a name="feature_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>
2279 </tr>
2280
2281 <tr class="tr-even">
2282 <td class="FieldCellName"><a name="feature_cvterm-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, Provenance for the annotation. Each annotation should have a single primary publication (which may be of the appropriate type for computational analyses) where more details can be found. Additional provenance dbxrefs can be attached using feature_cvterm_dbxref. </td> <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
2283 </tr>
2284
2285 <tr class="tr-odd">
2286 <td class="FieldCellName"><a name="feature_cvterm-is_not">is_not</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">false</td> <td class="FieldCellOther">NOT NULL, If this is set to true, then this annotation is interpreted as a NEGATIVE annotation - i.e. the feature does NOT have the specified function, process, component, part, etc. See GO docs for more details. </td> <td class="FieldCellFK"></td>
2287 </tr>
2288
2289 <tr class="tr-even">
2290 <td class="FieldCellName"><a name="feature_cvterm-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>
2291 </tr>
2292
2293 </table>
2294
2295 <h3>
2296 Indices
2297 </h3>
2298
2299 <table border="1">
2300
2301 <tr class="IndexRow">
2302 <th>
2303 Name
2304 </th>
2305 <th>
2306 Fields
2307 </th>
2308 </tr>
2309
2310 <tr class="IndexCell">
2311 <td>feature_cvterm_idx1</td><td>feature_id</td>
2312 </tr>
2313
2314 <tr class="IndexCell">
2315 <td>feature_cvterm_idx2</td><td>cvterm_id</td>
2316 </tr>
2317
2318 <tr class="IndexCell">
2319 <td>feature_cvterm_idx3</td><td>pub_id</td>
2320 </tr>
2321
2322 </table>
2323
2324 <h3>
2325 Constraints
2326 </h3>
2327
2328 <table border="1">
2329
2330 <tr class="IndexRow">
2331 <th>
2332 Type
2333 </th>
2334 <th>
2335 Fields
2336 </th>
2337 </tr>
2338
2339 <tr class="IndexCell">
2340 <td>NOT NULL</td><td>feature_cvterm_id</td>
2341 </tr>
2342
2343 <tr class="IndexCell">
2344 <td>NOT NULL</td><td>feature_id</td>
2345 </tr>
2346
2347 <tr class="IndexCell">
2348 <td>FOREIGN KEY</td><td>feature_id</td>
2349 </tr>
2350
2351 <tr class="IndexCell">
2352 <td>NOT NULL</td><td>cvterm_id</td>
2353 </tr>
2354
2355 <tr class="IndexCell">
2356 <td>FOREIGN KEY</td><td>cvterm_id</td>
2357 </tr>
2358
2359 <tr class="IndexCell">
2360 <td>NOT NULL</td><td>pub_id</td>
2361 </tr>
2362
2363 <tr class="IndexCell">
2364 <td>FOREIGN KEY</td><td>pub_id</td>
2365 </tr>
2366
2367 <tr class="IndexCell">
2368 <td>NOT NULL</td><td>is_not</td>
2369 </tr>
2370
2371 <tr class="IndexCell">
2372 <td>NOT NULL</td><td>rank</td>
2373 </tr>
2374
2375 <tr class="IndexCell">
2376 <td>UNIQUE</td><td>feature_id, cvterm_id, pub_id, rank</td>
2377 </tr>
2378
2379 </table>
2380
2381 <hr />
2382
2383 <!--
2384 Starting table 'feature_cvtermprop'
2385 -->
2386
2387 <a name="feature_cvtermprop" />
2388
2389 <table width="100%" class="TableHeader">
2390 <tr class="TableHeaderRow">
2391 <td class="TableHeaderCell"><h3>
2392 feature_cvtermprop
2393 </h3></td> <a name="feature_cvtermprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
2394 </tr>
2395 </table>
2396
2397 <b>
2398 Comments:
2399 </b>
2400
2401 <br />
2402
2403 <em>
2404 <br />
2405 ================================================ <br />
2406 TABLE: feature_cvtermprop <br />
2407 ================================================ <br />
2408 Extensible properties for
2409 feature to cvterm associations. Examples: GO evidence codes;
2410 qualifiers; metadata such as the date on which the entry was curated
2411 and the source of the association. See the featureprop table for
2412 meanings of type_id, value and rank.
2413 </em>
2414
2415 <table border="1">
2416
2417 <tr>
2418 <th class="FieldHeader">
2419 Field Name
2420 </th>
2421 <th class="FieldHeader">
2422 Data Type
2423 </th>
2424 <th class="FieldHeader">
2425 Size
2426 </th>
2427 <th class="FieldHeader">
2428 Default Value
2429 </th>
2430 <th class="FieldHeader">
2431 Other
2432 </th>
2433 <th class="FieldHeader">
2434 Foreign Key
2435 </th>
2436 </tr>
2437
2438 <tr class="tr-odd">
2439 <td class="FieldCellName"><a name="feature_cvtermprop-feature_cvtermprop_id">feature_cvtermprop_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>
2440 </tr>
2441
2442 <tr class="tr-even">
2443 <td class="FieldCellName"><a name="feature_cvtermprop-feature_cvterm_id">feature_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="#feature_cvterm-feature_cvterm_id">feature_cvterm.feature_cvterm_id</a></td>
2444 </tr>
2445
2446 <tr class="tr-odd">
2447 <td class="FieldCellName"><a name="feature_cvtermprop-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
2448 property/slot is a cvterm. The meaning of the property is defined in
2449 that cvterm. cvterms may come from the OBO evidence code cv. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
2450 </tr>
2451
2452 <tr class="tr-even">
2453 <td class="FieldCellName"><a name="feature_cvtermprop-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
2454 property, represented as text. Numeric values are converted to their
2455 text representation. This is less efficient than using native database
2456 types, but is easier to query. </td> <td class="FieldCellFK"></td>
2457 </tr>
2458
2459 <tr class="tr-odd">
2460 <td class="FieldCellName"><a name="feature_cvtermprop-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
2461 ordering. Any feature_cvterm can have multiple values for any particular
2462 property type - these are ordered in a list using rank, counting from
2463 zero. For properties that are single-valued rather than multi-valued,
2464 the default 0 value should be used. </td> <td class="FieldCellFK"></td>
2465 </tr>
2466
2467 </table>
2468
2469 <h3>
2470 Indices
2471 </h3>
2472
2473 <table border="1">
2474
2475 <tr class="IndexRow">
2476 <th>
2477 Name
2478 </th>
2479 <th>
2480 Fields
2481 </th>
2482 </tr>
2483
2484 <tr class="IndexCell">
2485 <td>feature_cvtermprop_idx1</td><td>feature_cvterm_id</td>
2486 </tr>
2487
2488 <tr class="IndexCell">
2489 <td>feature_cvtermprop_idx2</td><td>type_id</td>
2490 </tr>
2491
2492 </table>
2493
2494 <h3>
2495 Constraints
2496 </h3>
2497
2498 <table border="1">
2499
2500 <tr class="IndexRow">
2501 <th>
2502 Type
2503 </th>
2504 <th>
2505 Fields
2506 </th>
2507 </tr>
2508
2509 <tr class="IndexCell">
2510 <td>NOT NULL</td><td>feature_cvtermprop_id</td>
2511 </tr>
2512
2513 <tr class="IndexCell">
2514 <td>NOT NULL</td><td>feature_cvterm_id</td>
2515 </tr>
2516
2517 <tr class="IndexCell">
2518 <td>FOREIGN KEY</td><td>feature_cvterm_id</td>
2519 </tr>
2520
2521 <tr class="IndexCell">
2522 <td>NOT NULL</td><td>type_id</td>
2523 </tr>
2524
2525 <tr class="IndexCell">
2526 <td>FOREIGN KEY</td><td>type_id</td>
2527 </tr>
2528
2529 <tr class="IndexCell">
2530 <td>NOT NULL</td><td>rank</td>
2531 </tr>
2532
2533 <tr class="IndexCell">
2534 <td>UNIQUE</td><td>feature_cvterm_id, type_id, rank</td>
2535 </tr>
2536
2537 </table>
2538
2539 <hr />
2540
2541 <!--
2542 Starting table 'feature_cvterm_dbxref'
2543 -->
2544
2545 <a name="feature_cvterm_dbxref" />
2546
2547 <table class="TableHeader" width="100%">
2548 <tr class="TableHeaderRow">
2549 <td class="TableHeaderCell"><h3>
2550 feature_cvterm_dbxref
2551 </h3></td> <a name="feature_cvterm_dbxref"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
2552 </tr>
2553 </table>
2554
2555 <b>
2556 Comments:
2557 </b>
2558
2559 <br />
2560
2561 <em>
2562 <br />
2563 ================================================ <br />
2564 TABLE: feature_cvterm_dbxref <br />
2565 ================================================ <br />
2566 Additional dbxrefs for an association. Rows in the feature_cvterm table may be backed up by dbxrefs. For example, a feature_cvterm association that was inferred via a protein-protein interaction may be backed by by refering to the dbxref for the alternate protein. Corresponds to the WITH column in a GO gene association file (but can also be used for other analagous associations). See http://www.geneontology.org/doc/GO.annotation.shtml#file for more details.
2567 </em>
2568
2569 <table border="1">
2570
2571 <tr>
2572 <th class="FieldHeader">
2573 Field Name
2574 </th>
2575 <th class="FieldHeader">
2576 Data Type
2577 </th>
2578 <th class="FieldHeader">
2579 Size
2580 </th>
2581 <th class="FieldHeader">
2582 Default Value
2583 </th>
2584 <th class="FieldHeader">
2585 Other
2586 </th>
2587 <th class="FieldHeader">
2588 Foreign Key
2589 </th>
2590 </tr>
2591
2592 <tr class="tr-odd">
2593 <td class="FieldCellName"><a name="feature_cvterm_dbxref-feature_cvterm_dbxref_id">feature_cvterm_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>
2594 </tr>
2595
2596 <tr class="tr-even">
2597 <td class="FieldCellName"><a name="feature_cvterm_dbxref-feature_cvterm_id">feature_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="#feature_cvterm-feature_cvterm_id">feature_cvterm.feature_cvterm_id</a></td>
2598 </tr>
2599
2600 <tr class="tr-odd">
2601 <td class="FieldCellName"><a name="feature_cvterm_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>
2602 </tr>
2603
2604 </table>
2605
2606 <h3>
2607 Indices
2608 </h3>
2609
2610 <table border="1">
2611
2612 <tr class="IndexRow">
2613 <th>
2614 Name
2615 </th>
2616 <th>
2617 Fields
2618 </th>
2619 </tr>
2620
2621 <tr class="IndexCell">
2622 <td>feature_cvterm_dbxref_idx1</td><td>feature_cvterm_id</td>
2623 </tr>
2624
2625 <tr class="IndexCell">
2626 <td>feature_cvterm_dbxref_idx2</td><td>dbxref_id</td>
2627 </tr>
2628
2629 </table>
2630
2631 <h3>
2632 Constraints
2633 </h3>
2634
2635 <table border="1">
2636
2637 <tr class="IndexRow">
2638 <th>
2639 Type
2640 </th>
2641 <th>
2642 Fields
2643 </th>
2644 </tr>
2645
2646 <tr class="IndexCell">
2647 <td>NOT NULL</td><td>feature_cvterm_dbxref_id</td>
2648 </tr>
2649
2650 <tr class="IndexCell">
2651 <td>NOT NULL</td><td>feature_cvterm_id</td>
2652 </tr>
2653
2654 <tr class="IndexCell">
2655 <td>FOREIGN KEY</td><td>feature_cvterm_id</td>
2656 </tr>
2657
2658 <tr class="IndexCell">
2659 <td>NOT NULL</td><td>dbxref_id</td>
2660 </tr>
2661
2662 <tr class="IndexCell">
2663 <td>FOREIGN KEY</td><td>dbxref_id</td>
2664 </tr>
2665
2666 <tr class="IndexCell">
2667 <td>UNIQUE</td><td>feature_cvterm_id, dbxref_id</td>
2668 </tr>
2669
2670 </table>
2671
2672 <hr />
2673
2674 <!--
2675 Starting table 'feature_cvterm_pub'
2676 -->
2677
2678 <a name="feature_cvterm_pub" />
2679
2680 <table class="TableHeader" width="100%">
2681 <tr class="TableHeaderRow">
2682 <td class="TableHeaderCell"><h3>
2683 feature_cvterm_pub
2684 </h3></td> <a name="feature_cvterm_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
2685 </tr>
2686 </table>
2687
2688 <b>
2689 Comments:
2690 </b>
2691
2692 <br />
2693
2694 <em>
2695 <br />
2696 ================================================ <br />
2697 TABLE: feature_cvterm_pub <br />
2698 ================================================ <br />
2699 Secondary pubs for an
2700 association. Each feature_cvterm association is supported by a single
2701 primary publication. Additional secondary pubs can be added using this
2702 linking table (in a GO gene association file, these corresponding to
2703 any IDs after the pipe symbol in the publications column.
2704 </em>
2705
2706 <table border="1">
2707
2708 <tr>
2709 <th class="FieldHeader">
2710 Field Name
2711 </th>
2712 <th class="FieldHeader">
2713 Data Type
2714 </th>
2715 <th class="FieldHeader">
2716 Size
2717 </th>
2718 <th class="FieldHeader">
2719 Default Value
2720 </th>
2721 <th class="FieldHeader">
2722 Other
2723 </th>
2724 <th class="FieldHeader">
2725 Foreign Key
2726 </th>
2727 </tr>
2728
2729 <tr class="tr-odd">
2730 <td class="FieldCellName"><a name="feature_cvterm_pub-feature_cvterm_pub_id">feature_cvterm_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>
2731 </tr>
2732
2733 <tr class="tr-even">
2734 <td class="FieldCellName"><a name="feature_cvterm_pub-feature_cvterm_id">feature_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="#feature_cvterm-feature_cvterm_id">feature_cvterm.feature_cvterm_id</a></td>
2735 </tr>
2736
2737 <tr class="tr-odd">
2738 <td class="FieldCellName"><a name="feature_cvterm_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>
2739 </tr>
2740
2741 </table>
2742
2743 <h3>
2744 Indices
2745 </h3>
2746
2747 <table border="1">
2748
2749 <tr class="IndexRow">
2750 <th>
2751 Name
2752 </th>
2753 <th>
2754 Fields
2755 </th>
2756 </tr>
2757
2758 <tr class="IndexCell">
2759 <td>feature_cvterm_pub_idx1</td><td>feature_cvterm_id</td>
2760 </tr>
2761
2762 <tr class="IndexCell">
2763 <td>feature_cvterm_pub_idx2</td><td>pub_id</td>
2764 </tr>
2765
2766 </table>
2767
2768 <h3>
2769 Constraints
2770 </h3>
2771
2772 <table border="1">
2773
2774 <tr class="IndexRow">
2775 <th>
2776 Type
2777 </th>
2778 <th>
2779 Fields
2780 </th>
2781 </tr>
2782
2783 <tr class="IndexCell">
2784 <td>NOT NULL</td><td>feature_cvterm_pub_id</td>
2785 </tr>
2786
2787 <tr class="IndexCell">
2788 <td>NOT NULL</td><td>feature_cvterm_id</td>
2789 </tr>
2790
2791 <tr class="IndexCell">
2792 <td>FOREIGN KEY</td><td>feature_cvterm_id</td>
2793 </tr>
2794
2795 <tr class="IndexCell">
2796 <td>NOT NULL</td><td>pub_id</td>
2797 </tr>
2798
2799 <tr class="IndexCell">
2800 <td>FOREIGN KEY</td><td>pub_id</td>
2801 </tr>
2802
2803 <tr class="IndexCell">
2804 <td>UNIQUE</td><td>feature_cvterm_id, pub_id</td>
2805 </tr>
2806
2807 </table>
2808
2809 <hr />
2810
2811 <!--
2812 Starting table 'synonym'
2813 -->
2814
2815 <a name="synonym" />
2816
2817 <table class="TableHeader" width="100%">
2818 <tr class="TableHeaderRow">
2819 <td class="TableHeaderCell"><h3>
2820 synonym
2821 </h3></td> <a name="synonym"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
2822 </tr>
2823 </table>
2824
2825 <b>
2826 Comments:
2827 </b>
2828
2829 <br />
2830
2831 <em>
2832 <br />
2833 ================================================ <br />
2834 TABLE: synonym <br />
2835 ================================================ <br />
2836 A synonym for a feature. One feature can have multiple synonyms, and the same synonym can apply to multiple features.
2837 </em>
2838
2839 <table border="1">
2840
2841 <tr>
2842 <th class="FieldHeader">
2843 Field Name
2844 </th>
2845 <th class="FieldHeader">
2846 Data Type
2847 </th>
2848 <th class="FieldHeader">
2849 Size
2850 </th>
2851 <th class="FieldHeader">
2852 Default Value
2853 </th>
2854 <th class="FieldHeader">
2855 Other
2856 </th>
2857 <th class="FieldHeader">
2858 Foreign Key
2859 </th>
2860 </tr>
2861
2862 <tr class="tr-odd">
2863 <td class="FieldCellName"><a name="synonym-synonym_id">synonym_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>
2864 </tr>
2865
2866 <tr class="tr-even">
2867 <td class="FieldCellName"><a name="synonym-name">name</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, The synonym itself. Should be human-readable machine-searchable ascii text. </td> <td class="FieldCellFK"></td>
2868 </tr>
2869
2870 <tr class="tr-odd">
2871 <td class="FieldCellName"><a name="synonym-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, Types would be symbol and fullname for now. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
2872 </tr>
2873
2874 <tr class="tr-even">
2875 <td class="FieldCellName"><a name="synonym-synonym_sgml">synonym_sgml</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL, The fully specified synonym, with any non-ascii characters encoded in SGML. </td> <td class="FieldCellFK"></td>
2876 </tr>
2877
2878 </table>
2879
2880 <h3>
2881 Indices
2882 </h3>
2883
2884 <table border="1">
2885
2886 <tr class="IndexRow">
2887 <th>
2888 Name
2889 </th>
2890 <th>
2891 Fields
2892 </th>
2893 </tr>
2894
2895 <tr class="IndexCell">
2896 <td>synonym_idx1</td><td>type_id</td>
2897 </tr>
2898
2899 </table>
2900
2901 <h3>
2902 Constraints
2903 </h3>
2904
2905 <table border="1">
2906
2907 <tr class="IndexRow">
2908 <th>
2909 Type
2910 </th>
2911 <th>
2912 Fields
2913 </th>
2914 </tr>
2915
2916 <tr class="IndexCell">
2917 <td>NOT NULL</td><td>synonym_id</td>
2918 </tr>
2919
2920 <tr class="IndexCell">
2921 <td>NOT NULL</td><td>name</td>
2922 </tr>
2923
2924 <tr class="IndexCell">
2925 <td>NOT NULL</td><td>type_id</td>
2926 </tr>
2927
2928 <tr class="IndexCell">
2929 <td>FOREIGN KEY</td><td>type_id</td>
2930 </tr>
2931
2932 <tr class="IndexCell">
2933 <td>NOT NULL</td><td>synonym_sgml</td>
2934 </tr>
2935
2936 <tr class="IndexCell">
2937 <td>UNIQUE</td><td>name, type_id</td>
2938 </tr>
2939
2940 </table>
2941
2942 <hr />
2943
2944 <!--
2945 Starting table 'feature_synonym'
2946 -->
2947
2948 <a name="feature_synonym" />
2949
2950 <table width="100%" class="TableHeader">
2951 <tr class="TableHeaderRow">
2952 <td class="TableHeaderCell"><h3>
2953 feature_synonym
2954 </h3></td> <a name="feature_synonym"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
2955 </tr>
2956 </table>
2957
2958 <b>
2959 Comments:
2960 </b>
2961
2962 <br />
2963
2964 <em>
2965 <br />
2966 ================================================ <br />
2967 TABLE: feature_synonym <br />
2968 ================================================ <br />
2969 Linking table between feature and synonym.
2970 </em>
2971
2972 <table border="1">
2973
2974 <tr>
2975 <th class="FieldHeader">
2976 Field Name
2977 </th>
2978 <th class="FieldHeader">
2979 Data Type
2980 </th>
2981 <th class="FieldHeader">
2982 Size
2983 </th>
2984 <th class="FieldHeader">
2985 Default Value
2986 </th>
2987 <th class="FieldHeader">
2988 Other
2989 </th>
2990 <th class="FieldHeader">
2991 Foreign Key
2992 </th>
2993 </tr>
2994
2995 <tr class="tr-odd">
2996 <td class="FieldCellName"><a name="feature_synonym-feature_synonym_id">feature_synonym_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>
2997 </tr>
2998
2999 <tr class="tr-even">
3000 <td class="FieldCellName"><a name="feature_synonym-synonym_id">synonym_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="#synonym-synonym_id">synonym.synonym_id</a></td>
3001 </tr>
3002
3003 <tr class="tr-odd">
3004 <td class="FieldCellName"><a name="feature_synonym-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>
3005 </tr>
3006
3007 <tr class="tr-even">
3008 <td class="FieldCellName"><a name="feature_synonym-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, The pub_id link is for relating the usage of a given synonym to the publication in which it was used. </td> <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
3009 </tr>
3010
3011 <tr class="tr-odd">
3012 <td class="FieldCellName"><a name="feature_synonym-is_current">is_current</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">false</td> <td class="FieldCellOther">NOT NULL, The is_current boolean indicates whether the linked synonym is the current -official- symbol for the linked feature. </td> <td class="FieldCellFK"></td>
3013 </tr>
3014
3015 <tr class="tr-even">
3016 <td class="FieldCellName"><a name="feature_synonym-is_internal">is_internal</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">false</td> <td class="FieldCellOther">NOT NULL, Typically a synonym exists so that somebody querying the db with an obsolete name can find the object theyre looking for (under its current name. If the synonym has been used publicly and deliberately (e.g. in a paper), it may also be listed in reports as a synonym. If the synonym was not used deliberately (e.g. there was a typo which went public), then the is_internal boolean may be set to -true- so that it is known that the synonym is -internal- and should be queryable but should not be listed in reports as a valid synonym. </td> <td class="FieldCellFK"></td>
3017 </tr>
3018
3019 </table>
3020
3021 <h3>
3022 Indices
3023 </h3>
3024
3025 <table border="1">
3026
3027 <tr class="IndexRow">
3028 <th>
3029 Name
3030 </th>
3031 <th>
3032 Fields
3033 </th>
3034 </tr>
3035
3036 <tr class="IndexCell">
3037 <td>feature_synonym_idx1</td><td>synonym_id</td>
3038 </tr>
3039
3040 <tr class="IndexCell">
3041 <td>feature_synonym_idx2</td><td>feature_id</td>
3042 </tr>
3043
3044 <tr class="IndexCell">
3045 <td>feature_synonym_idx3</td><td>pub_id</td>
3046 </tr>
3047
3048 </table>
3049
3050 <h3>
3051 Constraints
3052 </h3>
3053
3054 <table border="1">
3055
3056 <tr class="IndexRow">
3057 <th>
3058 Type
3059 </th>
3060 <th>
3061 Fields
3062 </th>
3063 </tr>
3064
3065 <tr class="IndexCell">
3066 <td>NOT NULL</td><td>feature_synonym_id</td>
3067 </tr>
3068
3069 <tr class="IndexCell">
3070 <td>NOT NULL</td><td>synonym_id</td>
3071 </tr>
3072
3073 <tr class="IndexCell">
3074 <td>FOREIGN KEY</td><td>synonym_id</td>
3075 </tr>
3076
3077 <tr class="IndexCell">
3078 <td>NOT NULL</td><td>feature_id</td>
3079 </tr>
3080
3081 <tr class="IndexCell">
3082 <td>FOREIGN KEY</td><td>feature_id</td>
3083 </tr>
3084
3085 <tr class="IndexCell">
3086 <td>NOT NULL</td><td>pub_id</td>
3087 </tr>
3088
3089 <tr class="IndexCell">
3090 <td>FOREIGN KEY</td><td>pub_id</td>
3091 </tr>
3092
3093 <tr class="IndexCell">
3094 <td>NOT NULL</td><td>is_current</td>
3095 </tr>
3096
3097 <tr class="IndexCell">
3098 <td>NOT NULL</td><td>is_internal</td>
3099 </tr>
3100
3101 <tr class="IndexCell">
3102 <td>UNIQUE</td><td>synonym_id, feature_id, pub_id</td>
3103 </tr>
3104
3105 </table>
3106
3107 <hr />
3108
3109 <!--
3110 Starting table 'feature_contact'
3111 -->
3112
3113 <a name="feature_contact" />
3114
3115 <table width="100%" class="TableHeader">
3116 <tr class="TableHeaderRow">
3117 <td class="TableHeaderCell"><h3>
3118 feature_contact
3119 </h3></td> <a name="feature_contact"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
3120 </tr>
3121 </table>
3122
3123 <b>
3124 Comments:
3125 </b>
3126
3127 <br />
3128
3129 <em>
3130 <br />
3131 ================================================ <br />
3132 TABLE: feature_contact <br />
3133 ================================================ <br />
3134 Links contact(s) with a feature. Used to indicate a particular
3135 person or organization responsible for discovery or that can provide more information on a particular feature.
3136 </em>
3137
3138 <table border="1">
3139
3140 <tr>
3141 <th class="FieldHeader">
3142 Field Name
3143 </th>
3144 <th class="FieldHeader">
3145 Data Type
3146 </th>
3147 <th class="FieldHeader">
3148 Size
3149 </th>
3150 <th class="FieldHeader">
3151 Default Value
3152 </th>
3153 <th class="FieldHeader">
3154 Other
3155 </th>
3156 <th class="FieldHeader">
3157 Foreign Key
3158 </th>
3159 </tr>
3160
3161 <tr class="tr-odd">
3162 <td class="FieldCellName"><a name="feature_contact-feature_contact_id">feature_contact_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>
3163 </tr>
3164
3165 <tr class="tr-even">
3166 <td class="FieldCellName"><a name="feature_contact-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>
3167 </tr>
3168
3169 <tr class="tr-odd">
3170 <td class="FieldCellName"><a name="feature_contact-contact_id">contact_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="#contact-contact_id">contact.contact_id</a></td>
3171 </tr>
3172
3173 </table>
3174
3175 <h3>
3176 Indices
3177 </h3>
3178
3179 <table border="1">
3180
3181 <tr class="IndexRow">
3182 <th>
3183 Name
3184 </th>
3185 <th>
3186 Fields
3187 </th>
3188 </tr>
3189
3190 <tr class="IndexCell">
3191 <td>feature_contact_idx1</td><td>feature_id</td>
3192 </tr>
3193
3194 <tr class="IndexCell">
3195 <td>feature_contact_idx2</td><td>contact_id</td>
3196 </tr>
3197
3198 </table>
3199
3200 <h3>
3201 Constraints
3202 </h3>
3203
3204 <table border="1">
3205
3206 <tr class="IndexRow">
3207 <th>
3208 Type
3209 </th>
3210 <th>
3211 Fields
3212 </th>
3213 </tr>
3214
3215 <tr class="IndexCell">
3216 <td>NOT NULL</td><td>feature_contact_id</td>
3217 </tr>
3218
3219 <tr class="IndexCell">
3220 <td>NOT NULL</td><td>feature_id</td>
3221 </tr>
3222
3223 <tr class="IndexCell">
3224 <td>NOT NULL</td><td>contact_id</td>
3225 </tr>
3226
3227 <tr class="IndexCell">
3228 <td>UNIQUE</td><td>feature_id, contact_id</td>
3229 </tr>
3230
3231 <tr class="IndexCell">
3232 <td>FOREIGN KEY</td><td>contact_id</td>
3233 </tr>
3234
3235 <tr class="IndexCell">
3236 <td>FOREIGN KEY</td><td>feature_id</td>
3237 </tr>
3238
3239 </table>
3240
3241 <hr />
3242
3243 Created by <a href="http://sqlfairy.sourceforge.net">
3244 SQL::Translator 0.11020</a>
3245
3246 </body>
3247 </html>