Database Overview

(→User Tables)
(→User Tables)
Line 16: Line 16:
<caption>User Types</caption>
<caption>User Types</caption>
<tr><th>Type</th><th>Description</th><th>Access Code</th></tr>
<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>student</td><td>A student has access to<br>applications.</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>An admin has access to reports<br>and add/edit students.</td><td>code</td></tr>
<tr><td>...</td><td>...</td><td>...</td></tr>
<tr><td>...</td><td>...</td><td>...</td></tr>
</table>
</table>

Revision as of 18:31, 11 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
applications.		code
adminAn admin has access to reports
and add/edit students.		code
.........


User Details
UserIDPhotoAddress...

This and related tables should store some subset of the data shown in the following screen capture:

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
......
Retrieved from "http://www.cs.trincoll.edu/hfoss/wiki/Database_Overview"