Database Overview

(User Tables)
Line 2: Line 2:
====User Tables====
====User Tables====
 +
<table>
 +
<tr>
 +
<td>
<table border=1>
<table border=1>
<caption>User Table</caption>
<caption>User Table</caption>
Line 8: Line 11:
<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>
-
 
+
</td>
 +
<td>
<table border=1>
<table border=1>
<caption>User Types</caption>
<caption>User Types</caption>
Line 15: Line 19:
<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>...</td><td>...</td><td>...</td></tr>
<tr><td>...</td><td>...</td><td>...</td></tr>
 +
</table>
 +
</td>
 +
</tr>
</table>
</table>

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

Activity Tables

Activity Log
TimestampUserIdActivity Code
3/8/2008 09:00:23rsmithsys_in
3/8/2008 09:00:33rsmithlexia_in
3/8/2008 09:14:30rsmithlexia_out
3/8/2008 09:15:30rsmithsys_out
.........
Activity Codes
Activity CodeDescription
sys_inUser logged into AppTrac
sys_outUser logged out of AppTrac
lexia_inUser started Lexia Application
......