Assembla home | Assembla project page
 

WikiStart: database-design-0.1.html

File database-design-0.1.html, 65.7 kB (added by Vincent, 2 years ago)

Database tables (HTML)

Line 
1 <html>
2
3 <head>
4   <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
5   <meta name="description" content="DBDesigner4 HTML Report">
6   <title>DBDesigner4 HTML Report</title>
7   <style>
8 /* Links defaults */
9
10 a {color:#000000; text-decoration: underline;}
11 a:hover { text-decoration: none; color: #ff0000; text-decoration: underline}
12
13 /* Scrollers */
14 body, textarea {
15   scrollbar-base-color:#eeeeee;
16   scrollbar-3dlight-color:#62708A;
17   scrollbar-arrow-color:#62708A;
18   scrollbar-darkshadow-color:#000000;
19   scrollbar-face-color:#eeeeee;
20   scrollbar-highlight-color:#ffffff;
21   scrollbar-shadow-color:#aaaaaa;
22   scrollbar-track-color:#eeeeee;}
23
24 /* NoMargins */
25 body { margin-left: 15px; margin-right: 15px; margin-top: 15px; margin-bottom: 15px }
26
27 /* General Font */
28 div, p, td {font-family: Tahoma, Verdana, Arial, MS Sans Serif; color: black; font-size: 11px}
29
30 /* Fonts */
31 .fontNB {font-family: Tahoma, Verdana, Arial, Helvetica; font-size: 11px; font-weight: 700}
32 .fontL {font-family: Tahoma, Verdana, Arial, Helvetica; font-size: 12px}
33 .fontX {font-family: Tahoma, Verdana, Arial, Helvetica; font-size: 14px; font-weight: 700}
34 .fontXB {font-family: Tahoma, Verdana, Arial, Helvetica; font-size: 16px; font-weight: 700}
35 .fontS {font-family: Tahoma, Verdana, Arial, Helvetica; font-size: 10px; font-weight: 500}
36 .fontSB {font-family: Tahoma, Verdana, Arial, Helvetica; font-size: 10px; font-weight: 700}
37
38   </style>
39 </head>
40
41 <body>
42
43 <p class="fontX">Database Model plugin_tmp.xml<hr></p>
44
45 <table cellpadding="0" cellspacing="2" border="0" width="100%" bgcolor="#eef4ff">
46   <tr>
47     <td class="fontXB"><i>Other</i><hr></td>
48   </tr>
49   <tr>
50     <td>
51 <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#e4efff">
52   <tr>
53     <td class="fontX">account_settings
54      <font class="fontS"><br>Account related setting. Stores settings as an association between the setting name and user_id (not as a single user_id with a given number of settings). This allows for a variable number of settings, so the database structure won't have to change often.</font></td>
55   </tr>
56   <tr>
57     <td>
58       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d0dfff">
59         <tr>
60           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">ColumnName</td>
61           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">DataType</td>
62           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">PrimaryKey&nbsp;&nbsp;</td>
63           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">NotNull&nbsp;&nbsp;</td>
64           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">Flags</td>
65           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Default Value</td>
66           <td class="fontSB" style="border-bottom: 1px solid #606060" width="20%">Comment</td>
67           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">AutoInc</td>
68         </tr>
69         <tr>
70           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>user_id</b></td>
71           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
72           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
73           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
74           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
75           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
76           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
77           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
78         </tr>
79         <tr>
80           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>setting_name</b></td>
81           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>VARCHAR(20)</b></td>
82           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
83           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
84           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
85           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
86           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
87           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
88         </tr>
89         <tr>
90           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">value</td>
91           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(255)</td>
92           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
93           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
94           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
95           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
96           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
97           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
98         </tr>
99
100       </table>
101     </td>
102   </tr>
103   <tr>
104     <td class="fontB">
105       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d8e6ff">
106         <tr>
107           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexName</td>
108           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexType</td>
109           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Columns</td>
110         </tr>
111         <tr>
112           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
113           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
114           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">user_id<br>setting_name<br></td>
115         </tr>
116
117       </table>
118     </td>
119   </tr>
120
121 </table>
122 <br>
123 <br>
124 <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#e4efff">
125   <tr>
126     <td class="fontX">configuration
127      <font class="fontS"><br>This table can be used to store all kinds of settings and preferences, because we should only use a flat file for basic, one-time settings.</font></td>
128   </tr>
129   <tr>
130     <td>
131       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d0dfff">
132         <tr>
133           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">ColumnName</td>
134           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">DataType</td>
135           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">PrimaryKey&nbsp;&nbsp;</td>
136           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">NotNull&nbsp;&nbsp;</td>
137           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">Flags</td>
138           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Default Value</td>
139           <td class="fontSB" style="border-bottom: 1px solid #606060" width="20%">Comment</td>
140           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">AutoInc</td>
141         </tr>
142         <tr>
143           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>setting_id</b></td>
144           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
145           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
146           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
147           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
148           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
149           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
150           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">AI</td>
151         </tr>
152         <tr>
153           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">name</td>
154           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(20)</td>
155           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
156           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
157           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
158           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
159           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">The name of the setting</td>
160           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
161         </tr>
162         <tr>
163           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">value</td>
164           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(255)</td>
165           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
166           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
167           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
168           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
169           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">The value of the setting</td>
170           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
171         </tr>
172
173       </table>
174     </td>
175   </tr>
176   <tr>
177     <td class="fontB">
178       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d8e6ff">
179         <tr>
180           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexName</td>
181           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexType</td>
182           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Columns</td>
183         </tr>
184         <tr>
185           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
186           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
187           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">setting_id<br></td>
188         </tr>
189
190       </table>
191     </td>
192   </tr>
193
194 </table>
195 <br>
196 <br>
197
198     </td>
199   </tr>
200   <tr>
201     <td bgcolor="#ffffff"><br><br><br></td>
202   </tr>
203 </table>
204 <table cellpadding="0" cellspacing="2" border="0" width="100%" bgcolor="#eef4ff">
205   <tr>
206     <td class="fontXB"><i>Schedule choices</i><hr></td>
207   </tr>
208   <tr>
209     <td>
210 <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#e4efff">
211   <tr>
212     <td class="fontX">employee_meetings
213      <font class="fontS"><br>Links employees with the meetings that they can attend.</font></td>
214   </tr>
215   <tr>
216     <td>
217       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d0dfff">
218         <tr>
219           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">ColumnName</td>
220           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">DataType</td>
221           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">PrimaryKey&nbsp;&nbsp;</td>
222           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">NotNull&nbsp;&nbsp;</td>
223           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">Flags</td>
224           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Default Value</td>
225           <td class="fontSB" style="border-bottom: 1px solid #606060" width="20%">Comment</td>
226           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">AutoInc</td>
227         </tr>
228         <tr>
229           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>employee_id</b></td>
230           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
231           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
232           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
233           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
234           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
235           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
236           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
237         </tr>
238         <tr>
239           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>meeting_id</b></td>
240           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
241           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
242           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
243           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
244           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
245           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
246           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
247         </tr>
248
249       </table>
250     </td>
251   </tr>
252   <tr>
253     <td class="fontB">
254       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d8e6ff">
255         <tr>
256           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexName</td>
257           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexType</td>
258           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Columns</td>
259         </tr>
260         <tr>
261           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
262           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
263           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">employee_id<br>meeting_id<br></td>
264         </tr>
265
266       </table>
267     </td>
268   </tr>
269
270 </table>
271 <br>
272 <br>
273 <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#e4efff">
274   <tr>
275     <td class="fontX">student_meetings
276      <font class="fontS"><br>Keeps track of user choices regarding 'who' and 'when'.<br>After the close_date of an event (that is when the schedule is being created), the 'choices' will be replaced by the actual data (this will probably only involve setting the slot number, which can't be chosen by the user anyway).</font></td>
277   </tr>
278   <tr>
279     <td>
280       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d0dfff">
281         <tr>
282           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">ColumnName</td>
283           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">DataType</td>
284           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">PrimaryKey&nbsp;&nbsp;</td>
285           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">NotNull&nbsp;&nbsp;</td>
286           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">Flags</td>
287           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Default Value</td>
288           <td class="fontSB" style="border-bottom: 1px solid #606060" width="20%">Comment</td>
289           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">AutoInc</td>
290         </tr>
291         <tr>
292           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>meeting_id</b></td>
293           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
294           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
295           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
296           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
297           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
298           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
299           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
300         </tr>
301         <tr>
302           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>student_id</b></td>
303           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
304           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
305           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
306           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
307           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
308           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
309           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
310         </tr>
311         <tr>
312           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">employee_id</td>
313           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">INTEGER</td>
314           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
315           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
316           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
317           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
318           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Which employee to talk to</td>
319           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
320         </tr>
321         <tr>
322           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">slot</td>
323           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">INTEGER</td>
324           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
325           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
326           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
327           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
328           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Which slot number (can not be chosen by the user, will be set when creating a planning)</td>
329           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
330         </tr>
331
332       </table>
333     </td>
334   </tr>
335   <tr>
336     <td class="fontB">
337       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d8e6ff">
338         <tr>
339           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexName</td>
340           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexType</td>
341           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Columns</td>
342         </tr>
343         <tr>
344           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
345           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
346           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">meeting_id<br>student_id<br></td>
347         </tr>
348
349       </table>
350     </td>
351   </tr>
352
353 </table>
354 <br>
355 <br>
356
357     </td>
358   </tr>
359   <tr>
360     <td bgcolor="#ffffff"><br><br><br></td>
361   </tr>
362 </table>
363 <table cellpadding="0" cellspacing="2" border="0" width="100%" bgcolor="#eef4ff">
364   <tr>
365     <td class="fontXB"><i>Schedules</i><hr></td>
366   </tr>
367   <tr>
368     <td>
369 <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#e4efff">
370   <tr>
371     <td class="fontX">events
372      <font class="fontS"><br>Event information.</font></td>
373   </tr>
374   <tr>
375     <td>
376       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d0dfff">
377         <tr>
378           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">ColumnName</td>
379           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">DataType</td>
380           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">PrimaryKey&nbsp;&nbsp;</td>
381           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">NotNull&nbsp;&nbsp;</td>
382           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">Flags</td>
383           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Default Value</td>
384           <td class="fontSB" style="border-bottom: 1px solid #606060" width="20%">Comment</td>
385           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">AutoInc</td>
386         </tr>
387         <tr>
388           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>event_id</b></td>
389           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
390           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
391           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
392           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
393           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
394           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
395           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">AI</td>
396         </tr>
397         <tr>
398           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">friendly_name</td>
399           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(45)</td>
400           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td&