help_searches

Purpose: Holds information on searches conducted within the online help systems.
Joins: usersstaff_help and student_help tables.

FieldTypePurpose
idint(11)Primary Key – auto increment.
typeenum('student','staff')Type of user conducting the search (i.e. staff or student).
userIDint(10) unsignedID of the user doing the search
searcheddatetimeDatetime when the search was performed.
searchstringtextSearch string entered by the user
hitsint(11)How many hits the search returned