Table testsql_comments.search_history
Opac search history results

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int 10  √ 
z3950servers
search history id
userid int 10 the patron who performed the search (borrowers.borrowernumber)
sessionid varchar 32 a system generated session id
query_desc varchar 255 the search that was performed
query_cgi text 65535 the string to append to the search url to rerun the search
type varchar 16 biblio
account_offset_types
search type, must be 'biblio' or 'authority'
total int 10 the total of results found
time timestamp 19 CURRENT_TIMESTAMP the date and time the search was run

Table contained 0 rows at Mon Jul 16 09:22 NZST 2018

Indexes:
Column(s) Type Sort
id Primary key Asc
sessionid Performance Asc
userid Performance Asc

Close relationships: