Database Overview

(→User Tables)
(→User Tables)
Line 30: Line 30:
</table>
</table>
This and related tables should store some subset of the data shown in the following screen capture:
This and related tables should store some subset of the data shown in the following screen capture:
-
[[Image:hfossLacesKeyInfo.jp]]
+
[[Image:hfossLacesKeyInfo.jpg]]
====Activity Tables====
====Activity Tables====

Revision as of 02:09, 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
.........


User Details
UserIDPhotoAddress...

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

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"