<<

NAME

Koha::Schema::Result::Item

TABLE: items

ACCESSORS

itemnumber

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

biblionumber

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

biblioitemnumber

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

barcode

  data_type: 'varchar'
  is_nullable: 1
  size: 20

dateaccessioned

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

booksellerid

  data_type: 'mediumtext'
  is_nullable: 1

homebranch

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

price

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

replacementprice

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

replacementpricedate

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

datelastborrowed

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

datelastseen

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

stack

  data_type: 'tinyint'
  is_nullable: 1

notforloan

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

damaged

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

itemlost

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

itemlost_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

withdrawn

  data_type: 'tinyint'
  default_value: 0
  is_nullable: 0

withdrawn_on

  data_type: 'datetime'
  datetime_undef_if_invalid: 1
  is_nullable: 1

itemcallnumber

  data_type: 'varchar'
  is_nullable: 1
  size: 255

coded_location_qualifier

  data_type: 'varchar'
  is_nullable: 1
  size: 10

issues

  data_type: 'smallint'
  is_nullable: 1

renewals

  data_type: 'smallint'
  is_nullable: 1

reserves

  data_type: 'smallint'
  is_nullable: 1

restricted

  data_type: 'tinyint'
  is_nullable: 1

itemnotes

  data_type: 'mediumtext'
  is_nullable: 1

itemnotes_nonpublic

  data_type: 'mediumtext'
  is_nullable: 1

holdingbranch

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

paidfor

  data_type: 'mediumtext'
  is_nullable: 1

timestamp

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

location

  data_type: 'varchar'
  is_nullable: 1
  size: 80

permanent_location

  data_type: 'varchar'
  is_nullable: 1
  size: 80

onloan

  data_type: 'date'
  datetime_undef_if_invalid: 1
  is_nullable: 1

cn_source

  data_type: 'varchar'
  is_nullable: 1
  size: 10

cn_sort

  data_type: 'varchar'
  is_nullable: 1
  size: 255

ccode

  data_type: 'varchar'
  is_nullable: 1
  size: 10

materials

  data_type: 'text'
  is_nullable: 1

uri

  data_type: 'varchar'
  is_nullable: 1
  size: 255

itype

  data_type: 'varchar'
  is_nullable: 1
  size: 10

more_subfields_xml

  data_type: 'longtext'
  is_nullable: 1

enumchron

  data_type: 'text'
  is_nullable: 1

copynumber

  data_type: 'varchar'
  is_nullable: 1
  size: 32

stocknumber

  data_type: 'varchar'
  is_nullable: 1
  size: 32

new_status

  data_type: 'varchar'
  is_nullable: 1
  size: 32

PRIMARY KEY

• "itemnumber"

UNIQUE CONSTRAINTS

itembarcodeidx

• "barcode"

RELATIONS

accountlines

Type: has_many

Related object: Koha::Schema::Result::Accountline

article_requests

Type: has_many

Related object: Koha::Schema::Result::ArticleRequest

biblioitemnumber

Type: belongs_to

Related object: Koha::Schema::Result::Biblioitem

biblionumber

Type: belongs_to

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

branchtransfers

Type: has_many

Related object: Koha::Schema::Result::Branchtransfer

course_item

Type: might_have

Related object: Koha::Schema::Result::CourseItem

creator_batches

Type: has_many

Related object: Koha::Schema::Result::CreatorBatch

hold_fill_target

Type: might_have

Related object: Koha::Schema::Result::HoldFillTarget

holdingbranch

Type: belongs_to

Related object: Koha::Schema::Result::Branch

homebranch

Type: belongs_to

Related object: Koha::Schema::Result::Branch

issue

Type: might_have

Related object: Koha::Schema::Result::Issue

items_last_borrower

Type: might_have

Related object: Koha::Schema::Result::ItemsLastBorrower

old_issues

Type: has_many

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

old_reserves

Type: has_many

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

reserves

Type: has_many

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

serialitem

Type: might_have

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

<<