Debian Codegraph @

modules/project/project.html

raw
1 <!DOCTYPE html
2 PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
3 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4 <html xmlns="http://www.w3.org/1999/xhtml" lang="en-US" xml:lang="en-US">
5 <head>
6 <title>Description of Schema</title>
7 <meta name="generator" content="SQL::Translator::Producer::HTML" />
8 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
9 </head>
10 <body>
11
12
13 <h1 class="SchemaDescription">
14 Description of Schema
15 </h1>
16
17 <hr />
18
19 <!--
20 Table listing (9 tables)
21 -->
22
23 <a name="top" />
24
25 <table class="LinkTable" width="100%">
26
27 <tr>
28 <td class="LinkTableCell"><h2 class="LinkTableTitle">
29 Tables
30 </h2></td>
31 </tr>
32
33 <!--
34 Start link to table 'project'
35 -->
36
37 <tr class="LinkTableRow">
38 <td class="LinkTableCell"><a id="project-link" href="#project">project</a></td>
39 </tr>
40
41 <!--
42 End link to table 'project'
43 -->
44
45 <!--
46 Start link to table 'projectprop'
47 -->
48
49 <tr class="LinkTableRow">
50 <td class="LinkTableCell"><a id="projectprop-link" href="#projectprop">projectprop</a></td>
51 </tr>
52
53 <!--
54 End link to table 'projectprop'
55 -->
56
57 <!--
58 Start link to table 'project_relationship'
59 -->
60
61 <tr class="LinkTableRow">
62 <td class="LinkTableCell"><a id="project_relationship-link" href="#project_relationship">project_relationship</a></td>
63 </tr>
64
65 <!--
66 End link to table 'project_relationship'
67 -->
68
69 <!--
70 Start link to table 'project_pub'
71 -->
72
73 <tr class="LinkTableRow">
74 <td class="LinkTableCell"><a id="project_pub-link" href="#project_pub">project_pub</a></td>
75 </tr>
76
77 <!--
78 End link to table 'project_pub'
79 -->
80
81 <!--
82 Start link to table 'project_contact'
83 -->
84
85 <tr class="LinkTableRow">
86 <td class="LinkTableCell"><a id="project_contact-link" href="#project_contact">project_contact</a></td>
87 </tr>
88
89 <!--
90 End link to table 'project_contact'
91 -->
92
93 <!--
94 Start link to table 'project_dbxref'
95 -->
96
97 <tr class="LinkTableRow">
98 <td class="LinkTableCell"><a id="project_dbxref-link" href="#project_dbxref">project_dbxref</a></td>
99 </tr>
100
101 <!--
102 End link to table 'project_dbxref'
103 -->
104
105 <!--
106 Start link to table 'project_analysis'
107 -->
108
109 <tr class="LinkTableRow">
110 <td class="LinkTableCell"><a id="project_analysis-link" href="#project_analysis">project_analysis</a></td>
111 </tr>
112
113 <!--
114 End link to table 'project_analysis'
115 -->
116
117 <!--
118 Start link to table 'project_feature'
119 -->
120
121 <tr class="LinkTableRow">
122 <td class="LinkTableCell"><a id="project_feature-link" href="#project_feature">project_feature</a></td>
123 </tr>
124
125 <!--
126 End link to table 'project_feature'
127 -->
128
129 <!--
130 Start link to table 'project_stock'
131 -->
132
133 <tr class="LinkTableRow">
134 <td class="LinkTableCell"><a id="project_stock-link" href="#project_stock">project_stock</a></td>
135 </tr>
136
137 <!--
138 End link to table 'project_stock'
139 -->
140
141 </table>
142
143 <!--
144 Starting table 'project'
145 -->
146
147 <a name="project" />
148
149 <table width="100%" class="TableHeader">
150 <tr class="TableHeaderRow">
151 <td class="TableHeaderCell"><h3>
152 project
153 </h3></td> <a name="project"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
154 </tr>
155 </table>
156
157 <b>
158 Comments:
159 </b>
160
161 <br />
162
163 <em>
164 <br />
165 ========================================== <br />
166 Chado project module. Used primarily by other Chado modules to <br />
167 group experiments, stocks, and so forth that are associated with <br />
168 eachother administratively or organizationally. <br />
169 ================================================================= <br />
170 Dependencies: <br />
171 :import cvterm from cv <br />
172 :import pub from pub <br />
173 :import contact from contact <br />
174 :import dbxref from db <br />
175 :import analysis from companalysis <br />
176 :import feature from sequence <br />
177 :import stock from stock <br />
178 ================================================================= <br />
179 ================================================ <br />
180 TABLE: project <br />
181 ================================================ <br />
182 A project is some kind of planned endeavor. Used primarily by other
183 Chado modules to group experiments, stocks, and so forth that are
184 associated with eachother administratively or organizationally. <br />
185 Standard Chado flexible property table for projects.
186 </em>
187
188 <table border="1">
189
190 <tr>
191 <th class="FieldHeader">
192 Field Name
193 </th>
194 <th class="FieldHeader">
195 Data Type
196 </th>
197 <th class="FieldHeader">
198 Size
199 </th>
200 <th class="FieldHeader">
201 Default Value
202 </th>
203 <th class="FieldHeader">
204 Other
205 </th>
206 <th class="FieldHeader">
207 Foreign Key
208 </th>
209 </tr>
210
211 <tr class="tr-odd">
212 <td class="FieldCellName"><a name="project-project_id">project_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>
213 </tr>
214
215 <tr class="tr-even">
216 <td class="FieldCellName"><a name="project-name">name</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
217 </tr>
218
219 <tr class="tr-odd">
220 <td class="FieldCellName"><a name="project-description">description</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
221 </tr>
222
223 </table>
224
225 <h3>
226 Constraints
227 </h3>
228
229 <table border="1">
230
231 <tr class="IndexRow">
232 <th>
233 Type
234 </th>
235 <th>
236 Fields
237 </th>
238 </tr>
239
240 <tr class="IndexCell">
241 <td>NOT NULL</td><td>project_id</td>
242 </tr>
243
244 <tr class="IndexCell">
245 <td>NOT NULL</td><td>name</td>
246 </tr>
247
248 <tr class="IndexCell">
249 <td>UNIQUE</td><td>name</td>
250 </tr>
251
252 </table>
253
254 <hr />
255
256 <!--
257 Starting table 'projectprop'
258 -->
259
260 <a name="projectprop" />
261
262 <table width="100%" class="TableHeader">
263 <tr class="TableHeaderRow">
264 <td class="TableHeaderCell"><h3>
265 projectprop
266 </h3></td> <a name="projectprop"> <td class="TableHeaderCell" align="right"><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: projectprop <br />
280 ================================================
281 </em>
282
283 <table border="1">
284
285 <tr>
286 <th class="FieldHeader">
287 Field Name
288 </th>
289 <th class="FieldHeader">
290 Data Type
291 </th>
292 <th class="FieldHeader">
293 Size
294 </th>
295 <th class="FieldHeader">
296 Default Value
297 </th>
298 <th class="FieldHeader">
299 Other
300 </th>
301 <th class="FieldHeader">
302 Foreign Key
303 </th>
304 </tr>
305
306 <tr class="tr-odd">
307 <td class="FieldCellName"><a name="projectprop-projectprop_id">projectprop_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>
308 </tr>
309
310 <tr class="tr-even">
311 <td class="FieldCellName"><a name="projectprop-project_id">project_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="#project-project_id">project.project_id</a></td>
312 </tr>
313
314 <tr class="tr-odd">
315 <td class="FieldCellName"><a name="projectprop-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>
316 </tr>
317
318 <tr class="tr-even">
319 <td class="FieldCellName"><a name="projectprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
320 </tr>
321
322 <tr class="tr-odd">
323 <td class="FieldCellName"><a name="projectprop-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>
324 </tr>
325
326 </table>
327
328 <h3>
329 Constraints
330 </h3>
331
332 <table border="1">
333
334 <tr class="IndexRow">
335 <th>
336 Type
337 </th>
338 <th>
339 Fields
340 </th>
341 </tr>
342
343 <tr class="IndexCell">
344 <td>NOT NULL</td><td>projectprop_id</td>
345 </tr>
346
347 <tr class="IndexCell">
348 <td>NOT NULL</td><td>project_id</td>
349 </tr>
350
351 <tr class="IndexCell">
352 <td>FOREIGN KEY</td><td>project_id</td>
353 </tr>
354
355 <tr class="IndexCell">
356 <td>NOT NULL</td><td>type_id</td>
357 </tr>
358
359 <tr class="IndexCell">
360 <td>FOREIGN KEY</td><td>type_id</td>
361 </tr>
362
363 <tr class="IndexCell">
364 <td>NOT NULL</td><td>rank</td>
365 </tr>
366
367 <tr class="IndexCell">
368 <td>UNIQUE</td><td>project_id, type_id, rank</td>
369 </tr>
370
371 </table>
372
373 <hr />
374
375 <!--
376 Starting table 'project_relationship'
377 -->
378
379 <a name="project_relationship" />
380
381 <table width="100%" class="TableHeader">
382 <tr class="TableHeaderRow">
383 <td class="TableHeaderCell"><h3>
384 project_relationship
385 </h3></td> <a name="project_relationship"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
386 </tr>
387 </table>
388
389 <b>
390 Comments:
391 </b>
392
393 <br />
394
395 <em>
396 <br />
397 ================================================ <br />
398 TABLE: project_relationship <br />
399 ================================================ <br />
400 Linking table for relating projects to each other. For example, a
401 given project could be composed of several smaller subprojects
402 </em>
403
404 <table border="1">
405
406 <tr>
407 <th class="FieldHeader">
408 Field Name
409 </th>
410 <th class="FieldHeader">
411 Data Type
412 </th>
413 <th class="FieldHeader">
414 Size
415 </th>
416 <th class="FieldHeader">
417 Default Value
418 </th>
419 <th class="FieldHeader">
420 Other
421 </th>
422 <th class="FieldHeader">
423 Foreign Key
424 </th>
425 </tr>
426
427 <tr class="tr-odd">
428 <td class="FieldCellName"><a name="project_relationship-project_relationship_id">project_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>
429 </tr>
430
431 <tr class="tr-even">
432 <td class="FieldCellName"><a name="project_relationship-subject_project_id">subject_project_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="#project-project_id">project.project_id</a></td>
433 </tr>
434
435 <tr class="tr-odd">
436 <td class="FieldCellName"><a name="project_relationship-object_project_id">object_project_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="#project-project_id">project.project_id</a></td>
437 </tr>
438
439 <tr class="tr-even">
440 <td class="FieldCellName"><a name="project_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 cvterm type of the relationship being stated, such as "part of". </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
441 </tr>
442
443 </table>
444
445 <h3>
446 Constraints
447 </h3>
448
449 <table border="1">
450
451 <tr class="IndexRow">
452 <th>
453 Type
454 </th>
455 <th>
456 Fields
457 </th>
458 </tr>
459
460 <tr class="IndexCell">
461 <td>NOT NULL</td><td>project_relationship_id</td>
462 </tr>
463
464 <tr class="IndexCell">
465 <td>NOT NULL</td><td>subject_project_id</td>
466 </tr>
467
468 <tr class="IndexCell">
469 <td>FOREIGN KEY</td><td>subject_project_id</td>
470 </tr>
471
472 <tr class="IndexCell">
473 <td>NOT NULL</td><td>object_project_id</td>
474 </tr>
475
476 <tr class="IndexCell">
477 <td>FOREIGN KEY</td><td>object_project_id</td>
478 </tr>
479
480 <tr class="IndexCell">
481 <td>NOT NULL</td><td>type_id</td>
482 </tr>
483
484 <tr class="IndexCell">
485 <td>FOREIGN KEY</td><td>type_id</td>
486 </tr>
487
488 <tr class="IndexCell">
489 <td>UNIQUE</td><td>subject_project_id, object_project_id, type_id</td>
490 </tr>
491
492 </table>
493
494 <hr />
495
496 <!--
497 Starting table 'project_pub'
498 -->
499
500 <a name="project_pub" />
501
502 <table class="TableHeader" width="100%">
503 <tr class="TableHeaderRow">
504 <td class="TableHeaderCell"><h3>
505 project_pub
506 </h3></td> <a name="project_pub"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
507 </tr>
508 </table>
509
510 <b>
511 Comments:
512 </b>
513
514 <br />
515
516 <em>
517 <br />
518 ================================================ <br />
519 TABLE: project_pub <br />
520 ================================================ <br />
521 Linking table for associating projects and publications.
522 </em>
523
524 <table border="1">
525
526 <tr>
527 <th class="FieldHeader">
528 Field Name
529 </th>
530 <th class="FieldHeader">
531 Data Type
532 </th>
533 <th class="FieldHeader">
534 Size
535 </th>
536 <th class="FieldHeader">
537 Default Value
538 </th>
539 <th class="FieldHeader">
540 Other
541 </th>
542 <th class="FieldHeader">
543 Foreign Key
544 </th>
545 </tr>
546
547 <tr class="tr-odd">
548 <td class="FieldCellName"><a name="project_pub-project_pub_id">project_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>
549 </tr>
550
551 <tr class="tr-even">
552 <td class="FieldCellName"><a name="project_pub-project_id">project_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="#project-project_id">project.project_id</a></td>
553 </tr>
554
555 <tr class="tr-odd">
556 <td class="FieldCellName"><a name="project_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>
557 </tr>
558
559 </table>
560
561 <h3>
562 Indices
563 </h3>
564
565 <table border="1">
566
567 <tr class="IndexRow">
568 <th>
569 Name
570 </th>
571 <th>
572 Fields
573 </th>
574 </tr>
575
576 <tr class="IndexCell">
577 <td>project_pub_idx1</td><td>project_id</td>
578 </tr>
579
580 <tr class="IndexCell">
581 <td>project_pub_idx2</td><td>pub_id</td>
582 </tr>
583
584 </table>
585
586 <h3>
587 Constraints
588 </h3>
589
590 <table border="1">
591
592 <tr class="IndexRow">
593 <th>
594 Type
595 </th>
596 <th>
597 Fields
598 </th>
599 </tr>
600
601 <tr class="IndexCell">
602 <td>NOT NULL</td><td>project_pub_id</td>
603 </tr>
604
605 <tr class="IndexCell">
606 <td>NOT NULL</td><td>project_id</td>
607 </tr>
608
609 <tr class="IndexCell">
610 <td>FOREIGN KEY</td><td>project_id</td>
611 </tr>
612
613 <tr class="IndexCell">
614 <td>NOT NULL</td><td>pub_id</td>
615 </tr>
616
617 <tr class="IndexCell">
618 <td>FOREIGN KEY</td><td>pub_id</td>
619 </tr>
620
621 <tr class="IndexCell">
622 <td>UNIQUE</td><td>project_id, pub_id</td>
623 </tr>
624
625 </table>
626
627 <hr />
628
629 <!--
630 Starting table 'project_contact'
631 -->
632
633 <a name="project_contact" />
634
635 <table width="100%" class="TableHeader">
636 <tr class="TableHeaderRow">
637 <td class="TableHeaderCell"><h3>
638 project_contact
639 </h3></td> <a name="project_contact"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
640 </tr>
641 </table>
642
643 <b>
644 Comments:
645 </b>
646
647 <br />
648
649 <em>
650 <br />
651 ================================================ <br />
652 TABLE: project_contact <br />
653 ================================================ <br />
654 Linking table for associating projects and contacts.
655 </em>
656
657 <table border="1">
658
659 <tr>
660 <th class="FieldHeader">
661 Field Name
662 </th>
663 <th class="FieldHeader">
664 Data Type
665 </th>
666 <th class="FieldHeader">
667 Size
668 </th>
669 <th class="FieldHeader">
670 Default Value
671 </th>
672 <th class="FieldHeader">
673 Other
674 </th>
675 <th class="FieldHeader">
676 Foreign Key
677 </th>
678 </tr>
679
680 <tr class="tr-odd">
681 <td class="FieldCellName"><a name="project_contact-project_contact_id">project_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>
682 </tr>
683
684 <tr class="tr-even">
685 <td class="FieldCellName"><a name="project_contact-project_id">project_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="#project-project_id">project.project_id</a></td>
686 </tr>
687
688 <tr class="tr-odd">
689 <td class="FieldCellName"><a name="project_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>
690 </tr>
691
692 </table>
693
694 <h3>
695 Indices
696 </h3>
697
698 <table border="1">
699
700 <tr class="IndexRow">
701 <th>
702 Name
703 </th>
704 <th>
705 Fields
706 </th>
707 </tr>
708
709 <tr class="IndexCell">
710 <td>project_contact_idx1</td><td>project_id</td>
711 </tr>
712
713 <tr class="IndexCell">
714 <td>project_contact_idx2</td><td>contact_id</td>
715 </tr>
716
717 </table>
718
719 <h3>
720 Constraints
721 </h3>
722
723 <table border="1">
724
725 <tr class="IndexRow">
726 <th>
727 Type
728 </th>
729 <th>
730 Fields
731 </th>
732 </tr>
733
734 <tr class="IndexCell">
735 <td>NOT NULL</td><td>project_contact_id</td>
736 </tr>
737
738 <tr class="IndexCell">
739 <td>NOT NULL</td><td>project_id</td>
740 </tr>
741
742 <tr class="IndexCell">
743 <td>FOREIGN KEY</td><td>project_id</td>
744 </tr>
745
746 <tr class="IndexCell">
747 <td>NOT NULL</td><td>contact_id</td>
748 </tr>
749
750 <tr class="IndexCell">
751 <td>FOREIGN KEY</td><td>contact_id</td>
752 </tr>
753
754 <tr class="IndexCell">
755 <td>UNIQUE</td><td>project_id, contact_id</td>
756 </tr>
757
758 </table>
759
760 <hr />
761
762 <!--
763 Starting table 'project_dbxref'
764 -->
765
766 <a name="project_dbxref" />
767
768 <table class="TableHeader" width="100%">
769 <tr class="TableHeaderRow">
770 <td class="TableHeaderCell"><h3>
771 project_dbxref
772 </h3></td> <a name="project_dbxref"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
773 </tr>
774 </table>
775
776 <b>
777 Comments:
778 </b>
779
780 <br />
781
782 <em>
783 <br />
784 ================================================ <br />
785 TABLE: project_dbxref <br />
786 ================================================ <br />
787 project_dbxref links a project to dbxrefs.
788 </em>
789
790 <table border="1">
791
792 <tr>
793 <th class="FieldHeader">
794 Field Name
795 </th>
796 <th class="FieldHeader">
797 Data Type
798 </th>
799 <th class="FieldHeader">
800 Size
801 </th>
802 <th class="FieldHeader">
803 Default Value
804 </th>
805 <th class="FieldHeader">
806 Other
807 </th>
808 <th class="FieldHeader">
809 Foreign Key
810 </th>
811 </tr>
812
813 <tr class="tr-odd">
814 <td class="FieldCellName"><a name="project_dbxref-project_dbxref_id">project_dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
815 </tr>
816
817 <tr class="tr-even">
818 <td class="FieldCellName"><a name="project_dbxref-project_id">project_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="#project-project_id">project.project_id</a></td>
819 </tr>
820
821 <tr class="tr-odd">
822 <td class="FieldCellName"><a name="project_dbxref-dbxref_id">dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
823 </tr>
824
825 <tr class="tr-even">
826 <td class="FieldCellName"><a name="project_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, The is_current boolean indicates whether the linked dbxref is the current -official- dbxref for the linked project. </td> <td class="FieldCellFK"></td>
827 </tr>
828
829 </table>
830
831 <h3>
832 Indices
833 </h3>
834
835 <table border="1">
836
837 <tr class="IndexRow">
838 <th>
839 Name
840 </th>
841 <th>
842 Fields
843 </th>
844 </tr>
845
846 <tr class="IndexCell">
847 <td>project_dbxref_idx1</td><td>project_id</td>
848 </tr>
849
850 <tr class="IndexCell">
851 <td>project_dbxref_idx2</td><td>dbxref_id</td>
852 </tr>
853
854 </table>
855
856 <h3>
857 Constraints
858 </h3>
859
860 <table border="1">
861
862 <tr class="IndexRow">
863 <th>
864 Type
865 </th>
866 <th>
867 Fields
868 </th>
869 </tr>
870
871 <tr class="IndexCell">
872 <td>NOT NULL</td><td>project_dbxref_id</td>
873 </tr>
874
875 <tr class="IndexCell">
876 <td>NOT NULL</td><td>project_id</td>
877 </tr>
878
879 <tr class="IndexCell">
880 <td>NOT NULL</td><td>dbxref_id</td>
881 </tr>
882
883 <tr class="IndexCell">
884 <td>NOT NULL</td><td>is_current</td>
885 </tr>
886
887 <tr class="IndexCell">
888 <td>FOREIGN KEY</td><td>dbxref_id</td>
889 </tr>
890
891 <tr class="IndexCell">
892 <td>FOREIGN KEY</td><td>project_id</td>
893 </tr>
894
895 <tr class="IndexCell">
896 <td>UNIQUE</td><td>project_id, dbxref_id</td>
897 </tr>
898
899 </table>
900
901 <hr />
902
903 <!--
904 Starting table 'project_analysis'
905 -->
906
907 <a name="project_analysis" />
908
909 <table width="100%" class="TableHeader">
910 <tr class="TableHeaderRow">
911 <td class="TableHeaderCell"><h3>
912 project_analysis
913 </h3></td> <a name="project_analysis"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
914 </tr>
915 </table>
916
917 <b>
918 Comments:
919 </b>
920
921 <br />
922
923 <em>
924 <br />
925 ================================================ <br />
926 TABLE: project_analysis <br />
927 ================================================ <br />
928 Links an analysis to a project that may contain multiple analyses.
929 The rank column can be used to specify a simple ordering in which analyses were executed.
930 </em>
931
932 <table border="1">
933
934 <tr>
935 <th class="FieldHeader">
936 Field Name
937 </th>
938 <th class="FieldHeader">
939 Data Type
940 </th>
941 <th class="FieldHeader">
942 Size
943 </th>
944 <th class="FieldHeader">
945 Default Value
946 </th>
947 <th class="FieldHeader">
948 Other
949 </th>
950 <th class="FieldHeader">
951 Foreign Key
952 </th>
953 </tr>
954
955 <tr class="tr-odd">
956 <td class="FieldCellName"><a name="project_analysis-project_analysis_id">project_analysis_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>
957 </tr>
958
959 <tr class="tr-even">
960 <td class="FieldCellName"><a name="project_analysis-project_id">project_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="#project-project_id">project.project_id</a></td>
961 </tr>
962
963 <tr class="tr-odd">
964 <td class="FieldCellName"><a name="project_analysis-analysis_id">analysis_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="#analysis-analysis_id">analysis.analysis_id</a></td>
965 </tr>
966
967 <tr class="tr-even">
968 <td class="FieldCellName"><a name="project_analysis-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
969 </tr>
970
971 </table>
972
973 <h3>
974 Indices
975 </h3>
976
977 <table border="1">
978
979 <tr class="IndexRow">
980 <th>
981 Name
982 </th>
983 <th>
984 Fields
985 </th>
986 </tr>
987
988 <tr class="IndexCell">
989 <td>project_analysis_idx1</td><td>project_id</td>
990 </tr>
991
992 <tr class="IndexCell">
993 <td>project_analysis_idx2</td><td>analysis_id</td>
994 </tr>
995
996 </table>
997
998 <h3>
999 Constraints
1000 </h3>
1001
1002 <table border="1">
1003
1004 <tr class="IndexRow">
1005 <th>
1006 Type
1007 </th>
1008 <th>
1009 Fields
1010 </th>
1011 </tr>
1012
1013 <tr class="IndexCell">
1014 <td>NOT NULL</td><td>project_analysis_id</td>
1015 </tr>
1016
1017 <tr class="IndexCell">
1018 <td>NOT NULL</td><td>project_id</td>
1019 </tr>
1020
1021 <tr class="IndexCell">
1022 <td>FOREIGN KEY</td><td>project_id</td>
1023 </tr>
1024
1025 <tr class="IndexCell">
1026 <td>NOT NULL</td><td>analysis_id</td>
1027 </tr>
1028
1029 <tr class="IndexCell">
1030 <td>FOREIGN KEY</td><td>analysis_id</td>
1031 </tr>
1032
1033 <tr class="IndexCell">
1034 <td>NOT NULL</td><td>rank</td>
1035 </tr>
1036
1037 <tr class="IndexCell">
1038 <td>UNIQUE</td><td>project_id, analysis_id</td>
1039 </tr>
1040
1041 </table>
1042
1043 <hr />
1044
1045 <!--
1046 Starting table 'project_feature'
1047 -->
1048
1049 <a name="project_feature" />
1050
1051 <table width="100%" class="TableHeader">
1052 <tr class="TableHeaderRow">
1053 <td class="TableHeaderCell"><h3>
1054 project_feature
1055 </h3></td> <a name="project_feature"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1056 </tr>
1057 </table>
1058
1059 <b>
1060 Comments:
1061 </b>
1062
1063 <br />
1064
1065 <em>
1066 <br />
1067 ================================================ <br />
1068 TABLE: project_feature <br />
1069 ================================================ <br />
1070 This table is intended associate records in the feature table with a project.
1071 </em>
1072
1073 <table border="1">
1074
1075 <tr>
1076 <th class="FieldHeader">
1077 Field Name
1078 </th>
1079 <th class="FieldHeader">
1080 Data Type
1081 </th>
1082 <th class="FieldHeader">
1083 Size
1084 </th>
1085 <th class="FieldHeader">
1086 Default Value
1087 </th>
1088 <th class="FieldHeader">
1089 Other
1090 </th>
1091 <th class="FieldHeader">
1092 Foreign Key
1093 </th>
1094 </tr>
1095
1096 <tr class="tr-odd">
1097 <td class="FieldCellName"><a name="project_feature-project_feature_id">project_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>
1098 </tr>
1099
1100 <tr class="tr-even">
1101 <td class="FieldCellName"><a name="project_feature-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>
1102 </tr>
1103
1104 <tr class="tr-odd">
1105 <td class="FieldCellName"><a name="project_feature-project_id">project_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="#project-project_id">project.project_id</a></td>
1106 </tr>
1107
1108 </table>
1109
1110 <h3>
1111 Indices
1112 </h3>
1113
1114 <table border="1">
1115
1116 <tr class="IndexRow">
1117 <th>
1118 Name
1119 </th>
1120 <th>
1121 Fields
1122 </th>
1123 </tr>
1124
1125 <tr class="IndexCell">
1126 <td>project_feature_idx1</td><td>feature_id</td>
1127 </tr>
1128
1129 <tr class="IndexCell">
1130 <td>project_feature_idx2</td><td>project_id</td>
1131 </tr>
1132
1133 </table>
1134
1135 <h3>
1136 Constraints
1137 </h3>
1138
1139 <table border="1">
1140
1141 <tr class="IndexRow">
1142 <th>
1143 Type
1144 </th>
1145 <th>
1146 Fields
1147 </th>
1148 </tr>
1149
1150 <tr class="IndexCell">
1151 <td>NOT NULL</td><td>project_feature_id</td>
1152 </tr>
1153
1154 <tr class="IndexCell">
1155 <td>NOT NULL</td><td>feature_id</td>
1156 </tr>
1157
1158 <tr class="IndexCell">
1159 <td>NOT NULL</td><td>project_id</td>
1160 </tr>
1161
1162 <tr class="IndexCell">
1163 <td>UNIQUE</td><td>feature_id, project_id</td>
1164 </tr>
1165
1166 <tr class="IndexCell">
1167 <td>FOREIGN KEY</td><td>feature_id</td>
1168 </tr>
1169
1170 <tr class="IndexCell">
1171 <td>FOREIGN KEY</td><td>project_id</td>
1172 </tr>
1173
1174 </table>
1175
1176 <hr />
1177
1178 <!--
1179 Starting table 'project_stock'
1180 -->
1181
1182 <a name="project_stock" />
1183
1184 <table class="TableHeader" width="100%">
1185 <tr class="TableHeaderRow">
1186 <td class="TableHeaderCell"><h3>
1187 project_stock
1188 </h3></td> <a name="project_stock"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1189 </tr>
1190 </table>
1191
1192 <b>
1193 Comments:
1194 </b>
1195
1196 <br />
1197
1198 <em>
1199 <br />
1200 ================================================ <br />
1201 TABLE: project_stock <br />
1202 ================================================ <br />
1203 This table is intended associate records in the stock table with a project.
1204 </em>
1205
1206 <table border="1">
1207
1208 <tr>
1209 <th class="FieldHeader">
1210 Field Name
1211 </th>
1212 <th class="FieldHeader">
1213 Data Type
1214 </th>
1215 <th class="FieldHeader">
1216 Size
1217 </th>
1218 <th class="FieldHeader">
1219 Default Value
1220 </th>
1221 <th class="FieldHeader">
1222 Other
1223 </th>
1224 <th class="FieldHeader">
1225 Foreign Key
1226 </th>
1227 </tr>
1228
1229 <tr class="tr-odd">
1230 <td class="FieldCellName"><a name="project_stock-project_stock_id">project_stock_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>
1231 </tr>
1232
1233 <tr class="tr-even">
1234 <td class="FieldCellName"><a name="project_stock-stock_id">stock_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="#stock-stock_id">stock.stock_id</a></td>
1235 </tr>
1236
1237 <tr class="tr-odd">
1238 <td class="FieldCellName"><a name="project_stock-project_id">project_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="#project-project_id">project.project_id</a></td>
1239 </tr>
1240
1241 </table>
1242
1243 <h3>
1244 Indices
1245 </h3>
1246
1247 <table border="1">
1248
1249 <tr class="IndexRow">
1250 <th>
1251 Name
1252 </th>
1253 <th>
1254 Fields
1255 </th>
1256 </tr>
1257
1258 <tr class="IndexCell">
1259 <td>project_stock_idx1</td><td>stock_id</td>
1260 </tr>
1261
1262 <tr class="IndexCell">
1263 <td>project_stock_idx2</td><td>project_id</td>
1264 </tr>
1265
1266 </table>
1267
1268 <h3>
1269 Constraints
1270 </h3>
1271
1272 <table border="1">
1273
1274 <tr class="IndexRow">
1275 <th>
1276 Type
1277 </th>
1278 <th>
1279 Fields
1280 </th>
1281 </tr>
1282
1283 <tr class="IndexCell">
1284 <td>NOT NULL</td><td>project_stock_id</td>
1285 </tr>
1286
1287 <tr class="IndexCell">
1288 <td>NOT NULL</td><td>stock_id</td>
1289 </tr>
1290
1291 <tr class="IndexCell">
1292 <td>NOT NULL</td><td>project_id</td>
1293 </tr>
1294
1295 <tr class="IndexCell">
1296 <td>UNIQUE</td><td>stock_id, project_id</td>
1297 </tr>
1298
1299 <tr class="IndexCell">
1300 <td>FOREIGN KEY</td><td>stock_id</td>
1301 </tr>
1302
1303 <tr class="IndexCell">
1304 <td>FOREIGN KEY</td><td>project_id</td>
1305 </tr>
1306
1307 </table>
1308
1309 <hr />
1310
1311 Created by <a href="http://sqlfairy.sourceforge.net">
1312 SQL::Translator 0.11020</a>
1313
1314 </body>
1315 </html>