Assembla home | Assembla project page
 

WikiStart: database-design-0.1.html

File database-design-0.1.html, 65.7 kB (added by Vincent, 3 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>
401           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
402           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
403           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
404           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Name of the event used for display</td>
405           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
406         </tr>
407         <tr>
408           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">tag</td>
409           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(45)</td>
410           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
411           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
412           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
413           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
414           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Short, descriptive name. May be used for display</td>
415           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
416         </tr>
417         <tr>
418           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">event_status</td>
419           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">ENUM('planning','employees','clients','closed','done')</td>
420           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
421           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
422           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
423           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
424           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Describes which phase of the event has been completed</td>
425           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
426         </tr>
427         <tr>
428           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">notify_employees</td>
429           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">DATETIME</td>
430           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
431           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
432           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
433           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
434           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Time at which to tell the admin to active the 'employee procedure'</td>
435           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
436         </tr>
437         <tr>
438           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">notify_clients</td>
439           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">DATETIME</td>
440           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
441           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
442           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
443           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
444           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Time at which to tell the admin to active the 'client procedure'</td>
445           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
446         </tr>
447         <tr>
448           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">close_date</td>
449           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">DATETIME</td>
450           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
451           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
452           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
453           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
454           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Time at which to stop accepting choices and tell the admin to finish the planning process</td>
455           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
456         </tr>
457
458       </table>
459     </td>
460   </tr>
461   <tr>
462     <td class="fontB">
463       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d8e6ff">
464         <tr>
465           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexName</td>
466           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexType</td>
467           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Columns</td>
468         </tr>
469         <tr>
470           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
471           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
472           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">event_id<br></td>
473         </tr>
474
475       </table>
476     </td>
477   </tr>
478
479 </table>
480 <br>
481 <br>
482 <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#e4efff">
483   <tr>
484     <td class="fontX">event_group_junction
485      <font class="fontS"><br>Associates events with their relevant groups.</font></td>
486   </tr>
487   <tr>
488     <td>
489       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d0dfff">
490         <tr>
491           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">ColumnName</td>
492           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">DataType</td>
493           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">PrimaryKey&nbsp;&nbsp;</td>
494           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">NotNull&nbsp;&nbsp;</td>
495           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">Flags</td>
496           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Default Value</td>
497           <td class="fontSB" style="border-bottom: 1px solid #606060" width="20%">Comment</td>
498           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">AutoInc</td>
499         </tr>
500         <tr>
501           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>group_id</b></td>
502           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
503           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
504           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
505           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
506           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
507           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
508           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
509         </tr>
510         <tr>
511           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>event_id</b></td>
512           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
513           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
514           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
515           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
516           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
517           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
518           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
519         </tr>
520
521       </table>
522     </td>
523   </tr>
524   <tr>
525     <td class="fontB">
526       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d8e6ff">
527         <tr>
528           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexName</td>
529           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexType</td>
530           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Columns</td>
531         </tr>
532         <tr>
533           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
534           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
535           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">group_id<br>event_id<br></td>
536         </tr>
537
538       </table>
539     </td>
540   </tr>
541
542 </table>
543 <br>
544 <br>
545 <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#e4efff">
546   <tr>
547     <td class="fontX">meetings
548      <font class="fontS"><br>Events are made up of several meetings. This table stores information about meetings.</font></td>
549   </tr>
550   <tr>
551     <td>
552       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d0dfff">
553         <tr>
554           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">ColumnName</td>
555           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">DataType</td>
556           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">PrimaryKey&nbsp;&nbsp;</td>
557           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">NotNull&nbsp;&nbsp;</td>
558           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">Flags</td>
559           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Default Value</td>
560           <td class="fontSB" style="border-bottom: 1px solid #606060" width="20%">Comment</td>
561           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">AutoInc</td>
562         </tr>
563         <tr>
564           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>meeting_id</b></td>
565           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
566           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
567           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
568           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
569           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
570           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
571           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">AI</td>
572         </tr>
573         <tr>
574           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">event_id</td>
575           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">INTEGER</td>
576           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
577           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
578           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
579           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
580           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">The event to which this meeting belongs</td>
581           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
582         </tr>
583         <tr>
584           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">start_time</td>
585           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">DATETIME</td>
586           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
587           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
588           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
589           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
590           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">The time at which the meeting starts</td>
591           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
592         </tr>
593         <tr>
594           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">slot_duration</td>
595           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">TIME</td>
596           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
597           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
598           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
599           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
600           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">How long each slot (meeting session) will take</td>
601           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
602         </tr>
603         <tr>
604           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">slots</td>
605           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">INTEGER</td>
606           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
607           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
608           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
609           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
610           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">The number of slots (meeting sessions) for this meeting</td>
611           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
612         </tr>
613
614       </table>
615     </td>
616   </tr>
617   <tr>
618     <td class="fontB">
619       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d8e6ff">
620         <tr>
621           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexName</td>
622           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexType</td>
623           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Columns</td>
624         </tr>
625         <tr>
626           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
627           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
628           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">meeting_id<br></td>
629         </tr>
630
631       </table>
632     </td>
633   </tr>
634
635 </table>
636 <br>
637 <br>
638
639     </td>
640   </tr>
641   <tr>
642     <td bgcolor="#ffffff"><br><br><br></td>
643   </tr>
644 </table>
645 <table cellpadding="0" cellspacing="2" border="0" width="100%" bgcolor="#eef4ff">
646   <tr>
647     <td class="fontXB"><i>User management</i><hr></td>
648   </tr>
649   <tr>
650     <td>
651 <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#e4efff">
652   <tr>
653     <td class="fontX">accounts
654      <font class="fontS"><br>Lots of account information.</font></td>
655   </tr>
656   <tr>
657     <td>
658       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d0dfff">
659         <tr>
660           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">ColumnName</td>
661           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">DataType</td>
662           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">PrimaryKey&nbsp;&nbsp;</td>
663           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">NotNull&nbsp;&nbsp;</td>
664           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">Flags</td>
665           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Default Value</td>
666           <td class="fontSB" style="border-bottom: 1px solid #606060" width="20%">Comment</td>
667           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">AutoInc</td>
668         </tr>
669         <tr>
670           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>user_id</b></td>
671           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
672           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
673           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
674           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
675           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
676           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
677           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
678         </tr>
679         <tr>
680           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">username</td>
681           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(255)</td>
682           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
683           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
684           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
685           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
686           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Used when loggin in</td>
687           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
688         </tr>
689         <tr>
690           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">password</td>
691           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(40)</td>
692           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
693           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
694           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
695           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
696           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Hashed password</td>
697           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
698         </tr>
699         <tr>
700           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">salt</td>
701           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">INTEGER(4)</td>
702           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
703           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
704           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
705           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
706           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Salt used when creating the hash</td>
707           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
708         </tr>
709         <tr>
710           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">type</td>
711           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">ENUM('client','employee','admin')</td>
712           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
713           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
714           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
715           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
716           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">User type</td>
717           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
718         </tr>
719         <tr>
720           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">sex</td>
721           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">ENUM('m' , 'f')</td>
722           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
723           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
724           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
725           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
726           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Male or female</td>
727           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
728         </tr>
729         <tr>
730           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">first_name</td>
731           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(45)</td>
732           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
733           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
734           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
735           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
736           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
737           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
738         </tr>
739         <tr>
740           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">prefix</td>
741           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(10)</td>
742           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
743           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
744           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
745           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
746           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
747           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
748         </tr>
749         <tr>
750           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">last_name</td>
751           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(45)</td>
752           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
753           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
754           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
755           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
756           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
757           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
758         </tr>
759         <tr>
760           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">street</td>
761           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(50)</td>
762           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
763           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
764           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
765           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
766           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
767           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
768         </tr>
769         <tr>
770           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">nr</td>
771           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(10)</td>
772           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
773           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
774           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
775           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
776           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
777           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
778         </tr>
779         <tr>
780           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">city</td>
781           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(20)</td>
782           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
783           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
784           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
785           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
786           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
787           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
788         </tr>
789         <tr>
790           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">zipcode</td>
791           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(6)</td>
792           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
793           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
794           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
795           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
796           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
797           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
798         </tr>
799         <tr>
800           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">email</td>
801           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(255)</td>
802           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
803           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
804           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
805           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
806           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
807           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
808         </tr>
809
810       </table>
811     </td>
812   </tr>
813   <tr>
814     <td class="fontB">
815       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d8e6ff">
816         <tr>
817           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexName</td>
818           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexType</td>
819           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Columns</td>
820         </tr>
821         <tr>
822           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
823           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
824           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">user_id<br></td>
825         </tr>
826
827       </table>
828     </td>
829   </tr>
830
831 </table>
832 <br>
833 <br>
834 <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#e4efff">
835   <tr>
836     <td class="fontX">groups
837      <font class="fontS"><br>Information about groups.</font></td>
838   </tr>
839   <tr>
840     <td>
841       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d0dfff">
842         <tr>
843           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">ColumnName</td>
844           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">DataType</td>
845           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">PrimaryKey&nbsp;&nbsp;</td>
846           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">NotNull&nbsp;&nbsp;</td>
847           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">Flags</td>
848           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Default Value</td>
849           <td class="fontSB" style="border-bottom: 1px solid #606060" width="20%">Comment</td>
850           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">AutoInc</td>
851         </tr>
852         <tr>
853           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>group_id</b></td>
854           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
855           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
856           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
857           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
858           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
859           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
860           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">AI</td>
861         </tr>
862         <tr>
863           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">friendly_name</td>
864           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(45)</td>
865           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
866           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
867           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
868           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
869           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Name used for display</td>
870           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
871         </tr>
872         <tr>
873           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">tag</td>
874           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(45)</td>
875           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
876           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
877           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
878           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
879           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Short, descriptive name. May be used for display</td>
880           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
881         </tr>
882         <tr>
883           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">priority</td>
884           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">TINYINT</td>
885           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
886           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
887           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
888           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
889           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Determines which group 'wins' in case of a conflict in the planning</td>
890           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
891         </tr>
892
893       </table>
894     </td>
895   </tr>
896   <tr>
897     <td class="fontB">
898       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d8e6ff">
899         <tr>
900           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexName</td>
901           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexType</td>
902           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Columns</td>
903         </tr>
904         <tr>
905           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
906           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
907           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">group_id<br></td>
908         </tr>
909
910       </table>
911     </td>
912   </tr>
913
914 </table>
915 <br>
916 <br>
917 <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#e4efff">
918   <tr>
919     <td class="fontX">students
920      <font class="fontS"><br>Basic information about students. Note that students are not users and can therefore not login.<br>The only information we require at the moment is the studentnumber (the student_id column is there to provide a uniform way to link other tables).</font></td>
921   </tr>
922   <tr>
923     <td>
924       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d0dfff">
925         <tr>
926           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">ColumnName</td>
927           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">DataType</td>
928           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">PrimaryKey&nbsp;&nbsp;</td>
929           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">NotNull&nbsp;&nbsp;</td>
930           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">Flags</td>
931           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Default Value</td>
932           <td class="fontSB" style="border-bottom: 1px solid #606060" width="20%">Comment</td>
933           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">AutoInc</td>
934         </tr>
935         <tr>
936           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>student_id</b></td>
937           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
938           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
939           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
940           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
941           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
942           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
943           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">AI</td>
944         </tr>
945         <tr>
946           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">student_tag</td>
947           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(20)</td>
948           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
949           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
950           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
951           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
952           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">Usually a studentnumber</td>
953           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
954         </tr>
955         <tr>
956           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">name</td>
957           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">VARCHAR(255)</td>
958           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
959           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
960           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
961           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
962           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">The name of the student (optional?)</td>
963           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
964         </tr>
965
966       </table>
967     </td>
968   </tr>
969   <tr>
970     <td class="fontB">
971       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d8e6ff">
972         <tr>
973           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexName</td>
974           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexType</td>
975           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Columns</td>
976         </tr>
977         <tr>
978           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
979           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
980           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">student_id<br></td>
981         </tr>
982
983       </table>
984     </td>
985   </tr>
986
987 </table>
988 <br>
989 <br>
990 <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#e4efff">
991   <tr>
992     <td class="fontX">employee_group_junction
993      <font class="fontS"><br>This table associates certain users (with type 'employee') with the groups they belong to.</font></td>
994   </tr>
995   <tr>
996     <td>
997       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d0dfff">
998         <tr>
999           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">ColumnName</td>
1000           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">DataType</td>
1001           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">PrimaryKey&nbsp;&nbsp;</td>
1002           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">NotNull&nbsp;&nbsp;</td>
1003           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">Flags</td>
1004           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Default Value</td>
1005           <td class="fontSB" style="border-bottom: 1px solid #606060" width="20%">Comment</td>
1006           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">AutoInc</td>
1007         </tr>
1008         <tr>
1009           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>employee_id</b></td>
1010           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
1011           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
1012           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
1013           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
1014           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1015           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1016           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1017         </tr>
1018         <tr>
1019           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>group_id</b></td>
1020           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
1021           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
1022           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
1023           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
1024           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1025           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1026           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1027         </tr>
1028
1029       </table>
1030     </td>
1031   </tr>
1032   <tr>
1033     <td class="fontB">
1034       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d8e6ff">
1035         <tr>
1036           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexName</td>
1037           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexType</td>
1038           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Columns</td>
1039         </tr>
1040         <tr>
1041           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
1042           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
1043           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">employee_id<br>group_id<br></td>
1044         </tr>
1045
1046       </table>
1047     </td>
1048   </tr>
1049
1050 </table>
1051 <br>
1052 <br>
1053 <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#e4efff">
1054   <tr>
1055     <td class="fontX">student_group_junction
1056      <font class="fontS"><br>Associates students with a certain group.</font></td>
1057   </tr>
1058   <tr>
1059     <td>
1060       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d0dfff">
1061         <tr>
1062           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">ColumnName</td>
1063           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">DataType</td>
1064           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">PrimaryKey&nbsp;&nbsp;</td>
1065           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">NotNull&nbsp;&nbsp;</td>
1066           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">Flags</td>
1067           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Default Value</td>
1068           <td class="fontSB" style="border-bottom: 1px solid #606060" width="20%">Comment</td>
1069           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">AutoInc</td>
1070         </tr>
1071         <tr>
1072           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>group_id</b></td>
1073           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
1074           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
1075           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
1076           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
1077           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1078           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1079           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1080         </tr>
1081         <tr>
1082           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>student_id</b></td>
1083           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
1084           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
1085           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
1086           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
1087           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1088           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1089           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1090         </tr>
1091
1092       </table>
1093     </td>
1094   </tr>
1095   <tr>
1096     <td class="fontB">
1097       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d8e6ff">
1098         <tr>
1099           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexName</td>
1100           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexType</td>
1101           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Columns</td>
1102         </tr>
1103         <tr>
1104           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
1105           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
1106           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">group_id<br>student_id<br></td>
1107         </tr>
1108
1109       </table>
1110     </td>
1111   </tr>
1112
1113 </table>
1114 <br>
1115 <br>
1116 <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#e4efff">
1117   <tr>
1118     <td class="fontX">client_student_junction
1119      <font class="fontS"><br>This table associates certain users (with type ' client' ) with students.</font></td>
1120   </tr>
1121   <tr>
1122     <td>
1123       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d0dfff">
1124         <tr>
1125           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">ColumnName</td>
1126           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">DataType</td>
1127           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">PrimaryKey&nbsp;&nbsp;</td>
1128           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">NotNull&nbsp;&nbsp;</td>
1129           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">Flags</td>
1130           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Default Value</td>
1131           <td class="fontSB" style="border-bottom: 1px solid #606060" width="20%">Comment</td>
1132           <td class="fontSB" style="border-bottom: 1px solid #606060" width="1%">AutoInc</td>
1133         </tr>
1134         <tr>
1135           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>client_id</b></td>
1136           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
1137           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
1138           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
1139           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
1140           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1141           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1142           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1143         </tr>
1144         <tr>
1145           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>student_id</b></td>
1146           <td class="fontS" style="border-bottom: 1px solid #C0C0C0"><b>INTEGER</b></td>
1147           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">PK</td>
1148           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">NN</td>
1149           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">UNSIGNED </td>
1150           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1151           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1152           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">&nbsp;</td>
1153         </tr>
1154
1155       </table>
1156     </td>
1157   </tr>
1158   <tr>
1159     <td class="fontB">
1160       <table cellpadding="2" cellspacing="0" border="0" width="100%" bgcolor="#d8e6ff">
1161         <tr>
1162           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexName</td>
1163           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">IndexType</td>
1164           <td class="fontSB" style="border-bottom: 1px solid #606060" width="15%">Columns</td>
1165         </tr>
1166         <tr>
1167           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
1168           <td class="fontS" style="border-bottom: 1px solid #C0C0C0" valign="top">PRIMARY</td>
1169           <td class="fontS" style="border-bottom: 1px solid #C0C0C0">client_id<br>student_id<br></td>
1170         </tr>
1171
1172       </table>
1173     </td>
1174   </tr>
1175
1176 </table>
1177 <br>
1178 <br>
1179
1180     </td>
1181   </tr>
1182   <tr>
1183     <td bgcolor="#ffffff"><br><br><br></td>
1184   </tr>
1185 </table>
1186 </body>
1187
1188 </html>