NAME

Koha::Schema::Result::Item

TABLE: `items`

ACCESSORS

itemnumber

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key and unique identifier added by Koha

biblionumber

  data_type: 'integer'
  default_value: 0
  is_foreign_key: 1
  is_nullable: 0

foreign key from biblio table used to link this item to the right bib record

biblioitemnumber

  data_type: 'integer'
  default_value: 0
  is_foreign_key: 1
  is_nullable: 0

foreign key from the biblioitems table to link to item to additional information

barcode

  data_type: 'varchar'
  is_nullable: 1
  size: 20

item barcode (MARC21 952$p)

bookable

  data_type: 'tinyint'
  is_nullable: 1

nullable boolean value defining whether this this item is available for bookings or not

dateaccessioned

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date the item was acquired or added to Koha (MARC21 952$d)

booksellerid

  data_type: 'longtext'
  is_nullable: 1

where the item was purchased (MARC21 952$e)

homebranch

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 10

foreign key from the branches table for the library that owns this item (MARC21 952$a)

price

  data_type: 'decimal'
  is_nullable: 1
  size: [8,2]

purchase price (MARC21 952$g)

replacementprice

  data_type: 'decimal'
  is_nullable: 1
  size: [8,2]

cost the library charges to replace the item if it has been marked lost (MARC21 952$v)

replacementpricedate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the price is effective from (MARC21 952$w)

datelastborrowed

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the item was last checked out/issued

datelastseen

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date the item was last see (usually the last time the barcode was scanned or inventory was done)

stack

  data_type: 'tinyint'
  is_nullable: 1

notforloan

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

authorized value defining why this item is not for loan (MARC21 952$7)

damaged

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

authorized value defining this item as damaged (MARC21 952$4)

damaged_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date and time an item was last marked as damaged, NULL if not damaged

itemlost

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

authorized value defining this item as lost (MARC21 952$1)

itemlost_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date and time an item was last marked as lost, NULL if not lost

withdrawn

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

authorized value defining this item as withdrawn (MARC21 952$0)

withdrawn_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

the date and time an item was last marked as withdrawn, NULL if not withdrawn

itemcallnumber

  data_type: 'varchar'
  is_nullable: 1
  size: 255

call number for this item (MARC21 952$o)

coded_location_qualifier

  data_type: 'varchar'
  is_nullable: 1
  size: 10

coded location qualifier(MARC21 952$f)

issues

  data_type: 'smallint'
  default_value: 0
  is_nullable: 1

number of times this item has been checked out/issued

renewals

  data_type: 'smallint'
  is_nullable: 1

number of times this item has been renewed

localuse

  data_type: 'smallint'
  is_nullable: 1

number of times this item has been recorded as localuse

reserves

  data_type: 'smallint'
  is_nullable: 1

number of times this item has been placed on hold/reserved

restricted

  data_type: 'tinyint'
  is_nullable: 1

authorized value defining use restrictions for this item (MARC21 952$5)

itemnotes

  data_type: 'longtext'
  is_nullable: 1

public notes on this item (MARC21 952$z)

itemnotes_nonpublic

  data_type: 'longtext'
  is_nullable: 1

non-public notes on this item (MARC21 952$x)

holdingbranch

  data_type: 'varchar'
  is_foreign_key: 1
  is_nullable: 1
  size: 10

foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)

timestamp

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

date and time this item was last altered

deleted_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

date/time of deletion

location

  data_type: 'varchar'
  is_nullable: 1
  size: 80

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

permanent_location

  data_type: 'varchar'
  is_nullable: 1
  size: 80

linked to the CART and PROC temporary locations feature, stores the permanent shelving location

onloan

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

defines if item is checked out (NULL for not checked out, and due date for checked out)

cn_source

  data_type: 'varchar'
  is_nullable: 1
  size: 10

classification source used on this item (MARC21 952$2)

cn_sort

  data_type: 'varchar'
  is_nullable: 1
  size: 255

normalized form of the call number (MARC21 952$o) used for sorting

ccode

  data_type: 'varchar'
  is_nullable: 1
  size: 80

authorized value for the collection code associated with this item (MARC21 952$8)

materials

  data_type: 'mediumtext'
  is_nullable: 1

materials specified (MARC21 952$3)

uri

  data_type: 'mediumtext'
  is_nullable: 1

URL for the item (MARC21 952$u)

itype

  data_type: 'varchar'
  is_nullable: 1
  size: 10

foreign key from the itemtypes table defining the type for this item (MARC21 952$y)

more_subfields_xml

  data_type: 'longtext'
  is_nullable: 1

additional 952 subfields in XML format

enumchron

  data_type: 'mediumtext'
  is_nullable: 1

serial enumeration/chronology for the item (MARC21 952$h)

copynumber

  data_type: 'varchar'
  is_nullable: 1
  size: 32

copy number (MARC21 952$t)

stocknumber

  data_type: 'varchar'
  is_nullable: 1
  size: 32

inventory number (MARC21 952$i)

new_status

  data_type: 'varchar'
  is_nullable: 1
  size: 32

'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.

exclude_from_local_holds_priority

  data_type: 'tinyint'
  is_nullable: 1

Exclude this item from local holds priority

PRIMARY KEY

"itemnumber"

UNIQUE CONSTRAINTS

`itembarcodeidx`

"barcode"

linktrackers

Type: has_many

Related object: Koha::Schema::Result::Linktracker

old_issues

Type: has_many

Related object: Koha::Schema::Result::OldIssue

old_reserves

Type: has_many

Related object: Koha::Schema::Result::OldReserve

preservation_trains_items

Type: has_many

recalls

Type: has_many

Related object: Koha::Schema::Result::Recall

reserves

Type: has_many

Related object: Koha::Schema::Result::Reserve

return_claims

Type: has_many

Related object: Koha::Schema::Result::ReturnClaim

serialitem

Type: might_have

Related object: Koha::Schema::Result::Serialitem

stockrotationitem

Type: might_have

tmp_holdsqueue

Type: might_have

Related object: Koha::Schema::Result::TmpHoldsqueue