Database Overview
(→User Tables) |
|||
| (20 intermediate revisions not shown) | |||
| Line 2: | Line 2: | ||
====User Tables==== | ====User Tables==== | ||
| + | <table> | ||
| + | <tr> | ||
| + | <td> | ||
<table border=1> | <table border=1> | ||
<caption>User Table</caption> | <caption>User Table</caption> | ||
| Line 8: | Line 11: | ||
<td>student<br>volunteer<br>etc</td><td>active<br>etc</td></tr> | <td>student<br>volunteer<br>etc</td><td>active<br>etc</td></tr> | ||
</table> | </table> | ||
| - | + | </td> | |
| + | <td> | ||
<table border=1> | <table border=1> | ||
<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> | ||
| + | </td> | ||
| + | </tr> | ||
</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==== | ||
| + | |||
| + | <table> | ||
| + | <tr> | ||
| + | <td> | ||
<table border=1> | <table border=1> | ||
<caption>Activity Log</caption> | <caption>Activity Log</caption> | ||
| Line 27: | Line 56: | ||
<tr><td>...</td><td>...</td><td>...</td></tr> | <tr><td>...</td><td>...</td><td>...</td></tr> | ||
</table> | </table> | ||
| + | </td> | ||
| + | <td> | ||
<table border=1> | <table border=1> | ||
| Line 36: | Line 67: | ||
<tr><td>...</td><td>...</td></tr> | <tr><td>...</td><td>...</td></tr> | ||
</table> | </table> | ||
| + | </td> | ||
| + | </tr> | ||
| + | </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.