missing NULL terminator in set_config_x
[geda-gaf.git] / docs / wiki / geda-gparts_cc.html
bloba95cf27cf7ade51810d74763dcbdb640e88921b1
1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
2 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3 <html>
4 <head>
5 <link rel="stylesheet" media="screen" type="text/css" href="./style.css" />
6 <link rel="stylesheet" media="screen" type="text/css" href="./design.css" />
7 <link rel="stylesheet" media="print" type="text/css" href="./print.css" />
9 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
10 </head>
11 <body>
13 <p>
14 <a href="start.html" class="wikilink1" title="start.html">gEDA</a> » <a href="geda-developer.html" class="wikilink1" title="geda-developer.html">Development</a> » <a href="geda-gparts_tc.html" class="wikilink1" title="geda-gparts_tc.html">Parts Manager</a> » <a href="geda-gparts_cc.html" class="wikilink1" title="geda-gparts_cc.html">Component Classification</a>
15 </p>
17 <h1 class="sectionedit1" id="component_classification">Component Classification</h1>
18 <div class="level1">
20 </div>
21 <!-- EDIT1 SECTION "Component Classification" [115-153] -->
22 <h2 class="sectionedit2" id="part_categories">Part Categories</h2>
23 <div class="level2">
25 <p>
26 Part categories break down classes of parts hierarchically. The category hierarchy exists separately than the part hierarchy. The category hierarchy only provides the user with a system to locate parts quickly. A child in the category hierarchy does not need to inherit the attributes of a parent.
27 </p>
29 <p>
30 The parts manager uses categories to keep the lists of parts manageable. If the list of parts in a particular category grows large, the category can be subdivided into sub-categories.
31 </p>
33 <p>
34 It may be difficult to change the categories, using a <abbr title="Graphical User Interface">GUI</abbr>, because of the part table abstraction through database views and stored procedures. It may be better to distribute the parts manager with a default configuration that works for most.
35 </p>
36 <div class="noteclassic">Help is needed with the taxonomy of parts. Please send feedback to the geda-dev or geda-user mailing lists.
37 </div>
38 <p>
39 The default hierarchy of parts follow:
40 </p>
41 <ul>
42 <li class="level1 node"><div class="li"> Discretes</div>
43 <ul>
44 <li class="level2 node"><div class="li"> Diodes</div>
45 <ul>
46 <li class="level3"><div class="li"> Small-signal</div>
47 </li>
48 <li class="level3"><div class="li"> TVS</div>
49 </li>
50 <li class="level3"><div class="li"> Zeners</div>
51 </li>
52 </ul>
53 </li>
54 </ul>
55 </li>
56 <li class="level1 node"><div class="li"> Passives</div>
57 <ul>
58 <li class="level2"><div class="li"> Capacitors</div>
59 </li>
60 <li class="level2"><div class="li"> Inductors</div>
61 </li>
62 <li class="level2"><div class="li"> Resistors</div>
63 </li>
64 </ul>
65 </li>
66 </ul>
68 </div>
69 <!-- EDIT2 SECTION "Part Categories" [154-1219] -->
70 <h2 class="sectionedit3" id="part_hierarchy">Part Hierarchy</h2>
71 <div class="level2">
73 <p>
74 The part hierarchy allows the database to attach additional attributes to a class of parts. These attributes provide a faster means to locate and select parts, especially commodity parts. The database only provides these additional attributes when configured to use hierarchical part tables.
75 </p>
77 <p>
78 These additional attributes, stored in numeric format, allow SQL to select parts. For example, to locate diodes with reverse voltage greater than 60 volts, use the following SQL statement.
79 </p>
80 <pre class="code sql"><span class="kw1">SELECT</span> <span class="sy0">*</span> <span class="kw1">FROM</span> DiodeV
81 <span class="kw1">WHERE</span> VR <span class="sy0">&gt;</span> <span class="nu0">60</span>;</pre>
83 <p>
84 The intent of the part hierarchy does not include exhaustively classifying all electronic parts or fully parameterizing any class of electronic part. The part hierarchy simply intends to allow the user to quickly locate a part, such as a 4.751% 0603.
85 </p>
87 <p>
88 <em class="u">TODO: Develop guidelines for subclassing part.</em>
89 </p>
91 <p>
92 Proposed guidelines for including attributes:
93 </p>
94 <ul>
95 <li class="level1"><div class="li"> Include attributes that are encoded in the manufacturer part number.</div>
96 </li>
97 <li class="level1"><div class="li"> Exclude attributes that are inconsistently characterized between manufacturers.</div>
98 </li>
99 <li class="level1"><div class="li"> Exclude attributes that must be either read from graphs, or calculated. </div>
100 </li>
101 </ul>
104 These attributes may not work for everyone, so the database allows the user to customize these part tables.
105 </p>
107 </div>
108 <!-- EDIT3 SECTION "Part Hierarchy" [1220-2493] -->
109 <h3 class="sectionedit4" id="bjts">BJTs</h3>
110 <div class="level3">
113 Bipolar Junction Transistors (BJTs) extend part with one additional table of attributes.
114 </p>
117 Table name: BJT
118 </p>
121 View name: BJTV
122 </p>
123 <div class="table sectionedit5"><table class="inline">
124 <thead>
125 <tr class="row0">
126 <th class="col0 leftalign"> Field </th><th class="col1 leftalign"> Type </th><th class="col2 leftalign"> Units </th><th class="col3 leftalign"> Description </th>
127 </tr>
128 </thead>
129 <tr class="row1">
130 <td class="col0 leftalign"> PartID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Foreign key to Part </td>
131 </tr>
132 <tr class="row2">
133 <td class="col0 leftalign"> PackageID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Foreign key to Package </td>
134 </tr>
135 <tr class="row3">
136 <td class="col0 leftalign"> Polarity </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Either NPN or PNP </td>
137 </tr>
138 <tr class="row4">
139 <td class="col0 leftalign"> MaxCollectorCurrent </td><td class="col1"> Physical </td><td class="col2 leftalign"> AMPS </td><td class="col3 leftalign"> Maximum collector current (Absolute maximum rating) </td>
140 </tr>
141 <tr class="row5">
142 <td class="col0 leftalign"> MaxCollectorEmitterVoltage </td><td class="col1"> Physical </td><td class="col2 leftalign"> VOLTS </td><td class="col3"> Maximum collector-emitter voltage (Absolute maximum rating) </td>
143 </tr>
144 <tr class="row6">
145 <td class="col0 leftalign"> TransitionFrequency </td><td class="col1"> Physical </td><td class="col2 leftalign"> HERTZ </td><td class="col3 leftalign"> </td>
146 </tr>
147 <tr class="row7">
148 <td class="col0 leftalign"> PowerDissipation </td><td class="col1"> Physical </td><td class="col2 leftalign"> WATTS </td><td class="col3 leftalign"> Power dissipation (Pd) not including any derating </td>
149 </tr>
150 </table></div>
151 <!-- EDIT5 TABLE [2634-3569] -->
153 The same table contains small-signal and power BJTs. These transistors can be
154 placed into separate views using the following criteria.
155 </p>
156 <div class="table sectionedit6"><table class="inline">
157 <thead>
158 <tr class="row0">
159 <th class="col0 leftalign"> Category </th><th class="col1 leftalign"> Criteria </th><th class="col2"> View Name </th>
160 </tr>
161 </thead>
162 <tr class="row1">
163 <td class="col0"> Small-signal BJT </td><td class="col1"> PowerDissipation &lt; 1.0 </td><td class="col2 leftalign"> TBD </td>
164 </tr>
165 <tr class="row2">
166 <td class="col0 leftalign"> Power BJT </td><td class="col1"> PowerDissipation &gt;= 1.0 </td><td class="col2 leftalign"> TBD </td>
167 </tr>
168 </table></div>
169 <!-- EDIT6 TABLE [3707-3883] -->
170 </div>
171 <!-- EDIT4 SECTION "BJTs" [2494-3884] -->
172 <h3 class="sectionedit7" id="capacitors">Capacitors</h3>
173 <div class="level3">
176 Capacitors extend part with one additional table of attributes.
177 </p>
178 <div class="table sectionedit8"><table class="inline">
179 <thead>
180 <tr class="row0">
181 <th class="col0 leftalign"> Field </th><th class="col1 leftalign"> Type </th><th class="col2 leftalign"> Units </th><th class="col3 leftalign"> Description </th>
182 </tr>
183 </thead>
184 <tr class="row1">
185 <td class="col0 leftalign"> PartID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Foreign key to Part </td>
186 </tr>
187 <tr class="row2">
188 <td class="col0 leftalign"> PackageID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3"> Foreign key to Package </td>
189 </tr>
190 <tr class="row3">
191 <td class="col0"> Capacitance </td><td class="col1"> Physical </td><td class="col2 leftalign"> FARADS </td><td class="col3 leftalign"> Capacitance </td>
192 </tr>
193 </table></div>
194 <!-- EDIT8 TABLE [3972-4219] -->
196 When instantiating a component or creating a heavy symbol, the following database columns map to the following attributes.
197 </p>
198 <div class="table sectionedit9"><table class="inline">
199 <thead>
200 <tr class="row0">
201 <th class="col0 leftalign"> Column </th><th class="col1"> Attribute </th><th class="col2 leftalign"> Notes </th>
202 </tr>
203 </thead>
204 <tr class="row1">
205 <td class="col0 leftalign"> Device.DeviceName </td><td class="col1 leftalign"> DEVICE </td><td class="col2 leftalign"> </td>
206 </tr>
207 <tr class="row2">
208 <td class="col0"> Capacitor.Capacitance </td><td class="col1 leftalign"> VALUE </td><td class="col2 leftalign"> </td>
209 </tr>
210 </table></div>
211 <!-- EDIT9 TABLE [4345-4533] -->
212 </div>
213 <!-- EDIT7 SECTION "Capacitors" [3885-4534] -->
214 <h3 class="sectionedit10" id="inductors">Inductors</h3>
215 <div class="level3">
218 Inductors extend part with one additional table of attributes.
219 </p>
220 <div class="table sectionedit11"><table class="inline">
221 <thead>
222 <tr class="row0">
223 <th class="col0 leftalign"> Field </th><th class="col1 leftalign"> Type </th><th class="col2 leftalign"> Units </th><th class="col3 leftalign"> Description </th>
224 </tr>
225 </thead>
226 <tr class="row1">
227 <td class="col0 leftalign"> PartID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Foreign key to Part </td>
228 </tr>
229 <tr class="row2">
230 <td class="col0 leftalign"> PackageID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3"> Foreign key to Package </td>
231 </tr>
232 <tr class="row3">
233 <td class="col0"> Inductance </td><td class="col1"> Physical </td><td class="col2 leftalign"> HENRYS </td><td class="col3 leftalign"> Inductance </td>
234 </tr>
235 </table></div>
236 <!-- EDIT11 TABLE [4620-4863] -->
238 When instantiating a component or creating a heavy symbol, the following database columns map to the following attributes.
239 </p>
240 <div class="table sectionedit12"><table class="inline">
241 <thead>
242 <tr class="row0">
243 <th class="col0 leftalign"> Column </th><th class="col1"> Attribute </th><th class="col2 leftalign"> Notes </th>
244 </tr>
245 </thead>
246 <tr class="row1">
247 <td class="col0 leftalign"> Device.DeviceName </td><td class="col1 leftalign"> DEVICE </td><td class="col2 leftalign"> </td>
248 </tr>
249 <tr class="row2">
250 <td class="col0"> Inductor.Inductance </td><td class="col1 leftalign"> VALUE </td><td class="col2 leftalign"> </td>
251 </tr>
252 </table></div>
253 <!-- EDIT12 TABLE [4989-5171] -->
254 </div>
255 <!-- EDIT10 SECTION "Inductors" [4535-5172] -->
256 <h3 class="sectionedit13" id="mosfets">MOSFETs</h3>
257 <div class="level3">
260 MOSFETs extend part with one additional table of attributes.
261 </p>
262 <div class="table sectionedit14"><table class="inline">
263 <thead>
264 <tr class="row0">
265 <th class="col0 leftalign"> Field </th><th class="col1 leftalign"> Type </th><th class="col2 leftalign"> Units </th><th class="col3 leftalign"> Description </th>
266 </tr>
267 </thead>
268 <tr class="row1">
269 <td class="col0 leftalign"> PartID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Foreign key to Part </td>
270 </tr>
271 <tr class="row2">
272 <td class="col0 leftalign"> PackageID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Foreign key to Package </td>
273 </tr>
274 <tr class="row3">
275 <td class="col0 leftalign"> Polarity </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Either N or P </td>
276 </tr>
277 <tr class="row4">
278 <td class="col0 leftalign"> MaxDrainSourceVoltage </td><td class="col1"> Physical </td><td class="col2 leftalign"> VOLTS </td><td class="col3 leftalign"> Maximum drain-source voltage (Absolute maximum rating) </td>
279 </tr>
280 <tr class="row5">
281 <td class="col0 leftalign"> MaxDrainCurrent </td><td class="col1"> Physical </td><td class="col2 leftalign"> AMPS </td><td class="col3"> Maximum continuous drain current (Absolute maximum rating) </td>
282 </tr>
283 <tr class="row6">
284 <td class="col0"> TypGateThresholdVoltage </td><td class="col1"> Physical </td><td class="col2 leftalign"> VOLTS </td><td class="col3 leftalign"> Typical gate threshold voltage </td>
285 </tr>
286 <tr class="row7">
287 <td class="col0 leftalign"> PowerDissipation </td><td class="col1"> Physical </td><td class="col2 leftalign"> WATTS </td><td class="col3 leftalign"> Power dissipation (Pd) not including any derating </td>
288 </tr>
289 </table></div>
290 <!-- EDIT14 TABLE [5254-6133] -->
291 </div>
292 <!-- EDIT13 SECTION "MOSFETs" [5173-6134] -->
293 <h3 class="sectionedit15" id="rectifier_small-signal_and_switching_diodes">Rectifier, Small-signal and Switching Diodes</h3>
294 <div class="level3">
297 Rectifier, small-signal and switching diodes extend part with one additional table of
298 attributes. Most diodes can be placed into this table.
299 </p>
302 Table name: Diode
303 </p>
306 View name: DiodeV
307 </p>
308 <div class="table sectionedit16"><table class="inline">
309 <thead>
310 <tr class="row0">
311 <th class="col0 leftalign"> Field </th><th class="col1 leftalign"> Type </th><th class="col2"> Units </th><th class="col3 leftalign"> Description </th>
312 </tr>
313 </thead>
314 <tr class="row1">
315 <td class="col0 leftalign"> PartID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Foreign key to Part </td>
316 </tr>
317 <tr class="row2">
318 <td class="col0 leftalign"> PackageID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Foreign key to Package </td>
319 </tr>
320 <tr class="row3">
321 <td class="col0"> MaxReverseVoltage </td><td class="col1"> Physical </td><td class="col2"> VOLTS </td><td class="col3"> Maximum reverse voltage (Absolute maximum rating) </td>
322 </tr>
323 <tr class="row4">
324 <td class="col0"> MaxForwardCurrent </td><td class="col1"> Physical </td><td class="col2 leftalign"> AMPS </td><td class="col3"> Maximum forward current (Absolute maximum rating) </td>
325 </tr>
326 <tr class="row5">
327 <td class="col0"> TypForwardVoltage </td><td class="col1"> Physical </td><td class="col2"> VOLTS </td><td class="col3 leftalign"> Typical forward voltage </td>
328 </tr>
329 <tr class="row6">
330 <td class="col0"> AveForwardCurrent </td><td class="col1"> Physical </td><td class="col2 leftalign"> AMPS </td><td class="col3 leftalign"> Average forward current </td>
331 </tr>
332 </table></div>
333 <!-- EDIT16 TABLE [6371-7021] -->
335 The same table contains rectifier, small-signal and switching diodes. These diodes can be
336 placed into separate views using the following criteria.
337 </p>
338 <div class="table sectionedit17"><table class="inline">
339 <thead>
340 <tr class="row0">
341 <th class="col0 leftalign"> Category </th><th class="col1 leftalign"> Criteria </th><th class="col2"> View Name </th>
342 </tr>
343 </thead>
344 <tr class="row1">
345 <td class="col0"> Small-signal and switching diodes </td><td class="col1"> AveForwardCurrent &lt; 0.5 </td><td class="col2 leftalign"> TBD </td>
346 </tr>
347 <tr class="row2">
348 <td class="col0 leftalign"> Rectifier diodes </td><td class="col1"> AveForwardCurrent &gt;= 0.5 </td><td class="col2 leftalign"> TBD </td>
349 </tr>
350 </table></div>
351 <!-- EDIT17 TABLE [7171-7401] -->
352 </div>
353 <!-- EDIT15 SECTION "Rectifier, Small-signal and Switching Diodes" [6135-7402] -->
354 <h3 class="sectionedit18" id="resistors">Resistors</h3>
355 <div class="level3">
358 Resistors extend part with one additional table of attributes.
359 </p>
360 <div class="table sectionedit19"><table class="inline">
361 <thead>
362 <tr class="row0">
363 <th class="col0 leftalign"> Field </th><th class="col1 leftalign"> Type </th><th class="col2 leftalign"> Units </th><th class="col3 leftalign"> Description </th>
364 </tr>
365 </thead>
366 <tr class="row1">
367 <td class="col0 leftalign"> PartID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Foreign key to Part </td>
368 </tr>
369 <tr class="row2">
370 <td class="col0 leftalign"> PackageID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3"> Foreign key to Package </td>
371 </tr>
372 <tr class="row3">
373 <td class="col0"> Resistance </td><td class="col1"> Physical </td><td class="col2 leftalign"> OHMS </td><td class="col3 leftalign"> Resistance </td>
374 </tr>
375 <tr class="row4">
376 <td class="col0 leftalign"> Tolerance </td><td class="col1"> Physical </td><td class="col2"> PERCENT </td><td class="col3 leftalign"> Tolerance </td>
377 </tr>
378 </table></div>
379 <!-- EDIT19 TABLE [7488-7792] -->
381 When instantiating a component or creating a heavy symbol, the following database columns map to the following attributes.
382 </p>
383 <div class="table sectionedit20"><table class="inline">
384 <thead>
385 <tr class="row0">
386 <th class="col0 leftalign"> Column </th><th class="col1"> Attribute </th><th class="col2 leftalign"> Notes </th>
387 </tr>
388 </thead>
389 <tr class="row1">
390 <td class="col0 leftalign"> Device.DeviceName </td><td class="col1 leftalign"> DEVICE </td><td class="col2 leftalign"> </td>
391 </tr>
392 <tr class="row2">
393 <td class="col0"> Resistor.Resistance </td><td class="col1 leftalign"> VALUE </td><td class="col2 leftalign"> </td>
394 </tr>
395 </table></div>
396 <!-- EDIT20 TABLE [7918-8100] -->
397 </div>
398 <!-- EDIT18 SECTION "Resistors" [7403-8101] -->
399 <h3 class="sectionedit21" id="tvs_diodes">TVS Diodes</h3>
400 <div class="level3">
403 TVS diodes extend part with one additional table of attributes.
404 </p>
405 <div class="table sectionedit22"><table class="inline">
406 <thead>
407 <tr class="row0">
408 <th class="col0 leftalign"> Field </th><th class="col1 leftalign"> Type </th><th class="col2"> Units </th><th class="col3 leftalign"> Description </th>
409 </tr>
410 </thead>
411 <tr class="row1">
412 <td class="col0 leftalign"> PartID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Foreign key to Part </td>
413 </tr>
414 <tr class="row2">
415 <td class="col0 leftalign"> PackageID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3"> Foreign key to Package </td>
416 </tr>
417 <tr class="row3">
418 <td class="col0 leftalign"> WorkingVoltage </td><td class="col1"> Physical </td><td class="col2"> VOLTS </td><td class="col3 leftalign"> Working voltage </td>
419 </tr>
420 <tr class="row4">
421 <td class="col0"> BreakdownVoltage </td><td class="col1"> Physical </td><td class="col2"> VOLTS </td><td class="col3 leftalign"> Breakdown voltage </td>
422 </tr>
423 </table></div>
424 <!-- EDIT22 TABLE [8189-8513] -->
425 </div>
426 <!-- EDIT21 SECTION "TVS Diodes" [8102-8514] -->
427 <h3 class="sectionedit23" id="zener_diodes">Zener Diodes</h3>
428 <div class="level3">
431 Zener diodes extend part with one additional table of attributes.
432 </p>
435 Table name: ZenerDiode
436 </p>
439 View name: ZenerDiodeV
440 </p>
441 <div class="table sectionedit24"><table class="inline">
442 <thead>
443 <tr class="row0">
444 <th class="col0 leftalign"> Field </th><th class="col1 leftalign"> Type </th><th class="col2"> Units </th><th class="col3 leftalign"> Description </th>
445 </tr>
446 </thead>
447 <tr class="row1">
448 <td class="col0 leftalign"> PartID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Foreign key to Part </td>
449 </tr>
450 <tr class="row2">
451 <td class="col0 leftalign"> PackageID </td><td class="col1 leftalign"> </td><td class="col2 leftalign"> </td><td class="col3 leftalign"> Foreign key to Package </td>
452 </tr>
453 <tr class="row3">
454 <td class="col0 leftalign"> TypZenerVoltage </td><td class="col1"> Physical </td><td class="col2"> VOLTS </td><td class="col3 leftalign"> Zener voltage </td>
455 </tr>
456 <tr class="row4">
457 <td class="col0"> PowerDissipation </td><td class="col1"> Physical </td><td class="col2"> WATTS </td><td class="col3"> Power dissipation (Pd) not including any derating </td>
458 </tr>
459 </table></div>
460 <!-- EDIT24 TABLE [8654-9113] -->
461 </div>
462 <!-- EDIT23 SECTION "Zener Diodes" [8515-] --></body>
463 </html>