Purpose: Holds information on searches conducted within the online help systems.
Joins: users, staff_help and student_help tables.
| Field | Type | Purpose |
|---|---|---|
| id | int(11) | Primary Key – auto increment. |
| type | enum('student','staff') | Type of user conducting the search (i.e. staff or student). |
| userID | int(10) unsigned | ID of the user doing the search |
| searched | datetime | Datetime when the search was performed. |
| searchstring | text | Search string entered by the user |
| hits | int(11) | How many hits the search returned |