Database Overview

(User Table)
Line 1: Line 1:
-
For the prototype, we will focus on s small number tables.
+
AppTrac uses a MySQL relational database.  For the prototype, we will focus on s small number tables.
====User Tables====
====User Tables====
Line 7: Line 7:
<tr><td>Unique<br>autogenerated</td><td>String</td><td>encrypted</td>
<tr><td>Unique<br>autogenerated</td><td>String</td><td>encrypted</td>
<td>student<br>volunteer<br>etc</td><td>active<br>etc</td></tr>
<td>student<br>volunteer<br>etc</td><td>active<br>etc</td></tr>
 +
</table>
 +
 +
<table border=1>
 +
<caption>User Types</caption>
 +
<tr><th>Type</th><th>Description</th><th>Access Code</th></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>
 +
...
</table>
</table>

Revision as of 01:37, 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