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