Database Overview
AppTrac uses a MySQL relational database. For the prototype, we will focus on s small number tables.
User Tables
UserID | Name | Password | Type | Status |
---|---|---|---|---|
Unique autogenerated | String | encrypted | student volunteer etc | active etc |
Type | Description | Access Code |
---|---|---|
student | A student has access to | code |
admin | A admin has access to | code |
... |