Debian Codegraph @

modules/cv/cv.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 (11 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 'cv'
35 -->
36
37 <tr class="LinkTableRow">
38 <td class="LinkTableCell"><a id="cv-link" href="#cv">cv</a></td>
39 </tr>
40
41 <!--
42 End link to table 'cv'
43 -->
44
45 <!--
46 Start link to table 'cvterm'
47 -->
48
49 <tr class="LinkTableRow">
50 <td class="LinkTableCell"><a id="cvterm-link" href="#cvterm">cvterm</a></td>
51 </tr>
52
53 <!--
54 End link to table 'cvterm'
55 -->
56
57 <!--
58 Start link to table 'cvterm_relationship'
59 -->
60
61 <tr class="LinkTableRow">
62 <td class="LinkTableCell"><a id="cvterm_relationship-link" href="#cvterm_relationship">cvterm_relationship</a></td>
63 </tr>
64
65 <!--
66 End link to table 'cvterm_relationship'
67 -->
68
69 <!--
70 Start link to table 'cvtermpath'
71 -->
72
73 <tr class="LinkTableRow">
74 <td class="LinkTableCell"><a id="cvtermpath-link" href="#cvtermpath">cvtermpath</a></td>
75 </tr>
76
77 <!--
78 End link to table 'cvtermpath'
79 -->
80
81 <!--
82 Start link to table 'cvtermsynonym'
83 -->
84
85 <tr class="LinkTableRow">
86 <td class="LinkTableCell"><a id="cvtermsynonym-link" href="#cvtermsynonym">cvtermsynonym</a></td>
87 </tr>
88
89 <!--
90 End link to table 'cvtermsynonym'
91 -->
92
93 <!--
94 Start link to table 'cvterm_dbxref'
95 -->
96
97 <tr class="LinkTableRow">
98 <td class="LinkTableCell"><a id="cvterm_dbxref-link" href="#cvterm_dbxref">cvterm_dbxref</a></td>
99 </tr>
100
101 <!--
102 End link to table 'cvterm_dbxref'
103 -->
104
105 <!--
106 Start link to table 'cvtermprop'
107 -->
108
109 <tr class="LinkTableRow">
110 <td class="LinkTableCell"><a id="cvtermprop-link" href="#cvtermprop">cvtermprop</a></td>
111 </tr>
112
113 <!--
114 End link to table 'cvtermprop'
115 -->
116
117 <!--
118 Start link to table 'dbxrefprop'
119 -->
120
121 <tr class="LinkTableRow">
122 <td class="LinkTableCell"><a id="dbxrefprop-link" href="#dbxrefprop">dbxrefprop</a></td>
123 </tr>
124
125 <!--
126 End link to table 'dbxrefprop'
127 -->
128
129 <!--
130 Start link to table 'cvprop'
131 -->
132
133 <tr class="LinkTableRow">
134 <td class="LinkTableCell"><a id="cvprop-link" href="#cvprop">cvprop</a></td>
135 </tr>
136
137 <!--
138 End link to table 'cvprop'
139 -->
140
141 <!--
142 Start link to table 'chadoprop'
143 -->
144
145 <tr class="LinkTableRow">
146 <td class="LinkTableCell"><a id="chadoprop-link" href="#chadoprop">chadoprop</a></td>
147 </tr>
148
149 <!--
150 End link to table 'chadoprop'
151 -->
152
153 <!--
154 Start link to table 'dbprop'
155 -->
156
157 <tr class="LinkTableRow">
158 <td class="LinkTableCell"><a id="dbprop-link" href="#dbprop">dbprop</a></td>
159 </tr>
160
161 <!--
162 End link to table 'dbprop'
163 -->
164
165 </table>
166
167 <!--
168 Starting table 'cv'
169 -->
170
171 <a name="cv" />
172
173 <table class="TableHeader" width="100%">
174 <tr class="TableHeaderRow">
175 <td class="TableHeaderCell"><h3>
176 cv
177 </h3></td> <a name="cv"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
178 </tr>
179 </table>
180
181 <b>
182 Comments:
183 </b>
184
185 <br />
186
187 <em>
188 <br />
189 $Id: cv.sql,v 1.37 2007-02-28 15:08:48 briano Exp $ <br />
190 ========================================== <br />
191 Chado cv module <br />
192 ================================================================= <br />
193 Dependencies: <br />
194 :import dbxref from db <br />
195 ================================================================= <br />
196 ================================================ <br />
197 TABLE: cv <br />
198 ================================================ <br />
199 A controlled vocabulary or ontology. A cv is
200 composed of cvterms (AKA terms, classes, types, universals - relations
201 and properties are also stored in cvterm) and the relationships
202 between them.
203 </em>
204
205 <table border="1">
206
207 <tr>
208 <th class="FieldHeader">
209 Field Name
210 </th>
211 <th class="FieldHeader">
212 Data Type
213 </th>
214 <th class="FieldHeader">
215 Size
216 </th>
217 <th class="FieldHeader">
218 Default Value
219 </th>
220 <th class="FieldHeader">
221 Other
222 </th>
223 <th class="FieldHeader">
224 Foreign Key
225 </th>
226 </tr>
227
228 <tr class="tr-odd">
229 <td class="FieldCellName"><a name="cv-cv_id">cv_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>
230 </tr>
231
232 <tr class="tr-even">
233 <td class="FieldCellName"><a name="cv-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 name of the ontology. This
234 corresponds to the obo-format -namespace-. cv names uniquely identify
235 the cv. In OBO file format, the cv.name is known as the namespace. </td> <td class="FieldCellFK"></td>
236 </tr>
237
238 <tr class="tr-odd">
239 <td class="FieldCellName"><a name="cv-definition">definition</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">A text description of the criteria for
240 membership of this ontology. </td> <td class="FieldCellFK"></td>
241 </tr>
242
243 </table>
244
245 <h3>
246 Constraints
247 </h3>
248
249 <table border="1">
250
251 <tr class="IndexRow">
252 <th>
253 Type
254 </th>
255 <th>
256 Fields
257 </th>
258 </tr>
259
260 <tr class="IndexCell">
261 <td>NOT NULL</td><td>cv_id</td>
262 </tr>
263
264 <tr class="IndexCell">
265 <td>NOT NULL</td><td>name</td>
266 </tr>
267
268 <tr class="IndexCell">
269 <td>UNIQUE</td><td>name</td>
270 </tr>
271
272 </table>
273
274 <hr />
275
276 <!--
277 Starting table 'cvterm'
278 -->
279
280 <a name="cvterm" />
281
282 <table width="100%" class="TableHeader">
283 <tr class="TableHeaderRow">
284 <td class="TableHeaderCell"><h3>
285 cvterm
286 </h3></td> <a name="cvterm"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
287 </tr>
288 </table>
289
290 <b>
291 Comments:
292 </b>
293
294 <br />
295
296 <em>
297 <br />
298 ================================================ <br />
299 TABLE: cvterm <br />
300 ================================================ <br />
301 A term, class, universal or type within an
302 ontology or controlled vocabulary. This table is also used for
303 relations and properties. cvterms constitute nodes in the graph
304 defined by the collection of cvterms and cvterm_relationships.
305 </em>
306
307 <table border="1">
308
309 <tr>
310 <th class="FieldHeader">
311 Field Name
312 </th>
313 <th class="FieldHeader">
314 Data Type
315 </th>
316 <th class="FieldHeader">
317 Size
318 </th>
319 <th class="FieldHeader">
320 Default Value
321 </th>
322 <th class="FieldHeader">
323 Other
324 </th>
325 <th class="FieldHeader">
326 Foreign Key
327 </th>
328 </tr>
329
330 <tr class="tr-odd">
331 <td class="FieldCellName"><a name="cvterm-cvterm_id">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>
332 </tr>
333
334 <tr class="tr-even">
335 <td class="FieldCellName"><a name="cvterm-cv_id">cv_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, The cv or ontology or namespace to which
336 this cvterm belongs. </td> <td class="FieldCellFK"><a href="#cv-cv_id">cv.cv_id</a></td>
337 </tr>
338
339 <tr class="tr-odd">
340 <td class="FieldCellName"><a name="cvterm-name">name</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">1024</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, A concise human-readable name or
341 label for the cvterm. Uniquely identifies a cvterm within a cv. </td> <td class="FieldCellFK"></td>
342 </tr>
343
344 <tr class="tr-even">
345 <td class="FieldCellName"><a name="cvterm-definition">definition</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">A human-readable text
346 definition. </td> <td class="FieldCellFK"></td>
347 </tr>
348
349 <tr class="tr-odd">
350 <td class="FieldCellName"><a name="cvterm-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, Primary identifier dbxref - The
351 unique global OBO identifier for this cvterm. Note that a cvterm may
352 have multiple secondary dbxrefs - see also table: cvterm_dbxref. </td> <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
353 </tr>
354
355 <tr class="tr-even">
356 <td class="FieldCellName"><a name="cvterm-is_obsolete">is_obsolete</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL, Boolean 0=false,1=true; see
357 GO documentation for details of obsoletion. Note that two terms with
358 different primary dbxrefs may exist if one is obsolete. </td> <td class="FieldCellFK"></td>
359 </tr>
360
361 <tr class="tr-odd">
362 <td class="FieldCellName"><a name="cvterm-is_relationshiptype">is_relationshiptype</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">NOT NULL, Boolean
363 0=false,1=true relations or relationship types (also known as Typedefs
364 in OBO format, or as properties or slots) form a cv/ontology in
365 themselves. We use this flag to indicate whether this cvterm is an
366 actual term/class/universal or a relation. Relations may be drawn from
367 the OBO Relations ontology, but are not exclusively drawn from there. </td> <td class="FieldCellFK"></td>
368 </tr>
369
370 </table>
371
372 <h3>
373 Indices
374 </h3>
375
376 <table border="1">
377
378 <tr class="IndexRow">
379 <th>
380 Name
381 </th>
382 <th>
383 Fields
384 </th>
385 </tr>
386
387 <tr class="IndexCell">
388 <td>cvterm_idx1</td><td>cv_id</td>
389 </tr>
390
391 <tr class="IndexCell">
392 <td>cvterm_idx2</td><td>name</td>
393 </tr>
394
395 <tr class="IndexCell">
396 <td>cvterm_idx3</td><td>dbxref_id</td>
397 </tr>
398
399 </table>
400
401 <h3>
402 Constraints
403 </h3>
404
405 <table border="1">
406
407 <tr class="IndexRow">
408 <th>
409 Type
410 </th>
411 <th>
412 Fields
413 </th>
414 </tr>
415
416 <tr class="IndexCell">
417 <td>NOT NULL</td><td>cvterm_id</td>
418 </tr>
419
420 <tr class="IndexCell">
421 <td>NOT NULL</td><td>cv_id</td>
422 </tr>
423
424 <tr class="IndexCell">
425 <td>FOREIGN KEY</td><td>cv_id</td>
426 </tr>
427
428 <tr class="IndexCell">
429 <td>NOT NULL</td><td>name</td>
430 </tr>
431
432 <tr class="IndexCell">
433 <td>NOT NULL</td><td>dbxref_id</td>
434 </tr>
435
436 <tr class="IndexCell">
437 <td>FOREIGN KEY</td><td>dbxref_id</td>
438 </tr>
439
440 <tr class="IndexCell">
441 <td>NOT NULL</td><td>is_obsolete</td>
442 </tr>
443
444 <tr class="IndexCell">
445 <td>NOT NULL</td><td>is_relationshiptype</td>
446 </tr>
447
448 <tr class="IndexCell">
449 <td>UNIQUE</td><td>name, cv_id, is_obsolete</td>
450 </tr>
451
452 <tr class="IndexCell">
453 <td>UNIQUE</td><td>dbxref_id</td>
454 </tr>
455
456 </table>
457
458 <hr />
459
460 <!--
461 Starting table 'cvterm_relationship'
462 -->
463
464 <a name="cvterm_relationship" />
465
466 <table class="TableHeader" width="100%">
467 <tr class="TableHeaderRow">
468 <td class="TableHeaderCell"><h3>
469 cvterm_relationship
470 </h3></td> <a name="cvterm_relationship"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
471 </tr>
472 </table>
473
474 <b>
475 Comments:
476 </b>
477
478 <br />
479
480 <em>
481 <br />
482 A name can mean different things in
483 different contexts; for example "chromosome" in SO and GO. A name
484 should be unique within an ontology or cv. A name may exist twice in a
485 cv, in both obsolete and non-obsolete forms - these will be for
486 different cvterms with different OBO identifiers; so GO documentation
487 for more details on obsoletion. Note that occasionally multiple
488 obsolete terms with the same name will exist in the same cv. If this
489 is a possibility for the ontology under consideration (e.g. GO) then the
490 ID should be appended to the name to ensure uniqueness. <br />
491 The OBO identifier is globally unique. <br />
492 ================================================ <br />
493 TABLE: cvterm_relationship <br />
494 ================================================ <br />
495 A relationship linking two
496 cvterms. Each cvterm_relationship constitutes an edge in the graph
497 defined by the collection of cvterms and cvterm_relationships. The
498 meaning of the cvterm_relationship depends on the definition of the
499 cvterm R refered to by type_id. However, in general the definitions
500 are such that the statement "all SUBJs REL some OBJ" is true. The
501 cvterm_relationship statement is about the subject, not the
502 object. For example "insect wing part_of thorax".
503 </em>
504
505 <table border="1">
506
507 <tr>
508 <th class="FieldHeader">
509 Field Name
510 </th>
511 <th class="FieldHeader">
512 Data Type
513 </th>
514 <th class="FieldHeader">
515 Size
516 </th>
517 <th class="FieldHeader">
518 Default Value
519 </th>
520 <th class="FieldHeader">
521 Other
522 </th>
523 <th class="FieldHeader">
524 Foreign Key
525 </th>
526 </tr>
527
528 <tr class="tr-odd">
529 <td class="FieldCellName"><a name="cvterm_relationship-cvterm_relationship_id">cvterm_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>
530 </tr>
531
532 <tr class="tr-even">
533 <td class="FieldCellName"><a name="cvterm_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, The nature of the
534 relationship between subject and object. Note that relations are also
535 housed in the cvterm table, typically from the OBO relationship
536 ontology, although other relationship types are allowed. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
537 </tr>
538
539 <tr class="tr-odd">
540 <td class="FieldCellName"><a name="cvterm_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
541 the subj-predicate-obj sentence. The cvterm_relationship is about the
542 subject. In a graph, this typically corresponds to the child node. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
543 </tr>
544
545 <tr class="tr-even">
546 <td class="FieldCellName"><a name="cvterm_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
547 subj-predicate-obj sentence. The cvterm_relationship refers to the
548 object. In a graph, this typically corresponds to the parent node. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
549 </tr>
550
551 </table>
552
553 <h3>
554 Indices
555 </h3>
556
557 <table border="1">
558
559 <tr class="IndexRow">
560 <th>
561 Name
562 </th>
563 <th>
564 Fields
565 </th>
566 </tr>
567
568 <tr class="IndexCell">
569 <td>cvterm_relationship_idx1</td><td>type_id</td>
570 </tr>
571
572 <tr class="IndexCell">
573 <td>cvterm_relationship_idx2</td><td>subject_id</td>
574 </tr>
575
576 <tr class="IndexCell">
577 <td>cvterm_relationship_idx3</td><td>object_id</td>
578 </tr>
579
580 </table>
581
582 <h3>
583 Constraints
584 </h3>
585
586 <table border="1">
587
588 <tr class="IndexRow">
589 <th>
590 Type
591 </th>
592 <th>
593 Fields
594 </th>
595 </tr>
596
597 <tr class="IndexCell">
598 <td>NOT NULL</td><td>cvterm_relationship_id</td>
599 </tr>
600
601 <tr class="IndexCell">
602 <td>NOT NULL</td><td>type_id</td>
603 </tr>
604
605 <tr class="IndexCell">
606 <td>FOREIGN KEY</td><td>type_id</td>
607 </tr>
608
609 <tr class="IndexCell">
610 <td>NOT NULL</td><td>subject_id</td>
611 </tr>
612
613 <tr class="IndexCell">
614 <td>FOREIGN KEY</td><td>subject_id</td>
615 </tr>
616
617 <tr class="IndexCell">
618 <td>NOT NULL</td><td>object_id</td>
619 </tr>
620
621 <tr class="IndexCell">
622 <td>FOREIGN KEY</td><td>object_id</td>
623 </tr>
624
625 <tr class="IndexCell">
626 <td>UNIQUE</td><td>subject_id, object_id, type_id</td>
627 </tr>
628
629 </table>
630
631 <hr />
632
633 <!--
634 Starting table 'cvtermpath'
635 -->
636
637 <a name="cvtermpath" />
638
639 <table class="TableHeader" width="100%">
640 <tr class="TableHeaderRow">
641 <td class="TableHeaderCell"><h3>
642 cvtermpath
643 </h3></td> <a name="cvtermpath"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
644 </tr>
645 </table>
646
647 <b>
648 Comments:
649 </b>
650
651 <br />
652
653 <em>
654 <br />
655 ================================================ <br />
656 TABLE: cvtermpath <br />
657 ================================================ <br />
658 The reflexive transitive closure of
659 the cvterm_relationship relation.
660 </em>
661
662 <table border="1">
663
664 <tr>
665 <th class="FieldHeader">
666 Field Name
667 </th>
668 <th class="FieldHeader">
669 Data Type
670 </th>
671 <th class="FieldHeader">
672 Size
673 </th>
674 <th class="FieldHeader">
675 Default Value
676 </th>
677 <th class="FieldHeader">
678 Other
679 </th>
680 <th class="FieldHeader">
681 Foreign Key
682 </th>
683 </tr>
684
685 <tr class="tr-odd">
686 <td class="FieldCellName"><a name="cvtermpath-cvtermpath_id">cvtermpath_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>
687 </tr>
688
689 <tr class="tr-even">
690 <td class="FieldCellName"><a name="cvtermpath-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, The relationship type that
691 this is a closure over. If null, then this is a closure over ALL
692 relationship types. If non-null, then this references a relationship
693 cvterm - note that the closure will apply to both this relationship
694 AND the OBO_REL:is_a (subclass) relationship. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
695 </tr>
696
697 <tr class="tr-odd">
698 <td class="FieldCellName"><a name="cvtermpath-subject_id">subject_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
699 </tr>
700
701 <tr class="tr-even">
702 <td class="FieldCellName"><a name="cvtermpath-object_id">object_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
703 </tr>
704
705 <tr class="tr-odd">
706 <td class="FieldCellName"><a name="cvtermpath-cv_id">cv_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL, Closures will mostly be within
707 one cv. If the closure of a relationship traverses a cv, then this
708 refers to the cv of the object_id cvterm. </td> <td class="FieldCellFK"><a href="#cv-cv_id">cv.cv_id</a></td>
709 </tr>
710
711 <tr class="tr-even">
712 <td class="FieldCellName"><a name="cvtermpath-pathdistance">pathdistance</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, The number of steps
713 required to get from the subject cvterm to the object cvterm, counting
714 from zero (reflexive relationship). </td> <td class="FieldCellFK"></td>
715 </tr>
716
717 </table>
718
719 <h3>
720 Indices
721 </h3>
722
723 <table border="1">
724
725 <tr class="IndexRow">
726 <th>
727 Name
728 </th>
729 <th>
730 Fields
731 </th>
732 </tr>
733
734 <tr class="IndexCell">
735 <td>cvtermpath_idx1</td><td>type_id</td>
736 </tr>
737
738 <tr class="IndexCell">
739 <td>cvtermpath_idx2</td><td>subject_id</td>
740 </tr>
741
742 <tr class="IndexCell">
743 <td>cvtermpath_idx3</td><td>object_id</td>
744 </tr>
745
746 <tr class="IndexCell">
747 <td>cvtermpath_idx4</td><td>cv_id</td>
748 </tr>
749
750 </table>
751
752 <h3>
753 Constraints
754 </h3>
755
756 <table border="1">
757
758 <tr class="IndexRow">
759 <th>
760 Type
761 </th>
762 <th>
763 Fields
764 </th>
765 </tr>
766
767 <tr class="IndexCell">
768 <td>NOT NULL</td><td>cvtermpath_id</td>
769 </tr>
770
771 <tr class="IndexCell">
772 <td>FOREIGN KEY</td><td>type_id</td>
773 </tr>
774
775 <tr class="IndexCell">
776 <td>NOT NULL</td><td>subject_id</td>
777 </tr>
778
779 <tr class="IndexCell">
780 <td>FOREIGN KEY</td><td>subject_id</td>
781 </tr>
782
783 <tr class="IndexCell">
784 <td>NOT NULL</td><td>object_id</td>
785 </tr>
786
787 <tr class="IndexCell">
788 <td>FOREIGN KEY</td><td>object_id</td>
789 </tr>
790
791 <tr class="IndexCell">
792 <td>NOT NULL</td><td>cv_id</td>
793 </tr>
794
795 <tr class="IndexCell">
796 <td>FOREIGN KEY</td><td>cv_id</td>
797 </tr>
798
799 <tr class="IndexCell">
800 <td>UNIQUE</td><td>subject_id, object_id, type_id, pathdistance</td>
801 </tr>
802
803 </table>
804
805 <hr />
806
807 <!--
808 Starting table 'cvtermsynonym'
809 -->
810
811 <a name="cvtermsynonym" />
812
813 <table class="TableHeader" width="100%">
814 <tr class="TableHeaderRow">
815 <td class="TableHeaderCell"><h3>
816 cvtermsynonym
817 </h3></td> <a name="cvtermsynonym"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
818 </tr>
819 </table>
820
821 <b>
822 Comments:
823 </b>
824
825 <br />
826
827 <em>
828 <br />
829 ================================================ <br />
830 TABLE: cvtermsynonym <br />
831 ================================================ <br />
832 A cvterm actually represents a
833 distinct class or concept. A concept can be refered to by different
834 phrases or names. In addition to the primary name (cvterm.name) there
835 can be a number of alternative aliases or synonyms. For example, "T
836 cell" as a synonym for "T lymphocyte".
837 </em>
838
839 <table border="1">
840
841 <tr>
842 <th class="FieldHeader">
843 Field Name
844 </th>
845 <th class="FieldHeader">
846 Data Type
847 </th>
848 <th class="FieldHeader">
849 Size
850 </th>
851 <th class="FieldHeader">
852 Default Value
853 </th>
854 <th class="FieldHeader">
855 Other
856 </th>
857 <th class="FieldHeader">
858 Foreign Key
859 </th>
860 </tr>
861
862 <tr class="tr-odd">
863 <td class="FieldCellName"><a name="cvtermsynonym-cvtermsynonym_id">cvtermsynonym_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>
864 </tr>
865
866 <tr class="tr-even">
867 <td class="FieldCellName"><a name="cvtermsynonym-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>
868 </tr>
869
870 <tr class="tr-odd">
871 <td class="FieldCellName"><a name="cvtermsynonym-synonym">synonym</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">1024</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
872 </tr>
873
874 <tr class="tr-even">
875 <td class="FieldCellName"><a name="cvtermsynonym-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">A synonym can be exact,
876 narrower, or broader than. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
877 </tr>
878
879 </table>
880
881 <h3>
882 Indices
883 </h3>
884
885 <table border="1">
886
887 <tr class="IndexRow">
888 <th>
889 Name
890 </th>
891 <th>
892 Fields
893 </th>
894 </tr>
895
896 <tr class="IndexCell">
897 <td>cvtermsynonym_idx1</td><td>cvterm_id</td>
898 </tr>
899
900 </table>
901
902 <h3>
903 Constraints
904 </h3>
905
906 <table border="1">
907
908 <tr class="IndexRow">
909 <th>
910 Type
911 </th>
912 <th>
913 Fields
914 </th>
915 </tr>
916
917 <tr class="IndexCell">
918 <td>NOT NULL</td><td>cvtermsynonym_id</td>
919 </tr>
920
921 <tr class="IndexCell">
922 <td>NOT NULL</td><td>cvterm_id</td>
923 </tr>
924
925 <tr class="IndexCell">
926 <td>FOREIGN KEY</td><td>cvterm_id</td>
927 </tr>
928
929 <tr class="IndexCell">
930 <td>NOT NULL</td><td>synonym</td>
931 </tr>
932
933 <tr class="IndexCell">
934 <td>FOREIGN KEY</td><td>type_id</td>
935 </tr>
936
937 <tr class="IndexCell">
938 <td>UNIQUE</td><td>cvterm_id, synonym</td>
939 </tr>
940
941 </table>
942
943 <hr />
944
945 <!--
946 Starting table 'cvterm_dbxref'
947 -->
948
949 <a name="cvterm_dbxref" />
950
951 <table width="100%" class="TableHeader">
952 <tr class="TableHeaderRow">
953 <td class="TableHeaderCell"><h3>
954 cvterm_dbxref
955 </h3></td> <a name="cvterm_dbxref"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
956 </tr>
957 </table>
958
959 <b>
960 Comments:
961 </b>
962
963 <br />
964
965 <em>
966 <br />
967 ================================================ <br />
968 TABLE: cvterm_dbxref <br />
969 ================================================ <br />
970 In addition to the primary
971 identifier (cvterm.dbxref_id) a cvterm can have zero or more secondary
972 identifiers/dbxrefs, which may refer to records in external
973 databases. The exact semantics of cvterm_dbxref are not fixed. For
974 example: the dbxref could be a pubmed ID that is pertinent to the
975 cvterm, or it could be an equivalent or similar term in another
976 ontology. For example, GO cvterms are typically linked to InterPro
977 IDs, even though the nature of the relationship between them is
978 largely one of statistical association. The dbxref may be have data
979 records attached in the same database instance, or it could be a
980 "hanging" dbxref pointing to some external database. NOTE: If the
981 desired objective is to link two cvterms together, and the nature of
982 the relation is known and holds for all instances of the subject
983 cvterm then consider instead using cvterm_relationship together with a
984 well-defined relation.
985 </em>
986
987 <table border="1">
988
989 <tr>
990 <th class="FieldHeader">
991 Field Name
992 </th>
993 <th class="FieldHeader">
994 Data Type
995 </th>
996 <th class="FieldHeader">
997 Size
998 </th>
999 <th class="FieldHeader">
1000 Default Value
1001 </th>
1002 <th class="FieldHeader">
1003 Other
1004 </th>
1005 <th class="FieldHeader">
1006 Foreign Key
1007 </th>
1008 </tr>
1009
1010 <tr class="tr-odd">
1011 <td class="FieldCellName"><a name="cvterm_dbxref-cvterm_dbxref_id">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>
1012 </tr>
1013
1014 <tr class="tr-even">
1015 <td class="FieldCellName"><a name="cvterm_dbxref-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>
1016 </tr>
1017
1018 <tr class="tr-odd">
1019 <td class="FieldCellName"><a name="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>
1020 </tr>
1021
1022 <tr class="tr-even">
1023 <td class="FieldCellName"><a name="cvterm_dbxref-is_for_definition">is_for_definition</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">NOT NULL, A
1024 cvterm.definition should be supported by one or more references. If
1025 this column is true, the dbxref is not for a term in an external database -
1026 it is a dbxref for provenance information for the definition. </td> <td class="FieldCellFK"></td>
1027 </tr>
1028
1029 </table>
1030
1031 <h3>
1032 Indices
1033 </h3>
1034
1035 <table border="1">
1036
1037 <tr class="IndexRow">
1038 <th>
1039 Name
1040 </th>
1041 <th>
1042 Fields
1043 </th>
1044 </tr>
1045
1046 <tr class="IndexCell">
1047 <td>cvterm_dbxref_idx1</td><td>cvterm_id</td>
1048 </tr>
1049
1050 <tr class="IndexCell">
1051 <td>cvterm_dbxref_idx2</td><td>dbxref_id</td>
1052 </tr>
1053
1054 </table>
1055
1056 <h3>
1057 Constraints
1058 </h3>
1059
1060 <table border="1">
1061
1062 <tr class="IndexRow">
1063 <th>
1064 Type
1065 </th>
1066 <th>
1067 Fields
1068 </th>
1069 </tr>
1070
1071 <tr class="IndexCell">
1072 <td>NOT NULL</td><td>cvterm_dbxref_id</td>
1073 </tr>
1074
1075 <tr class="IndexCell">
1076 <td>NOT NULL</td><td>cvterm_id</td>
1077 </tr>
1078
1079 <tr class="IndexCell">
1080 <td>FOREIGN KEY</td><td>cvterm_id</td>
1081 </tr>
1082
1083 <tr class="IndexCell">
1084 <td>NOT NULL</td><td>dbxref_id</td>
1085 </tr>
1086
1087 <tr class="IndexCell">
1088 <td>FOREIGN KEY</td><td>dbxref_id</td>
1089 </tr>
1090
1091 <tr class="IndexCell">
1092 <td>NOT NULL</td><td>is_for_definition</td>
1093 </tr>
1094
1095 <tr class="IndexCell">
1096 <td>UNIQUE</td><td>cvterm_id, dbxref_id</td>
1097 </tr>
1098
1099 </table>
1100
1101 <hr />
1102
1103 <!--
1104 Starting table 'cvtermprop'
1105 -->
1106
1107 <a name="cvtermprop" />
1108
1109 <table width="100%" class="TableHeader">
1110 <tr class="TableHeaderRow">
1111 <td class="TableHeaderCell"><h3>
1112 cvtermprop
1113 </h3></td> <a name="cvtermprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1114 </tr>
1115 </table>
1116
1117 <b>
1118 Comments:
1119 </b>
1120
1121 <br />
1122
1123 <em>
1124 <br />
1125 ================================================ <br />
1126 TABLE: cvtermprop <br />
1127 ================================================ <br />
1128 Additional extensible properties can be attached to a cvterm using this table. Corresponds to -AnnotationProperty- in W3C OWL format.
1129 </em>
1130
1131 <table border="1">
1132
1133 <tr>
1134 <th class="FieldHeader">
1135 Field Name
1136 </th>
1137 <th class="FieldHeader">
1138 Data Type
1139 </th>
1140 <th class="FieldHeader">
1141 Size
1142 </th>
1143 <th class="FieldHeader">
1144 Default Value
1145 </th>
1146 <th class="FieldHeader">
1147 Other
1148 </th>
1149 <th class="FieldHeader">
1150 Foreign Key
1151 </th>
1152 </tr>
1153
1154 <tr class="tr-odd">
1155 <td class="FieldCellName"><a name="cvtermprop-cvtermprop_id">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>
1156 </tr>
1157
1158 <tr class="tr-even">
1159 <td class="FieldCellName"><a name="cvtermprop-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>
1160 </tr>
1161
1162 <tr class="tr-odd">
1163 <td class="FieldCellName"><a name="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 property or slot is a cvterm. The meaning of the property is defined in that cvterm. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1164 </tr>
1165
1166 <tr class="tr-even">
1167 <td class="FieldCellName"><a name="cvtermprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, The value of the property, represented as text. Numeric values are converted to their text representation. </td> <td class="FieldCellFK"></td>
1168 </tr>
1169
1170 <tr class="tr-odd">
1171 <td class="FieldCellName"><a name="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 ordering. Any
1172 cvterm can have multiple values for any particular property type -
1173 these are ordered in a list using rank, counting from zero. For
1174 properties that are single-valued rather than multi-valued, the
1175 default 0 value should be used. </td> <td class="FieldCellFK"></td>
1176 </tr>
1177
1178 </table>
1179
1180 <h3>
1181 Indices
1182 </h3>
1183
1184 <table border="1">
1185
1186 <tr class="IndexRow">
1187 <th>
1188 Name
1189 </th>
1190 <th>
1191 Fields
1192 </th>
1193 </tr>
1194
1195 <tr class="IndexCell">
1196 <td>cvtermprop_idx1</td><td>cvterm_id</td>
1197 </tr>
1198
1199 <tr class="IndexCell">
1200 <td>cvtermprop_idx2</td><td>type_id</td>
1201 </tr>
1202
1203 </table>
1204
1205 <h3>
1206 Constraints
1207 </h3>
1208
1209 <table border="1">
1210
1211 <tr class="IndexRow">
1212 <th>
1213 Type
1214 </th>
1215 <th>
1216 Fields
1217 </th>
1218 </tr>
1219
1220 <tr class="IndexCell">
1221 <td>NOT NULL</td><td>cvtermprop_id</td>
1222 </tr>
1223
1224 <tr class="IndexCell">
1225 <td>NOT NULL</td><td>cvterm_id</td>
1226 </tr>
1227
1228 <tr class="IndexCell">
1229 <td>FOREIGN KEY</td><td>cvterm_id</td>
1230 </tr>
1231
1232 <tr class="IndexCell">
1233 <td>NOT NULL</td><td>type_id</td>
1234 </tr>
1235
1236 <tr class="IndexCell">
1237 <td>FOREIGN KEY</td><td>type_id</td>
1238 </tr>
1239
1240 <tr class="IndexCell">
1241 <td>NOT NULL</td><td>value</td>
1242 </tr>
1243
1244 <tr class="IndexCell">
1245 <td>NOT NULL</td><td>rank</td>
1246 </tr>
1247
1248 <tr class="IndexCell">
1249 <td>UNIQUE</td><td>cvterm_id, type_id, value, rank</td>
1250 </tr>
1251
1252 </table>
1253
1254 <hr />
1255
1256 <!--
1257 Starting table 'dbxrefprop'
1258 -->
1259
1260 <a name="dbxrefprop" />
1261
1262 <table class="TableHeader" width="100%">
1263 <tr class="TableHeaderRow">
1264 <td class="TableHeaderCell"><h3>
1265 dbxrefprop
1266 </h3></td> <a name="dbxrefprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1267 </tr>
1268 </table>
1269
1270 <b>
1271 Comments:
1272 </b>
1273
1274 <br />
1275
1276 <em>
1277 <br />
1278 ================================================ <br />
1279 TABLE: dbxrefprop <br />
1280 ================================================ <br />
1281 Metadata about a dbxref. Note that this is not defined in the dbxref module, as it depends on the cvterm table. This table has a structure analagous to cvtermprop.
1282 </em>
1283
1284 <table border="1">
1285
1286 <tr>
1287 <th class="FieldHeader">
1288 Field Name
1289 </th>
1290 <th class="FieldHeader">
1291 Data Type
1292 </th>
1293 <th class="FieldHeader">
1294 Size
1295 </th>
1296 <th class="FieldHeader">
1297 Default Value
1298 </th>
1299 <th class="FieldHeader">
1300 Other
1301 </th>
1302 <th class="FieldHeader">
1303 Foreign Key
1304 </th>
1305 </tr>
1306
1307 <tr class="tr-odd">
1308 <td class="FieldCellName"><a name="dbxrefprop-dbxrefprop_id">dbxrefprop_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>
1309 </tr>
1310
1311 <tr class="tr-even">
1312 <td class="FieldCellName"><a name="dbxrefprop-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>
1313 </tr>
1314
1315 <tr class="tr-odd">
1316 <td class="FieldCellName"><a name="dbxrefprop-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>
1317 </tr>
1318
1319 <tr class="tr-even">
1320 <td class="FieldCellName"><a name="dbxrefprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
1321 </tr>
1322
1323 <tr class="tr-odd">
1324 <td class="FieldCellName"><a name="dbxrefprop-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>
1325 </tr>
1326
1327 </table>
1328
1329 <h3>
1330 Indices
1331 </h3>
1332
1333 <table border="1">
1334
1335 <tr class="IndexRow">
1336 <th>
1337 Name
1338 </th>
1339 <th>
1340 Fields
1341 </th>
1342 </tr>
1343
1344 <tr class="IndexCell">
1345 <td>dbxrefprop_idx1</td><td>dbxref_id</td>
1346 </tr>
1347
1348 <tr class="IndexCell">
1349 <td>dbxrefprop_idx2</td><td>type_id</td>
1350 </tr>
1351
1352 </table>
1353
1354 <h3>
1355 Constraints
1356 </h3>
1357
1358 <table border="1">
1359
1360 <tr class="IndexRow">
1361 <th>
1362 Type
1363 </th>
1364 <th>
1365 Fields
1366 </th>
1367 </tr>
1368
1369 <tr class="IndexCell">
1370 <td>NOT NULL</td><td>dbxrefprop_id</td>
1371 </tr>
1372
1373 <tr class="IndexCell">
1374 <td>NOT NULL</td><td>dbxref_id</td>
1375 </tr>
1376
1377 <tr class="IndexCell">
1378 <td>FOREIGN KEY</td><td>dbxref_id</td>
1379 </tr>
1380
1381 <tr class="IndexCell">
1382 <td>NOT NULL</td><td>type_id</td>
1383 </tr>
1384
1385 <tr class="IndexCell">
1386 <td>FOREIGN KEY</td><td>type_id</td>
1387 </tr>
1388
1389 <tr class="IndexCell">
1390 <td>NOT NULL</td><td>value</td>
1391 </tr>
1392
1393 <tr class="IndexCell">
1394 <td>NOT NULL</td><td>rank</td>
1395 </tr>
1396
1397 <tr class="IndexCell">
1398 <td>UNIQUE</td><td>dbxref_id, type_id, rank</td>
1399 </tr>
1400
1401 </table>
1402
1403 <hr />
1404
1405 <!--
1406 Starting table 'cvprop'
1407 -->
1408
1409 <a name="cvprop" />
1410
1411 <table width="100%" class="TableHeader">
1412 <tr class="TableHeaderRow">
1413 <td class="TableHeaderCell"><h3>
1414 cvprop
1415 </h3></td> <a name="cvprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1416 </tr>
1417 </table>
1418
1419 <b>
1420 Comments:
1421 </b>
1422
1423 <br />
1424
1425 <em>
1426 <br />
1427 ================================================ <br />
1428 TABLE: cvprop <br />
1429 ================================================ <br />
1430 Additional extensible properties can be attached to a cv using this table. A notable example would be the cv version
1431 </em>
1432
1433 <table border="1">
1434
1435 <tr>
1436 <th class="FieldHeader">
1437 Field Name
1438 </th>
1439 <th class="FieldHeader">
1440 Data Type
1441 </th>
1442 <th class="FieldHeader">
1443 Size
1444 </th>
1445 <th class="FieldHeader">
1446 Default Value
1447 </th>
1448 <th class="FieldHeader">
1449 Other
1450 </th>
1451 <th class="FieldHeader">
1452 Foreign Key
1453 </th>
1454 </tr>
1455
1456 <tr class="tr-odd">
1457 <td class="FieldCellName"><a name="cvprop-cvprop_id">cvprop_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>
1458 </tr>
1459
1460 <tr class="tr-even">
1461 <td class="FieldCellName"><a name="cvprop-cv_id">cv_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="#cv-cv_id">cv.cv_id</a></td>
1462 </tr>
1463
1464 <tr class="tr-odd">
1465 <td class="FieldCellName"><a name="cvprop-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, The name of the property or slot is a cvterm. The meaning of the property is defined in that cvterm. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1466 </tr>
1467
1468 <tr class="tr-even">
1469 <td class="FieldCellName"><a name="cvprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">The value of the property, represented as text. Numeric values are converted to their text representation. </td> <td class="FieldCellFK"></td>
1470 </tr>
1471
1472 <tr class="tr-odd">
1473 <td class="FieldCellName"><a name="cvprop-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
1474 cv can have multiple values for any particular property type -
1475 these are ordered in a list using rank, counting from zero. For
1476 properties that are single-valued rather than multi-valued, the
1477 default 0 value should be used. </td> <td class="FieldCellFK"></td>
1478 </tr>
1479
1480 </table>
1481
1482 <h3>
1483 Constraints
1484 </h3>
1485
1486 <table border="1">
1487
1488 <tr class="IndexRow">
1489 <th>
1490 Type
1491 </th>
1492 <th>
1493 Fields
1494 </th>
1495 </tr>
1496
1497 <tr class="IndexCell">
1498 <td>NOT NULL</td><td>cvprop_id</td>
1499 </tr>
1500
1501 <tr class="IndexCell">
1502 <td>NOT NULL</td><td>cv_id</td>
1503 </tr>
1504
1505 <tr class="IndexCell">
1506 <td>FOREIGN KEY</td><td>cv_id</td>
1507 </tr>
1508
1509 <tr class="IndexCell">
1510 <td>NOT NULL</td><td>type_id</td>
1511 </tr>
1512
1513 <tr class="IndexCell">
1514 <td>FOREIGN KEY</td><td>type_id</td>
1515 </tr>
1516
1517 <tr class="IndexCell">
1518 <td>NOT NULL</td><td>rank</td>
1519 </tr>
1520
1521 <tr class="IndexCell">
1522 <td>UNIQUE</td><td>cv_id, type_id, rank</td>
1523 </tr>
1524
1525 </table>
1526
1527 <hr />
1528
1529 <!--
1530 Starting table 'chadoprop'
1531 -->
1532
1533 <a name="chadoprop" />
1534
1535 <table width="100%" class="TableHeader">
1536 <tr class="TableHeaderRow">
1537 <td class="TableHeaderCell"><h3>
1538 chadoprop
1539 </h3></td> <a name="chadoprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1540 </tr>
1541 </table>
1542
1543 <b>
1544 Comments:
1545 </b>
1546
1547 <br />
1548
1549 <em>
1550 <br />
1551 ================================================ <br />
1552 TABLE: chadoprop <br />
1553 ================================================ <br />
1554 This table is different from other prop tables in the database, as it is for storing information about the database itself, like schema version
1555 </em>
1556
1557 <table border="1">
1558
1559 <tr>
1560 <th class="FieldHeader">
1561 Field Name
1562 </th>
1563 <th class="FieldHeader">
1564 Data Type
1565 </th>
1566 <th class="FieldHeader">
1567 Size
1568 </th>
1569 <th class="FieldHeader">
1570 Default Value
1571 </th>
1572 <th class="FieldHeader">
1573 Other
1574 </th>
1575 <th class="FieldHeader">
1576 Foreign Key
1577 </th>
1578 </tr>
1579
1580 <tr class="tr-odd">
1581 <td class="FieldCellName"><a name="chadoprop-chadoprop_id">chadoprop_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>
1582 </tr>
1583
1584 <tr class="tr-even">
1585 <td class="FieldCellName"><a name="chadoprop-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, The name of the property or slot is a cvterm. The meaning of the property is defined in that cvterm. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1586 </tr>
1587
1588 <tr class="tr-odd">
1589 <td class="FieldCellName"><a name="chadoprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">The value of the property, represented as text. Numeric values are converted to their text representation. </td> <td class="FieldCellFK"></td>
1590 </tr>
1591
1592 <tr class="tr-even">
1593 <td class="FieldCellName"><a name="chadoprop-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
1594 cv can have multiple values for any particular property type -
1595 these are ordered in a list using rank, counting from zero. For
1596 properties that are single-valued rather than multi-valued, the
1597 default 0 value should be used. </td> <td class="FieldCellFK"></td>
1598 </tr>
1599
1600 </table>
1601
1602 <h3>
1603 Constraints
1604 </h3>
1605
1606 <table border="1">
1607
1608 <tr class="IndexRow">
1609 <th>
1610 Type
1611 </th>
1612 <th>
1613 Fields
1614 </th>
1615 </tr>
1616
1617 <tr class="IndexCell">
1618 <td>NOT NULL</td><td>chadoprop_id</td>
1619 </tr>
1620
1621 <tr class="IndexCell">
1622 <td>NOT NULL</td><td>type_id</td>
1623 </tr>
1624
1625 <tr class="IndexCell">
1626 <td>FOREIGN KEY</td><td>type_id</td>
1627 </tr>
1628
1629 <tr class="IndexCell">
1630 <td>NOT NULL</td><td>rank</td>
1631 </tr>
1632
1633 <tr class="IndexCell">
1634 <td>UNIQUE</td><td>type_id, rank</td>
1635 </tr>
1636
1637 </table>
1638
1639 <hr />
1640
1641 <!--
1642 Starting table 'dbprop'
1643 -->
1644
1645 <a name="dbprop" />
1646
1647 <table width="100%" class="TableHeader">
1648 <tr class="TableHeaderRow">
1649 <td class="TableHeaderCell"><h3>
1650 dbprop
1651 </h3></td> <a name="dbprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1652 </tr>
1653 </table>
1654
1655 <b>
1656 Comments:
1657 </b>
1658
1659 <br />
1660
1661 <em>
1662 <br />
1663 ================================================ <br />
1664 TABLE: dbprop <br />
1665 ================================================ <br />
1666 An external database can have any number of
1667 slot-value property tags attached to it. This is an alternative to
1668 hardcoding a list of columns in the relational schema, and is
1669 completely extensible. There is a unique constraint, dbprop_c1, for
1670 the combination of db_id, rank, and type_id. Multivalued property-value pairs must be differentiated by rank.
1671 </em>
1672
1673 <table border="1">
1674
1675 <tr>
1676 <th class="FieldHeader">
1677 Field Name
1678 </th>
1679 <th class="FieldHeader">
1680 Data Type
1681 </th>
1682 <th class="FieldHeader">
1683 Size
1684 </th>
1685 <th class="FieldHeader">
1686 Default Value
1687 </th>
1688 <th class="FieldHeader">
1689 Other
1690 </th>
1691 <th class="FieldHeader">
1692 Foreign Key
1693 </th>
1694 </tr>
1695
1696 <tr class="tr-odd">
1697 <td class="FieldCellName"><a name="dbprop-dbprop_id">dbprop_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>
1698 </tr>
1699
1700 <tr class="tr-even">
1701 <td class="FieldCellName"><a name="dbprop-db_id">db_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="#db-db_id">db.db_id</a></td>
1702 </tr>
1703
1704 <tr class="tr-odd">
1705 <td class="FieldCellName"><a name="dbprop-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>
1706 </tr>
1707
1708 <tr class="tr-even">
1709 <td class="FieldCellName"><a name="dbprop-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>
1710 </tr>
1711
1712 <tr class="tr-odd">
1713 <td class="FieldCellName"><a name="dbprop-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>
1714 </tr>
1715
1716 </table>
1717
1718 <h3>
1719 Indices
1720 </h3>
1721
1722 <table border="1">
1723
1724 <tr class="IndexRow">
1725 <th>
1726 Name
1727 </th>
1728 <th>
1729 Fields
1730 </th>
1731 </tr>
1732
1733 <tr class="IndexCell">
1734 <td>dbprop_idx1</td><td>db_id</td>
1735 </tr>
1736
1737 <tr class="IndexCell">
1738 <td>dbprop_idx2</td><td>type_id</td>
1739 </tr>
1740
1741 </table>
1742
1743 <h3>
1744 Constraints
1745 </h3>
1746
1747 <table border="1">
1748
1749 <tr class="IndexRow">
1750 <th>
1751 Type
1752 </th>
1753 <th>
1754 Fields
1755 </th>
1756 </tr>
1757
1758 <tr class="IndexCell">
1759 <td>NOT NULL</td><td>dbprop_id</td>
1760 </tr>
1761
1762 <tr class="IndexCell">
1763 <td>NOT NULL</td><td>db_id</td>
1764 </tr>
1765
1766 <tr class="IndexCell">
1767 <td>NOT NULL</td><td>type_id</td>
1768 </tr>
1769
1770 <tr class="IndexCell">
1771 <td>NOT NULL</td><td>rank</td>
1772 </tr>
1773
1774 <tr class="IndexCell">
1775 <td>FOREIGN KEY</td><td>type_id</td>
1776 </tr>
1777
1778 <tr class="IndexCell">
1779 <td>FOREIGN KEY</td><td>db_id</td>
1780 </tr>
1781
1782 <tr class="IndexCell">
1783 <td>UNIQUE</td><td>db_id, type_id, rank</td>
1784 </tr>
1785
1786 </table>
1787
1788 <hr />
1789
1790 Created by <a href="http://sqlfairy.sourceforge.net">
1791 SQL::Translator 0.11020</a>
1792
1793 </body>
1794 </html>