<<

NAME

Koha::Schema::Result::SearchHistory - Opac search history results

TABLE: search_history

ACCESSORS

id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

search history id

userid

  data_type: 'integer'
  is_nullable: 0

the patron who performed the search (borrowers.borrowernumber)

sessionid

  data_type: 'varchar'
  is_nullable: 0
  size: 32

a system generated session id

query_desc

  data_type: 'varchar'
  is_nullable: 0
  size: 255

the search that was performed

query_cgi

  data_type: 'mediumtext'
  is_nullable: 0

the string to append to the search url to rerun the search

type

  data_type: 'varchar'
  default_value: 'biblio'
  is_nullable: 0
  size: 16

search type, must be 'biblio' or 'authority'

total

  data_type: 'integer'
  is_nullable: 0

the total of results found

time

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

the date and time the search was run

PRIMARY KEY

• "id"

<<