2 package Koha::Schema::Result::Biblio;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Biblio
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<biblio>
22 __PACKAGE__->table("biblio");
32 unique identifier assigned to each bibliographic record
37 default_value: (empty string)
41 foreign key from the biblio_framework table to identify which framework was used in cataloging this record
48 statement of responsibility from MARC record (100$a in MARC21)
55 title (without the subtitle) from the MARC record (245$a in MARC21)
62 medium from the MARC record (245$h in MARC21)
69 remainder of the title from the MARC record (245$b in MARC21)
76 part number from the MARC record (245$n in MARC21)
83 part name from the MARC record (245$p in MARC21)
90 uniform title (without the subtitle) from the MARC record (240$a in MARC21)
97 values from the general notes field in the MARC record (500$a in MARC21) split by bar (|)
104 Boolean indicating whether biblio is for a serial
108 data_type: 'longtext'
113 data_type: 'smallint'
116 publication or copyright date from the MARC record
120 data_type: 'timestamp'
121 datetime_undef_if_invalid: 1
122 default_value: current_timestamp
125 date and time this record was last touched
130 datetime_undef_if_invalid: 1
133 the date this record was added to Koha
137 data_type: 'longtext'
140 summary from the MARC record (520$a in MARC21)
144 __PACKAGE__->add_columns(
146 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
148 { data_type => "varchar", default_value => "", is_nullable => 0, size => 4 },
150 { data_type => "longtext", is_nullable => 1 },
152 { data_type => "longtext", is_nullable => 1 },
154 { data_type => "longtext", is_nullable => 1 },
156 { data_type => "longtext", is_nullable => 1 },
158 { data_type => "longtext", is_nullable => 1 },
160 { data_type => "longtext", is_nullable => 1 },
162 { data_type => "longtext", is_nullable => 1 },
164 { data_type => "longtext", is_nullable => 1 },
166 { data_type => "tinyint", is_nullable => 1 },
168 { data_type => "longtext", is_nullable => 1 },
170 { data_type => "smallint", is_nullable => 1 },
173 data_type => "timestamp",
174 datetime_undef_if_invalid => 1,
175 default_value => \"current_timestamp",
179 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
181 { data_type => "longtext", is_nullable => 1 },
188 =item * L</biblionumber>
194 __PACKAGE__->set_primary_key("biblionumber");
202 Related object: L<Koha::Schema::Result::Aqorder>
206 __PACKAGE__->has_many(
208 "Koha::Schema::Result::Aqorder",
209 { "foreign.biblionumber" => "self.biblionumber" },
210 { cascade_copy => 0, cascade_delete => 0 },
213 =head2 article_requests
217 Related object: L<Koha::Schema::Result::ArticleRequest>
221 __PACKAGE__->has_many(
223 "Koha::Schema::Result::ArticleRequest",
224 { "foreign.biblionumber" => "self.biblionumber" },
225 { cascade_copy => 0, cascade_delete => 0 },
228 =head2 biblio_metadatas
232 Related object: L<Koha::Schema::Result::BiblioMetadata>
236 __PACKAGE__->has_many(
238 "Koha::Schema::Result::BiblioMetadata",
239 { "foreign.biblionumber" => "self.biblionumber" },
240 { cascade_copy => 0, cascade_delete => 0 },
247 Related object: L<Koha::Schema::Result::Biblioitem>
251 __PACKAGE__->has_many(
253 "Koha::Schema::Result::Biblioitem",
254 { "foreign.biblionumber" => "self.biblionumber" },
255 { cascade_copy => 0, cascade_delete => 0 },
262 Related object: L<Koha::Schema::Result::Booking>
266 __PACKAGE__->has_many(
268 "Koha::Schema::Result::Booking",
269 { "foreign.biblio_id" => "self.biblionumber" },
270 { cascade_copy => 0, cascade_delete => 0 },
277 Related object: L<Koha::Schema::Result::ClubHold>
281 __PACKAGE__->has_many(
283 "Koha::Schema::Result::ClubHold",
284 { "foreign.biblio_id" => "self.biblionumber" },
285 { cascade_copy => 0, cascade_delete => 0 },
292 Related object: L<Koha::Schema::Result::CourseItem>
296 __PACKAGE__->has_many(
298 "Koha::Schema::Result::CourseItem",
299 { "foreign.biblionumber" => "self.biblionumber" },
300 { cascade_copy => 0, cascade_delete => 0 },
307 Related object: L<Koha::Schema::Result::CoverImage>
311 __PACKAGE__->has_many(
313 "Koha::Schema::Result::CoverImage",
314 { "foreign.biblionumber" => "self.biblionumber" },
315 { cascade_copy => 0, cascade_delete => 0 },
318 =head2 erm_eholdings_titles
322 Related object: L<Koha::Schema::Result::ErmEholdingsTitle>
326 __PACKAGE__->has_many(
327 "erm_eholdings_titles",
328 "Koha::Schema::Result::ErmEholdingsTitle",
329 { "foreign.biblio_id" => "self.biblionumber" },
330 { cascade_copy => 0, cascade_delete => 0 },
333 =head2 hold_fill_targets
337 Related object: L<Koha::Schema::Result::HoldFillTarget>
341 __PACKAGE__->has_many(
343 "Koha::Schema::Result::HoldFillTarget",
344 { "foreign.biblionumber" => "self.biblionumber" },
345 { cascade_copy => 0, cascade_delete => 0 },
352 Related object: L<Koha::Schema::Result::Illrequest>
356 __PACKAGE__->has_many(
358 "Koha::Schema::Result::Illrequest",
359 { "foreign.biblio_id" => "self.biblionumber" },
360 { cascade_copy => 0, cascade_delete => 0 },
367 Related object: L<Koha::Schema::Result::ItemGroup>
371 __PACKAGE__->has_many(
373 "Koha::Schema::Result::ItemGroup",
374 { "foreign.biblio_id" => "self.biblionumber" },
375 { cascade_copy => 0, cascade_delete => 0 },
382 Related object: L<Koha::Schema::Result::Item>
386 __PACKAGE__->has_many(
388 "Koha::Schema::Result::Item",
389 { "foreign.biblionumber" => "self.biblionumber" },
390 { cascade_copy => 0, cascade_delete => 0 },
397 Related object: L<Koha::Schema::Result::Linktracker>
401 __PACKAGE__->has_many(
403 "Koha::Schema::Result::Linktracker",
404 { "foreign.biblionumber" => "self.biblionumber" },
405 { cascade_copy => 0, cascade_delete => 0 },
412 Related object: L<Koha::Schema::Result::OldReserve>
416 __PACKAGE__->has_many(
418 "Koha::Schema::Result::OldReserve",
419 { "foreign.biblionumber" => "self.biblionumber" },
420 { cascade_copy => 0, cascade_delete => 0 },
427 Related object: L<Koha::Schema::Result::Rating>
431 __PACKAGE__->has_many(
433 "Koha::Schema::Result::Rating",
434 { "foreign.biblionumber" => "self.biblionumber" },
435 { cascade_copy => 0, cascade_delete => 0 },
442 Related object: L<Koha::Schema::Result::Recall>
446 __PACKAGE__->has_many(
448 "Koha::Schema::Result::Recall",
449 { "foreign.biblio_id" => "self.biblionumber" },
450 { cascade_copy => 0, cascade_delete => 0 },
457 Related object: L<Koha::Schema::Result::Reserve>
461 __PACKAGE__->has_many(
463 "Koha::Schema::Result::Reserve",
464 { "foreign.biblionumber" => "self.biblionumber" },
465 { cascade_copy => 0, cascade_delete => 0 },
472 Related object: L<Koha::Schema::Result::Review>
476 __PACKAGE__->has_many(
478 "Koha::Schema::Result::Review",
479 { "foreign.biblionumber" => "self.biblionumber" },
480 { cascade_copy => 0, cascade_delete => 0 },
487 Related object: L<Koha::Schema::Result::Serial>
491 __PACKAGE__->has_many(
493 "Koha::Schema::Result::Serial",
494 { "foreign.biblionumber" => "self.biblionumber" },
495 { cascade_copy => 0, cascade_delete => 0 },
498 =head2 subscriptionhistories
502 Related object: L<Koha::Schema::Result::Subscriptionhistory>
506 __PACKAGE__->has_many(
507 "subscriptionhistories",
508 "Koha::Schema::Result::Subscriptionhistory",
509 { "foreign.biblionumber" => "self.biblionumber" },
510 { cascade_copy => 0, cascade_delete => 0 },
517 Related object: L<Koha::Schema::Result::Subscription>
521 __PACKAGE__->has_many(
523 "Koha::Schema::Result::Subscription",
524 { "foreign.biblionumber" => "self.biblionumber" },
525 { cascade_copy => 0, cascade_delete => 0 },
532 Related object: L<Koha::Schema::Result::Suggestion>
536 __PACKAGE__->has_many(
538 "Koha::Schema::Result::Suggestion",
539 { "foreign.biblionumber" => "self.biblionumber" },
540 { cascade_copy => 0, cascade_delete => 0 },
547 Related object: L<Koha::Schema::Result::TagAll>
551 __PACKAGE__->has_many(
553 "Koha::Schema::Result::TagAll",
554 { "foreign.biblionumber" => "self.biblionumber" },
555 { cascade_copy => 0, cascade_delete => 0 },
562 Related object: L<Koha::Schema::Result::TagsIndex>
566 __PACKAGE__->has_many(
568 "Koha::Schema::Result::TagsIndex",
569 { "foreign.biblionumber" => "self.biblionumber" },
570 { cascade_copy => 0, cascade_delete => 0 },
577 Related object: L<Koha::Schema::Result::Ticket>
581 __PACKAGE__->has_many(
583 "Koha::Schema::Result::Ticket",
584 { "foreign.biblio_id" => "self.biblionumber" },
585 { cascade_copy => 0, cascade_delete => 0 },
588 =head2 tmp_holdsqueues
592 Related object: L<Koha::Schema::Result::TmpHoldsqueue>
596 __PACKAGE__->has_many(
598 "Koha::Schema::Result::TmpHoldsqueue",
599 { "foreign.biblionumber" => "self.biblionumber" },
600 { cascade_copy => 0, cascade_delete => 0 },
603 =head2 virtualshelfcontents
607 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
611 __PACKAGE__->has_many(
612 "virtualshelfcontents",
613 "Koha::Schema::Result::Virtualshelfcontent",
614 { "foreign.biblionumber" => "self.biblionumber" },
615 { cascade_copy => 0, cascade_delete => 0 },
619 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-05-09 07:11:30
620 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AZgt+4mVV/QYtSsdhxmaBQ
622 __PACKAGE__->has_many(
624 "Koha::Schema::Result::Biblioitem",
625 { "foreign.biblionumber" => "self.biblionumber" },
626 { cascade_copy => 0, cascade_delete => 0 },
629 __PACKAGE__->has_many(
631 "Koha::Schema::Result::Illrequest",
632 { "foreign.biblio_id" => "self.biblionumber" },
633 { cascade_copy => 0, cascade_delete => 0 },
636 __PACKAGE__->has_one(
638 "Koha::Schema::Result::BiblioMetadata",
639 { "foreign.biblionumber" => "self.biblionumber" },
640 { cascade_copy => 0, cascade_delete => 0 },
643 __PACKAGE__->has_many(
645 "Koha::Schema::Result::Aqorder",
646 { "foreign.biblionumber" => "self.biblionumber" },
647 { cascade_copy => 0, cascade_delete => 0 },
650 __PACKAGE__->add_columns(
651 "+serial" => { is_boolean => 1 }