Debian Codegraph @

modules/cell_line/cell_line.html

raw
1 <!DOCTYPE html
2 PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
3 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
4 <html xmlns="http://www.w3.org/1999/xhtml" lang="en-US" xml:lang="en-US">
5 <head>
6 <title>Description of Schema</title>
7 <meta name="generator" content="SQL::Translator::Producer::HTML" />
8 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
9 </head>
10 <body>
11
12
13 <h1 class="SchemaDescription">
14 Description of Schema
15 </h1>
16
17 <hr />
18
19 <!--
20 Table listing (11 tables)
21 -->
22
23 <a name="top" />
24
25 <table 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 'cell_line'
35 -->
36
37 <tr class="LinkTableRow">
38 <td class="LinkTableCell"><a id="cell_line-link" href="#cell_line">cell_line</a></td>
39 </tr>
40
41 <!--
42 End link to table 'cell_line'
43 -->
44
45 <!--
46 Start link to table 'cell_line_relationship'
47 -->
48
49 <tr class="LinkTableRow">
50 <td class="LinkTableCell"><a id="cell_line_relationship-link" href="#cell_line_relationship">cell_line_relationship</a></td>
51 </tr>
52
53 <!--
54 End link to table 'cell_line_relationship'
55 -->
56
57 <!--
58 Start link to table 'cell_line_synonym'
59 -->
60
61 <tr class="LinkTableRow">
62 <td class="LinkTableCell"><a id="cell_line_synonym-link" href="#cell_line_synonym">cell_line_synonym</a></td>
63 </tr>
64
65 <!--
66 End link to table 'cell_line_synonym'
67 -->
68
69 <!--
70 Start link to table 'cell_line_cvterm'
71 -->
72
73 <tr class="LinkTableRow">
74 <td class="LinkTableCell"><a id="cell_line_cvterm-link" href="#cell_line_cvterm">cell_line_cvterm</a></td>
75 </tr>
76
77 <!--
78 End link to table 'cell_line_cvterm'
79 -->
80
81 <!--
82 Start link to table 'cell_line_dbxref'
83 -->
84
85 <tr class="LinkTableRow">
86 <td class="LinkTableCell"><a id="cell_line_dbxref-link" href="#cell_line_dbxref">cell_line_dbxref</a></td>
87 </tr>
88
89 <!--
90 End link to table 'cell_line_dbxref'
91 -->
92
93 <!--
94 Start link to table 'cell_lineprop'
95 -->
96
97 <tr class="LinkTableRow">
98 <td class="LinkTableCell"><a id="cell_lineprop-link" href="#cell_lineprop">cell_lineprop</a></td>
99 </tr>
100
101 <!--
102 End link to table 'cell_lineprop'
103 -->
104
105 <!--
106 Start link to table 'cell_lineprop_pub'
107 -->
108
109 <tr class="LinkTableRow">
110 <td class="LinkTableCell"><a id="cell_lineprop_pub-link" href="#cell_lineprop_pub">cell_lineprop_pub</a></td>
111 </tr>
112
113 <!--
114 End link to table 'cell_lineprop_pub'
115 -->
116
117 <!--
118 Start link to table 'cell_line_feature'
119 -->
120
121 <tr class="LinkTableRow">
122 <td class="LinkTableCell"><a id="cell_line_feature-link" href="#cell_line_feature">cell_line_feature</a></td>
123 </tr>
124
125 <!--
126 End link to table 'cell_line_feature'
127 -->
128
129 <!--
130 Start link to table 'cell_line_cvtermprop'
131 -->
132
133 <tr class="LinkTableRow">
134 <td class="LinkTableCell"><a id="cell_line_cvtermprop-link" href="#cell_line_cvtermprop">cell_line_cvtermprop</a></td>
135 </tr>
136
137 <!--
138 End link to table 'cell_line_cvtermprop'
139 -->
140
141 <!--
142 Start link to table 'cell_line_pub'
143 -->
144
145 <tr class="LinkTableRow">
146 <td class="LinkTableCell"><a id="cell_line_pub-link" href="#cell_line_pub">cell_line_pub</a></td>
147 </tr>
148
149 <!--
150 End link to table 'cell_line_pub'
151 -->
152
153 <!--
154 Start link to table 'cell_line_library'
155 -->
156
157 <tr class="LinkTableRow">
158 <td class="LinkTableCell"><a id="cell_line_library-link" href="#cell_line_library">cell_line_library</a></td>
159 </tr>
160
161 <!--
162 End link to table 'cell_line_library'
163 -->
164
165 </table>
166
167 <!--
168 Starting table 'cell_line'
169 -->
170
171 <a name="cell_line" />
172
173 <table width="100%" class="TableHeader">
174 <tr class="TableHeaderRow">
175 <td class="TableHeaderCell"><h3>
176 cell_line
177 </h3></td> <a name="cell_line"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
178 </tr>
179 </table>
180
181 <b>
182 Comments:
183 </b>
184
185 <br />
186
187 <em>
188 <br />
189 ========================================== <br />
190 Chado cell line module <br />
191 ============ <br />
192 DEPENDENCIES <br />
193 ============ <br />
194 :import feature from sequence <br />
195 :import synonym from sequence <br />
196 :import library from library <br />
197 :import cvterm from cv <br />
198 :import dbxref from db <br />
199 :import pub from pub <br />
200 :import organism from organism <br />
201 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ <br />
202 ================================================ <br />
203 TABLE: cell_line <br />
204 ================================================
205 </em>
206
207 <table border="1">
208
209 <tr>
210 <th class="FieldHeader">
211 Field Name
212 </th>
213 <th class="FieldHeader">
214 Data Type
215 </th>
216 <th class="FieldHeader">
217 Size
218 </th>
219 <th class="FieldHeader">
220 Default Value
221 </th>
222 <th class="FieldHeader">
223 Other
224 </th>
225 <th class="FieldHeader">
226 Foreign Key
227 </th>
228 </tr>
229
230 <tr class="tr-odd">
231 <td class="FieldCellName"><a name="cell_line-cell_line_id">cell_line_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>
232 </tr>
233
234 <tr class="tr-even">
235 <td class="FieldCellName"><a name="cell_line-name">name</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
236 </tr>
237
238 <tr class="tr-odd">
239 <td class="FieldCellName"><a name="cell_line-uniquename">uniquename</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>
240 </tr>
241
242 <tr class="tr-even">
243 <td class="FieldCellName"><a name="cell_line-organism_id">organism_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#organism-organism_id">organism.organism_id</a></td>
244 </tr>
245
246 <tr class="tr-odd">
247 <td class="FieldCellName"><a name="cell_line-timeaccessioned">timeaccessioned</a></td> <td class="FieldCellType">timestamp</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">current_timestamp</td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
248 </tr>
249
250 <tr class="tr-even">
251 <td class="FieldCellName"><a name="cell_line-timelastmodified">timelastmodified</a></td> <td class="FieldCellType">timestamp</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">current_timestamp</td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
252 </tr>
253
254 </table>
255
256 <h3>
257 Constraints
258 </h3>
259
260 <table border="1">
261
262 <tr class="IndexRow">
263 <th>
264 Type
265 </th>
266 <th>
267 Fields
268 </th>
269 </tr>
270
271 <tr class="IndexCell">
272 <td>NOT NULL</td><td>cell_line_id</td>
273 </tr>
274
275 <tr class="IndexCell">
276 <td>NOT NULL</td><td>uniquename</td>
277 </tr>
278
279 <tr class="IndexCell">
280 <td>NOT NULL</td><td>organism_id</td>
281 </tr>
282
283 <tr class="IndexCell">
284 <td>FOREIGN KEY</td><td>organism_id</td>
285 </tr>
286
287 <tr class="IndexCell">
288 <td>NOT NULL</td><td>timeaccessioned</td>
289 </tr>
290
291 <tr class="IndexCell">
292 <td>NOT NULL</td><td>timelastmodified</td>
293 </tr>
294
295 <tr class="IndexCell">
296 <td>UNIQUE</td><td>uniquename, organism_id</td>
297 </tr>
298
299 </table>
300
301 <hr />
302
303 <!--
304 Starting table 'cell_line_relationship'
305 -->
306
307 <a name="cell_line_relationship" />
308
309 <table class="TableHeader" width="100%">
310 <tr class="TableHeaderRow">
311 <td class="TableHeaderCell"><h3>
312 cell_line_relationship
313 </h3></td> <a name="cell_line_relationship"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
314 </tr>
315 </table>
316
317 <b>
318 Comments:
319 </b>
320
321 <br />
322
323 <em>
324 <br />
325 ================================================ <br />
326 TABLE: cell_line_relationship <br />
327 ================================================
328 </em>
329
330 <table border="1">
331
332 <tr>
333 <th class="FieldHeader">
334 Field Name
335 </th>
336 <th class="FieldHeader">
337 Data Type
338 </th>
339 <th class="FieldHeader">
340 Size
341 </th>
342 <th class="FieldHeader">
343 Default Value
344 </th>
345 <th class="FieldHeader">
346 Other
347 </th>
348 <th class="FieldHeader">
349 Foreign Key
350 </th>
351 </tr>
352
353 <tr class="tr-odd">
354 <td class="FieldCellName"><a name="cell_line_relationship-cell_line_relationship_id">cell_line_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>
355 </tr>
356
357 <tr class="tr-even">
358 <td class="FieldCellName"><a name="cell_line_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</td> <td class="FieldCellFK"><a href="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
359 </tr>
360
361 <tr class="tr-odd">
362 <td class="FieldCellName"><a name="cell_line_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</td> <td class="FieldCellFK"><a href="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
363 </tr>
364
365 <tr class="tr-even">
366 <td class="FieldCellName"><a name="cell_line_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</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
367 </tr>
368
369 </table>
370
371 <h3>
372 Constraints
373 </h3>
374
375 <table border="1">
376
377 <tr class="IndexRow">
378 <th>
379 Type
380 </th>
381 <th>
382 Fields
383 </th>
384 </tr>
385
386 <tr class="IndexCell">
387 <td>NOT NULL</td><td>cell_line_relationship_id</td>
388 </tr>
389
390 <tr class="IndexCell">
391 <td>NOT NULL</td><td>subject_id</td>
392 </tr>
393
394 <tr class="IndexCell">
395 <td>FOREIGN KEY</td><td>subject_id</td>
396 </tr>
397
398 <tr class="IndexCell">
399 <td>NOT NULL</td><td>object_id</td>
400 </tr>
401
402 <tr class="IndexCell">
403 <td>FOREIGN KEY</td><td>object_id</td>
404 </tr>
405
406 <tr class="IndexCell">
407 <td>NOT NULL</td><td>type_id</td>
408 </tr>
409
410 <tr class="IndexCell">
411 <td>FOREIGN KEY</td><td>type_id</td>
412 </tr>
413
414 <tr class="IndexCell">
415 <td>UNIQUE</td><td>subject_id, object_id, type_id</td>
416 </tr>
417
418 </table>
419
420 <hr />
421
422 <!--
423 Starting table 'cell_line_synonym'
424 -->
425
426 <a name="cell_line_synonym" />
427
428 <table width="100%" class="TableHeader">
429 <tr class="TableHeaderRow">
430 <td class="TableHeaderCell"><h3>
431 cell_line_synonym
432 </h3></td> <a name="cell_line_synonym"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
433 </tr>
434 </table>
435
436 <b>
437 Comments:
438 </b>
439
440 <br />
441
442 <em>
443 <br />
444 ================================================ <br />
445 TABLE: cell_line_synonym <br />
446 ================================================
447 </em>
448
449 <table border="1">
450
451 <tr>
452 <th class="FieldHeader">
453 Field Name
454 </th>
455 <th class="FieldHeader">
456 Data Type
457 </th>
458 <th class="FieldHeader">
459 Size
460 </th>
461 <th class="FieldHeader">
462 Default Value
463 </th>
464 <th class="FieldHeader">
465 Other
466 </th>
467 <th class="FieldHeader">
468 Foreign Key
469 </th>
470 </tr>
471
472 <tr class="tr-odd">
473 <td class="FieldCellName"><a name="cell_line_synonym-cell_line_synonym_id">cell_line_synonym_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td> <td class="FieldCellFK"></td>
474 </tr>
475
476 <tr class="tr-even">
477 <td class="FieldCellName"><a name="cell_line_synonym-cell_line_id">cell_line_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="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
478 </tr>
479
480 <tr class="tr-odd">
481 <td class="FieldCellName"><a name="cell_line_synonym-synonym_id">synonym_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#synonym-synonym_id">synonym.synonym_id</a></td>
482 </tr>
483
484 <tr class="tr-even">
485 <td class="FieldCellName"><a name="cell_line_synonym-pub_id">pub_id</a></td> <td class="FieldCellType">integer</td> <td class="FieldCellSize">20</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"><a href="#pub-pub_id">pub.pub_id</a></td>
486 </tr>
487
488 <tr class="tr-odd">
489 <td class="FieldCellName"><a name="cell_line_synonym-is_current">is_current</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">false</td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
490 </tr>
491
492 <tr class="tr-even">
493 <td class="FieldCellName"><a name="cell_line_synonym-is_internal">is_internal</a></td> <td class="FieldCellType">boolean</td> <td class="FieldCellSize">0</td> <td class="FieldCellDefault">false</td> <td class="FieldCellOther">NOT NULL</td> <td class="FieldCellFK"></td>
494 </tr>
495
496 </table>
497
498 <h3>
499 Constraints
500 </h3>
501
502 <table border="1">
503
504 <tr class="IndexRow">
505 <th>
506 Type
507 </th>
508 <th>
509 Fields
510 </th>
511 </tr>
512
513 <tr class="IndexCell">
514 <td>NOT NULL</td><td>cell_line_synonym_id</td>
515 </tr>
516
517 <tr class="IndexCell">
518 <td>NOT NULL</td><td>cell_line_id</td>
519 </tr>
520
521 <tr class="IndexCell">
522 <td>FOREIGN KEY</td><td>cell_line_id</td>
523 </tr>
524
525 <tr class="IndexCell">
526 <td>NOT NULL</td><td>synonym_id</td>
527 </tr>
528
529 <tr class="IndexCell">
530 <td>FOREIGN KEY</td><td>synonym_id</td>
531 </tr>
532
533 <tr class="IndexCell">
534 <td>NOT NULL</td><td>pub_id</td>
535 </tr>
536
537 <tr class="IndexCell">
538 <td>FOREIGN KEY</td><td>pub_id</td>
539 </tr>
540
541 <tr class="IndexCell">
542 <td>NOT NULL</td><td>is_current</td>
543 </tr>
544
545 <tr class="IndexCell">
546 <td>NOT NULL</td><td>is_internal</td>
547 </tr>
548
549 <tr class="IndexCell">
550 <td>UNIQUE</td><td>synonym_id, cell_line_id, pub_id</td>
551 </tr>
552
553 </table>
554
555 <hr />
556
557 <!--
558 Starting table 'cell_line_cvterm'
559 -->
560
561 <a name="cell_line_cvterm" />
562
563 <table class="TableHeader" width="100%">
564 <tr class="TableHeaderRow">
565 <td class="TableHeaderCell"><h3>
566 cell_line_cvterm
567 </h3></td> <a name="cell_line_cvterm"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
568 </tr>
569 </table>
570
571 <b>
572 Comments:
573 </b>
574
575 <br />
576
577 <em>
578 <br />
579 ================================================ <br />
580 TABLE: cell_line_cvterm <br />
581 ================================================
582 </em>
583
584 <table border="1">
585
586 <tr>
587 <th class="FieldHeader">
588 Field Name
589 </th>
590 <th class="FieldHeader">
591 Data Type
592 </th>
593 <th class="FieldHeader">
594 Size
595 </th>
596 <th class="FieldHeader">
597 Default Value
598 </th>
599 <th class="FieldHeader">
600 Other
601 </th>
602 <th class="FieldHeader">
603 Foreign Key
604 </th>
605 </tr>
606
607 <tr class="tr-odd">
608 <td class="FieldCellName"><a name="cell_line_cvterm-cell_line_cvterm_id">cell_line_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>
609 </tr>
610
611 <tr class="tr-even">
612 <td class="FieldCellName"><a name="cell_line_cvterm-cell_line_id">cell_line_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="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
613 </tr>
614
615 <tr class="tr-odd">
616 <td class="FieldCellName"><a name="cell_line_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>
617 </tr>
618
619 <tr class="tr-even">
620 <td class="FieldCellName"><a name="cell_line_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>
621 </tr>
622
623 <tr class="tr-odd">
624 <td class="FieldCellName"><a name="cell_line_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>
625 </tr>
626
627 </table>
628
629 <h3>
630 Constraints
631 </h3>
632
633 <table border="1">
634
635 <tr class="IndexRow">
636 <th>
637 Type
638 </th>
639 <th>
640 Fields
641 </th>
642 </tr>
643
644 <tr class="IndexCell">
645 <td>NOT NULL</td><td>cell_line_cvterm_id</td>
646 </tr>
647
648 <tr class="IndexCell">
649 <td>NOT NULL</td><td>cell_line_id</td>
650 </tr>
651
652 <tr class="IndexCell">
653 <td>FOREIGN KEY</td><td>cell_line_id</td>
654 </tr>
655
656 <tr class="IndexCell">
657 <td>NOT NULL</td><td>cvterm_id</td>
658 </tr>
659
660 <tr class="IndexCell">
661 <td>FOREIGN KEY</td><td>cvterm_id</td>
662 </tr>
663
664 <tr class="IndexCell">
665 <td>NOT NULL</td><td>pub_id</td>
666 </tr>
667
668 <tr class="IndexCell">
669 <td>FOREIGN KEY</td><td>pub_id</td>
670 </tr>
671
672 <tr class="IndexCell">
673 <td>NOT NULL</td><td>rank</td>
674 </tr>
675
676 <tr class="IndexCell">
677 <td>UNIQUE</td><td>cell_line_id, cvterm_id, pub_id, rank</td>
678 </tr>
679
680 </table>
681
682 <hr />
683
684 <!--
685 Starting table 'cell_line_dbxref'
686 -->
687
688 <a name="cell_line_dbxref" />
689
690 <table class="TableHeader" width="100%">
691 <tr class="TableHeaderRow">
692 <td class="TableHeaderCell"><h3>
693 cell_line_dbxref
694 </h3></td> <a name="cell_line_dbxref"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
695 </tr>
696 </table>
697
698 <b>
699 Comments:
700 </b>
701
702 <br />
703
704 <em>
705 <br />
706 ================================================ <br />
707 TABLE: cell_line_dbxref <br />
708 ================================================
709 </em>
710
711 <table border="1">
712
713 <tr>
714 <th class="FieldHeader">
715 Field Name
716 </th>
717 <th class="FieldHeader">
718 Data Type
719 </th>
720 <th class="FieldHeader">
721 Size
722 </th>
723 <th class="FieldHeader">
724 Default Value
725 </th>
726 <th class="FieldHeader">
727 Other
728 </th>
729 <th class="FieldHeader">
730 Foreign Key
731 </th>
732 </tr>
733
734 <tr class="tr-odd">
735 <td class="FieldCellName"><a name="cell_line_dbxref-cell_line_dbxref_id">cell_line_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>
736 </tr>
737
738 <tr class="tr-even">
739 <td class="FieldCellName"><a name="cell_line_dbxref-cell_line_id">cell_line_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="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
740 </tr>
741
742 <tr class="tr-odd">
743 <td class="FieldCellName"><a name="cell_line_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>
744 </tr>
745
746 <tr class="tr-even">
747 <td class="FieldCellName"><a name="cell_line_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</td> <td class="FieldCellFK"></td>
748 </tr>
749
750 </table>
751
752 <h3>
753 Constraints
754 </h3>
755
756 <table border="1">
757
758 <tr class="IndexRow">
759 <th>
760 Type
761 </th>
762 <th>
763 Fields
764 </th>
765 </tr>
766
767 <tr class="IndexCell">
768 <td>NOT NULL</td><td>cell_line_dbxref_id</td>
769 </tr>
770
771 <tr class="IndexCell">
772 <td>NOT NULL</td><td>cell_line_id</td>
773 </tr>
774
775 <tr class="IndexCell">
776 <td>FOREIGN KEY</td><td>cell_line_id</td>
777 </tr>
778
779 <tr class="IndexCell">
780 <td>NOT NULL</td><td>dbxref_id</td>
781 </tr>
782
783 <tr class="IndexCell">
784 <td>FOREIGN KEY</td><td>dbxref_id</td>
785 </tr>
786
787 <tr class="IndexCell">
788 <td>NOT NULL</td><td>is_current</td>
789 </tr>
790
791 <tr class="IndexCell">
792 <td>UNIQUE</td><td>cell_line_id, dbxref_id</td>
793 </tr>
794
795 </table>
796
797 <hr />
798
799 <!--
800 Starting table 'cell_lineprop'
801 -->
802
803 <a name="cell_lineprop" />
804
805 <table class="TableHeader" width="100%">
806 <tr class="TableHeaderRow">
807 <td class="TableHeaderCell"><h3>
808 cell_lineprop
809 </h3></td> <a name="cell_lineprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
810 </tr>
811 </table>
812
813 <b>
814 Comments:
815 </b>
816
817 <br />
818
819 <em>
820 <br />
821 ================================================ <br />
822 TABLE: cell_lineprop <br />
823 ================================================
824 </em>
825
826 <table border="1">
827
828 <tr>
829 <th class="FieldHeader">
830 Field Name
831 </th>
832 <th class="FieldHeader">
833 Data Type
834 </th>
835 <th class="FieldHeader">
836 Size
837 </th>
838 <th class="FieldHeader">
839 Default Value
840 </th>
841 <th class="FieldHeader">
842 Other
843 </th>
844 <th class="FieldHeader">
845 Foreign Key
846 </th>
847 </tr>
848
849 <tr class="tr-odd">
850 <td class="FieldCellName"><a name="cell_lineprop-cell_lineprop_id">cell_lineprop_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>
851 </tr>
852
853 <tr class="tr-even">
854 <td class="FieldCellName"><a name="cell_lineprop-cell_line_id">cell_line_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="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
855 </tr>
856
857 <tr class="tr-odd">
858 <td class="FieldCellName"><a name="cell_lineprop-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>
859 </tr>
860
861 <tr class="tr-even">
862 <td class="FieldCellName"><a name="cell_lineprop-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>
863 </tr>
864
865 <tr class="tr-odd">
866 <td class="FieldCellName"><a name="cell_lineprop-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>
867 </tr>
868
869 </table>
870
871 <h3>
872 Constraints
873 </h3>
874
875 <table border="1">
876
877 <tr class="IndexRow">
878 <th>
879 Type
880 </th>
881 <th>
882 Fields
883 </th>
884 </tr>
885
886 <tr class="IndexCell">
887 <td>NOT NULL</td><td>cell_lineprop_id</td>
888 </tr>
889
890 <tr class="IndexCell">
891 <td>NOT NULL</td><td>cell_line_id</td>
892 </tr>
893
894 <tr class="IndexCell">
895 <td>FOREIGN KEY</td><td>cell_line_id</td>
896 </tr>
897
898 <tr class="IndexCell">
899 <td>NOT NULL</td><td>type_id</td>
900 </tr>
901
902 <tr class="IndexCell">
903 <td>FOREIGN KEY</td><td>type_id</td>
904 </tr>
905
906 <tr class="IndexCell">
907 <td>NOT NULL</td><td>rank</td>
908 </tr>
909
910 <tr class="IndexCell">
911 <td>UNIQUE</td><td>cell_line_id, type_id, rank</td>
912 </tr>
913
914 </table>
915
916 <hr />
917
918 <!--
919 Starting table 'cell_lineprop_pub'
920 -->
921
922 <a name="cell_lineprop_pub" />
923
924 <table class="TableHeader" width="100%">
925 <tr class="TableHeaderRow">
926 <td class="TableHeaderCell"><h3>
927 cell_lineprop_pub
928 </h3></td> <a name="cell_lineprop_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
929 </tr>
930 </table>
931
932 <b>
933 Comments:
934 </b>
935
936 <br />
937
938 <em>
939 <br />
940 ================================================ <br />
941 TABLE: cell_lineprop_pub <br />
942 ================================================
943 </em>
944
945 <table border="1">
946
947 <tr>
948 <th class="FieldHeader">
949 Field Name
950 </th>
951 <th class="FieldHeader">
952 Data Type
953 </th>
954 <th class="FieldHeader">
955 Size
956 </th>
957 <th class="FieldHeader">
958 Default Value
959 </th>
960 <th class="FieldHeader">
961 Other
962 </th>
963 <th class="FieldHeader">
964 Foreign Key
965 </th>
966 </tr>
967
968 <tr class="tr-odd">
969 <td class="FieldCellName"><a name="cell_lineprop_pub-cell_lineprop_pub_id">cell_lineprop_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>
970 </tr>
971
972 <tr class="tr-even">
973 <td class="FieldCellName"><a name="cell_lineprop_pub-cell_lineprop_id">cell_lineprop_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="#cell_lineprop-cell_lineprop_id">cell_lineprop.cell_lineprop_id</a></td>
974 </tr>
975
976 <tr class="tr-odd">
977 <td class="FieldCellName"><a name="cell_lineprop_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>
978 </tr>
979
980 </table>
981
982 <h3>
983 Constraints
984 </h3>
985
986 <table border="1">
987
988 <tr class="IndexRow">
989 <th>
990 Type
991 </th>
992 <th>
993 Fields
994 </th>
995 </tr>
996
997 <tr class="IndexCell">
998 <td>NOT NULL</td><td>cell_lineprop_pub_id</td>
999 </tr>
1000
1001 <tr class="IndexCell">
1002 <td>NOT NULL</td><td>cell_lineprop_id</td>
1003 </tr>
1004
1005 <tr class="IndexCell">
1006 <td>FOREIGN KEY</td><td>cell_lineprop_id</td>
1007 </tr>
1008
1009 <tr class="IndexCell">
1010 <td>NOT NULL</td><td>pub_id</td>
1011 </tr>
1012
1013 <tr class="IndexCell">
1014 <td>FOREIGN KEY</td><td>pub_id</td>
1015 </tr>
1016
1017 <tr class="IndexCell">
1018 <td>UNIQUE</td><td>cell_lineprop_id, pub_id</td>
1019 </tr>
1020
1021 </table>
1022
1023 <hr />
1024
1025 <!--
1026 Starting table 'cell_line_feature'
1027 -->
1028
1029 <a name="cell_line_feature" />
1030
1031 <table class="TableHeader" width="100%">
1032 <tr class="TableHeaderRow">
1033 <td class="TableHeaderCell"><h3>
1034 cell_line_feature
1035 </h3></td> <a name="cell_line_feature"> <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: cell_line_feature <br />
1049 ================================================
1050 </em>
1051
1052 <table border="1">
1053
1054 <tr>
1055 <th class="FieldHeader">
1056 Field Name
1057 </th>
1058 <th class="FieldHeader">
1059 Data Type
1060 </th>
1061 <th class="FieldHeader">
1062 Size
1063 </th>
1064 <th class="FieldHeader">
1065 Default Value
1066 </th>
1067 <th class="FieldHeader">
1068 Other
1069 </th>
1070 <th class="FieldHeader">
1071 Foreign Key
1072 </th>
1073 </tr>
1074
1075 <tr class="tr-odd">
1076 <td class="FieldCellName"><a name="cell_line_feature-cell_line_feature_id">cell_line_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>
1077 </tr>
1078
1079 <tr class="tr-even">
1080 <td class="FieldCellName"><a name="cell_line_feature-cell_line_id">cell_line_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="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
1081 </tr>
1082
1083 <tr class="tr-odd">
1084 <td class="FieldCellName"><a name="cell_line_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>
1085 </tr>
1086
1087 <tr class="tr-even">
1088 <td class="FieldCellName"><a name="cell_line_feature-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>
1089 </tr>
1090
1091 </table>
1092
1093 <h3>
1094 Constraints
1095 </h3>
1096
1097 <table border="1">
1098
1099 <tr class="IndexRow">
1100 <th>
1101 Type
1102 </th>
1103 <th>
1104 Fields
1105 </th>
1106 </tr>
1107
1108 <tr class="IndexCell">
1109 <td>NOT NULL</td><td>cell_line_feature_id</td>
1110 </tr>
1111
1112 <tr class="IndexCell">
1113 <td>NOT NULL</td><td>cell_line_id</td>
1114 </tr>
1115
1116 <tr class="IndexCell">
1117 <td>FOREIGN KEY</td><td>cell_line_id</td>
1118 </tr>
1119
1120 <tr class="IndexCell">
1121 <td>NOT NULL</td><td>feature_id</td>
1122 </tr>
1123
1124 <tr class="IndexCell">
1125 <td>FOREIGN KEY</td><td>feature_id</td>
1126 </tr>
1127
1128 <tr class="IndexCell">
1129 <td>NOT NULL</td><td>pub_id</td>
1130 </tr>
1131
1132 <tr class="IndexCell">
1133 <td>FOREIGN KEY</td><td>pub_id</td>
1134 </tr>
1135
1136 <tr class="IndexCell">
1137 <td>UNIQUE</td><td>cell_line_id, feature_id, pub_id</td>
1138 </tr>
1139
1140 </table>
1141
1142 <hr />
1143
1144 <!--
1145 Starting table 'cell_line_cvtermprop'
1146 -->
1147
1148 <a name="cell_line_cvtermprop" />
1149
1150 <table width="100%" class="TableHeader">
1151 <tr class="TableHeaderRow">
1152 <td class="TableHeaderCell"><h3>
1153 cell_line_cvtermprop
1154 </h3></td> <a name="cell_line_cvtermprop"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
1155 </tr>
1156 </table>
1157
1158 <b>
1159 Comments:
1160 </b>
1161
1162 <br />
1163
1164 <em>
1165 <br />
1166 ================================================ <br />
1167 TABLE: cell_line_cvtermprop <br />
1168 ================================================
1169 </em>
1170
1171 <table border="1">
1172
1173 <tr>
1174 <th class="FieldHeader">
1175 Field Name
1176 </th>
1177 <th class="FieldHeader">
1178 Data Type
1179 </th>
1180 <th class="FieldHeader">
1181 Size
1182 </th>
1183 <th class="FieldHeader">
1184 Default Value
1185 </th>
1186 <th class="FieldHeader">
1187 Other
1188 </th>
1189 <th class="FieldHeader">
1190 Foreign Key
1191 </th>
1192 </tr>
1193
1194 <tr class="tr-odd">
1195 <td class="FieldCellName"><a name="cell_line_cvtermprop-cell_line_cvtermprop_id">cell_line_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>
1196 </tr>
1197
1198 <tr class="tr-even">
1199 <td class="FieldCellName"><a name="cell_line_cvtermprop-cell_line_cvterm_id">cell_line_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="#cell_line_cvterm-cell_line_cvterm_id">cell_line_cvterm.cell_line_cvterm_id</a></td>
1200 </tr>
1201
1202 <tr class="tr-odd">
1203 <td class="FieldCellName"><a name="cell_line_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</td> <td class="FieldCellFK"><a href="#cvterm-cvterm_id">cvterm.cvterm_id</a></td>
1204 </tr>
1205
1206 <tr class="tr-even">
1207 <td class="FieldCellName"><a name="cell_line_cvtermprop-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>
1208 </tr>
1209
1210 <tr class="tr-odd">
1211 <td class="FieldCellName"><a name="cell_line_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</td> <td class="FieldCellFK"></td>
1212 </tr>
1213
1214 </table>
1215
1216 <h3>
1217 Constraints
1218 </h3>
1219
1220 <table border="1">
1221
1222 <tr class="IndexRow">
1223 <th>
1224 Type
1225 </th>
1226 <th>
1227 Fields
1228 </th>
1229 </tr>
1230
1231 <tr class="IndexCell">
1232 <td>NOT NULL</td><td>cell_line_cvtermprop_id</td>
1233 </tr>
1234
1235 <tr class="IndexCell">
1236 <td>NOT NULL</td><td>cell_line_cvterm_id</td>
1237 </tr>
1238
1239 <tr class="IndexCell">
1240 <td>FOREIGN KEY</td><td>cell_line_cvterm_id</td>
1241 </tr>
1242
1243 <tr class="IndexCell">
1244 <td>NOT NULL</td><td>type_id</td>
1245 </tr>
1246
1247 <tr class="IndexCell">
1248 <td>FOREIGN KEY</td><td>type_id</td>
1249 </tr>
1250
1251 <tr class="IndexCell">
1252 <td>NOT NULL</td><td>rank</td>
1253 </tr>
1254
1255 <tr class="IndexCell">
1256 <td>UNIQUE</td><td>cell_line_cvterm_id, type_id, rank</td>
1257 </tr>
1258
1259 </table>
1260
1261 <hr />
1262
1263 <!--
1264 Starting table 'cell_line_pub'
1265 -->
1266
1267 <a name="cell_line_pub" />
1268
1269 <table class="TableHeader" width="100%">
1270 <tr class="TableHeaderRow">
1271 <td class="TableHeaderCell"><h3>
1272 cell_line_pub
1273 </h3></td> <a name="cell_line_pub"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1274 </tr>
1275 </table>
1276
1277 <b>
1278 Comments:
1279 </b>
1280
1281 <br />
1282
1283 <em>
1284 <br />
1285 ================================================ <br />
1286 TABLE: cell_line_pub <br />
1287 ================================================
1288 </em>
1289
1290 <table border="1">
1291
1292 <tr>
1293 <th class="FieldHeader">
1294 Field Name
1295 </th>
1296 <th class="FieldHeader">
1297 Data Type
1298 </th>
1299 <th class="FieldHeader">
1300 Size
1301 </th>
1302 <th class="FieldHeader">
1303 Default Value
1304 </th>
1305 <th class="FieldHeader">
1306 Other
1307 </th>
1308 <th class="FieldHeader">
1309 Foreign Key
1310 </th>
1311 </tr>
1312
1313 <tr class="tr-odd">
1314 <td class="FieldCellName"><a name="cell_line_pub-cell_line_pub_id">cell_line_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>
1315 </tr>
1316
1317 <tr class="tr-even">
1318 <td class="FieldCellName"><a name="cell_line_pub-cell_line_id">cell_line_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="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
1319 </tr>
1320
1321 <tr class="tr-odd">
1322 <td class="FieldCellName"><a name="cell_line_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>
1323 </tr>
1324
1325 </table>
1326
1327 <h3>
1328 Constraints
1329 </h3>
1330
1331 <table border="1">
1332
1333 <tr class="IndexRow">
1334 <th>
1335 Type
1336 </th>
1337 <th>
1338 Fields
1339 </th>
1340 </tr>
1341
1342 <tr class="IndexCell">
1343 <td>NOT NULL</td><td>cell_line_pub_id</td>
1344 </tr>
1345
1346 <tr class="IndexCell">
1347 <td>NOT NULL</td><td>cell_line_id</td>
1348 </tr>
1349
1350 <tr class="IndexCell">
1351 <td>FOREIGN KEY</td><td>cell_line_id</td>
1352 </tr>
1353
1354 <tr class="IndexCell">
1355 <td>NOT NULL</td><td>pub_id</td>
1356 </tr>
1357
1358 <tr class="IndexCell">
1359 <td>FOREIGN KEY</td><td>pub_id</td>
1360 </tr>
1361
1362 <tr class="IndexCell">
1363 <td>UNIQUE</td><td>cell_line_id, pub_id</td>
1364 </tr>
1365
1366 </table>
1367
1368 <hr />
1369
1370 <!--
1371 Starting table 'cell_line_library'
1372 -->
1373
1374 <a name="cell_line_library" />
1375
1376 <table width="100%" class="TableHeader">
1377 <tr class="TableHeaderRow">
1378 <td class="TableHeaderCell"><h3>
1379 cell_line_library
1380 </h3></td> <a name="cell_line_library"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
1381 </tr>
1382 </table>
1383
1384 <b>
1385 Comments:
1386 </b>
1387
1388 <br />
1389
1390 <em>
1391 <br />
1392 ================================================ <br />
1393 TABLE: cell_line_library <br />
1394 ================================================
1395 </em>
1396
1397 <table border="1">
1398
1399 <tr>
1400 <th class="FieldHeader">
1401 Field Name
1402 </th>
1403 <th class="FieldHeader">
1404 Data Type
1405 </th>
1406 <th class="FieldHeader">
1407 Size
1408 </th>
1409 <th class="FieldHeader">
1410 Default Value
1411 </th>
1412 <th class="FieldHeader">
1413 Other
1414 </th>
1415 <th class="FieldHeader">
1416 Foreign Key
1417 </th>
1418 </tr>
1419
1420 <tr class="tr-odd">
1421 <td class="FieldCellName"><a name="cell_line_library-cell_line_library_id">cell_line_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>
1422 </tr>
1423
1424 <tr class="tr-even">
1425 <td class="FieldCellName"><a name="cell_line_library-cell_line_id">cell_line_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="#cell_line-cell_line_id">cell_line.cell_line_id</a></td>
1426 </tr>
1427
1428 <tr class="tr-odd">
1429 <td class="FieldCellName"><a name="cell_line_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>
1430 </tr>
1431
1432 <tr class="tr-even">
1433 <td class="FieldCellName"><a name="cell_line_library-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>
1434 </tr>
1435
1436 </table>
1437
1438 <h3>
1439 Constraints
1440 </h3>
1441
1442 <table border="1">
1443
1444 <tr class="IndexRow">
1445 <th>
1446 Type
1447 </th>
1448 <th>
1449 Fields
1450 </th>
1451 </tr>
1452
1453 <tr class="IndexCell">
1454 <td>NOT NULL</td><td>cell_line_library_id</td>
1455 </tr>
1456
1457 <tr class="IndexCell">
1458 <td>NOT NULL</td><td>cell_line_id</td>
1459 </tr>
1460
1461 <tr class="IndexCell">
1462 <td>FOREIGN KEY</td><td>cell_line_id</td>
1463 </tr>
1464
1465 <tr class="IndexCell">
1466 <td>NOT NULL</td><td>library_id</td>
1467 </tr>
1468
1469 <tr class="IndexCell">
1470 <td>FOREIGN KEY</td><td>library_id</td>
1471 </tr>
1472
1473 <tr class="IndexCell">
1474 <td>NOT NULL</td><td>pub_id</td>
1475 </tr>
1476
1477 <tr class="IndexCell">
1478 <td>FOREIGN KEY</td><td>pub_id</td>
1479 </tr>
1480
1481 <tr class="IndexCell">
1482 <td>UNIQUE</td><td>cell_line_id, library_id, pub_id</td>
1483 </tr>
1484
1485 </table>
1486
1487 <hr />
1488
1489 Created by <a href="http://sqlfairy.sourceforge.net">
1490 SQL::Translator 0.11020</a>
1491
1492 </body>
1493 </html>