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::CoverImage>
281 __PACKAGE__->has_many(
283 "Koha::Schema::Result::CoverImage",
284 { "foreign.biblionumber" => "self.biblionumber" },
285 { cascade_copy => 0, cascade_delete => 0 },
288 =head2 hold_fill_targets
292 Related object: L<Koha::Schema::Result::HoldFillTarget>
296 __PACKAGE__->has_many(
298 "Koha::Schema::Result::HoldFillTarget",
299 { "foreign.biblionumber" => "self.biblionumber" },
300 { cascade_copy => 0, cascade_delete => 0 },
307 Related object: L<Koha::Schema::Result::Item>
311 __PACKAGE__->has_many(
313 "Koha::Schema::Result::Item",
314 { "foreign.biblionumber" => "self.biblionumber" },
315 { cascade_copy => 0, cascade_delete => 0 },
322 Related object: L<Koha::Schema::Result::OldReserve>
326 __PACKAGE__->has_many(
328 "Koha::Schema::Result::OldReserve",
329 { "foreign.biblionumber" => "self.biblionumber" },
330 { cascade_copy => 0, cascade_delete => 0 },
337 Related object: L<Koha::Schema::Result::Rating>
341 __PACKAGE__->has_many(
343 "Koha::Schema::Result::Rating",
344 { "foreign.biblionumber" => "self.biblionumber" },
345 { cascade_copy => 0, cascade_delete => 0 },
352 Related object: L<Koha::Schema::Result::Reserve>
356 __PACKAGE__->has_many(
358 "Koha::Schema::Result::Reserve",
359 { "foreign.biblionumber" => "self.biblionumber" },
360 { cascade_copy => 0, cascade_delete => 0 },
367 Related object: L<Koha::Schema::Result::Review>
371 __PACKAGE__->has_many(
373 "Koha::Schema::Result::Review",
374 { "foreign.biblionumber" => "self.biblionumber" },
375 { cascade_copy => 0, cascade_delete => 0 },
382 Related object: L<Koha::Schema::Result::Serial>
386 __PACKAGE__->has_many(
388 "Koha::Schema::Result::Serial",
389 { "foreign.biblionumber" => "self.biblionumber" },
390 { cascade_copy => 0, cascade_delete => 0 },
393 =head2 subscriptionhistories
397 Related object: L<Koha::Schema::Result::Subscriptionhistory>
401 __PACKAGE__->has_many(
402 "subscriptionhistories",
403 "Koha::Schema::Result::Subscriptionhistory",
404 { "foreign.biblionumber" => "self.biblionumber" },
405 { cascade_copy => 0, cascade_delete => 0 },
412 Related object: L<Koha::Schema::Result::Subscription>
416 __PACKAGE__->has_many(
418 "Koha::Schema::Result::Subscription",
419 { "foreign.biblionumber" => "self.biblionumber" },
420 { cascade_copy => 0, cascade_delete => 0 },
427 Related object: L<Koha::Schema::Result::Suggestion>
431 __PACKAGE__->has_many(
433 "Koha::Schema::Result::Suggestion",
434 { "foreign.biblionumber" => "self.biblionumber" },
435 { cascade_copy => 0, cascade_delete => 0 },
442 Related object: L<Koha::Schema::Result::TagAll>
446 __PACKAGE__->has_many(
448 "Koha::Schema::Result::TagAll",
449 { "foreign.biblionumber" => "self.biblionumber" },
450 { cascade_copy => 0, cascade_delete => 0 },
457 Related object: L<Koha::Schema::Result::TagsIndex>
461 __PACKAGE__->has_many(
463 "Koha::Schema::Result::TagsIndex",
464 { "foreign.biblionumber" => "self.biblionumber" },
465 { cascade_copy => 0, cascade_delete => 0 },
468 =head2 virtualshelfcontents
472 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
476 __PACKAGE__->has_many(
477 "virtualshelfcontents",
478 "Koha::Schema::Result::Virtualshelfcontent",
479 { "foreign.biblionumber" => "self.biblionumber" },
480 { cascade_copy => 0, cascade_delete => 0 },
484 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-01-21 13:39:29
485 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nmmsZusHYNAMimE9sImSNg
487 __PACKAGE__->has_many(
489 "Koha::Schema::Result::Biblioitem",
490 { "foreign.biblionumber" => "self.biblionumber" },
491 { cascade_copy => 0, cascade_delete => 0 },
494 __PACKAGE__->has_one(
496 "Koha::Schema::Result::BiblioMetadata",
497 { "foreign.biblionumber" => "self.biblionumber" },
498 { cascade_copy => 0, cascade_delete => 0 },
501 __PACKAGE__->has_many(
503 "Koha::Schema::Result::Aqorder",
504 { "foreign.biblionumber" => "self.biblionumber" },
505 { cascade_copy => 0, cascade_delete => 0 },
508 __PACKAGE__->add_columns(
509 "+serial" => { is_boolean => 1 }