<<

NAME

Koha::Schema::Result::Deleteditem

TABLE: deleteditems

ACCESSORS

itemnumber

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

biblionumber

  data_type: 'integer'
  default_value: 0
  is_nullable: 0

biblioitemnumber

  data_type: 'integer'
  default_value: 0
  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_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

holdingbranch

  data_type: 'varchar'
  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: 30

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

PRIMARY KEY

• "itemnumber"

<<