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::ClubHold>
266 __PACKAGE__->has_many(
268 "Koha::Schema::Result::ClubHold",
269 { "foreign.biblio_id" => "self.biblionumber" },
270 { cascade_copy => 0, cascade_delete => 0 },
277 Related object: L<Koha::Schema::Result::CourseItem>
281 __PACKAGE__->has_many(
283 "Koha::Schema::Result::CourseItem",
284 { "foreign.biblionumber" => "self.biblionumber" },
285 { cascade_copy => 0, cascade_delete => 0 },
292 Related object: L<Koha::Schema::Result::CoverImage>
296 __PACKAGE__->has_many(
298 "Koha::Schema::Result::CoverImage",
299 { "foreign.biblionumber" => "self.biblionumber" },
300 { cascade_copy => 0, cascade_delete => 0 },
303 =head2 hold_fill_targets
307 Related object: L<Koha::Schema::Result::HoldFillTarget>
311 __PACKAGE__->has_many(
313 "Koha::Schema::Result::HoldFillTarget",
314 { "foreign.biblionumber" => "self.biblionumber" },
315 { cascade_copy => 0, cascade_delete => 0 },
322 Related object: L<Koha::Schema::Result::Item>
326 __PACKAGE__->has_many(
328 "Koha::Schema::Result::Item",
329 { "foreign.biblionumber" => "self.biblionumber" },
330 { cascade_copy => 0, cascade_delete => 0 },
337 Related object: L<Koha::Schema::Result::Linktracker>
341 __PACKAGE__->has_many(
343 "Koha::Schema::Result::Linktracker",
344 { "foreign.biblionumber" => "self.biblionumber" },
345 { cascade_copy => 0, cascade_delete => 0 },
352 Related object: L<Koha::Schema::Result::OldReserve>
356 __PACKAGE__->has_many(
358 "Koha::Schema::Result::OldReserve",
359 { "foreign.biblionumber" => "self.biblionumber" },
360 { cascade_copy => 0, cascade_delete => 0 },
367 Related object: L<Koha::Schema::Result::Rating>
371 __PACKAGE__->has_many(
373 "Koha::Schema::Result::Rating",
374 { "foreign.biblionumber" => "self.biblionumber" },
375 { cascade_copy => 0, cascade_delete => 0 },
382 Related object: L<Koha::Schema::Result::Reserve>
386 __PACKAGE__->has_many(
388 "Koha::Schema::Result::Reserve",
389 { "foreign.biblionumber" => "self.biblionumber" },
390 { cascade_copy => 0, cascade_delete => 0 },
397 Related object: L<Koha::Schema::Result::Review>
401 __PACKAGE__->has_many(
403 "Koha::Schema::Result::Review",
404 { "foreign.biblionumber" => "self.biblionumber" },
405 { cascade_copy => 0, cascade_delete => 0 },
412 Related object: L<Koha::Schema::Result::Serial>
416 __PACKAGE__->has_many(
418 "Koha::Schema::Result::Serial",
419 { "foreign.biblionumber" => "self.biblionumber" },
420 { cascade_copy => 0, cascade_delete => 0 },
423 =head2 subscriptionhistories
427 Related object: L<Koha::Schema::Result::Subscriptionhistory>
431 __PACKAGE__->has_many(
432 "subscriptionhistories",
433 "Koha::Schema::Result::Subscriptionhistory",
434 { "foreign.biblionumber" => "self.biblionumber" },
435 { cascade_copy => 0, cascade_delete => 0 },
442 Related object: L<Koha::Schema::Result::Subscription>
446 __PACKAGE__->has_many(
448 "Koha::Schema::Result::Subscription",
449 { "foreign.biblionumber" => "self.biblionumber" },
450 { cascade_copy => 0, cascade_delete => 0 },
457 Related object: L<Koha::Schema::Result::Suggestion>
461 __PACKAGE__->has_many(
463 "Koha::Schema::Result::Suggestion",
464 { "foreign.biblionumber" => "self.biblionumber" },
465 { cascade_copy => 0, cascade_delete => 0 },
472 Related object: L<Koha::Schema::Result::TagAll>
476 __PACKAGE__->has_many(
478 "Koha::Schema::Result::TagAll",
479 { "foreign.biblionumber" => "self.biblionumber" },
480 { cascade_copy => 0, cascade_delete => 0 },
487 Related object: L<Koha::Schema::Result::TagsIndex>
491 __PACKAGE__->has_many(
493 "Koha::Schema::Result::TagsIndex",
494 { "foreign.biblionumber" => "self.biblionumber" },
495 { cascade_copy => 0, cascade_delete => 0 },
498 =head2 tmp_holdsqueues
502 Related object: L<Koha::Schema::Result::TmpHoldsqueue>
506 __PACKAGE__->has_many(
508 "Koha::Schema::Result::TmpHoldsqueue",
509 { "foreign.biblionumber" => "self.biblionumber" },
510 { cascade_copy => 0, cascade_delete => 0 },
513 =head2 virtualshelfcontents
517 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
521 __PACKAGE__->has_many(
522 "virtualshelfcontents",
523 "Koha::Schema::Result::Virtualshelfcontent",
524 { "foreign.biblionumber" => "self.biblionumber" },
525 { cascade_copy => 0, cascade_delete => 0 },
529 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-09-20 12:00:15
530 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:troBZEbpX+2RhgH2jptVZQ
532 __PACKAGE__->has_many(
534 "Koha::Schema::Result::Biblioitem",
535 { "foreign.biblionumber" => "self.biblionumber" },
536 { cascade_copy => 0, cascade_delete => 0 },
539 __PACKAGE__->has_one(
541 "Koha::Schema::Result::BiblioMetadata",
542 { "foreign.biblionumber" => "self.biblionumber" },
543 { cascade_copy => 0, cascade_delete => 0 },
546 __PACKAGE__->has_many(
548 "Koha::Schema::Result::Aqorder",
549 { "foreign.biblionumber" => "self.biblionumber" },
550 { cascade_copy => 0, cascade_delete => 0 },
553 __PACKAGE__->add_columns(
554 "+serial" => { is_boolean => 1 }