2 package Koha::Schema::Result::Item;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Item
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<items>
22 __PACKAGE__->table("items");
38 =head2 biblioitemnumber
51 =head2 dateaccessioned
54 datetime_undef_if_invalid: 1
59 data_type: 'mediumtext'
75 =head2 replacementprice
81 =head2 replacementpricedate
84 datetime_undef_if_invalid: 1
87 =head2 datelastborrowed
90 datetime_undef_if_invalid: 1
96 datetime_undef_if_invalid: 1
128 =head2 itemcallnumber
134 =head2 coded_location_qualifier
142 data_type: 'smallint'
147 data_type: 'smallint'
152 data_type: 'smallint'
162 data_type: 'mediumtext'
174 data_type: 'mediumtext'
179 data_type: 'timestamp'
180 datetime_undef_if_invalid: 1
181 default_value: current_timestamp
190 =head2 permanent_location
199 datetime_undef_if_invalid: 1
237 =head2 more_subfields_xml
239 data_type: 'longtext'
261 __PACKAGE__->add_columns(
263 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
265 { data_type => "integer", default_value => 0, is_nullable => 0 },
268 data_type => "integer",
274 { data_type => "varchar", is_nullable => 1, size => 20 },
276 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
278 { data_type => "mediumtext", is_nullable => 1 },
280 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
282 { data_type => "decimal", is_nullable => 1, size => [8, 2] },
284 { data_type => "decimal", is_nullable => 1, size => [8, 2] },
285 "replacementpricedate",
286 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
288 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
290 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
292 { data_type => "tinyint", is_nullable => 1 },
294 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
296 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
298 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
300 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
302 { data_type => "varchar", is_nullable => 1, size => 255 },
303 "coded_location_qualifier",
304 { data_type => "varchar", is_nullable => 1, size => 10 },
306 { data_type => "smallint", is_nullable => 1 },
308 { data_type => "smallint", is_nullable => 1 },
310 { data_type => "smallint", is_nullable => 1 },
312 { data_type => "tinyint", is_nullable => 1 },
314 { data_type => "mediumtext", is_nullable => 1 },
316 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
318 { data_type => "mediumtext", is_nullable => 1 },
321 data_type => "timestamp",
322 datetime_undef_if_invalid => 1,
323 default_value => \"current_timestamp",
327 { data_type => "varchar", is_nullable => 1, size => 80 },
328 "permanent_location",
329 { data_type => "varchar", is_nullable => 1, size => 80 },
331 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
333 { data_type => "varchar", is_nullable => 1, size => 10 },
335 { data_type => "varchar", is_nullable => 1, size => 30 },
337 { data_type => "varchar", is_nullable => 1, size => 10 },
339 { data_type => "text", is_nullable => 1 },
341 { data_type => "varchar", is_nullable => 1, size => 255 },
343 { data_type => "varchar", is_nullable => 1, size => 10 },
344 "more_subfields_xml",
345 { data_type => "longtext", is_nullable => 1 },
347 { data_type => "text", is_nullable => 1 },
349 { data_type => "varchar", is_nullable => 1, size => 32 },
351 { data_type => "varchar", is_nullable => 1, size => 32 },
358 =item * L</itemnumber>
364 __PACKAGE__->set_primary_key("itemnumber");
366 =head1 UNIQUE CONSTRAINTS
368 =head2 C<itembarcodeidx>
378 __PACKAGE__->add_unique_constraint("itembarcodeidx", ["barcode"]);
386 Related object: L<Koha::Schema::Result::Accountline>
390 __PACKAGE__->has_many(
392 "Koha::Schema::Result::Accountline",
393 { "foreign.itemnumber" => "self.itemnumber" },
394 { cascade_copy => 0, cascade_delete => 0 },
397 =head2 biblioitemnumber
401 Related object: L<Koha::Schema::Result::Biblioitem>
405 __PACKAGE__->belongs_to(
407 "Koha::Schema::Result::Biblioitem",
408 { biblioitemnumber => "biblioitemnumber" },
409 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
412 =head2 branchtransfers
416 Related object: L<Koha::Schema::Result::Branchtransfer>
420 __PACKAGE__->has_many(
422 "Koha::Schema::Result::Branchtransfer",
423 { "foreign.itemnumber" => "self.itemnumber" },
424 { cascade_copy => 0, cascade_delete => 0 },
431 Related object: L<Koha::Schema::Result::CourseItem>
435 __PACKAGE__->might_have(
437 "Koha::Schema::Result::CourseItem",
438 { "foreign.itemnumber" => "self.itemnumber" },
439 { cascade_copy => 0, cascade_delete => 0 },
442 =head2 creator_batches
446 Related object: L<Koha::Schema::Result::CreatorBatch>
450 __PACKAGE__->has_many(
452 "Koha::Schema::Result::CreatorBatch",
453 { "foreign.item_number" => "self.itemnumber" },
454 { cascade_copy => 0, cascade_delete => 0 },
457 =head2 hold_fill_target
461 Related object: L<Koha::Schema::Result::HoldFillTarget>
465 __PACKAGE__->might_have(
467 "Koha::Schema::Result::HoldFillTarget",
468 { "foreign.itemnumber" => "self.itemnumber" },
469 { cascade_copy => 0, cascade_delete => 0 },
476 Related object: L<Koha::Schema::Result::Branch>
480 __PACKAGE__->belongs_to(
482 "Koha::Schema::Result::Branch",
483 { branchcode => "holdingbranch" },
487 on_delete => "CASCADE",
488 on_update => "CASCADE",
496 Related object: L<Koha::Schema::Result::Branch>
500 __PACKAGE__->belongs_to(
502 "Koha::Schema::Result::Branch",
503 { branchcode => "homebranch" },
507 on_delete => "CASCADE",
508 on_update => "CASCADE",
516 Related object: L<Koha::Schema::Result::Issue>
520 __PACKAGE__->has_many(
522 "Koha::Schema::Result::Issue",
523 { "foreign.itemnumber" => "self.itemnumber" },
524 { cascade_copy => 0, cascade_delete => 0 },
531 Related object: L<Koha::Schema::Result::OldIssue>
535 __PACKAGE__->has_many(
537 "Koha::Schema::Result::OldIssue",
538 { "foreign.itemnumber" => "self.itemnumber" },
539 { cascade_copy => 0, cascade_delete => 0 },
546 Related object: L<Koha::Schema::Result::OldReserve>
550 __PACKAGE__->has_many(
552 "Koha::Schema::Result::OldReserve",
553 { "foreign.itemnumber" => "self.itemnumber" },
554 { cascade_copy => 0, cascade_delete => 0 },
561 Related object: L<Koha::Schema::Result::Reserve>
565 __PACKAGE__->has_many(
567 "Koha::Schema::Result::Reserve",
568 { "foreign.itemnumber" => "self.itemnumber" },
569 { cascade_copy => 0, cascade_delete => 0 },
576 Related object: L<Koha::Schema::Result::Serialitem>
580 __PACKAGE__->might_have(
582 "Koha::Schema::Result::Serialitem",
583 { "foreign.itemnumber" => "self.itemnumber" },
584 { cascade_copy => 0, cascade_delete => 0 },
588 # Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
589 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JV1Q/UVlKQ6QgVFMGBIZCw
591 __PACKAGE__->belongs_to(
593 "Koha::Schema::Result::Biblio",
594 { "foreign.biblionumber" => "self.biblionumber" }