Debian Codegraph @

modules/phenotype/phenotype.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 (4 tables)
21 -->
22
23 <a name="top" />
24
25 <table width="100%" class="LinkTable">
26
27 <tr>
28 <td class="LinkTableCell"><h2 class="LinkTableTitle">
29 Tables
30 </h2></td>
31 </tr>
32
33 <!--
34 Start link to table 'phenotype'
35 -->
36
37 <tr class="LinkTableRow">
38 <td class="LinkTableCell"><a id="phenotype-link" href="#phenotype">phenotype</a></td>
39 </tr>
40
41 <!--
42 End link to table 'phenotype'
43 -->
44
45 <!--
46 Start link to table 'phenotype_cvterm'
47 -->
48
49 <tr class="LinkTableRow">
50 <td class="LinkTableCell"><a id="phenotype_cvterm-link" href="#phenotype_cvterm">phenotype_cvterm</a></td>
51 </tr>
52
53 <!--
54 End link to table 'phenotype_cvterm'
55 -->
56
57 <!--
58 Start link to table 'feature_phenotype'
59 -->
60
61 <tr class="LinkTableRow">
62 <td class="LinkTableCell"><a id="feature_phenotype-link" href="#feature_phenotype">feature_phenotype</a></td>
63 </tr>
64
65 <!--
66 End link to table 'feature_phenotype'
67 -->
68
69 <!--
70 Start link to table 'phenotypeprop'
71 -->
72
73 <tr class="LinkTableRow">
74 <td class="LinkTableCell"><a id="phenotypeprop-link" href="#phenotypeprop">phenotypeprop</a></td>
75 </tr>
76
77 <!--
78 End link to table 'phenotypeprop'
79 -->
80
81 </table>
82
83 <!--
84 Starting table 'phenotype'
85 -->
86
87 <a name="phenotype" />
88
89 <table width="100%" class="TableHeader">
90 <tr class="TableHeaderRow">
91 <td class="TableHeaderCell"><h3>
92 phenotype
93 </h3></td> <a name="phenotype"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
94 </tr>
95 </table>
96
97 <b>
98 Comments:
99 </b>
100
101 <br />
102
103 <em>
104 <br />
105 $Id: phenotype.sql,v 1.6 2007-04-27 16:09:46 emmert Exp $ <br />
106 ========================================== <br />
107 Chado phenotype module <br />
108 05-31-2011 <br />
109 added 'name' column to phenotype. non-unique human readable field. <br />
110 ================================================================= <br />
111 Dependencies: <br />
112 :import cvterm from cv <br />
113 :import feature from sequence <br />
114 ================================================================= <br />
115 ================================================ <br />
116 TABLE: phenotype <br />
117 ================================================ <br />
118 A phenotypic statement, or a single
119 atomic phenotypic observation, is a controlled sentence describing
120 observable effects of non-wild type function. E.g. Obs=eye, attribute=color, cvalue=red.
121 </em>
122
123 <table border="1">
124
125 <tr>
126 <th class="FieldHeader">
127 Field Name
128 </th>
129 <th class="FieldHeader">
130 Data Type
131 </th>
132 <th class="FieldHeader">
133 Size
134 </th>
135 <th class="FieldHeader">
136 Default Value
137 </th>
138 <th class="FieldHeader">
139 Other
140 </th>
141 <th class="FieldHeader">
142 Foreign Key
143 </th>
144 </tr>
145
146 <tr class="tr-odd">
147 <td class="FieldCellName"><a name="phenotype-phenotype_id">phenotype_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>
148 </tr>
149
150 <tr class="tr-even">
151 <td class="FieldCellName"><a name="phenotype-uniquename">uniquename</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
152 </tr>
153
154 <tr class="tr-odd">
155 <td class="FieldCellName"><a name="phenotype-name">name</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">null</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
156 </tr>
157
158 <tr class="tr-even">
159 <td class="FieldCellName"><a name="phenotype-observable_id">observable_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">The entity: e.g. anatomy_part, biological_process. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
160 </tr>
161
162 <tr class="tr-odd">
163 <td class="FieldCellName"><a name="phenotype-attr_id">attr_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">Phenotypic attribute (quality, property, attribute, character) - drawn from PATO. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
164 </tr>
165
166 <tr class="tr-even">
167 <td class="FieldCellName"><a name="phenotype-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">Value of attribute - unconstrained free text. Used only if cvalue_id is not appropriate. </td> <td class="FieldCellFK"></td>
168 </tr>
169
170 <tr class="tr-odd">
171 <td class="FieldCellName"><a name="phenotype-cvalue_id">cvalue_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">Phenotype attribute value (state). </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
172 </tr>
173
174 <tr class="tr-even">
175 <td class="FieldCellName"><a name="phenotype-assay_id">assay_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">Evidence type. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
176 </tr>
177
178 </table>
179
180 <h3>
181 Indices
182 </h3>
183
184 <table border="1">
185
186 <tr class="IndexRow">
187 <th>
188 Name
189 </th>
190 <th>
191 Fields
192 </th>
193 </tr>
194
195 <tr class="IndexCell">
196 <td>phenotype_idx1</td><td>cvalue_id</td>
197 </tr>
198
199 <tr class="IndexCell">
200 <td>phenotype_idx2</td><td>observable_id</td>
201 </tr>
202
203 <tr class="IndexCell">
204 <td>phenotype_idx3</td><td>attr_id</td>
205 </tr>
206
207 </table>
208
209 <h3>
210 Constraints
211 </h3>
212
213 <table border="1">
214
215 <tr class="IndexRow">
216 <th>
217 Type
218 </th>
219 <th>
220 Fields
221 </th>
222 </tr>
223
224 <tr class="IndexCell">
225 <td>NOT NULL</td><td>phenotype_id</td>
226 </tr>
227
228 <tr class="IndexCell">
229 <td>NOT NULL</td><td>uniquename</td>
230 </tr>
231
232 <tr class="IndexCell">
233 <td>FOREIGN KEY</td><td>observable_id</td>
234 </tr>
235
236 <tr class="IndexCell">
237 <td>FOREIGN KEY</td><td>attr_id</td>
238 </tr>
239
240 <tr class="IndexCell">
241 <td>FOREIGN KEY</td><td>cvalue_id</td>
242 </tr>
243
244 <tr class="IndexCell">
245 <td>FOREIGN KEY</td><td>assay_id</td>
246 </tr>
247
248 <tr class="IndexCell">
249 <td>UNIQUE</td><td>uniquename</td>
250 </tr>
251
252 </table>
253
254 <hr />
255
256 <!--
257 Starting table 'phenotype_cvterm'
258 -->
259
260 <a name="phenotype_cvterm" />
261
262 <table width="100%" class="TableHeader">
263 <tr class="TableHeaderRow">
264 <td class="TableHeaderCell"><h3>
265 phenotype_cvterm
266 </h3></td> <a name="phenotype_cvterm"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
267 </tr>
268 </table>
269
270 <b>
271 Comments:
272 </b>
273
274 <br />
275
276 <em>
277 <br />
278 ================================================ <br />
279 TABLE: phenotype_cvterm <br />
280 ================================================ <br />
281 phenotype to cvterm associations.
282 </em>
283
284 <table border="1">
285
286 <tr>
287 <th class="FieldHeader">
288 Field Name
289 </th>
290 <th class="FieldHeader">
291 Data Type
292 </th>
293 <th class="FieldHeader">
294 Size
295 </th>
296 <th class="FieldHeader">
297 Default Value
298 </th>
299 <th class="FieldHeader">
300 Other
301 </th>
302 <th class="FieldHeader">
303 Foreign Key
304 </th>
305 </tr>
306
307 <tr class="tr-odd">
308 <td class="FieldCellName"><a name="phenotype_cvterm-phenotype_cvterm_id">phenotype_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>
309 </tr>
310
311 <tr class="tr-even">
312 <td class="FieldCellName"><a name="phenotype_cvterm-phenotype_id">phenotype_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#phenotype-phenotype_id">phenotype.phenotype_id</a></td>
313 </tr>
314
315 <tr class="tr-odd">
316 <td class="FieldCellName"><a name="phenotype_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>
317 </tr>
318
319 <tr class="tr-even">
320 <td class="FieldCellName"><a name="phenotype_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>
321 </tr>
322
323 </table>
324
325 <h3>
326 Indices
327 </h3>
328
329 <table border="1">
330
331 <tr class="IndexRow">
332 <th>
333 Name
334 </th>
335 <th>
336 Fields
337 </th>
338 </tr>
339
340 <tr class="IndexCell">
341 <td>phenotype_cvterm_idx1</td><td>phenotype_id</td>
342 </tr>
343
344 <tr class="IndexCell">
345 <td>phenotype_cvterm_idx2</td><td>cvterm_id</td>
346 </tr>
347
348 </table>
349
350 <h3>
351 Constraints
352 </h3>
353
354 <table border="1">
355
356 <tr class="IndexRow">
357 <th>
358 Type
359 </th>
360 <th>
361 Fields
362 </th>
363 </tr>
364
365 <tr class="IndexCell">
366 <td>NOT NULL</td><td>phenotype_cvterm_id</td>
367 </tr>
368
369 <tr class="IndexCell">
370 <td>NOT NULL</td><td>phenotype_id</td>
371 </tr>
372
373 <tr class="IndexCell">
374 <td>FOREIGN KEY</td><td>phenotype_id</td>
375 </tr>
376
377 <tr class="IndexCell">
378 <td>NOT NULL</td><td>cvterm_id</td>
379 </tr>
380
381 <tr class="IndexCell">
382 <td>FOREIGN KEY</td><td>cvterm_id</td>
383 </tr>
384
385 <tr class="IndexCell">
386 <td>NOT NULL</td><td>rank</td>
387 </tr>
388
389 <tr class="IndexCell">
390 <td>UNIQUE</td><td>phenotype_id, cvterm_id, rank</td>
391 </tr>
392
393 </table>
394
395 <hr />
396
397 <!--
398 Starting table 'feature_phenotype'
399 -->
400
401 <a name="feature_phenotype" />
402
403 <table class="TableHeader" width="100%">
404 <tr class="TableHeaderRow">
405 <td class="TableHeaderCell"><h3>
406 feature_phenotype
407 </h3></td> <a name="feature_phenotype"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
408 </tr>
409 </table>
410
411 <b>
412 Comments:
413 </b>
414
415 <br />
416
417 <em>
418 <br />
419 ================================================ <br />
420 TABLE: feature_phenotype <br />
421 ================================================ <br />
422 Linking table between features and phenotypes.
423 </em>
424
425 <table border="1">
426
427 <tr>
428 <th class="FieldHeader">
429 Field Name
430 </th>
431 <th class="FieldHeader">
432 Data Type
433 </th>
434 <th class="FieldHeader">
435 Size
436 </th>
437 <th class="FieldHeader">
438 Default Value
439 </th>
440 <th class="FieldHeader">
441 Other
442 </th>
443 <th class="FieldHeader">
444 Foreign Key
445 </th>
446 </tr>
447
448 <tr class="tr-odd">
449 <td class="FieldCellName"><a name="feature_phenotype-feature_phenotype_id">feature_phenotype_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>
450 </tr>
451
452 <tr class="tr-even">
453 <td class="FieldCellName"><a name="feature_phenotype-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>
454 </tr>
455
456 <tr class="tr-odd">
457 <td class="FieldCellName"><a name="feature_phenotype-phenotype_id">phenotype_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#phenotype-phenotype_id">phenotype.phenotype_id</a></td>
458 </tr>
459
460 </table>
461
462 <h3>
463 Indices
464 </h3>
465
466 <table border="1">
467
468 <tr class="IndexRow">
469 <th>
470 Name
471 </th>
472 <th>
473 Fields
474 </th>
475 </tr>
476
477 <tr class="IndexCell">
478 <td>feature_phenotype_idx1</td><td>feature_id</td>
479 </tr>
480
481 <tr class="IndexCell">
482 <td>feature_phenotype_idx2</td><td>phenotype_id</td>
483 </tr>
484
485 </table>
486
487 <h3>
488 Constraints
489 </h3>
490
491 <table border="1">
492
493 <tr class="IndexRow">
494 <th>
495 Type
496 </th>
497 <th>
498 Fields
499 </th>
500 </tr>
501
502 <tr class="IndexCell">
503 <td>NOT NULL</td><td>feature_phenotype_id</td>
504 </tr>
505
506 <tr class="IndexCell">
507 <td>NOT NULL</td><td>feature_id</td>
508 </tr>
509
510 <tr class="IndexCell">
511 <td>FOREIGN KEY</td><td>feature_id</td>
512 </tr>
513
514 <tr class="IndexCell">
515 <td>NOT NULL</td><td>phenotype_id</td>
516 </tr>
517
518 <tr class="IndexCell">
519 <td>FOREIGN KEY</td><td>phenotype_id</td>
520 </tr>
521
522 <tr class="IndexCell">
523 <td>UNIQUE</td><td>feature_id, phenotype_id</td>
524 </tr>
525
526 </table>
527
528 <hr />
529
530 <!--
531 Starting table 'phenotypeprop'
532 -->
533
534 <a name="phenotypeprop" />
535
536 <table width="100%" class="TableHeader">
537 <tr class="TableHeaderRow">
538 <td class="TableHeaderCell"><h3>
539 phenotypeprop
540 </h3></td> <a name="phenotypeprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
541 </tr>
542 </table>
543
544 <b>
545 Comments:
546 </b>
547
548 <br />
549
550 <em>
551 <br />
552 ================================================ <br />
553 TABLE: phenotypeprop <br />
554 ================================================ <br />
555 A phenotype 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. There is a unique constraint, phenotypeprop_c1, for the combination of phenotype_id, rank, and type_id. Multivalued property-value pairs must be differentiated by rank.
556 </em>
557
558 <table border="1">
559
560 <tr>
561 <th class="FieldHeader">
562 Field Name
563 </th>
564 <th class="FieldHeader">
565 Data Type
566 </th>
567 <th class="FieldHeader">
568 Size
569 </th>
570 <th class="FieldHeader">
571 Default Value
572 </th>
573 <th class="FieldHeader">
574 Other
575 </th>
576 <th class="FieldHeader">
577 Foreign Key
578 </th>
579 </tr>
580
581 <tr class="tr-odd">
582 <td class="FieldCellName"><a name="phenotypeprop-phenotypeprop_id">phenotypeprop_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>
583 </tr>
584
585 <tr class="tr-even">
586 <td class="FieldCellName"><a name="phenotypeprop-phenotype_id">phenotype_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#phenotype-phenotype_id">phenotype.phenotype_id</a></td>
587 </tr>
588
589 <tr class="tr-odd">
590 <td class="FieldCellName"><a name="phenotypeprop-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>
591 </tr>
592
593 <tr class="tr-even">
594 <td class="FieldCellName"><a name="phenotypeprop-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>
595 </tr>
596
597 <tr class="tr-odd">
598 <td class="FieldCellName"><a name="phenotypeprop-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>
599 </tr>
600
601 </table>
602
603 <h3>
604 Indices
605 </h3>
606
607 <table border="1">
608
609 <tr class="IndexRow">
610 <th>
611 Name
612 </th>
613 <th>
614 Fields
615 </th>
616 </tr>
617
618 <tr class="IndexCell">
619 <td>phenotypeprop_idx1</td><td>phenotype_id</td>
620 </tr>
621
622 <tr class="IndexCell">
623 <td>phenotypeprop_idx2</td><td>type_id</td>
624 </tr>
625
626 </table>
627
628 <h3>
629 Constraints
630 </h3>
631
632 <table border="1">
633
634 <tr class="IndexRow">
635 <th>
636 Type
637 </th>
638 <th>
639 Fields
640 </th>
641 </tr>
642
643 <tr class="IndexCell">
644 <td>NOT NULL</td><td>phenotypeprop_id</td>
645 </tr>
646
647 <tr class="IndexCell">
648 <td>NOT NULL</td><td>phenotype_id</td>
649 </tr>
650
651 <tr class="IndexCell">
652 <td>FOREIGN KEY</td><td>phenotype_id</td>
653 </tr>
654
655 <tr class="IndexCell">
656 <td>NOT NULL</td><td>type_id</td>
657 </tr>
658
659 <tr class="IndexCell">
660 <td>FOREIGN KEY</td><td>type_id</td>
661 </tr>
662
663 <tr class="IndexCell">
664 <td>NOT NULL</td><td>rank</td>
665 </tr>
666
667 <tr class="IndexCell">
668 <td>UNIQUE</td><td>phenotype_id, type_id, rank</td>
669 </tr>
670
671 </table>
672
673 <hr />
674
675 Created by <a href="http://sqlfairy.sourceforge.net">
676 SQL::Translator 0.11020</a>
677
678 </body>
679 </html>