Koha::Schema::Result::Deleteditem
deleteditems
data_type: 'integer' default_value: 0 is_nullable: 0
primary key and unique identifier added by Koha
data_type: 'integer' default_value: 0 is_nullable: 0
foreign key from biblio table used to link this item to the right bib record
data_type: 'integer' default_value: 0 is_nullable: 0
foreign key from the biblioitems table to link to item to additional information
data_type: 'varchar' is_nullable: 1 size: 20
item barcode (MARC21 952$p)
data_type: 'tinyint' is_nullable: 1
nullable boolean value defining whether this this item is available for bookings or not
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
date the item was acquired or added to Koha (MARC21 952$d)
data_type: 'longtext' is_nullable: 1
where the item was purchased (MARC21 952$e)
data_type: 'varchar' is_nullable: 1 size: 10
foreign key from the branches table for the library that owns this item (MARC21 952$a)
data_type: 'decimal' is_nullable: 1 size: [8,2]
purchase price (MARC21 952$g)
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)
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
the date the price is effective from (MARC21 952$w)
data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 1
the date the item was last checked out
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)
data_type: 'tinyint' is_nullable: 1
data_type: 'tinyint' default_value: 0 is_nullable: 0
authorized value defining why this item is not for loan (MARC21 952$7)
data_type: 'tinyint' default_value: 0 is_nullable: 0
authorized value defining this item as damaged (MARC21 952$4)
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
data_type: 'tinyint' default_value: 0 is_nullable: 0
authorized value defining this item as lost (MARC21 952$1)
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
data_type: 'tinyint' default_value: 0 is_nullable: 0
authorized value defining this item as withdrawn (MARC21 952$0)
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
data_type: 'varchar' is_nullable: 1 size: 255
call number for this item (MARC21 952$o)
data_type: 'varchar' is_nullable: 1 size: 10
coded location qualifier(MARC21 952$f)
data_type: 'smallint' default_value: 0 is_nullable: 1
number of times this item has been checked out
data_type: 'smallint' is_nullable: 1
number of times this item has been renewed
data_type: 'smallint' is_nullable: 1
number of times this item has been recorded as localuse
data_type: 'smallint' is_nullable: 1
number of times this item has been placed on hold/reserved
data_type: 'tinyint' is_nullable: 1
authorized value defining use restrictions for this item (MARC21 952$5)
data_type: 'longtext' is_nullable: 1
public notes on this item (MARC21 952$z)
data_type: 'longtext' is_nullable: 1
non-public notes on this item (MARC21 952$x)
data_type: 'varchar' is_nullable: 1 size: 10
foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
data_type: 'timestamp' datetime_undef_if_invalid: 1 default_value: current_timestamp is_nullable: 0
date and time this item was last altered
data_type: 'datetime' datetime_undef_if_invalid: 1 is_nullable: 1
date/time of deletion
data_type: 'varchar' is_nullable: 1 size: 80
authorized value for the shelving location for this item (MARC21 952$c)
data_type: 'varchar' is_nullable: 1 size: 80
linked to the CART and PROC temporary locations feature, stores the permanent shelving location
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)
data_type: 'varchar' is_nullable: 1 size: 10
classification source used on this item (MARC21 952$2)
data_type: 'varchar' is_nullable: 1 size: 255
normalized form of the call number (MARC21 952$o) used for sorting
data_type: 'varchar' is_nullable: 1 size: 80
authorized value for the collection code associated with this item (MARC21 952$8)
data_type: 'mediumtext' is_nullable: 1
materials specified (MARC21 952$3)
data_type: 'mediumtext' is_nullable: 1
URL for the item (MARC21 952$u)
data_type: 'varchar' is_nullable: 1 size: 10
foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
data_type: 'longtext' is_nullable: 1
additional 952 subfields in XML format
data_type: 'mediumtext' is_nullable: 1
serial enumeration/chronology for the item (MARC21 952$h)
data_type: 'varchar' is_nullable: 1 size: 32
copy number (MARC21 952$t)
data_type: 'varchar' is_nullable: 1 size: 32
inventory number (MARC21 952$i)
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.
data_type: 'tinyint' is_nullable: 1
Exclude this item from local holds priority