<<

NAME

Koha::Schema::Result::Biblioitem

TABLE: biblioitems

ACCESSORS

biblioitemnumber

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

primary key, unique identifier assigned by Koha

biblionumber

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

foreign key linking this table to the biblio table

volume

  data_type: 'longtext'
  is_nullable: 1

number

  data_type: 'longtext'
  is_nullable: 1

itemtype

  data_type: 'varchar'
  is_nullable: 1
  size: 10

biblio level item type (MARC21 942$c)

isbn

  data_type: 'longtext'
  is_nullable: 1

ISBN (MARC21 020$a)

issn

  data_type: 'longtext'
  is_nullable: 1

ISSN (MARC21 022$a)

ean

  data_type: 'longtext'
  is_nullable: 1

publicationyear

  data_type: 'mediumtext'
  is_nullable: 1

publishercode

  data_type: 'text'
  is_nullable: 1

publisher (MARC21 260$b and 264$b)

volumedate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

volumedesc

  data_type: 'mediumtext'
  is_nullable: 1

volume information (MARC21 362$a)

collectiontitle

  data_type: 'longtext'
  is_nullable: 1

collectionissn

  data_type: 'mediumtext'
  is_nullable: 1

collectionvolume

  data_type: 'longtext'
  is_nullable: 1

editionstatement

  data_type: 'mediumtext'
  is_nullable: 1

editionresponsibility

  data_type: 'mediumtext'
  is_nullable: 1

timestamp

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

illus

  data_type: 'text'
  is_nullable: 1

illustrations (MARC21 300$b)

pages

  data_type: 'text'
  is_nullable: 1

number of pages (MARC21 300$a)

notes

  data_type: 'longtext'
  is_nullable: 1

size

  data_type: 'text'
  is_nullable: 1

material size (MARC21 300$c)

place

  data_type: 'text'
  is_nullable: 1

publication place (MARC21 260$a and 264$a)

lccn

  data_type: 'longtext'
  is_nullable: 1

library of congress control number (MARC21 010$a)

url

  data_type: 'mediumtext'
  is_nullable: 1

url (MARC21 856$u)

cn_source

  data_type: 'varchar'
  is_nullable: 1
  size: 10

classification source (MARC21 942$2)

cn_class

  data_type: 'varchar'
  is_nullable: 1
  size: 30

cn_item

  data_type: 'varchar'
  is_nullable: 1
  size: 10

cn_suffix

  data_type: 'varchar'
  is_nullable: 1
  size: 10

cn_sort

  data_type: 'varchar'
  is_nullable: 1
  size: 255

normalized version of the call number used for sorting

agerestriction

  data_type: 'varchar'
  is_nullable: 1
  size: 255

target audience/age restriction from the bib record (MARC21 521$a)

totalissues

  data_type: 'integer'
  is_nullable: 1

PRIMARY KEY

RELATIONS

biblionumber

Type: belongs_to

Related object: Koha::Schema::Result::Biblio

items

Type: has_many

Related object: Koha::Schema::Result::Item

<<