Debian Codegraph @

modules/stock/stock.html

raw
1 <!DOCTYPE html
2 PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
3 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4 <html xmlns="http://www.w3.org/1999/xhtml" lang="en-US" xml:lang="en-US">
5 <head>
6 <title>Description of Schema</title>
7 <meta name="generator" content="SQL::Translator::Producer::HTML" />
8 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
9 </head>
10 <body>
11
12
13 <h1 class="SchemaDescription">
14 Description of Schema
15 </h1>
16
17 <hr />
18
19 <!--
20 Table listing (19 tables)
21 -->
22
23 <a name="top" />
24
25 <table 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 'stock'
35 -->
36
37 <tr class="LinkTableRow">
38 <td class="LinkTableCell"><a id="stock-link" href="#stock">stock</a></td>
39 </tr>
40
41 <!--
42 End link to table 'stock'
43 -->
44
45 <!--
46 Start link to table 'stock_pub'
47 -->
48
49 <tr class="LinkTableRow">
50 <td class="LinkTableCell"><a id="stock_pub-link" href="#stock_pub">stock_pub</a></td>
51 </tr>
52
53 <!--
54 End link to table 'stock_pub'
55 -->
56
57 <!--
58 Start link to table 'stockprop'
59 -->
60
61 <tr class="LinkTableRow">
62 <td class="LinkTableCell"><a id="stockprop-link" href="#stockprop">stockprop</a></td>
63 </tr>
64
65 <!--
66 End link to table 'stockprop'
67 -->
68
69 <!--
70 Start link to table 'stockprop_pub'
71 -->
72
73 <tr class="LinkTableRow">
74 <td class="LinkTableCell"><a id="stockprop_pub-link" href="#stockprop_pub">stockprop_pub</a></td>
75 </tr>
76
77 <!--
78 End link to table 'stockprop_pub'
79 -->
80
81 <!--
82 Start link to table 'stock_relationship'
83 -->
84
85 <tr class="LinkTableRow">
86 <td class="LinkTableCell"><a id="stock_relationship-link" href="#stock_relationship">stock_relationship</a></td>
87 </tr>
88
89 <!--
90 End link to table 'stock_relationship'
91 -->
92
93 <!--
94 Start link to table 'stock_relationship_cvterm'
95 -->
96
97 <tr class="LinkTableRow">
98 <td class="LinkTableCell"><a id="stock_relationship_cvterm-link" href="#stock_relationship_cvterm">stock_relationship_cvterm</a></td>
99 </tr>
100
101 <!--
102 End link to table 'stock_relationship_cvterm'
103 -->
104
105 <!--
106 Start link to table 'stock_relationship_pub'
107 -->
108
109 <tr class="LinkTableRow">
110 <td class="LinkTableCell"><a id="stock_relationship_pub-link" href="#stock_relationship_pub">stock_relationship_pub</a></td>
111 </tr>
112
113 <!--
114 End link to table 'stock_relationship_pub'
115 -->
116
117 <!--
118 Start link to table 'stock_dbxref'
119 -->
120
121 <tr class="LinkTableRow">
122 <td class="LinkTableCell"><a id="stock_dbxref-link" href="#stock_dbxref">stock_dbxref</a></td>
123 </tr>
124
125 <!--
126 End link to table 'stock_dbxref'
127 -->
128
129 <!--
130 Start link to table 'stock_cvterm'
131 -->
132
133 <tr class="LinkTableRow">
134 <td class="LinkTableCell"><a id="stock_cvterm-link" href="#stock_cvterm">stock_cvterm</a></td>
135 </tr>
136
137 <!--
138 End link to table 'stock_cvterm'
139 -->
140
141 <!--
142 Start link to table 'stock_cvtermprop'
143 -->
144
145 <tr class="LinkTableRow">
146 <td class="LinkTableCell"><a id="stock_cvtermprop-link" href="#stock_cvtermprop">stock_cvtermprop</a></td>
147 </tr>
148
149 <!--
150 End link to table 'stock_cvtermprop'
151 -->
152
153 <!--
154 Start link to table 'stock_genotype'
155 -->
156
157 <tr class="LinkTableRow">
158 <td class="LinkTableCell"><a id="stock_genotype-link" href="#stock_genotype">stock_genotype</a></td>
159 </tr>
160
161 <!--
162 End link to table 'stock_genotype'
163 -->
164
165 <!--
166 Start link to table 'stockcollection'
167 -->
168
169 <tr class="LinkTableRow">
170 <td class="LinkTableCell"><a id="stockcollection-link" href="#stockcollection">stockcollection</a></td>
171 </tr>
172
173 <!--
174 End link to table 'stockcollection'
175 -->
176
177 <!--
178 Start link to table 'stockcollectionprop'
179 -->
180
181 <tr class="LinkTableRow">
182 <td class="LinkTableCell"><a id="stockcollectionprop-link" href="#stockcollectionprop">stockcollectionprop</a></td>
183 </tr>
184
185 <!--
186 End link to table 'stockcollectionprop'
187 -->
188
189 <!--
190 Start link to table 'stockcollection_stock'
191 -->
192
193 <tr class="LinkTableRow">
194 <td class="LinkTableCell"><a id="stockcollection_stock-link" href="#stockcollection_stock">stockcollection_stock</a></td>
195 </tr>
196
197 <!--
198 End link to table 'stockcollection_stock'
199 -->
200
201 <!--
202 Start link to table 'stock_dbxrefprop'
203 -->
204
205 <tr class="LinkTableRow">
206 <td class="LinkTableCell"><a id="stock_dbxrefprop-link" href="#stock_dbxrefprop">stock_dbxrefprop</a></td>
207 </tr>
208
209 <!--
210 End link to table 'stock_dbxrefprop'
211 -->
212
213 <!--
214 Start link to table 'stockcollection_db'
215 -->
216
217 <tr class="LinkTableRow">
218 <td class="LinkTableCell"><a id="stockcollection_db-link" href="#stockcollection_db">stockcollection_db</a></td>
219 </tr>
220
221 <!--
222 End link to table 'stockcollection_db'
223 -->
224
225 <!--
226 Start link to table 'stock_feature'
227 -->
228
229 <tr class="LinkTableRow">
230 <td class="LinkTableCell"><a id="stock_feature-link" href="#stock_feature">stock_feature</a></td>
231 </tr>
232
233 <!--
234 End link to table 'stock_feature'
235 -->
236
237 <!--
238 Start link to table 'stock_featuremap'
239 -->
240
241 <tr class="LinkTableRow">
242 <td class="LinkTableCell"><a id="stock_featuremap-link" href="#stock_featuremap">stock_featuremap</a></td>
243 </tr>
244
245 <!--
246 End link to table 'stock_featuremap'
247 -->
248
249 <!--
250 Start link to table 'stock_library'
251 -->
252
253 <tr class="LinkTableRow">
254 <td class="LinkTableCell"><a id="stock_library-link" href="#stock_library">stock_library</a></td>
255 </tr>
256
257 <!--
258 End link to table 'stock_library'
259 -->
260
261 </table>
262
263 <!--
264 Starting table 'stock'
265 -->
266
267 <a name="stock" />
268
269 <table width="100%" class="TableHeader">
270 <tr class="TableHeaderRow">
271 <td class="TableHeaderCell"><h3>
272 stock
273 </h3></td> <a name="stock"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
274 </tr>
275 </table>
276
277 <b>
278 Comments:
279 </b>
280
281 <br />
282
283 <em>
284 <br />
285 $Id: stock.sql,v 1.7 2007-03-23 15:18:03 scottcain Exp $ <br />
286 ========================================== <br />
287 Chado stock module <br />
288 DEPENDENCIES <br />
289 ============ <br />
290 :import cvterm from cv <br />
291 :import pub from pub <br />
292 :import dbxref from db <br />
293 :import organism from organism <br />
294 :import genotype from genetic <br />
295 :import contact from contact <br />
296 :import feature from sequence <br />
297 :import featuremap from map <br />
298 ================================================ <br />
299 TABLE: stock <br />
300 ================================================ <br />
301 Any stock can be globally identified by the
302 combination of organism, uniquename and stock type. A stock is the physical entities, either living or preserved, held by collections. Stocks belong to a collection; they have IDs, type, organism, description and may have a genotype.
303 </em>
304
305 <table border="1">
306
307 <tr>
308 <th class="FieldHeader">
309 Field Name
310 </th>
311 <th class="FieldHeader">
312 Data Type
313 </th>
314 <th class="FieldHeader">
315 Size
316 </th>
317 <th class="FieldHeader">
318 Default Value
319 </th>
320 <th class="FieldHeader">
321 Other
322 </th>
323 <th class="FieldHeader">
324 Foreign Key
325 </th>
326 </tr>
327
328 <tr class="tr-odd">
329 <td class="FieldCellName"><a name="stock-stock_id">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>
330 </tr>
331
332 <tr class="tr-even">
333 <td class="FieldCellName"><a name="stock-dbxref_id">dbxref_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">The dbxref_id is an optional primary stable identifier for this stock. Secondary indentifiers and external dbxrefs go in table: stock_dbxref. </td> <td class="FieldCellFK"><a href="#dbxref-dbxref_id">dbxref.dbxref_id</a></td>
334 </tr>
335
336 <tr class="tr-odd">
337 <td class="FieldCellName"><a name="stock-organism_id">organism_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, The organism_id is the organism to which the stock belongs. This column should only be left blank if the organism cannot be determined. </td> <td class="FieldCellFK"><a href="#organism-organism_id">organism.organism_id</a></td>
338 </tr>
339
340 <tr class="tr-even">
341 <td class="FieldCellName"><a name="stock-name">name</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">The name is a human-readable local name for a stock. </td> <td class="FieldCellFK"></td>
342 </tr>
343
344 <tr class="tr-odd">
345 <td class="FieldCellName"><a name="stock-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>
346 </tr>
347
348 <tr class="tr-even">
349 <td class="FieldCellName"><a name="stock-description">description</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">The description is the genetic description provided in the stock list. </td> <td class="FieldCellFK"></td>
350 </tr>
351
352 <tr class="tr-odd">
353 <td class="FieldCellName"><a name="stock-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 type_id foreign key links to a controlled vocabulary of stock types. The would include living stock, genomic DNA, preserved specimen. Secondary cvterms for stocks would go in stock_cvterm. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
354 </tr>
355
356 <tr class="tr-even">
357 <td class="FieldCellName"><a name="stock-is_obsolete">is_obsolete</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">false</td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
358 </tr>
359
360 </table>
361
362 <h3>
363 Indices
364 </h3>
365
366 <table border="1">
367
368 <tr class="IndexRow">
369 <th>
370 Name
371 </th>
372 <th>
373 Fields
374 </th>
375 </tr>
376
377 <tr class="IndexCell">
378 <td>stock_name_ind1</td><td>name</td>
379 </tr>
380
381 <tr class="IndexCell">
382 <td>stock_idx1</td><td>dbxref_id</td>
383 </tr>
384
385 <tr class="IndexCell">
386 <td>stock_idx2</td><td>organism_id</td>
387 </tr>
388
389 <tr class="IndexCell">
390 <td>stock_idx3</td><td>type_id</td>
391 </tr>
392
393 <tr class="IndexCell">
394 <td>stock_idx4</td><td>uniquename</td>
395 </tr>
396
397 </table>
398
399 <h3>
400 Constraints
401 </h3>
402
403 <table border="1">
404
405 <tr class="IndexRow">
406 <th>
407 Type
408 </th>
409 <th>
410 Fields
411 </th>
412 </tr>
413
414 <tr class="IndexCell">
415 <td>NOT NULL</td><td>stock_id</td>
416 </tr>
417
418 <tr class="IndexCell">
419 <td>FOREIGN KEY</td><td>dbxref_id</td>
420 </tr>
421
422 <tr class="IndexCell">
423 <td>FOREIGN KEY</td><td>organism_id</td>
424 </tr>
425
426 <tr class="IndexCell">
427 <td>NOT NULL</td><td>uniquename</td>
428 </tr>
429
430 <tr class="IndexCell">
431 <td>NOT NULL</td><td>type_id</td>
432 </tr>
433
434 <tr class="IndexCell">
435 <td>FOREIGN KEY</td><td>type_id</td>
436 </tr>
437
438 <tr class="IndexCell">
439 <td>NOT NULL</td><td>is_obsolete</td>
440 </tr>
441
442 <tr class="IndexCell">
443 <td>UNIQUE</td><td>organism_id, uniquename, type_id</td>
444 </tr>
445
446 </table>
447
448 <hr />
449
450 <!--
451 Starting table 'stock_pub'
452 -->
453
454 <a name="stock_pub" />
455
456 <table width="100%" class="TableHeader">
457 <tr class="TableHeaderRow">
458 <td class="TableHeaderCell"><h3>
459 stock_pub
460 </h3></td> <a name="stock_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
461 </tr>
462 </table>
463
464 <b>
465 Comments:
466 </b>
467
468 <br />
469
470 <em>
471 <br />
472 ================================================ <br />
473 TABLE: stock_pub <br />
474 ================================================ <br />
475 Provenance. Linking table between stocks and, for example, a stocklist computer file.
476 </em>
477
478 <table border="1">
479
480 <tr>
481 <th class="FieldHeader">
482 Field Name
483 </th>
484 <th class="FieldHeader">
485 Data Type
486 </th>
487 <th class="FieldHeader">
488 Size
489 </th>
490 <th class="FieldHeader">
491 Default Value
492 </th>
493 <th class="FieldHeader">
494 Other
495 </th>
496 <th class="FieldHeader">
497 Foreign Key
498 </th>
499 </tr>
500
501 <tr class="tr-odd">
502 <td class="FieldCellName"><a name="stock_pub-stock_pub_id">stock_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>
503 </tr>
504
505 <tr class="tr-even">
506 <td class="FieldCellName"><a name="stock_pub-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>
507 </tr>
508
509 <tr class="tr-odd">
510 <td class="FieldCellName"><a name="stock_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>
511 </tr>
512
513 </table>
514
515 <h3>
516 Indices
517 </h3>
518
519 <table border="1">
520
521 <tr class="IndexRow">
522 <th>
523 Name
524 </th>
525 <th>
526 Fields
527 </th>
528 </tr>
529
530 <tr class="IndexCell">
531 <td>stock_pub_idx1</td><td>stock_id</td>
532 </tr>
533
534 <tr class="IndexCell">
535 <td>stock_pub_idx2</td><td>pub_id</td>
536 </tr>
537
538 </table>
539
540 <h3>
541 Constraints
542 </h3>
543
544 <table border="1">
545
546 <tr class="IndexRow">
547 <th>
548 Type
549 </th>
550 <th>
551 Fields
552 </th>
553 </tr>
554
555 <tr class="IndexCell">
556 <td>NOT NULL</td><td>stock_pub_id</td>
557 </tr>
558
559 <tr class="IndexCell">
560 <td>NOT NULL</td><td>stock_id</td>
561 </tr>
562
563 <tr class="IndexCell">
564 <td>FOREIGN KEY</td><td>stock_id</td>
565 </tr>
566
567 <tr class="IndexCell">
568 <td>NOT NULL</td><td>pub_id</td>
569 </tr>
570
571 <tr class="IndexCell">
572 <td>FOREIGN KEY</td><td>pub_id</td>
573 </tr>
574
575 <tr class="IndexCell">
576 <td>UNIQUE</td><td>stock_id, pub_id</td>
577 </tr>
578
579 </table>
580
581 <hr />
582
583 <!--
584 Starting table 'stockprop'
585 -->
586
587 <a name="stockprop" />
588
589 <table width="100%" class="TableHeader">
590 <tr class="TableHeaderRow">
591 <td class="TableHeaderCell"><h3>
592 stockprop
593 </h3></td> <a name="stockprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
594 </tr>
595 </table>
596
597 <b>
598 Comments:
599 </b>
600
601 <br />
602
603 <em>
604 <br />
605 ================================================ <br />
606 TABLE: stockprop <br />
607 ================================================ <br />
608 A stock can have any number of
609 slot-value property tags attached to it. This is an alternative to
610 hardcoding a list of columns in the relational schema, and is
611 completely extensible. There is a unique constraint, stockprop_c1, for
612 the combination of stock_id, rank, and type_id. Multivalued property-value pairs must be differentiated by rank.
613 </em>
614
615 <table border="1">
616
617 <tr>
618 <th class="FieldHeader">
619 Field Name
620 </th>
621 <th class="FieldHeader">
622 Data Type
623 </th>
624 <th class="FieldHeader">
625 Size
626 </th>
627 <th class="FieldHeader">
628 Default Value
629 </th>
630 <th class="FieldHeader">
631 Other
632 </th>
633 <th class="FieldHeader">
634 Foreign Key
635 </th>
636 </tr>
637
638 <tr class="tr-odd">
639 <td class="FieldCellName"><a name="stockprop-stockprop_id">stockprop_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>
640 </tr>
641
642 <tr class="tr-even">
643 <td class="FieldCellName"><a name="stockprop-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>
644 </tr>
645
646 <tr class="tr-odd">
647 <td class="FieldCellName"><a name="stockprop-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>
648 </tr>
649
650 <tr class="tr-even">
651 <td class="FieldCellName"><a name="stockprop-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>
652 </tr>
653
654 <tr class="tr-odd">
655 <td class="FieldCellName"><a name="stockprop-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>
656 </tr>
657
658 </table>
659
660 <h3>
661 Indices
662 </h3>
663
664 <table border="1">
665
666 <tr class="IndexRow">
667 <th>
668 Name
669 </th>
670 <th>
671 Fields
672 </th>
673 </tr>
674
675 <tr class="IndexCell">
676 <td>stockprop_idx1</td><td>stock_id</td>
677 </tr>
678
679 <tr class="IndexCell">
680 <td>stockprop_idx2</td><td>type_id</td>
681 </tr>
682
683 </table>
684
685 <h3>
686 Constraints
687 </h3>
688
689 <table border="1">
690
691 <tr class="IndexRow">
692 <th>
693 Type
694 </th>
695 <th>
696 Fields
697 </th>
698 </tr>
699
700 <tr class="IndexCell">
701 <td>NOT NULL</td><td>stockprop_id</td>
702 </tr>
703
704 <tr class="IndexCell">
705 <td>NOT NULL</td><td>stock_id</td>
706 </tr>
707
708 <tr class="IndexCell">
709 <td>FOREIGN KEY</td><td>stock_id</td>
710 </tr>
711
712 <tr class="IndexCell">
713 <td>NOT NULL</td><td>type_id</td>
714 </tr>
715
716 <tr class="IndexCell">
717 <td>FOREIGN KEY</td><td>type_id</td>
718 </tr>
719
720 <tr class="IndexCell">
721 <td>NOT NULL</td><td>rank</td>
722 </tr>
723
724 <tr class="IndexCell">
725 <td>UNIQUE</td><td>stock_id, type_id, rank</td>
726 </tr>
727
728 </table>
729
730 <hr />
731
732 <!--
733 Starting table 'stockprop_pub'
734 -->
735
736 <a name="stockprop_pub" />
737
738 <table class="TableHeader" width="100%">
739 <tr class="TableHeaderRow">
740 <td class="TableHeaderCell"><h3>
741 stockprop_pub
742 </h3></td> <a name="stockprop_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
743 </tr>
744 </table>
745
746 <b>
747 Comments:
748 </b>
749
750 <br />
751
752 <em>
753 <br />
754 ================================================ <br />
755 TABLE: stockprop_pub <br />
756 ================================================ <br />
757 Provenance. Any stockprop assignment can optionally be supported by a publication.
758 </em>
759
760 <table border="1">
761
762 <tr>
763 <th class="FieldHeader">
764 Field Name
765 </th>
766 <th class="FieldHeader">
767 Data Type
768 </th>
769 <th class="FieldHeader">
770 Size
771 </th>
772 <th class="FieldHeader">
773 Default Value
774 </th>
775 <th class="FieldHeader">
776 Other
777 </th>
778 <th class="FieldHeader">
779 Foreign Key
780 </th>
781 </tr>
782
783 <tr class="tr-odd">
784 <td class="FieldCellName"><a name="stockprop_pub-stockprop_pub_id">stockprop_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>
785 </tr>
786
787 <tr class="tr-even">
788 <td class="FieldCellName"><a name="stockprop_pub-stockprop_id">stockprop_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="#stockprop-stockprop_id">stockprop.stockprop_id</a></td>
789 </tr>
790
791 <tr class="tr-odd">
792 <td class="FieldCellName"><a name="stockprop_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>
793 </tr>
794
795 </table>
796
797 <h3>
798 Indices
799 </h3>
800
801 <table border="1">
802
803 <tr class="IndexRow">
804 <th>
805 Name
806 </th>
807 <th>
808 Fields
809 </th>
810 </tr>
811
812 <tr class="IndexCell">
813 <td>stockprop_pub_idx1</td><td>stockprop_id</td>
814 </tr>
815
816 <tr class="IndexCell">
817 <td>stockprop_pub_idx2</td><td>pub_id</td>
818 </tr>
819
820 </table>
821
822 <h3>
823 Constraints
824 </h3>
825
826 <table border="1">
827
828 <tr class="IndexRow">
829 <th>
830 Type
831 </th>
832 <th>
833 Fields
834 </th>
835 </tr>
836
837 <tr class="IndexCell">
838 <td>NOT NULL</td><td>stockprop_pub_id</td>
839 </tr>
840
841 <tr class="IndexCell">
842 <td>NOT NULL</td><td>stockprop_id</td>
843 </tr>
844
845 <tr class="IndexCell">
846 <td>FOREIGN KEY</td><td>stockprop_id</td>
847 </tr>
848
849 <tr class="IndexCell">
850 <td>NOT NULL</td><td>pub_id</td>
851 </tr>
852
853 <tr class="IndexCell">
854 <td>FOREIGN KEY</td><td>pub_id</td>
855 </tr>
856
857 <tr class="IndexCell">
858 <td>UNIQUE</td><td>stockprop_id, pub_id</td>
859 </tr>
860
861 </table>
862
863 <hr />
864
865 <!--
866 Starting table 'stock_relationship'
867 -->
868
869 <a name="stock_relationship" />
870
871 <table width="100%" class="TableHeader">
872 <tr class="TableHeaderRow">
873 <td class="TableHeaderCell"><h3>
874 stock_relationship
875 </h3></td> <a name="stock_relationship"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
876 </tr>
877 </table>
878
879 <b>
880 Comments:
881 </b>
882
883 <br />
884
885 <em>
886 <br />
887 ================================================ <br />
888 TABLE: stock_relationship <br />
889 ================================================
890 </em>
891
892 <table border="1">
893
894 <tr>
895 <th class="FieldHeader">
896 Field Name
897 </th>
898 <th class="FieldHeader">
899 Data Type
900 </th>
901 <th class="FieldHeader">
902 Size
903 </th>
904 <th class="FieldHeader">
905 Default Value
906 </th>
907 <th class="FieldHeader">
908 Other
909 </th>
910 <th class="FieldHeader">
911 Foreign Key
912 </th>
913 </tr>
914
915 <tr class="tr-odd">
916 <td class="FieldCellName"><a name="stock_relationship-stock_relationship_id">stock_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>
917 </tr>
918
919 <tr class="tr-even">
920 <td class="FieldCellName"><a name="stock_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, stock_relationship.subject_id is the subject of the subj-predicate-obj sentence. This is typically the substock. </td> <td class="FieldCellFK"><a href="#stock-stock_id">stock.stock_id</a></td>
921 </tr>
922
923 <tr class="tr-odd">
924 <td class="FieldCellName"><a name="stock_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, stock_relationship.object_id is the object of the subj-predicate-obj sentence. This is typically the container stock. </td> <td class="FieldCellFK"><a href="#stock-stock_id">stock.stock_id</a></td>
925 </tr>
926
927 <tr class="tr-even">
928 <td class="FieldCellName"><a name="stock_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, stock_relationship.type_id is relationship type between subject and object. This is a cvterm, typically from the OBO relationship ontology, although other relationship types are allowed. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
929 </tr>
930
931 <tr class="tr-odd">
932 <td class="FieldCellName"><a name="stock_relationship-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">stock_relationship.value is for additional notes or comments. </td> <td class="FieldCellFK"></td>
933 </tr>
934
935 <tr class="tr-even">
936 <td class="FieldCellName"><a name="stock_relationship-rank">rank</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">10</td> <td class="FieldCellDefault">0</td> <td class="FieldCellOther">UNIQUE, NOT NULL, stock_relationship.rank is the ordering of subject stocks with respect to the object stock may be important where rank is used to order these; starts from zero. </td> <td class="FieldCellFK"></td>
937 </tr>
938
939 </table>
940
941 <h3>
942 Indices
943 </h3>
944
945 <table border="1">
946
947 <tr class="IndexRow">
948 <th>
949 Name
950 </th>
951 <th>
952 Fields
953 </th>
954 </tr>
955
956 <tr class="IndexCell">
957 <td>stock_relationship_idx1</td><td>subject_id</td>
958 </tr>
959
960 <tr class="IndexCell">
961 <td>stock_relationship_idx2</td><td>object_id</td>
962 </tr>
963
964 <tr class="IndexCell">
965 <td>stock_relationship_idx3</td><td>type_id</td>
966 </tr>
967
968 </table>
969
970 <h3>
971 Constraints
972 </h3>
973
974 <table border="1">
975
976 <tr class="IndexRow">
977 <th>
978 Type
979 </th>
980 <th>
981 Fields
982 </th>
983 </tr>
984
985 <tr class="IndexCell">
986 <td>NOT NULL</td><td>stock_relationship_id</td>
987 </tr>
988
989 <tr class="IndexCell">
990 <td>NOT NULL</td><td>subject_id</td>
991 </tr>
992
993 <tr class="IndexCell">
994 <td>FOREIGN KEY</td><td>subject_id</td>
995 </tr>
996
997 <tr class="IndexCell">
998 <td>NOT NULL</td><td>object_id</td>
999 </tr>
1000
1001 <tr class="IndexCell">
1002 <td>FOREIGN KEY</td><td>object_id</td>
1003 </tr>
1004
1005 <tr class="IndexCell">
1006 <td>NOT NULL</td><td>type_id</td>
1007 </tr>
1008
1009 <tr class="IndexCell">
1010 <td>FOREIGN KEY</td><td>type_id</td>
1011 </tr>
1012
1013 <tr class="IndexCell">
1014 <td>NOT NULL</td><td>rank</td>
1015 </tr>
1016
1017 <tr class="IndexCell">
1018 <td>UNIQUE</td><td>subject_id, object_id, type_id, rank</td>
1019 </tr>
1020
1021 </table>
1022
1023 <hr />
1024
1025 <!--
1026 Starting table 'stock_relationship_cvterm'
1027 -->
1028
1029 <a name="stock_relationship_cvterm" />
1030
1031 <table width="100%" class="TableHeader">
1032 <tr class="TableHeaderRow">
1033 <td class="TableHeaderCell"><h3>
1034 stock_relationship_cvterm
1035 </h3></td> <a name="stock_relationship_cvterm"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1036 </tr>
1037 </table>
1038
1039 <b>
1040 Comments:
1041 </b>
1042
1043 <br />
1044
1045 <em>
1046 <br />
1047 ================================================ <br />
1048 TABLE: stock_relationship_cvterm <br />
1049 ================================================ <br />
1050 For germplasm maintenance and pedigree data, stock_relationship. type_id will record cvterms such as "is a female parent of", "a parent for mutation", "is a group_id of", "is a source_id of", etc The cvterms for higher categories such as "generative", "derivative" or "maintenance" can be stored in table stock_relationship_cvterm
1051 </em>
1052
1053 <table border="1">
1054
1055 <tr>
1056 <th class="FieldHeader">
1057 Field Name
1058 </th>
1059 <th class="FieldHeader">
1060 Data Type
1061 </th>
1062 <th class="FieldHeader">
1063 Size
1064 </th>
1065 <th class="FieldHeader">
1066 Default Value
1067 </th>
1068 <th class="FieldHeader">
1069 Other
1070 </th>
1071 <th class="FieldHeader">
1072 Foreign Key
1073 </th>
1074 </tr>
1075
1076 <tr class="tr-odd">
1077 <td class="FieldCellName"><a name="stock_relationship_cvterm-stock_relationship_cvterm_id">stock_relationship_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>
1078 </tr>
1079
1080 <tr class="tr-even">
1081 <td class="FieldCellName"><a name="stock_relationship_cvterm-stock_relationship_id">stock_relationship_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#stock_relationship-stock_relationship_id">stock_relationship.stock_relationship_id</a></td>
1082 </tr>
1083
1084 <tr class="tr-odd">
1085 <td class="FieldCellName"><a name="stock_relationship_cvterm-cvterm_id">cvterm_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1086 </tr>
1087
1088 <tr class="tr-even">
1089 <td class="FieldCellName"><a name="stock_relationship_cvterm-pub_id">pub_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther"></td> <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
1090 </tr>
1091
1092 </table>
1093
1094 <h3>
1095 Constraints
1096 </h3>
1097
1098 <table border="1">
1099
1100 <tr class="IndexRow">
1101 <th>
1102 Type
1103 </th>
1104 <th>
1105 Fields
1106 </th>
1107 </tr>
1108
1109 <tr class="IndexCell">
1110 <td>NOT NULL</td><td>stock_relationship_cvterm_id</td>
1111 </tr>
1112
1113 <tr class="IndexCell">
1114 <td>NOT NULL</td><td>stock_relationship_id</td>
1115 </tr>
1116
1117 <tr class="IndexCell">
1118 <td>FOREIGN KEY</td><td>stock_relationship_id</td>
1119 </tr>
1120
1121 <tr class="IndexCell">
1122 <td>NOT NULL</td><td>cvterm_id</td>
1123 </tr>
1124
1125 <tr class="IndexCell">
1126 <td>FOREIGN KEY</td><td>cvterm_id</td>
1127 </tr>
1128
1129 <tr class="IndexCell">
1130 <td>FOREIGN KEY</td><td>pub_id</td>
1131 </tr>
1132
1133 </table>
1134
1135 <hr />
1136
1137 <!--
1138 Starting table 'stock_relationship_pub'
1139 -->
1140
1141 <a name="stock_relationship_pub" />
1142
1143 <table width="100%" class="TableHeader">
1144 <tr class="TableHeaderRow">
1145 <td class="TableHeaderCell"><h3>
1146 stock_relationship_pub
1147 </h3></td> <a name="stock_relationship_pub"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1148 </tr>
1149 </table>
1150
1151 <b>
1152 Comments:
1153 </b>
1154
1155 <br />
1156
1157 <em>
1158 <br />
1159 ================================================ <br />
1160 TABLE: stock_relationship_pub <br />
1161 ================================================ <br />
1162 Provenance. Attach optional evidence to a stock_relationship in the form of a publication.
1163 </em>
1164
1165 <table border="1">
1166
1167 <tr>
1168 <th class="FieldHeader">
1169 Field Name
1170 </th>
1171 <th class="FieldHeader">
1172 Data Type
1173 </th>
1174 <th class="FieldHeader">
1175 Size
1176 </th>
1177 <th class="FieldHeader">
1178 Default Value
1179 </th>
1180 <th class="FieldHeader">
1181 Other
1182 </th>
1183 <th class="FieldHeader">
1184 Foreign Key
1185 </th>
1186 </tr>
1187
1188 <tr class="tr-odd">
1189 <td class="FieldCellName"><a name="stock_relationship_pub-stock_relationship_pub_id">stock_relationship_pub_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
1190 </tr>
1191
1192 <tr class="tr-even">
1193 <td class="FieldCellName"><a name="stock_relationship_pub-stock_relationship_id">stock_relationship_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#stock_relationship-stock_relationship_id">stock_relationship.stock_relationship_id</a></td>
1194 </tr>
1195
1196 <tr class="tr-odd">
1197 <td class="FieldCellName"><a name="stock_relationship_pub-pub_id">pub_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
1198 </tr>
1199
1200 </table>
1201
1202 <h3>
1203 Indices
1204 </h3>
1205
1206 <table border="1">
1207
1208 <tr class="IndexRow">
1209 <th>
1210 Name
1211 </th>
1212 <th>
1213 Fields
1214 </th>
1215 </tr>
1216
1217 <tr class="IndexCell">
1218 <td>stock_relationship_pub_idx1</td><td>stock_relationship_id</td>
1219 </tr>
1220
1221 <tr class="IndexCell">
1222 <td>stock_relationship_pub_idx2</td><td>pub_id</td>
1223 </tr>
1224
1225 </table>
1226
1227 <h3>
1228 Constraints
1229 </h3>
1230
1231 <table border="1">
1232
1233 <tr class="IndexRow">
1234 <th>
1235 Type
1236 </th>
1237 <th>
1238 Fields
1239 </th>
1240 </tr>
1241
1242 <tr class="IndexCell">
1243 <td>NOT NULL</td><td>stock_relationship_pub_id</td>
1244 </tr>
1245
1246 <tr class="IndexCell">
1247 <td>NOT NULL</td><td>stock_relationship_id</td>
1248 </tr>
1249
1250 <tr class="IndexCell">
1251 <td>FOREIGN KEY</td><td>stock_relationship_id</td>
1252 </tr>
1253
1254 <tr class="IndexCell">
1255 <td>NOT NULL</td><td>pub_id</td>
1256 </tr>
1257
1258 <tr class="IndexCell">
1259 <td>FOREIGN KEY</td><td>pub_id</td>
1260 </tr>
1261
1262 <tr class="IndexCell">
1263 <td>UNIQUE</td><td>stock_relationship_id, pub_id</td>
1264 </tr>
1265
1266 </table>
1267
1268 <hr />
1269
1270 <!--
1271 Starting table 'stock_dbxref'
1272 -->
1273
1274 <a name="stock_dbxref" />
1275
1276 <table class="TableHeader" width="100%">
1277 <tr class="TableHeaderRow">
1278 <td class="TableHeaderCell"><h3>
1279 stock_dbxref
1280 </h3></td> <a name="stock_dbxref"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1281 </tr>
1282 </table>
1283
1284 <b>
1285 Comments:
1286 </b>
1287
1288 <br />
1289
1290 <em>
1291 <br />
1292 ================================================ <br />
1293 TABLE: stock_dbxref <br />
1294 ================================================ <br />
1295 stock_dbxref links a stock to dbxrefs. This is for secondary identifiers; primary identifiers should use stock.dbxref_id.
1296 </em>
1297
1298 <table border="1">
1299
1300 <tr>
1301 <th class="FieldHeader">
1302 Field Name
1303 </th>
1304 <th class="FieldHeader">
1305 Data Type
1306 </th>
1307 <th class="FieldHeader">
1308 Size
1309 </th>
1310 <th class="FieldHeader">
1311 Default Value
1312 </th>
1313 <th class="FieldHeader">
1314 Other
1315 </th>
1316 <th class="FieldHeader">
1317 Foreign Key
1318 </th>
1319 </tr>
1320
1321 <tr class="tr-odd">
1322 <td class="FieldCellName"><a name="stock_dbxref-stock_dbxref_id">stock_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>
1323 </tr>
1324
1325 <tr class="tr-even">
1326 <td class="FieldCellName"><a name="stock_dbxref-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>
1327 </tr>
1328
1329 <tr class="tr-odd">
1330 <td class="FieldCellName"><a name="stock_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>
1331 </tr>
1332
1333 <tr class="tr-even">
1334 <td class="FieldCellName"><a name="stock_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 stock. </td> <td class="FieldCellFK"></td>
1335 </tr>
1336
1337 </table>
1338
1339 <h3>
1340 Indices
1341 </h3>
1342
1343 <table border="1">
1344
1345 <tr class="IndexRow">
1346 <th>
1347 Name
1348 </th>
1349 <th>
1350 Fields
1351 </th>
1352 </tr>
1353
1354 <tr class="IndexCell">
1355 <td>stock_dbxref_idx1</td><td>stock_id</td>
1356 </tr>
1357
1358 <tr class="IndexCell">
1359 <td>stock_dbxref_idx2</td><td>dbxref_id</td>
1360 </tr>
1361
1362 </table>
1363
1364 <h3>
1365 Constraints
1366 </h3>
1367
1368 <table border="1">
1369
1370 <tr class="IndexRow">
1371 <th>
1372 Type
1373 </th>
1374 <th>
1375 Fields
1376 </th>
1377 </tr>
1378
1379 <tr class="IndexCell">
1380 <td>NOT NULL</td><td>stock_dbxref_id</td>
1381 </tr>
1382
1383 <tr class="IndexCell">
1384 <td>NOT NULL</td><td>stock_id</td>
1385 </tr>
1386
1387 <tr class="IndexCell">
1388 <td>FOREIGN KEY</td><td>stock_id</td>
1389 </tr>
1390
1391 <tr class="IndexCell">
1392 <td>NOT NULL</td><td>dbxref_id</td>
1393 </tr>
1394
1395 <tr class="IndexCell">
1396 <td>FOREIGN KEY</td><td>dbxref_id</td>
1397 </tr>
1398
1399 <tr class="IndexCell">
1400 <td>NOT NULL</td><td>is_current</td>
1401 </tr>
1402
1403 <tr class="IndexCell">
1404 <td>UNIQUE</td><td>stock_id, dbxref_id</td>
1405 </tr>
1406
1407 </table>
1408
1409 <hr />
1410
1411 <!--
1412 Starting table 'stock_cvterm'
1413 -->
1414
1415 <a name="stock_cvterm" />
1416
1417 <table class="TableHeader" width="100%">
1418 <tr class="TableHeaderRow">
1419 <td class="TableHeaderCell"><h3>
1420 stock_cvterm
1421 </h3></td> <a name="stock_cvterm"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1422 </tr>
1423 </table>
1424
1425 <b>
1426 Comments:
1427 </b>
1428
1429 <br />
1430
1431 <em>
1432 <br />
1433 ================================================ <br />
1434 TABLE: stock_cvterm <br />
1435 ================================================ <br />
1436 stock_cvterm links a stock to cvterms. This is for secondary cvterms; primary cvterms should use stock.type_id.
1437 </em>
1438
1439 <table border="1">
1440
1441 <tr>
1442 <th class="FieldHeader">
1443 Field Name
1444 </th>
1445 <th class="FieldHeader">
1446 Data Type
1447 </th>
1448 <th class="FieldHeader">
1449 Size
1450 </th>
1451 <th class="FieldHeader">
1452 Default Value
1453 </th>
1454 <th class="FieldHeader">
1455 Other
1456 </th>
1457 <th class="FieldHeader">
1458 Foreign Key
1459 </th>
1460 </tr>
1461
1462 <tr class="tr-odd">
1463 <td class="FieldCellName"><a name="stock_cvterm-stock_cvterm_id">stock_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>
1464 </tr>
1465
1466 <tr class="tr-even">
1467 <td class="FieldCellName"><a name="stock_cvterm-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>
1468 </tr>
1469
1470 <tr class="tr-odd">
1471 <td class="FieldCellName"><a name="stock_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>
1472 </tr>
1473
1474 <tr class="tr-even">
1475 <td class="FieldCellName"><a name="stock_cvterm-pub_id">pub_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
1476 </tr>
1477
1478 <tr class="tr-odd">
1479 <td class="FieldCellName"><a name="stock_cvterm-is_not">is_not</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">false</td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
1480 </tr>
1481
1482 <tr class="tr-even">
1483 <td class="FieldCellName"><a name="stock_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>
1484 </tr>
1485
1486 </table>
1487
1488 <h3>
1489 Indices
1490 </h3>
1491
1492 <table border="1">
1493
1494 <tr class="IndexRow">
1495 <th>
1496 Name
1497 </th>
1498 <th>
1499 Fields
1500 </th>
1501 </tr>
1502
1503 <tr class="IndexCell">
1504 <td>stock_cvterm_idx1</td><td>stock_id</td>
1505 </tr>
1506
1507 <tr class="IndexCell">
1508 <td>stock_cvterm_idx2</td><td>cvterm_id</td>
1509 </tr>
1510
1511 <tr class="IndexCell">
1512 <td>stock_cvterm_idx3</td><td>pub_id</td>
1513 </tr>
1514
1515 </table>
1516
1517 <h3>
1518 Constraints
1519 </h3>
1520
1521 <table border="1">
1522
1523 <tr class="IndexRow">
1524 <th>
1525 Type
1526 </th>
1527 <th>
1528 Fields
1529 </th>
1530 </tr>
1531
1532 <tr class="IndexCell">
1533 <td>NOT NULL</td><td>stock_cvterm_id</td>
1534 </tr>
1535
1536 <tr class="IndexCell">
1537 <td>NOT NULL</td><td>stock_id</td>
1538 </tr>
1539
1540 <tr class="IndexCell">
1541 <td>FOREIGN KEY</td><td>stock_id</td>
1542 </tr>
1543
1544 <tr class="IndexCell">
1545 <td>NOT NULL</td><td>cvterm_id</td>
1546 </tr>
1547
1548 <tr class="IndexCell">
1549 <td>FOREIGN KEY</td><td>cvterm_id</td>
1550 </tr>
1551
1552 <tr class="IndexCell">
1553 <td>NOT NULL</td><td>pub_id</td>
1554 </tr>
1555
1556 <tr class="IndexCell">
1557 <td>FOREIGN KEY</td><td>pub_id</td>
1558 </tr>
1559
1560 <tr class="IndexCell">
1561 <td>NOT NULL</td><td>is_not</td>
1562 </tr>
1563
1564 <tr class="IndexCell">
1565 <td>NOT NULL</td><td>rank</td>
1566 </tr>
1567
1568 <tr class="IndexCell">
1569 <td>UNIQUE</td><td>stock_id, cvterm_id, pub_id, rank</td>
1570 </tr>
1571
1572 </table>
1573
1574 <hr />
1575
1576 <!--
1577 Starting table 'stock_cvtermprop'
1578 -->
1579
1580 <a name="stock_cvtermprop" />
1581
1582 <table class="TableHeader" width="100%">
1583 <tr class="TableHeaderRow">
1584 <td class="TableHeaderCell"><h3>
1585 stock_cvtermprop
1586 </h3></td> <a name="stock_cvtermprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1587 </tr>
1588 </table>
1589
1590 <b>
1591 Comments:
1592 </b>
1593
1594 <br />
1595
1596 <em>
1597 <br />
1598 ================================================ <br />
1599 TABLE: stock_cvtermprop <br />
1600 ================================================ <br />
1601 Extensible properties for
1602 stock to cvterm associations. Examples: GO evidence codes;
1603 qualifiers; metadata such as the date on which the entry was curated
1604 and the source of the association. See the stockprop table for
1605 meanings of type_id, value and rank.
1606 </em>
1607
1608 <table border="1">
1609
1610 <tr>
1611 <th class="FieldHeader">
1612 Field Name
1613 </th>
1614 <th class="FieldHeader">
1615 Data Type
1616 </th>
1617 <th class="FieldHeader">
1618 Size
1619 </th>
1620 <th class="FieldHeader">
1621 Default Value
1622 </th>
1623 <th class="FieldHeader">
1624 Other
1625 </th>
1626 <th class="FieldHeader">
1627 Foreign Key
1628 </th>
1629 </tr>
1630
1631 <tr class="tr-odd">
1632 <td class="FieldCellName"><a name="stock_cvtermprop-stock_cvtermprop_id">stock_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>
1633 </tr>
1634
1635 <tr class="tr-even">
1636 <td class="FieldCellName"><a name="stock_cvtermprop-stock_cvterm_id">stock_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="#stock_cvterm-stock_cvterm_id">stock_cvterm.stock_cvterm_id</a></td>
1637 </tr>
1638
1639 <tr class="tr-odd">
1640 <td class="FieldCellName"><a name="stock_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
1641 property/slot is a cvterm. The meaning of the property is defined in
1642 that cvterm. cvterms may come from the OBO evidence code cv. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1643 </tr>
1644
1645 <tr class="tr-even">
1646 <td class="FieldCellName"><a name="stock_cvtermprop-value">value</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">The value of the
1647 property, represented as text. Numeric values are converted to their
1648 text representation. This is less efficient than using native database
1649 types, but is easier to query. </td> <td class="FieldCellFK"></td>
1650 </tr>
1651
1652 <tr class="tr-odd">
1653 <td class="FieldCellName"><a name="stock_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
1654 ordering. Any stock_cvterm can have multiple values for any particular
1655 property type - these are ordered in a list using rank, counting from
1656 zero. For properties that are single-valued rather than multi-valued,
1657 the default 0 value should be used. </td> <td class="FieldCellFK"></td>
1658 </tr>
1659
1660 </table>
1661
1662 <h3>
1663 Indices
1664 </h3>
1665
1666 <table border="1">
1667
1668 <tr class="IndexRow">
1669 <th>
1670 Name
1671 </th>
1672 <th>
1673 Fields
1674 </th>
1675 </tr>
1676
1677 <tr class="IndexCell">
1678 <td>stock_cvtermprop_idx1</td><td>stock_cvterm_id</td>
1679 </tr>
1680
1681 <tr class="IndexCell">
1682 <td>stock_cvtermprop_idx2</td><td>type_id</td>
1683 </tr>
1684
1685 </table>
1686
1687 <h3>
1688 Constraints
1689 </h3>
1690
1691 <table border="1">
1692
1693 <tr class="IndexRow">
1694 <th>
1695 Type
1696 </th>
1697 <th>
1698 Fields
1699 </th>
1700 </tr>
1701
1702 <tr class="IndexCell">
1703 <td>NOT NULL</td><td>stock_cvtermprop_id</td>
1704 </tr>
1705
1706 <tr class="IndexCell">
1707 <td>NOT NULL</td><td>stock_cvterm_id</td>
1708 </tr>
1709
1710 <tr class="IndexCell">
1711 <td>FOREIGN KEY</td><td>stock_cvterm_id</td>
1712 </tr>
1713
1714 <tr class="IndexCell">
1715 <td>NOT NULL</td><td>type_id</td>
1716 </tr>
1717
1718 <tr class="IndexCell">
1719 <td>FOREIGN KEY</td><td>type_id</td>
1720 </tr>
1721
1722 <tr class="IndexCell">
1723 <td>NOT NULL</td><td>rank</td>
1724 </tr>
1725
1726 <tr class="IndexCell">
1727 <td>UNIQUE</td><td>stock_cvterm_id, type_id, rank</td>
1728 </tr>
1729
1730 </table>
1731
1732 <hr />
1733
1734 <!--
1735 Starting table 'stock_genotype'
1736 -->
1737
1738 <a name="stock_genotype" />
1739
1740 <table width="100%" class="TableHeader">
1741 <tr class="TableHeaderRow">
1742 <td class="TableHeaderCell"><h3>
1743 stock_genotype
1744 </h3></td> <a name="stock_genotype"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1745 </tr>
1746 </table>
1747
1748 <b>
1749 Comments:
1750 </b>
1751
1752 <br />
1753
1754 <em>
1755 <br />
1756 ================================================ <br />
1757 TABLE: stock_genotype <br />
1758 ================================================ <br />
1759 Simple table linking a stock to
1760 a genotype. Features with genotypes can be linked to stocks thru feature_genotype -> genotype -> stock_genotype -> stock.
1761 </em>
1762
1763 <table border="1">
1764
1765 <tr>
1766 <th class="FieldHeader">
1767 Field Name
1768 </th>
1769 <th class="FieldHeader">
1770 Data Type
1771 </th>
1772 <th class="FieldHeader">
1773 Size
1774 </th>
1775 <th class="FieldHeader">
1776 Default Value
1777 </th>
1778 <th class="FieldHeader">
1779 Other
1780 </th>
1781 <th class="FieldHeader">
1782 Foreign Key
1783 </th>
1784 </tr>
1785
1786 <tr class="tr-odd">
1787 <td class="FieldCellName"><a name="stock_genotype-stock_genotype_id">stock_genotype_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>
1788 </tr>
1789
1790 <tr class="tr-even">
1791 <td class="FieldCellName"><a name="stock_genotype-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>
1792 </tr>
1793
1794 <tr class="tr-odd">
1795 <td class="FieldCellName"><a name="stock_genotype-genotype_id">genotype_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="#genotype-genotype_id">genotype.genotype_id</a></td>
1796 </tr>
1797
1798 </table>
1799
1800 <h3>
1801 Indices
1802 </h3>
1803
1804 <table border="1">
1805
1806 <tr class="IndexRow">
1807 <th>
1808 Name
1809 </th>
1810 <th>
1811 Fields
1812 </th>
1813 </tr>
1814
1815 <tr class="IndexCell">
1816 <td>stock_genotype_idx1</td><td>stock_id</td>
1817 </tr>
1818
1819 <tr class="IndexCell">
1820 <td>stock_genotype_idx2</td><td>genotype_id</td>
1821 </tr>
1822
1823 </table>
1824
1825 <h3>
1826 Constraints
1827 </h3>
1828
1829 <table border="1">
1830
1831 <tr class="IndexRow">
1832 <th>
1833 Type
1834 </th>
1835 <th>
1836 Fields
1837 </th>
1838 </tr>
1839
1840 <tr class="IndexCell">
1841 <td>NOT NULL</td><td>stock_genotype_id</td>
1842 </tr>
1843
1844 <tr class="IndexCell">
1845 <td>NOT NULL</td><td>stock_id</td>
1846 </tr>
1847
1848 <tr class="IndexCell">
1849 <td>FOREIGN KEY</td><td>stock_id</td>
1850 </tr>
1851
1852 <tr class="IndexCell">
1853 <td>NOT NULL</td><td>genotype_id</td>
1854 </tr>
1855
1856 <tr class="IndexCell">
1857 <td>FOREIGN KEY</td><td>genotype_id</td>
1858 </tr>
1859
1860 <tr class="IndexCell">
1861 <td>UNIQUE</td><td>stock_id, genotype_id</td>
1862 </tr>
1863
1864 </table>
1865
1866 <hr />
1867
1868 <!--
1869 Starting table 'stockcollection'
1870 -->
1871
1872 <a name="stockcollection" />
1873
1874 <table class="TableHeader" width="100%">
1875 <tr class="TableHeaderRow">
1876 <td class="TableHeaderCell"><h3>
1877 stockcollection
1878 </h3></td> <a name="stockcollection"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1879 </tr>
1880 </table>
1881
1882 <b>
1883 Comments:
1884 </b>
1885
1886 <br />
1887
1888 <em>
1889 <br />
1890 ================================================ <br />
1891 TABLE: stockcollection <br />
1892 ================================================ <br />
1893 The lab or stock center distributing the stocks in their collection.
1894 </em>
1895
1896 <table border="1">
1897
1898 <tr>
1899 <th class="FieldHeader">
1900 Field Name
1901 </th>
1902 <th class="FieldHeader">
1903 Data Type
1904 </th>
1905 <th class="FieldHeader">
1906 Size
1907 </th>
1908 <th class="FieldHeader">
1909 Default Value
1910 </th>
1911 <th class="FieldHeader">
1912 Other
1913 </th>
1914 <th class="FieldHeader">
1915 Foreign Key
1916 </th>
1917 </tr>
1918
1919 <tr class="tr-odd">
1920 <td class="FieldCellName"><a name="stockcollection-stockcollection_id">stockcollection_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>
1921 </tr>
1922
1923 <tr class="tr-even">
1924 <td class="FieldCellName"><a name="stockcollection-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, type_id is the collection type cv. </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1925 </tr>
1926
1927 <tr class="tr-odd">
1928 <td class="FieldCellName"><a name="stockcollection-contact_id">contact_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">contact_id links to the contact information for the collection. </td> <td class="FieldCellFK"><a href="#contact-contact_id">contact.contact_id</a></td>
1929 </tr>
1930
1931 <tr class="tr-even">
1932 <td class="FieldCellName"><a name="stockcollection-name">name</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">name is the collection. </td> <td class="FieldCellFK"></td>
1933 </tr>
1934
1935 <tr class="tr-odd">
1936 <td class="FieldCellName"><a name="stockcollection-uniquename">uniquename</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, uniqename is the value of the collection cv. </td> <td class="FieldCellFK"></td>
1937 </tr>
1938
1939 </table>
1940
1941 <h3>
1942 Indices
1943 </h3>
1944
1945 <table border="1">
1946
1947 <tr class="IndexRow">
1948 <th>
1949 Name
1950 </th>
1951 <th>
1952 Fields
1953 </th>
1954 </tr>
1955
1956 <tr class="IndexCell">
1957 <td>stockcollection_name_ind1</td><td>name</td>
1958 </tr>
1959
1960 <tr class="IndexCell">
1961 <td>stockcollection_idx1</td><td>contact_id</td>
1962 </tr>
1963
1964 <tr class="IndexCell">
1965 <td>stockcollection_idx2</td><td>type_id</td>
1966 </tr>
1967
1968 <tr class="IndexCell">
1969 <td>stockcollection_idx3</td><td>uniquename</td>
1970 </tr>
1971
1972 </table>
1973
1974 <h3>
1975 Constraints
1976 </h3>
1977
1978 <table border="1">
1979
1980 <tr class="IndexRow">
1981 <th>
1982 Type
1983 </th>
1984 <th>
1985 Fields
1986 </th>
1987 </tr>
1988
1989 <tr class="IndexCell">
1990 <td>NOT NULL</td><td>stockcollection_id</td>
1991 </tr>
1992
1993 <tr class="IndexCell">
1994 <td>NOT NULL</td><td>type_id</td>
1995 </tr>
1996
1997 <tr class="IndexCell">
1998 <td>FOREIGN KEY</td><td>type_id</td>
1999 </tr>
2000
2001 <tr class="IndexCell">
2002 <td>FOREIGN KEY</td><td>contact_id</td>
2003 </tr>
2004
2005 <tr class="IndexCell">
2006 <td>NOT NULL</td><td>uniquename</td>
2007 </tr>
2008
2009 <tr class="IndexCell">
2010 <td>UNIQUE</td><td>uniquename, type_id</td>
2011 </tr>
2012
2013 </table>
2014
2015 <hr />
2016
2017 <!--
2018 Starting table 'stockcollectionprop'
2019 -->
2020
2021 <a name="stockcollectionprop" />
2022
2023 <table class="TableHeader" width="100%">
2024 <tr class="TableHeaderRow">
2025 <td class="TableHeaderCell"><h3>
2026 stockcollectionprop
2027 </h3></td> <a name="stockcollectionprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
2028 </tr>
2029 </table>
2030
2031 <b>
2032 Comments:
2033 </b>
2034
2035 <br />
2036
2037 <em>
2038 <br />
2039 ================================================ <br />
2040 TABLE: stockcollectionprop <br />
2041 ================================================ <br />
2042 The table stockcollectionprop
2043 contains the value of the stock collection such as website/email URLs;
2044 the value of the stock collection order URLs.
2045 </em>
2046
2047 <table border="1">
2048
2049 <tr>
2050 <th class="FieldHeader">
2051 Field Name
2052 </th>
2053 <th class="FieldHeader">
2054 Data Type
2055 </th>
2056 <th class="FieldHeader">
2057 Size
2058 </th>
2059 <th class="FieldHeader">
2060 Default Value
2061 </th>
2062 <th class="FieldHeader">
2063 Other
2064 </th>
2065 <th class="FieldHeader">
2066 Foreign Key
2067 </th>
2068 </tr>
2069
2070 <tr class="tr-odd">
2071 <td class="FieldCellName"><a name="stockcollectionprop-stockcollectionprop_id">stockcollectionprop_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>
2072 </tr>
2073
2074 <tr class="tr-even">
2075 <td class="FieldCellName"><a name="stockcollectionprop-stockcollection_id">stockcollection_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="#stockcollection-stockcollection_id">stockcollection.stockcollection_id</a></td>
2076 </tr>
2077
2078 <tr class="tr-odd">
2079 <td class="FieldCellName"><a name="stockcollectionprop-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 cv for the type_id is "stockcollection property type". </td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
2080 </tr>
2081
2082 <tr class="tr-even">
2083 <td class="FieldCellName"><a name="stockcollectionprop-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>
2084 </tr>
2085
2086 <tr class="tr-odd">
2087 <td class="FieldCellName"><a name="stockcollectionprop-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>
2088 </tr>
2089
2090 </table>
2091
2092 <h3>
2093 Indices
2094 </h3>
2095
2096 <table border="1">
2097
2098 <tr class="IndexRow">
2099 <th>
2100 Name
2101 </th>
2102 <th>
2103 Fields
2104 </th>
2105 </tr>
2106
2107 <tr class="IndexCell">
2108 <td>stockcollectionprop_idx1</td><td>stockcollection_id</td>
2109 </tr>
2110
2111 <tr class="IndexCell">
2112 <td>stockcollectionprop_idx2</td><td>type_id</td>
2113 </tr>
2114
2115 </table>
2116
2117 <h3>
2118 Constraints
2119 </h3>
2120
2121 <table border="1">
2122
2123 <tr class="IndexRow">
2124 <th>
2125 Type
2126 </th>
2127 <th>
2128 Fields
2129 </th>
2130 </tr>
2131
2132 <tr class="IndexCell">
2133 <td>NOT NULL</td><td>stockcollectionprop_id</td>
2134 </tr>
2135
2136 <tr class="IndexCell">
2137 <td>NOT NULL</td><td>stockcollection_id</td>
2138 </tr>
2139
2140 <tr class="IndexCell">
2141 <td>FOREIGN KEY</td><td>stockcollection_id</td>
2142 </tr>
2143
2144 <tr class="IndexCell">
2145 <td>NOT NULL</td><td>type_id</td>
2146 </tr>
2147
2148 <tr class="IndexCell">
2149 <td>FOREIGN KEY</td><td>type_id</td>
2150 </tr>
2151
2152 <tr class="IndexCell">
2153 <td>NOT NULL</td><td>rank</td>
2154 </tr>
2155
2156 <tr class="IndexCell">
2157 <td>UNIQUE</td><td>stockcollection_id, type_id, rank</td>
2158 </tr>
2159
2160 </table>
2161
2162 <hr />
2163
2164 <!--
2165 Starting table 'stockcollection_stock'
2166 -->
2167
2168 <a name="stockcollection_stock" />
2169
2170 <table class="TableHeader" width="100%">
2171 <tr class="TableHeaderRow">
2172 <td class="TableHeaderCell"><h3>
2173 stockcollection_stock
2174 </h3></td> <a name="stockcollection_stock"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
2175 </tr>
2176 </table>
2177
2178 <b>
2179 Comments:
2180 </b>
2181
2182 <br />
2183
2184 <em>
2185 <br />
2186 ================================================ <br />
2187 TABLE: stockcollection_stock <br />
2188 ================================================ <br />
2189 stockcollection_stock links
2190 a stock collection to the stocks which are contained in the collection.
2191 </em>
2192
2193 <table border="1">
2194
2195 <tr>
2196 <th class="FieldHeader">
2197 Field Name
2198 </th>
2199 <th class="FieldHeader">
2200 Data Type
2201 </th>
2202 <th class="FieldHeader">
2203 Size
2204 </th>
2205 <th class="FieldHeader">
2206 Default Value
2207 </th>
2208 <th class="FieldHeader">
2209 Other
2210 </th>
2211 <th class="FieldHeader">
2212 Foreign Key
2213 </th>
2214 </tr>
2215
2216 <tr class="tr-odd">
2217 <td class="FieldCellName"><a name="stockcollection_stock-stockcollection_stock_id">stockcollection_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>
2218 </tr>
2219
2220 <tr class="tr-even">
2221 <td class="FieldCellName"><a name="stockcollection_stock-stockcollection_id">stockcollection_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="#stockcollection-stockcollection_id">stockcollection.stockcollection_id</a></td>
2222 </tr>
2223
2224 <tr class="tr-odd">
2225 <td class="FieldCellName"><a name="stockcollection_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>
2226 </tr>
2227
2228 </table>
2229
2230 <h3>
2231 Indices
2232 </h3>
2233
2234 <table border="1">
2235
2236 <tr class="IndexRow">
2237 <th>
2238 Name
2239 </th>
2240 <th>
2241 Fields
2242 </th>
2243 </tr>
2244
2245 <tr class="IndexCell">
2246 <td>stockcollection_stock_idx1</td><td>stockcollection_id</td>
2247 </tr>
2248
2249 <tr class="IndexCell">
2250 <td>stockcollection_stock_idx2</td><td>stock_id</td>
2251 </tr>
2252
2253 </table>
2254
2255 <h3>
2256 Constraints
2257 </h3>
2258
2259 <table border="1">
2260
2261 <tr class="IndexRow">
2262 <th>
2263 Type
2264 </th>
2265 <th>
2266 Fields
2267 </th>
2268 </tr>
2269
2270 <tr class="IndexCell">
2271 <td>NOT NULL</td><td>stockcollection_stock_id</td>
2272 </tr>
2273
2274 <tr class="IndexCell">
2275 <td>NOT NULL</td><td>stockcollection_id</td>
2276 </tr>
2277
2278 <tr class="IndexCell">
2279 <td>FOREIGN KEY</td><td>stockcollection_id</td>
2280 </tr>
2281
2282 <tr class="IndexCell">
2283 <td>NOT NULL</td><td>stock_id</td>
2284 </tr>
2285
2286 <tr class="IndexCell">
2287 <td>FOREIGN KEY</td><td>stock_id</td>
2288 </tr>
2289
2290 <tr class="IndexCell">
2291 <td>UNIQUE</td><td>stockcollection_id, stock_id</td>
2292 </tr>
2293
2294 </table>
2295
2296 <hr />
2297
2298 <!--
2299 Starting table 'stock_dbxrefprop'
2300 -->
2301
2302 <a name="stock_dbxrefprop" />
2303
2304 <table width="100%" class="TableHeader">
2305 <tr class="TableHeaderRow">
2306 <td class="TableHeaderCell"><h3>
2307 stock_dbxrefprop
2308 </h3></td> <a name="stock_dbxrefprop"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
2309 </tr>
2310 </table>
2311
2312 <b>
2313 Comments:
2314 </b>
2315
2316 <br />
2317
2318 <em>
2319 <br />
2320 ================================================ <br />
2321 TABLE: stock_dbxrefprop <br />
2322 ================================================ <br />
2323 A stock_dbxref can have any number of
2324 slot-value property tags attached to it. This is useful for storing properties related to dbxref annotations of stocks, such as evidence codes, and references, and metadata, such as create/modify dates. This is an alternative to
2325 hardcoding a list of columns in the relational schema, and is
2326 completely extensible. There is a unique constraint, stock_dbxrefprop_c1, for
2327 the combination of stock_dbxref_id, rank, and type_id. Multivalued property-value pairs must be differentiated by rank.
2328 </em>
2329
2330 <table border="1">
2331
2332 <tr>
2333 <th class="FieldHeader">
2334 Field Name
2335 </th>
2336 <th class="FieldHeader">
2337 Data Type
2338 </th>
2339 <th class="FieldHeader">
2340 Size
2341 </th>
2342 <th class="FieldHeader">
2343 Default Value
2344 </th>
2345 <th class="FieldHeader">
2346 Other
2347 </th>
2348 <th class="FieldHeader">
2349 Foreign Key
2350 </th>
2351 </tr>
2352
2353 <tr class="tr-odd">
2354 <td class="FieldCellName"><a name="stock_dbxrefprop-stock_dbxrefprop_id">stock_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>
2355 </tr>
2356
2357 <tr class="tr-even">
2358 <td class="FieldCellName"><a name="stock_dbxrefprop-stock_dbxref_id">stock_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="#stock_dbxref-stock_dbxref_id">stock_dbxref.stock_dbxref_id</a></td>
2359 </tr>
2360
2361 <tr class="tr-odd">
2362 <td class="FieldCellName"><a name="stock_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>
2363 </tr>
2364
2365 <tr class="tr-even">
2366 <td class="FieldCellName"><a name="stock_dbxrefprop-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>
2367 </tr>
2368
2369 <tr class="tr-odd">
2370 <td class="FieldCellName"><a name="stock_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>
2371 </tr>
2372
2373 </table>
2374
2375 <h3>
2376 Indices
2377 </h3>
2378
2379 <table border="1">
2380
2381 <tr class="IndexRow">
2382 <th>
2383 Name
2384 </th>
2385 <th>
2386 Fields
2387 </th>
2388 </tr>
2389
2390 <tr class="IndexCell">
2391 <td>stock_dbxrefprop_idx1</td><td>stock_dbxref_id</td>
2392 </tr>
2393
2394 <tr class="IndexCell">
2395 <td>stock_dbxrefprop_idx2</td><td>type_id</td>
2396 </tr>
2397
2398 </table>
2399
2400 <h3>
2401 Constraints
2402 </h3>
2403
2404 <table border="1">
2405
2406 <tr class="IndexRow">
2407 <th>
2408 Type
2409 </th>
2410 <th>
2411 Fields
2412 </th>
2413 </tr>
2414
2415 <tr class="IndexCell">
2416 <td>NOT NULL</td><td>stock_dbxrefprop_id</td>
2417 </tr>
2418
2419 <tr class="IndexCell">
2420 <td>NOT NULL</td><td>stock_dbxref_id</td>
2421 </tr>
2422
2423 <tr class="IndexCell">
2424 <td>FOREIGN KEY</td><td>stock_dbxref_id</td>
2425 </tr>
2426
2427 <tr class="IndexCell">
2428 <td>NOT NULL</td><td>type_id</td>
2429 </tr>
2430
2431 <tr class="IndexCell">
2432 <td>FOREIGN KEY</td><td>type_id</td>
2433 </tr>
2434
2435 <tr class="IndexCell">
2436 <td>NOT NULL</td><td>rank</td>
2437 </tr>
2438
2439 <tr class="IndexCell">
2440 <td>UNIQUE</td><td>stock_dbxref_id, type_id, rank</td>
2441 </tr>
2442
2443 </table>
2444
2445 <hr />
2446
2447 <!--
2448 Starting table 'stockcollection_db'
2449 -->
2450
2451 <a name="stockcollection_db" />
2452
2453 <table width="100%" class="TableHeader">
2454 <tr class="TableHeaderRow">
2455 <td class="TableHeaderCell"><h3>
2456 stockcollection_db
2457 </h3></td> <a name="stockcollection_db"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
2458 </tr>
2459 </table>
2460
2461 <b>
2462 Comments:
2463 </b>
2464
2465 <br />
2466
2467 <em>
2468 <br />
2469 ================================================ <br />
2470 TABLE: stockcollection_db <br />
2471 ================================================ <br />
2472 Stock collections may be respresented
2473 by an external online database. This table associates a stock collection with
2474 a database where its member stocks can be found. Individual stock that are part
2475 of this collction should have entries in the stock_dbxref table with the same
2476 db_id record
2477 </em>
2478
2479 <table border="1">
2480
2481 <tr>
2482 <th class="FieldHeader">
2483 Field Name
2484 </th>
2485 <th class="FieldHeader">
2486 Data Type
2487 </th>
2488 <th class="FieldHeader">
2489 Size
2490 </th>
2491 <th class="FieldHeader">
2492 Default Value
2493 </th>
2494 <th class="FieldHeader">
2495 Other
2496 </th>
2497 <th class="FieldHeader">
2498 Foreign Key
2499 </th>
2500 </tr>
2501
2502 <tr class="tr-odd">
2503 <td class="FieldCellName"><a name="stockcollection_db-stockcollection_db_id">stockcollection_db_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>
2504 </tr>
2505
2506 <tr class="tr-even">
2507 <td class="FieldCellName"><a name="stockcollection_db-stockcollection_id">stockcollection_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="#stockcollection-stockcollection_id">stockcollection.stockcollection_id</a></td>
2508 </tr>
2509
2510 <tr class="tr-odd">
2511 <td class="FieldCellName"><a name="stockcollection_db-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>
2512 </tr>
2513
2514 </table>
2515
2516 <h3>
2517 Indices
2518 </h3>
2519
2520 <table border="1">
2521
2522 <tr class="IndexRow">
2523 <th>
2524 Name
2525 </th>
2526 <th>
2527 Fields
2528 </th>
2529 </tr>
2530
2531 <tr class="IndexCell">
2532 <td>stockcollection_db_idx1</td><td>stockcollection_id</td>
2533 </tr>
2534
2535 <tr class="IndexCell">
2536 <td>stockcollection_db_idx2</td><td>db_id</td>
2537 </tr>
2538
2539 </table>
2540
2541 <h3>
2542 Constraints
2543 </h3>
2544
2545 <table border="1">
2546
2547 <tr class="IndexRow">
2548 <th>
2549 Type
2550 </th>
2551 <th>
2552 Fields
2553 </th>
2554 </tr>
2555
2556 <tr class="IndexCell">
2557 <td>NOT NULL</td><td>stockcollection_db_id</td>
2558 </tr>
2559
2560 <tr class="IndexCell">
2561 <td>NOT NULL</td><td>stockcollection_id</td>
2562 </tr>
2563
2564 <tr class="IndexCell">
2565 <td>NOT NULL</td><td>db_id</td>
2566 </tr>
2567
2568 <tr class="IndexCell">
2569 <td>UNIQUE</td><td>stockcollection_id, db_id</td>
2570 </tr>
2571
2572 <tr class="IndexCell">
2573 <td>FOREIGN KEY</td><td>db_id</td>
2574 </tr>
2575
2576 <tr class="IndexCell">
2577 <td>FOREIGN KEY</td><td>stockcollection_id</td>
2578 </tr>
2579
2580 </table>
2581
2582 <hr />
2583
2584 <!--
2585 Starting table 'stock_feature'
2586 -->
2587
2588 <a name="stock_feature" />
2589
2590 <table class="TableHeader" width="100%">
2591 <tr class="TableHeaderRow">
2592 <td class="TableHeaderCell"><h3>
2593 stock_feature
2594 </h3></td> <a name="stock_feature"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
2595 </tr>
2596 </table>
2597
2598 <b>
2599 Comments:
2600 </b>
2601
2602 <br />
2603
2604 <em>
2605 <br />
2606 ================================================ <br />
2607 TABLE: stock_feature <br />
2608 ================================================ <br />
2609 Links a stock to a feature.
2610 </em>
2611
2612 <table border="1">
2613
2614 <tr>
2615 <th class="FieldHeader">
2616 Field Name
2617 </th>
2618 <th class="FieldHeader">
2619 Data Type
2620 </th>
2621 <th class="FieldHeader">
2622 Size
2623 </th>
2624 <th class="FieldHeader">
2625 Default Value
2626 </th>
2627 <th class="FieldHeader">
2628 Other
2629 </th>
2630 <th class="FieldHeader">
2631 Foreign Key
2632 </th>
2633 </tr>
2634
2635 <tr class="tr-odd">
2636 <td class="FieldCellName"><a name="stock_feature-stock_feature_id">stock_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>
2637 </tr>
2638
2639 <tr class="tr-even">
2640 <td class="FieldCellName"><a name="stock_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>
2641 </tr>
2642
2643 <tr class="tr-odd">
2644 <td class="FieldCellName"><a name="stock_feature-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>
2645 </tr>
2646
2647 <tr class="tr-even">
2648 <td class="FieldCellName"><a name="stock_feature-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
2649 </tr>
2650
2651 <tr class="tr-odd">
2652 <td class="FieldCellName"><a name="stock_feature-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>
2653 </tr>
2654
2655 </table>
2656
2657 <h3>
2658 Indices
2659 </h3>
2660
2661 <table border="1">
2662
2663 <tr class="IndexRow">
2664 <th>
2665 Name
2666 </th>
2667 <th>
2668 Fields
2669 </th>
2670 </tr>
2671
2672 <tr class="IndexCell">
2673 <td>stock_feature_idx1</td><td>stock_feature_id</td>
2674 </tr>
2675
2676 <tr class="IndexCell">
2677 <td>stock_feature_idx2</td><td>feature_id</td>
2678 </tr>
2679
2680 <tr class="IndexCell">
2681 <td>stock_feature_idx3</td><td>stock_id</td>
2682 </tr>
2683
2684 <tr class="IndexCell">
2685 <td>stock_feature_idx4</td><td>type_id</td>
2686 </tr>
2687
2688 </table>
2689
2690 <h3>
2691 Constraints
2692 </h3>
2693
2694 <table border="1">
2695
2696 <tr class="IndexRow">
2697 <th>
2698 Type
2699 </th>
2700 <th>
2701 Fields
2702 </th>
2703 </tr>
2704
2705 <tr class="IndexCell">
2706 <td>NOT NULL</td><td>stock_feature_id</td>
2707 </tr>
2708
2709 <tr class="IndexCell">
2710 <td>NOT NULL</td><td>feature_id</td>
2711 </tr>
2712
2713 <tr class="IndexCell">
2714 <td>NOT NULL</td><td>stock_id</td>
2715 </tr>
2716
2717 <tr class="IndexCell">
2718 <td>NOT NULL</td><td>type_id</td>
2719 </tr>
2720
2721 <tr class="IndexCell">
2722 <td>NOT NULL</td><td>rank</td>
2723 </tr>
2724
2725 <tr class="IndexCell">
2726 <td>FOREIGN KEY</td><td>feature_id</td>
2727 </tr>
2728
2729 <tr class="IndexCell">
2730 <td>FOREIGN KEY</td><td>stock_id</td>
2731 </tr>
2732
2733 <tr class="IndexCell">
2734 <td>FOREIGN KEY</td><td>type_id</td>
2735 </tr>
2736
2737 <tr class="IndexCell">
2738 <td>UNIQUE</td><td>feature_id, stock_id, type_id, rank</td>
2739 </tr>
2740
2741 </table>
2742
2743 <hr />
2744
2745 <!--
2746 Starting table 'stock_featuremap'
2747 -->
2748
2749 <a name="stock_featuremap" />
2750
2751 <table width="100%" class="TableHeader">
2752 <tr class="TableHeaderRow">
2753 <td class="TableHeaderCell"><h3>
2754 stock_featuremap
2755 </h3></td> <a name="stock_featuremap"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
2756 </tr>
2757 </table>
2758
2759 <b>
2760 Comments:
2761 </b>
2762
2763 <br />
2764
2765 <em>
2766 <br />
2767 ================================================ <br />
2768 TABLE: stock_featuremap <br />
2769 ================================================ <br />
2770 Links a featuremap to a stock.
2771 </em>
2772
2773 <table border="1">
2774
2775 <tr>
2776 <th class="FieldHeader">
2777 Field Name
2778 </th>
2779 <th class="FieldHeader">
2780 Data Type
2781 </th>
2782 <th class="FieldHeader">
2783 Size
2784 </th>
2785 <th class="FieldHeader">
2786 Default Value
2787 </th>
2788 <th class="FieldHeader">
2789 Other
2790 </th>
2791 <th class="FieldHeader">
2792 Foreign Key
2793 </th>
2794 </tr>
2795
2796 <tr class="tr-odd">
2797 <td class="FieldCellName"><a name="stock_featuremap-stock_featuremap_id">stock_featuremap_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>
2798 </tr>
2799
2800 <tr class="tr-even">
2801 <td class="FieldCellName"><a name="stock_featuremap-featuremap_id">featuremap_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="#featuremap-featuremap_id">featuremap.featuremap_id</a></td>
2802 </tr>
2803
2804 <tr class="tr-odd">
2805 <td class="FieldCellName"><a name="stock_featuremap-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>
2806 </tr>
2807
2808 <tr class="tr-even">
2809 <td class="FieldCellName"><a name="stock_featuremap-type_id">type_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
2810 </tr>
2811
2812 </table>
2813
2814 <h3>
2815 Indices
2816 </h3>
2817
2818 <table border="1">
2819
2820 <tr class="IndexRow">
2821 <th>
2822 Name
2823 </th>
2824 <th>
2825 Fields
2826 </th>
2827 </tr>
2828
2829 <tr class="IndexCell">
2830 <td>stock_featuremap_idx1</td><td>featuremap_id</td>
2831 </tr>
2832
2833 <tr class="IndexCell">
2834 <td>stock_featuremap_idx2</td><td>stock_id</td>
2835 </tr>
2836
2837 <tr class="IndexCell">
2838 <td>stock_featuremap_idx3</td><td>type_id</td>
2839 </tr>
2840
2841 </table>
2842
2843 <h3>
2844 Constraints
2845 </h3>
2846
2847 <table border="1">
2848
2849 <tr class="IndexRow">
2850 <th>
2851 Type
2852 </th>
2853 <th>
2854 Fields
2855 </th>
2856 </tr>
2857
2858 <tr class="IndexCell">
2859 <td>NOT NULL</td><td>stock_featuremap_id</td>
2860 </tr>
2861
2862 <tr class="IndexCell">
2863 <td>NOT NULL</td><td>featuremap_id</td>
2864 </tr>
2865
2866 <tr class="IndexCell">
2867 <td>NOT NULL</td><td>stock_id</td>
2868 </tr>
2869
2870 <tr class="IndexCell">
2871 <td>FOREIGN KEY</td><td>featuremap_id</td>
2872 </tr>
2873
2874 <tr class="IndexCell">
2875 <td>FOREIGN KEY</td><td>stock_id</td>
2876 </tr>
2877
2878 <tr class="IndexCell">
2879 <td>FOREIGN KEY</td><td>type_id</td>
2880 </tr>
2881
2882 <tr class="IndexCell">
2883 <td>UNIQUE</td><td>featuremap_id, stock_id, type_id</td>
2884 </tr>
2885
2886 </table>
2887
2888 <hr />
2889
2890 <!--
2891 Starting table 'stock_library'
2892 -->
2893
2894 <a name="stock_library" />
2895
2896 <table width="100%" class="TableHeader">
2897 <tr class="TableHeaderRow">
2898 <td class="TableHeaderCell"><h3>
2899 stock_library
2900 </h3></td> <a name="stock_library"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
2901 </tr>
2902 </table>
2903
2904 <b>
2905 Comments:
2906 </b>
2907
2908 <br />
2909
2910 <em>
2911 <br />
2912 ================================================ <br />
2913 TABLE: stock_library <br />
2914 ================================================ <br />
2915 Links a stock with a library.
2916 </em>
2917
2918 <table border="1">
2919
2920 <tr>
2921 <th class="FieldHeader">
2922 Field Name
2923 </th>
2924 <th class="FieldHeader">
2925 Data Type
2926 </th>
2927 <th class="FieldHeader">
2928 Size
2929 </th>
2930 <th class="FieldHeader">
2931 Default Value
2932 </th>
2933 <th class="FieldHeader">
2934 Other
2935 </th>
2936 <th class="FieldHeader">
2937 Foreign Key
2938 </th>
2939 </tr>
2940
2941 <tr class="tr-odd">
2942 <td class="FieldCellName"><a name="stock_library-stock_library_id">stock_library_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>
2943 </tr>
2944
2945 <tr class="tr-even">
2946 <td class="FieldCellName"><a name="stock_library-library_id">library_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="#library-library_id">library.library_id</a></td>
2947 </tr>
2948
2949 <tr class="tr-odd">
2950 <td class="FieldCellName"><a name="stock_library-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>
2951 </tr>
2952
2953 </table>
2954
2955 <h3>
2956 Indices
2957 </h3>
2958
2959 <table border="1">
2960
2961 <tr class="IndexRow">
2962 <th>
2963 Name
2964 </th>
2965 <th>
2966 Fields
2967 </th>
2968 </tr>
2969
2970 <tr class="IndexCell">
2971 <td>stock_library_idx1</td><td>library_id</td>
2972 </tr>
2973
2974 <tr class="IndexCell">
2975 <td>stock_library_idx2</td><td>stock_id</td>
2976 </tr>
2977
2978 </table>
2979
2980 <h3>
2981 Constraints
2982 </h3>
2983
2984 <table border="1">
2985
2986 <tr class="IndexRow">
2987 <th>
2988 Type
2989 </th>
2990 <th>
2991 Fields
2992 </th>
2993 </tr>
2994
2995 <tr class="IndexCell">
2996 <td>NOT NULL</td><td>stock_library_id</td>
2997 </tr>
2998
2999 <tr class="IndexCell">
3000 <td>NOT NULL</td><td>library_id</td>
3001 </tr>
3002
3003 <tr class="IndexCell">
3004 <td>NOT NULL</td><td>stock_id</td>
3005 </tr>
3006
3007 <tr class="IndexCell">
3008 <td>UNIQUE</td><td>library_id, stock_id</td>
3009 </tr>
3010
3011 <tr class="IndexCell">
3012 <td>FOREIGN KEY</td><td>library_id</td>
3013 </tr>
3014
3015 <tr class="IndexCell">
3016 <td>FOREIGN KEY</td><td>stock_id</td>
3017 </tr>
3018
3019 </table>
3020
3021 <hr />
3022
3023 Created by <a href="http://sqlfairy.sourceforge.net">
3024 SQL::Translator 0.11020</a>
3025
3026 </body>
3027 </html>