Database Overview

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
......