help_searches
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 |