Debian Codegraph @

modules/db/db.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 (2 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 'db'
35 -->
36
37 <tr class="LinkTableRow">
38 <td class="LinkTableCell"><a id="db-link" href="#db">db</a></td>
39 </tr>
40
41 <!--
42 End link to table 'db'
43 -->
44
45 <!--
46 Start link to table 'dbxref'
47 -->
48
49 <tr class="LinkTableRow">
50 <td class="LinkTableCell"><a id="dbxref-link" href="#dbxref">dbxref</a></td>
51 </tr>
52
53 <!--
54 End link to table 'dbxref'
55 -->
56
57 </table>
58
59 <!--
60 Starting table 'db'
61 -->
62
63 <a name="db" />
64
65 <table class="TableHeader" width="100%">
66 <tr class="TableHeaderRow">
67 <td class="TableHeaderCell"><h3>
68 db
69 </h3></td> <a name="db"> <td class="TableHeaderCell" align="right"><a href="#top">Top</a></td>
70 </tr>
71 </table>
72
73 <b>
74 Comments:
75 </b>
76
77 <br />
78
79 <em>
80 <br />
81 ================================================ <br />
82 TABLE: db <br />
83 ================================================ <br />
84 A database authority. Typical databases in
85 bioinformatics are FlyBase, GO, UniProt, NCBI, MGI, etc. The authority
86 is generally known by this shortened form, which is unique within the
87 bioinformatics and biomedical realm. To Do - add support for URIs,
88 URNs (e.g. LSIDs). We can do this by treating the URL as a URI -
89 however, some applications may expect this to be resolvable - to be
90 decided.
91 </em>
92
93 <table border="1">
94
95 <tr>
96 <th class="FieldHeader">
97 Field Name
98 </th>
99 <th class="FieldHeader">
100 Data Type
101 </th>
102 <th class="FieldHeader">
103 Size
104 </th>
105 <th class="FieldHeader">
106 Default Value
107 </th>
108 <th class="FieldHeader">
109 Other
110 </th>
111 <th class="FieldHeader">
112 Foreign Key
113 </th>
114 </tr>
115
116 <tr class="tr-odd">
117 <td class="FieldCellName"><a name="db-db_id">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>
118 </tr>
119
120 <tr class="tr-even">
121 <td class="FieldCellName"><a name="db-name">name</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL</td> <td class="FieldCellFK"></td>
122 </tr>
123
124 <tr class="tr-odd">
125 <td class="FieldCellName"><a name="db-description">description</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">255</td> <td class="FieldCellDefault">NULL</td> <td class="FieldCellOther">contact_id bigint,
126 foreign key (contact_id) references contact (contact_id) on delete cascade INITIALLY DEFERRED,</td> <td class="FieldCellFK"></td>
127 </tr>
128
129 <tr class="tr-even">
130 <td class="FieldCellName"><a name="db-urlprefix">urlprefix</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>
131 </tr>
132
133 <tr class="tr-odd">
134 <td class="FieldCellName"><a name="db-url">url</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>
135 </tr>
136
137 </table>
138
139 <h3>
140 Constraints
141 </h3>
142
143 <table border="1">
144
145 <tr class="IndexRow">
146 <th>
147 Type
148 </th>
149 <th>
150 Fields
151 </th>
152 </tr>
153
154 <tr class="IndexCell">
155 <td>NOT NULL</td><td>db_id</td>
156 </tr>
157
158 <tr class="IndexCell">
159 <td>NOT NULL</td><td>name</td>
160 </tr>
161
162 <tr class="IndexCell">
163 <td>UNIQUE</td><td>name</td>
164 </tr>
165
166 </table>
167
168 <hr />
169
170 <!--
171 Starting table 'dbxref'
172 -->
173
174 <a name="dbxref" />
175
176 <table class="TableHeader" width="100%">
177 <tr class="TableHeaderRow">
178 <td class="TableHeaderCell"><h3>
179 dbxref
180 </h3></td> <a name="dbxref"> <td align="right" class="TableHeaderCell"><a href="#top">Top</a></td>
181 </tr>
182 </table>
183
184 <b>
185 Comments:
186 </b>
187
188 <br />
189
190 <em>
191 <br />
192 ================================================ <br />
193 TABLE: dbxref <br />
194 ================================================ <br />
195 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>.
196 </em>
197
198 <table border="1">
199
200 <tr>
201 <th class="FieldHeader">
202 Field Name
203 </th>
204 <th class="FieldHeader">
205 Data Type
206 </th>
207 <th class="FieldHeader">
208 Size
209 </th>
210 <th class="FieldHeader">
211 Default Value
212 </th>
213 <th class="FieldHeader">
214 Other
215 </th>
216 <th class="FieldHeader">
217 Foreign Key
218 </th>
219 </tr>
220
221 <tr class="tr-odd">
222 <td class="FieldCellName"><a name="dbxref-dbxref_id">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>
223 </tr>
224
225 <tr class="tr-even">
226 <td class="FieldCellName"><a name="dbxref-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>
227 </tr>
228
229 <tr class="tr-odd">
230 <td class="FieldCellName"><a name="dbxref-accession">accession</a></td> <td class="FieldCellType">varchar</td> <td class="FieldCellSize">1024</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther">UNIQUE, NOT NULL, The local part of the identifier. Guaranteed by the db authority to be unique for that db. </td> <td class="FieldCellFK"></td>
231 </tr>
232
233 <tr class="tr-even">
234 <td class="FieldCellName"><a name="dbxref-version">version</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>
235 </tr>
236
237 <tr class="tr-odd">
238 <td class="FieldCellName"><a name="dbxref-description">description</a></td> <td class="FieldCellType">text</td> <td class="FieldCellSize">64000</td> <td class="FieldCellDefault"></td> <td class="FieldCellOther"></td> <td class="FieldCellFK"></td>
239 </tr>
240
241 </table>
242
243 <h3>
244 Indices
245 </h3>
246
247 <table border="1">
248
249 <tr class="IndexRow">
250 <th>
251 Name
252 </th>
253 <th>
254 Fields
255 </th>
256 </tr>
257
258 <tr class="IndexCell">
259 <td>dbxref_idx1</td><td>db_id</td>
260 </tr>
261
262 <tr class="IndexCell">
263 <td>dbxref_idx2</td><td>accession</td>
264 </tr>
265
266 <tr class="IndexCell">
267 <td>dbxref_idx3</td><td>version</td>
268 </tr>
269
270 </table>
271
272 <h3>
273 Constraints
274 </h3>
275
276 <table border="1">
277
278 <tr class="IndexRow">
279 <th>
280 Type
281 </th>
282 <th>
283 Fields
284 </th>
285 </tr>
286
287 <tr class="IndexCell">
288 <td>NOT NULL</td><td>dbxref_id</td>
289 </tr>
290
291 <tr class="IndexCell">
292 <td>NOT NULL</td><td>db_id</td>
293 </tr>
294
295 <tr class="IndexCell">
296 <td>FOREIGN KEY</td><td>db_id</td>
297 </tr>
298
299 <tr class="IndexCell">
300 <td>NOT NULL</td><td>accession</td>
301 </tr>
302
303 <tr class="IndexCell">
304 <td>NOT NULL</td><td>version</td>
305 </tr>
306
307 <tr class="IndexCell">
308 <td>UNIQUE</td><td>db_id, accession, version</td>
309 </tr>
310
311 </table>
312
313 <hr />
314
315 Created by <a href="http://sqlfairy.sourceforge.net">
316 SQL::Translator 0.11020</a>
317
318 </body>
319 </html>