id |
INT |
10 |
|
√ |
null |
|
|
search history id |
userid |
INT |
10 |
|
|
null |
|
|
the patron who performed the search (borrowers.borrowernumber) |
sessionid |
VARCHAR |
32 |
|
|
null |
|
|
a system generated session id |
query_desc |
VARCHAR |
255 |
|
|
null |
|
|
the search that was performed |
query_cgi |
MEDIUMTEXT |
16777215 |
|
|
null |
|
|
the string to append to the search url to rerun the search |
type |
VARCHAR |
16 |
|
|
biblio |
|
|
search type, must be 'biblio' or 'authority' |
total |
INT |
10 |
|
|
null |
|
|
the total of results found |
time |
TIMESTAMP |
19 |
|
|
current_timestamp() |
|
|
the date and time the search was run |