2 package Koha::Schema::Result::Deleteditem;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Deleteditem
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<deleteditems>
22 __PACKAGE__->table("deleteditems");
32 primary key and unique identifier added by Koha
40 foreign key from biblio table used to link this item to the right bib record
42 =head2 biblioitemnumber
48 foreign key from the biblioitems table to link to item to additional information
56 item barcode (MARC21 952$p)
58 =head2 dateaccessioned
61 datetime_undef_if_invalid: 1
64 date the item was acquired or added to Koha (MARC21 952$d)
71 where the item was purchased (MARC21 952$e)
79 foreign key from the branches table for the library that owns this item (MARC21 952$a)
87 purchase price (MARC21 952$g)
89 =head2 replacementprice
95 cost the library charges to replace the item if it has been marked lost (MARC21 952$v)
97 =head2 replacementpricedate
100 datetime_undef_if_invalid: 1
103 the date the price is effective from (MARC21 952$w)
105 =head2 datelastborrowed
108 datetime_undef_if_invalid: 1
111 the date the item was last checked out
116 datetime_undef_if_invalid: 1
119 the date the item was last see (usually the last time the barcode was scanned or inventory was done)
132 authorized value defining why this item is not for loan (MARC21 952$7)
140 authorized value defining this item as damaged (MARC21 952$4)
144 data_type: 'datetime'
145 datetime_undef_if_invalid: 1
148 the date and time an item was last marked as damaged, NULL if not damaged
156 authorized value defining this item as lost (MARC21 952$1)
160 data_type: 'datetime'
161 datetime_undef_if_invalid: 1
164 the date and time an item was last marked as lost, NULL if not lost
172 authorized value defining this item as withdrawn (MARC21 952$0)
176 data_type: 'datetime'
177 datetime_undef_if_invalid: 1
180 the date and time an item was last marked as withdrawn, NULL if not withdrawn
182 =head2 itemcallnumber
188 call number for this item (MARC21 952$o)
190 =head2 coded_location_qualifier
196 coded location qualifier(MARC21 952$f)
200 data_type: 'smallint'
204 number of times this item has been checked out
208 data_type: 'smallint'
211 number of times this item has been renewed
215 data_type: 'smallint'
218 number of times this item has been placed on hold/reserved
225 authorized value defining use restrictions for this item (MARC21 952$5)
229 data_type: 'longtext'
232 public notes on this item (MARC21 952$z)
234 =head2 itemnotes_nonpublic
236 data_type: 'longtext'
239 non-public notes on this item (MARC21 952$x)
247 foreign key from the branches table for the library that is currently in possession item (MARC21 952$b)
251 data_type: 'timestamp'
252 datetime_undef_if_invalid: 1
253 default_value: current_timestamp
256 date and time this item was last altered
260 data_type: 'datetime'
261 datetime_undef_if_invalid: 1
264 date/time of deletion
272 authorized value for the shelving location for this item (MARC21 952$c)
274 =head2 permanent_location
280 linked to the CART and PROC temporary locations feature, stores the permanent shelving location
285 datetime_undef_if_invalid: 1
288 defines if item is checked out (NULL for not checked out, and due date for checked out)
296 classification source used on this item (MARC21 952$2)
304 normalized form of the call number (MARC21 952$o) used for sorting
312 authorized value for the collection code associated with this item (MARC21 952$8)
316 data_type: 'mediumtext'
319 materials specified (MARC21 952$3)
323 data_type: 'mediumtext'
326 URL for the item (MARC21 952$u)
334 foreign key from the itemtypes table defining the type for this item (MARC21 952$y)
336 =head2 more_subfields_xml
338 data_type: 'longtext'
341 additional 952 subfields in XML format
345 data_type: 'mediumtext'
348 serial enumeration/chronology for the item (MARC21 952$h)
356 copy number (MARC21 952$t)
364 inventory number (MARC21 952$i)
372 'new' value, you can put whatever free-text information. This field is intented to be managed by the automatic_item_modification_by_age cronjob.
374 =head2 exclude_from_local_holds_priority
379 Exclude this item from local holds priority
383 __PACKAGE__->add_columns(
385 { data_type => "integer", default_value => 0, is_nullable => 0 },
387 { data_type => "integer", default_value => 0, is_nullable => 0 },
389 { data_type => "integer", default_value => 0, is_nullable => 0 },
391 { data_type => "varchar", is_nullable => 1, size => 20 },
393 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
395 { data_type => "longtext", is_nullable => 1 },
397 { data_type => "varchar", is_nullable => 1, size => 10 },
399 { data_type => "decimal", is_nullable => 1, size => [8, 2] },
401 { data_type => "decimal", is_nullable => 1, size => [8, 2] },
402 "replacementpricedate",
403 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
405 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
407 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
409 { data_type => "tinyint", is_nullable => 1 },
411 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
413 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
416 data_type => "datetime",
417 datetime_undef_if_invalid => 1,
421 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
424 data_type => "datetime",
425 datetime_undef_if_invalid => 1,
429 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
432 data_type => "datetime",
433 datetime_undef_if_invalid => 1,
437 { data_type => "varchar", is_nullable => 1, size => 255 },
438 "coded_location_qualifier",
439 { data_type => "varchar", is_nullable => 1, size => 10 },
441 { data_type => "smallint", default_value => 0, is_nullable => 1 },
443 { data_type => "smallint", is_nullable => 1 },
445 { data_type => "smallint", is_nullable => 1 },
447 { data_type => "tinyint", is_nullable => 1 },
449 { data_type => "longtext", is_nullable => 1 },
450 "itemnotes_nonpublic",
451 { data_type => "longtext", is_nullable => 1 },
453 { data_type => "varchar", is_nullable => 1, size => 10 },
456 data_type => "timestamp",
457 datetime_undef_if_invalid => 1,
458 default_value => \"current_timestamp",
463 data_type => "datetime",
464 datetime_undef_if_invalid => 1,
468 { data_type => "varchar", is_nullable => 1, size => 80 },
469 "permanent_location",
470 { data_type => "varchar", is_nullable => 1, size => 80 },
472 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
474 { data_type => "varchar", is_nullable => 1, size => 10 },
476 { data_type => "varchar", is_nullable => 1, size => 255 },
478 { data_type => "varchar", is_nullable => 1, size => 80 },
480 { data_type => "mediumtext", is_nullable => 1 },
482 { data_type => "mediumtext", is_nullable => 1 },
484 { data_type => "varchar", is_nullable => 1, size => 10 },
485 "more_subfields_xml",
486 { data_type => "longtext", is_nullable => 1 },
488 { data_type => "mediumtext", is_nullable => 1 },
490 { data_type => "varchar", is_nullable => 1, size => 32 },
492 { data_type => "varchar", is_nullable => 1, size => 32 },
494 { data_type => "varchar", is_nullable => 1, size => 32 },
495 "exclude_from_local_holds_priority",
496 { data_type => "tinyint", is_nullable => 1 },
503 =item * L</itemnumber>
509 __PACKAGE__->set_primary_key("itemnumber");
512 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-08-01 17:33:12
513 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RMuehNvH+0WSXxEurJks/g
515 __PACKAGE__->add_columns(
516 '+exclude_from_local_holds_priority' => { is_boolean => 1 },
519 sub koha_objects_class {
522 sub koha_object_class {