Database Overview

(User Tables)
(User Tables)
Line 14: Line 14:
<tr><td>student</td><td>A student has access to </td><td>code</td></tr>
<tr><td>student</td><td>A student has access to </td><td>code</td></tr>
<tr><td>admin</td><td>A admin has access to </td><td>code</td></tr>
<tr><td>admin</td><td>A admin has access to </td><td>code</td></tr>
-
<tr><td cols=3>...</td></tr>
+
<tr><td colspan=3>...</td></tr>
</table>
</table>

Revision as of 01:38, 10 March 2008

AppTrac uses a MySQL relational database. For the prototype, we will focus on s small number tables.

User Tables

User Table
UserIDNamePasswordTypeStatus
Unique
autogenerated
Stringencrypted student
volunteer
etc
active
etc
User Types
TypeDescriptionAccess Code
studentA student has access to code
adminA admin has access to code
...