Database Overview
(→Activity Tables) |
|||
| (18 intermediate revisions not shown) | |||
| 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> | + | <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> | ||
| Line 24: | Line 24: | ||
</table> | </table> | ||
| + | |||
| + | <table border=1> | ||
| + | <caption>User Details</caption> | ||
| + | <tr><th>UserID</th><th>Photo</th><th>Address</th><th>...</th></tr> | ||
| + | </table> | ||
| + | This and related tables should store some subset of the data shown in the following screen capture: | ||
| + | [[Image:hfossLacesKeyInfo.jpg|thumb|left]] | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | <br> | ||
====Activity Tables==== | ====Activity Tables==== | ||
| Line 52: | Line 70: | ||
</tr> | </tr> | ||
</table> | </table> | ||
| + | |||
| + | |||
| + | |||
| + | [[Category:AppTrac]] | ||
Current revision as of 20:53, 5 October 2008
AppTrac uses a MySQL relational database. For the prototype, we will focus on s small number tables.
User Tables
|
|
| UserID | Photo | Address | ... |
|---|
This and related tables should store some subset of the data shown in the following screen capture:
Activity Tables
|
|
Tools
Acknowledgment and Disclaimer: This material is based upon work supported by the National Science Foundation under Grant No. CCF-0722137. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.
License: HFOSS is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.