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.id Implied Constraint R
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.type Implied Constraint R
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 Tue Jan 16 21:06 NZDT 2018

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

Close relationships: