search_history


Description

Opac search history results

Columns

Column Type Size Nulls Auto Default Children Parents Comments
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
account_offset_types.type Implied Constraint R

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

Table contained 0 rows

Indexes

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

Relationships