<<

NAME

Koha::Schema::Result::Statistic

TABLE: statistics

ACCESSORS

datetime

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date and time of the transaction

branch

  data_type: 'varchar'
  is_nullable: 1
  size: 10

foreign key, branch where the transaction occurred

value

  data_type: 'double precision'
  is_nullable: 1
  size: [16,4]

monetary value associated with the transaction

type

  data_type: 'varchar'
  is_nullable: 1
  size: 16

transaction type (localuse, issue, return, renew, writeoff, payment)

other

  data_type: 'longtext'
  is_nullable: 1

used by SIP

itemnumber

  data_type: 'integer'
  is_nullable: 1

foreign key from the items table, links transaction to a specific item

itemtype

  data_type: 'varchar'
  is_nullable: 1
  size: 10

foreign key from the itemtypes table, links transaction to a specific item type

location

  data_type: 'varchar'
  is_nullable: 1
  size: 80

authorized value for the shelving location for this item (MARC21 952$c)

borrowernumber

  data_type: 'integer'
  is_nullable: 1

foreign key from the borrowers table, links transaction to a specific borrower

ccode

  data_type: 'varchar'
  is_nullable: 1
  size: 80

foreign key from the items table, links transaction to a specific collection code

categorycode

  data_type: 'varchar'
  is_nullable: 1
  size: 10

foreign key from the borrowers table, links transaction to a specific borrower category

interface

  data_type: 'varchar'
  is_nullable: 1
  size: 30

the context this action was taken in

<<