Database Overview

(Activity Tables)
Line 25: Line 25:
====Activity Tables====
====Activity Tables====
 +
 +
<table>
 +
<tr>
 +
<td>
<table border=1>
<table border=1>
<caption>Activity Log</caption>
<caption>Activity Log</caption>
Line 34: Line 38:
<tr><td>...</td><td>...</td><td>...</td></tr>
<tr><td>...</td><td>...</td><td>...</td></tr>
</table>
</table>
 +
</td>
 +
<td>
<table border=1>
<table border=1>
Line 42: Line 48:
<tr><td>lexia_in</td><td>User started Lexia Application</td></tr>
<tr><td>lexia_in</td><td>User started Lexia Application</td></tr>
<tr><td>...</td><td>...</td></tr>
<tr><td>...</td><td>...</td></tr>
 +
</table>
 +
</td>
 +
</tr>
</table>
</table>

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