Database Overview

(User Tables)
(User Tables)
Line 15: Line 15:
<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>
 +
 +
====Activity Tables====
 +
<table border=1>
 +
<caption>Activity Log</caption>
 +
<tr><th>Timestamp</th><th>UserId</th><th>Activity Code</th></tr>
 +
<tr><td>3/8/2008 09:00:23</td><td>rsmith</td><td>sys_in</td></tr>
 +
<tr><td>3/8/2008 09:00:33</td><td>rsmith</td><td>lexia_in</td></tr>
 +
<tr><td>3/8/2008 09:14:30</td><td>rsmith</td><td>lexia_out</td></tr>
 +
<tr><td>3/8/2008 09:15:30</td><td>rsmith</td><td>sys_out</td></tr>
 +
<tr><td>...</td><td>...</td><td>...</td></tr>
 +
</table>
 +
 +
<table border=1>
 +
<caption>Activity Codes</caption>
 +
<tr><th>Activity Code</th><th>Description</th></tr>
 +
<tr><td>sys_in</td><td>User logged into AppTrac</td></tr>
 +
<tr><td>sys_out</td><td>User logged out of AppTrac</td></tr>
 +
<tr><td>lexia_in</td><td>User started Lexia Application</td></tr>
 +
<tr><td>...</td><td>...</td></tr>
</table>
</table>

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