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");
35 default_value: (empty string)
96 data_type: 'timestamp'
97 datetime_undef_if_invalid: 1
98 default_value: current_timestamp
104 datetime_undef_if_invalid: 1
109 data_type: 'longtext'
114 __PACKAGE__->add_columns(
116 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
118 { data_type => "varchar", default_value => "", is_nullable => 0, size => 4 },
120 { data_type => "longtext", is_nullable => 1 },
122 { data_type => "longtext", is_nullable => 1 },
124 { data_type => "longtext", is_nullable => 1 },
126 { data_type => "longtext", is_nullable => 1 },
128 { data_type => "longtext", is_nullable => 1 },
130 { data_type => "longtext", is_nullable => 1 },
132 { data_type => "longtext", is_nullable => 1 },
134 { data_type => "longtext", is_nullable => 1 },
136 { data_type => "tinyint", is_nullable => 1 },
138 { data_type => "longtext", is_nullable => 1 },
140 { data_type => "smallint", is_nullable => 1 },
143 data_type => "timestamp",
144 datetime_undef_if_invalid => 1,
145 default_value => \"current_timestamp",
149 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
151 { data_type => "longtext", is_nullable => 1 },
158 =item * L</biblionumber>
164 __PACKAGE__->set_primary_key("biblionumber");
172 Related object: L<Koha::Schema::Result::Aqorder>
176 __PACKAGE__->has_many(
178 "Koha::Schema::Result::Aqorder",
179 { "foreign.biblionumber" => "self.biblionumber" },
180 { cascade_copy => 0, cascade_delete => 0 },
183 =head2 article_requests
187 Related object: L<Koha::Schema::Result::ArticleRequest>
191 __PACKAGE__->has_many(
193 "Koha::Schema::Result::ArticleRequest",
194 { "foreign.biblionumber" => "self.biblionumber" },
195 { cascade_copy => 0, cascade_delete => 0 },
198 =head2 biblio_metadatas
202 Related object: L<Koha::Schema::Result::BiblioMetadata>
206 __PACKAGE__->has_many(
208 "Koha::Schema::Result::BiblioMetadata",
209 { "foreign.biblionumber" => "self.biblionumber" },
210 { cascade_copy => 0, cascade_delete => 0 },
217 Related object: L<Koha::Schema::Result::Biblioimage>
221 __PACKAGE__->has_many(
223 "Koha::Schema::Result::Biblioimage",
224 { "foreign.biblionumber" => "self.biblionumber" },
225 { cascade_copy => 0, cascade_delete => 0 },
232 Related object: L<Koha::Schema::Result::Biblioitem>
236 __PACKAGE__->has_many(
238 "Koha::Schema::Result::Biblioitem",
239 { "foreign.biblionumber" => "self.biblionumber" },
240 { cascade_copy => 0, cascade_delete => 0 },
247 Related object: L<Koha::Schema::Result::ClubHold>
251 __PACKAGE__->has_many(
253 "Koha::Schema::Result::ClubHold",
254 { "foreign.biblio_id" => "self.biblionumber" },
255 { cascade_copy => 0, cascade_delete => 0 },
258 =head2 hold_fill_targets
262 Related object: L<Koha::Schema::Result::HoldFillTarget>
266 __PACKAGE__->has_many(
268 "Koha::Schema::Result::HoldFillTarget",
269 { "foreign.biblionumber" => "self.biblionumber" },
270 { cascade_copy => 0, cascade_delete => 0 },
277 Related object: L<Koha::Schema::Result::Item>
281 __PACKAGE__->has_many(
283 "Koha::Schema::Result::Item",
284 { "foreign.biblionumber" => "self.biblionumber" },
285 { cascade_copy => 0, cascade_delete => 0 },
292 Related object: L<Koha::Schema::Result::OldReserve>
296 __PACKAGE__->has_many(
298 "Koha::Schema::Result::OldReserve",
299 { "foreign.biblionumber" => "self.biblionumber" },
300 { cascade_copy => 0, cascade_delete => 0 },
307 Related object: L<Koha::Schema::Result::Rating>
311 __PACKAGE__->has_many(
313 "Koha::Schema::Result::Rating",
314 { "foreign.biblionumber" => "self.biblionumber" },
315 { cascade_copy => 0, cascade_delete => 0 },
322 Related object: L<Koha::Schema::Result::Reserve>
326 __PACKAGE__->has_many(
328 "Koha::Schema::Result::Reserve",
329 { "foreign.biblionumber" => "self.biblionumber" },
330 { cascade_copy => 0, cascade_delete => 0 },
337 Related object: L<Koha::Schema::Result::Review>
341 __PACKAGE__->has_many(
343 "Koha::Schema::Result::Review",
344 { "foreign.biblionumber" => "self.biblionumber" },
345 { cascade_copy => 0, cascade_delete => 0 },
352 Related object: L<Koha::Schema::Result::Serial>
356 __PACKAGE__->has_many(
358 "Koha::Schema::Result::Serial",
359 { "foreign.biblionumber" => "self.biblionumber" },
360 { cascade_copy => 0, cascade_delete => 0 },
363 =head2 subscriptionhistories
367 Related object: L<Koha::Schema::Result::Subscriptionhistory>
371 __PACKAGE__->has_many(
372 "subscriptionhistories",
373 "Koha::Schema::Result::Subscriptionhistory",
374 { "foreign.biblionumber" => "self.biblionumber" },
375 { cascade_copy => 0, cascade_delete => 0 },
382 Related object: L<Koha::Schema::Result::Subscription>
386 __PACKAGE__->has_many(
388 "Koha::Schema::Result::Subscription",
389 { "foreign.biblionumber" => "self.biblionumber" },
390 { cascade_copy => 0, cascade_delete => 0 },
397 Related object: L<Koha::Schema::Result::Suggestion>
401 __PACKAGE__->has_many(
403 "Koha::Schema::Result::Suggestion",
404 { "foreign.biblionumber" => "self.biblionumber" },
405 { cascade_copy => 0, cascade_delete => 0 },
412 Related object: L<Koha::Schema::Result::TagAll>
416 __PACKAGE__->has_many(
418 "Koha::Schema::Result::TagAll",
419 { "foreign.biblionumber" => "self.biblionumber" },
420 { cascade_copy => 0, cascade_delete => 0 },
427 Related object: L<Koha::Schema::Result::TagsIndex>
431 __PACKAGE__->has_many(
433 "Koha::Schema::Result::TagsIndex",
434 { "foreign.biblionumber" => "self.biblionumber" },
435 { cascade_copy => 0, cascade_delete => 0 },
438 =head2 virtualshelfcontents
442 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
446 __PACKAGE__->has_many(
447 "virtualshelfcontents",
448 "Koha::Schema::Result::Virtualshelfcontent",
449 { "foreign.biblionumber" => "self.biblionumber" },
450 { cascade_copy => 0, cascade_delete => 0 },
454 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-04-17 09:15:51
455 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p2SIq565zPyE3ZUkSuXyBA
458 __PACKAGE__->has_one(
460 "Koha::Schema::Result::BiblioMetadata",
461 { "foreign.biblionumber" => "self.biblionumber" },
462 { cascade_copy => 0, cascade_delete => 0 },
465 __PACKAGE__->has_many(
467 "Koha::Schema::Result::Aqorder",
468 { "foreign.biblionumber" => "self.biblionumber" },
469 { cascade_copy => 0, cascade_delete => 0 },
472 __PACKAGE__->add_columns(
473 "+serial" => { is_boolean => 1 }