Debian Codegraph @

modules/general/general.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 (3 tables)
21 -->
22
23 <a name="top" />
24
25 <table class="LinkTable" width="100%">
26
27 <tr>
28 <td class="LinkTableCell"><h2 class="LinkTableTitle">
29 Tables
30 </h2></td>
31 </tr>
32
33 <!--
34 Start link to table 'tableinfo'
35 -->
36
37 <tr class="LinkTableRow">
38 <td class="LinkTableCell"><a id="tableinfo-link" href="#tableinfo">tableinfo</a></td>
39 </tr>
40
41 <!--
42 End link to table 'tableinfo'
43 -->
44
45 <!--
46 Start link to table 'db'
47 -->
48
49 <tr class="LinkTableRow">
50 <td class="LinkTableCell"><a id="db-link" href="#db">db</a></td>
51 </tr>
52
53 <!--
54 End link to table 'db'
55 -->
56
57 <!--
58 Start link to table 'dbxref'
59 -->
60
61 <tr class="LinkTableRow">
62 <td class="LinkTableCell"><a id="dbxref-link" href="#dbxref">dbxref</a></td>
63 </tr>
64
65 <!--
66 End link to table 'dbxref'
67 -->
68
69 </table>
70
71 <!--
72 Starting table 'tableinfo'
73 -->
74
75 <a name="tableinfo" />
76
77 <table class="TableHeader" width="100%">
78 <tr class="TableHeaderRow">
79 <td class="TableHeaderCell"><h3>
80 tableinfo
81 </h3></td>
82 <a name="tableinfo"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
83 </tr>
84 </table>
85
86 <b>
87 Comments:
88 </b>
89
90 <br />
91
92 <em>
93 <br />
94 $Id: general.sql,v 1.31 2007-03-01 02:45:54 briano Exp $ <br />
95 ========================================== <br />
96 Chado general module <br />
97 ================================================ <br />
98 TABLE: tableinfo <br />
99 ================================================ <br />
100 NULL
101 </em>
102
103 <table border="1">
104
105 <tr>
106 <th class="FieldHeader">
107 Field Name
108 </th>
109 <th class="FieldHeader">
110 Data Type
111 </th>
112 <th class="FieldHeader">
113 Size
114 </th>
115 <th class="FieldHeader">
116 Default Value
117 </th>
118 <th class="FieldHeader">
119 Other
120 </th>
121 <th class="FieldHeader">
122 Foreign Key
123 </th>
124 </tr>
125
126 <tr class="tr-odd">
127 <td class="FieldCellName"><a name="tableinfo-tableinfo_id">tableinfo_id</a></td>
128 <td class="FieldCellType">integer</td>
129 <td class="FieldCellSize">11</td>
130 <td class="FieldCellDefault"></td>
131 <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
132 <td class="FieldCellFK"></td>
133 </tr>
134
135 <tr class="tr-even">
136 <td class="FieldCellName"><a name="tableinfo-name">name</a></td>
137 <td class="FieldCellType">varchar</td>
138 <td class="FieldCellSize">30</td>
139 <td class="FieldCellDefault"></td>
140 <td class="FieldCellOther">UNIQUE, NOT NULL</td>
141 <td class="FieldCellFK"></td>
142 </tr>
143
144 <tr class="tr-odd">
145 <td class="FieldCellName"><a name="tableinfo-primary_key_column">primary_key_column</a></td>
146 <td class="FieldCellType">varchar</td>
147 <td class="FieldCellSize">30</td>
148 <td class="FieldCellDefault">NULL</td>
149 <td class="FieldCellOther"></td>
150 <td class="FieldCellFK"></td>
151 </tr>
152
153 <tr class="tr-even">
154 <td class="FieldCellName"><a name="tableinfo-is_view">is_view</a></td>
155 <td class="FieldCellType">integer</td>
156 <td class="FieldCellSize">10</td>
157 <td class="FieldCellDefault">0</td>
158 <td class="FieldCellOther">NOT NULL</td>
159 <td class="FieldCellFK"></td>
160 </tr>
161
162 <tr class="tr-odd">
163 <td class="FieldCellName"><a name="tableinfo-view_on_table_id">view_on_table_id</a></td>
164 <td class="FieldCellType">integer</td>
165 <td class="FieldCellSize">10</td>
166 <td class="FieldCellDefault">NULL</td>
167 <td class="FieldCellOther"></td>
168 <td class="FieldCellFK"></td>
169 </tr>
170
171 <tr class="tr-even">
172 <td class="FieldCellName"><a name="tableinfo-superclass_table_id">superclass_table_id</a></td>
173 <td class="FieldCellType">integer</td>
174 <td class="FieldCellSize">10</td>
175 <td class="FieldCellDefault">NULL</td>
176 <td class="FieldCellOther"></td>
177 <td class="FieldCellFK"></td>
178 </tr>
179
180 <tr class="tr-odd">
181 <td class="FieldCellName"><a name="tableinfo-is_updateable">is_updateable</a></td>
182 <td class="FieldCellType">integer</td>
183 <td class="FieldCellSize">10</td>
184 <td class="FieldCellDefault">1</td>
185 <td class="FieldCellOther">NOT NULL</td>
186 <td class="FieldCellFK"></td>
187 </tr>
188
189 <tr class="tr-even">
190 <td class="FieldCellName"><a name="tableinfo-modification_date">modification_date</a></td>
191 <td class="FieldCellType">date</td>
192 <td class="FieldCellSize">0</td>
193 <td class="FieldCellDefault">now()</td>
194 <td class="FieldCellOther">NOT NULL</td>
195 <td class="FieldCellFK"></td>
196 </tr>
197
198 </table>
199
200 <h3>
201 Constraints
202 </h3>
203
204 <table border="1">
205
206 <tr class="IndexRow">
207 <th>
208 Type
209 </th>
210 <th>
211 Fields
212 </th>
213 </tr>
214
215 <tr class="IndexCell">
216 <td>NOT NULL</td>
217 <td>tableinfo_id</td>
218 </tr>
219
220 <tr class="IndexCell">
221 <td>NOT NULL</td>
222 <td>name</td>
223 </tr>
224
225 <tr class="IndexCell">
226 <td>NOT NULL</td>
227 <td>is_view</td>
228 </tr>
229
230 <tr class="IndexCell">
231 <td>NOT NULL</td>
232 <td>is_updateable</td>
233 </tr>
234
235 <tr class="IndexCell">
236 <td>NOT NULL</td>
237 <td>modification_date</td>
238 </tr>
239
240 <tr class="IndexCell">
241 <td>UNIQUE</td>
242 <td>name</td>
243 </tr>
244
245 </table>
246
247 <hr />
248
249 <!--
250 Starting table 'db'
251 -->
252
253 <a name="db" />
254
255 <table class="TableHeader" width="100%">
256 <tr class="TableHeaderRow">
257 <td class="TableHeaderCell"><h3>
258 db
259 </h3></td>
260 <a name="db"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
261 </tr>
262 </table>
263
264 <b>
265 Comments:
266 </b>
267
268 <br />
269
270 <em>
271 <br />
272 ================================================ <br />
273 TABLE: db <br />
274 ================================================ <br />
275 A database authority. Typical databases in
276 bioinformatics are FlyBase, GO, UniProt, NCBI, MGI, etc. The authority
277 is generally known by this shortened form, which is unique within the
278 bioinformatics and biomedical realm. To Do - add support for URIs,
279 URNs (e.g. LSIDs). We can do this by treating the URL as a URI -
280 however, some applications may expect this to be resolvable - to be
281 decided.
282 </em>
283
284 <table border="1">
285
286 <tr>
287 <th class="FieldHeader">
288 Field Name
289 </th>
290 <th class="FieldHeader">
291 Data Type
292 </th>
293 <th class="FieldHeader">
294 Size
295 </th>
296 <th class="FieldHeader">
297 Default Value
298 </th>
299 <th class="FieldHeader">
300 Other
301 </th>
302 <th class="FieldHeader">
303 Foreign Key
304 </th>
305 </tr>
306
307 <tr class="tr-odd">
308 <td class="FieldCellName"><a name="db-db_id">db_id</a></td>
309 <td class="FieldCellType">integer</td>
310 <td class="FieldCellSize">11</td>
311 <td class="FieldCellDefault"></td>
312 <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
313 <td class="FieldCellFK"></td>
314 </tr>
315
316 <tr class="tr-even">
317 <td class="FieldCellName"><a name="db-name">name</a></td>
318 <td class="FieldCellType">varchar</td>
319 <td class="FieldCellSize">255</td>
320 <td class="FieldCellDefault"></td>
321 <td class="FieldCellOther">UNIQUE, NOT NULL</td>
322 <td class="FieldCellFK"></td>
323 </tr>
324
325 <tr class="tr-odd">
326 <td class="FieldCellName"><a name="db-description">description</a></td>
327 <td class="FieldCellType">varchar</td>
328 <td class="FieldCellSize">255</td>
329 <td class="FieldCellDefault">NULL</td>
330 <td class="FieldCellOther">contact_id bigint,</td>
331 <td class="FieldCellFK"></td>
332 </tr>
333
334 <tr class="tr-even">
335 <td class="FieldCellName"><a name="db-urlprefix">urlprefix</a></td>
336 <td class="FieldCellType">varchar</td>
337 <td class="FieldCellSize">255</td>
338 <td class="FieldCellDefault">NULL</td>
339 <td class="FieldCellOther"></td>
340 <td class="FieldCellFK"></td>
341 </tr>
342
343 <tr class="tr-odd">
344 <td class="FieldCellName"><a name="db-url">url</a></td>
345 <td class="FieldCellType">varchar</td>
346 <td class="FieldCellSize">255</td>
347 <td class="FieldCellDefault">NULL</td>
348 <td class="FieldCellOther"></td>
349 <td class="FieldCellFK"></td>
350 </tr>
351
352 </table>
353
354 <h3>
355 Constraints
356 </h3>
357
358 <table border="1">
359
360 <tr class="IndexRow">
361 <th>
362 Type
363 </th>
364 <th>
365 Fields
366 </th>
367 </tr>
368
369 <tr class="IndexCell">
370 <td>NOT NULL</td>
371 <td>db_id</td>
372 </tr>
373
374 <tr class="IndexCell">
375 <td>NOT NULL</td>
376 <td>name</td>
377 </tr>
378
379 <tr class="IndexCell">
380 <td>UNIQUE</td>
381 <td>name</td>
382 </tr>
383
384 </table>
385
386 <hr />
387
388 <!--
389 Starting table 'dbxref'
390 -->
391
392 <a name="dbxref" />
393
394 <table class="TableHeader" width="100%">
395 <tr class="TableHeaderRow">
396 <td class="TableHeaderCell"><h3>
397 dbxref
398 </h3></td>
399 <a name="dbxref"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
400 </tr>
401 </table>
402
403 <b>
404 Comments:
405 </b>
406
407 <br />
408
409 <em>
410 <br />
411 ================================================ <br />
412 TABLE: dbxref <br />
413 ================================================ <br />
414 A unique, global, public, stable identifier. Not necessarily an external reference - can reference data items inside the particular chado instance being used. Typically a row in a table can be uniquely identified with a primary identifier (called dbxref_id); a table may also have secondary identifiers (in a linking table <T>_dbxref). A dbxref is generally written as <DB>:<ACCESSION> or as <DB>:<ACCESSION>:<VERSION>.
415 </em>
416
417 <table border="1">
418
419 <tr>
420 <th class="FieldHeader">
421 Field Name
422 </th>
423 <th class="FieldHeader">
424 Data Type
425 </th>
426 <th class="FieldHeader">
427 Size
428 </th>
429 <th class="FieldHeader">
430 Default Value
431 </th>
432 <th class="FieldHeader">
433 Other
434 </th>
435 <th class="FieldHeader">
436 Foreign Key
437 </th>
438 </tr>
439
440 <tr class="tr-odd">
441 <td class="FieldCellName"><a name="dbxref-dbxref_id">dbxref_id</a></td>
442 <td class="FieldCellType">integer</td>
443 <td class="FieldCellSize">11</td>
444 <td class="FieldCellDefault"></td>
445 <td class="FieldCellOther">PRIMARY KEY, NOT NULL</td>
446 <td class="FieldCellFK"></td>
447 </tr>
448
449 <tr class="tr-even">
450 <td class="FieldCellName"><a name="dbxref-db_id">db_id</a></td>
451 <td class="FieldCellType">integer</td>
452 <td class="FieldCellSize">10</td>
453 <td class="FieldCellDefault"></td>
454 <td class="FieldCellOther">UNIQUE, NOT NULL</td>
455 <td class="FieldCellFK"><a href="#db-db_id">db.db_id</a></td>
456 </tr>
457
458 <tr class="tr-odd">
459 <td class="FieldCellName"><a name="dbxref-accession">accession</a></td>
460 <td class="FieldCellType">varchar</td>
461 <td class="FieldCellSize">255</td>
462 <td class="FieldCellDefault"></td>
463 <td class="FieldCellOther">UNIQUE, NOT NULL, The local part of the identifier. Guaranteed by the db authority to be unique for that db. </td>
464 <td class="FieldCellFK"></td>
465 </tr>
466
467 <tr class="tr-even">
468 <td class="FieldCellName"><a name="dbxref-version">version</a></td>
469 <td class="FieldCellType">varchar</td>
470 <td class="FieldCellSize">255</td>
471 <td class="FieldCellDefault"></td>
472 <td class="FieldCellOther">UNIQUE, NOT NULL</td>
473 <td class="FieldCellFK"></td>
474 </tr>
475
476 <tr class="tr-odd">
477 <td class="FieldCellName"><a name="dbxref-description">description</a></td>
478 <td class="FieldCellType">text</td>
479 <td class="FieldCellSize">64000</td>
480 <td class="FieldCellDefault"></td>
481 <td class="FieldCellOther"></td>
482 <td class="FieldCellFK"></td>
483 </tr>
484
485 </table>
486
487 <h3>
488 Indices
489 </h3>
490
491 <table border="1">
492
493 <tr class="IndexRow">
494 <th>
495 Name
496 </th>
497 <th>
498 Fields
499 </th>
500 </tr>
501
502 <tr class="IndexCell">
503 <td>dbxref_idx1</td>
504 <td>db_id</td>
505 </tr>
506
507 <tr class="IndexCell">
508 <td>dbxref_idx2</td>
509 <td>accession</td>
510 </tr>
511
512 <tr class="IndexCell">
513 <td>dbxref_idx3</td>
514 <td>version</td>
515 </tr>
516
517 </table>
518
519 <h3>
520 Constraints
521 </h3>
522
523 <table border="1">
524
525 <tr class="IndexRow">
526 <th>
527 Type
528 </th>
529 <th>
530 Fields
531 </th>
532 </tr>
533
534 <tr class="IndexCell">
535 <td>NOT NULL</td>
536 <td>dbxref_id</td>
537 </tr>
538
539 <tr class="IndexCell">
540 <td>NOT NULL</td>
541 <td>db_id</td>
542 </tr>
543
544 <tr class="IndexCell">
545 <td>FOREIGN KEY</td>
546 <td>db_id</td>
547 </tr>
548
549 <tr class="IndexCell">
550 <td>NOT NULL</td>
551 <td>accession</td>
552 </tr>
553
554 <tr class="IndexCell">
555 <td>NOT NULL</td>
556 <td>version</td>
557 </tr>
558
559 <tr class="IndexCell">
560 <td>UNIQUE</td>
561 <td>db_id, accession, version</td>
562 </tr>
563
564 </table>
565
566 <hr />
567
568 Created by <a href="http://sqlfairy.sourceforge.net">
569 SQL::Translator 0.11003</a>
570
571 </body>
572 </html>