use utf8; package Koha::Schema::Result::Biblio; # Created by DBIx::Class::Schema::Loader # DO NOT MODIFY THE FIRST PART OF THIS FILE =head1 NAME Koha::Schema::Result::Biblio =cut use strict; use warnings; use base 'DBIx::Class::Core'; =head1 TABLE: C =cut __PACKAGE__->table("biblio"); =head1 ACCESSORS =head2 biblionumber data_type: 'integer' is_auto_increment: 1 is_nullable: 0 unique identifier assigned to each bibliographic record =head2 frameworkcode data_type: 'varchar' default_value: (empty string) is_nullable: 0 size: 4 foreign key from the biblio_framework table to identify which framework was used in cataloging this record =head2 author data_type: 'longtext' is_nullable: 1 statement of responsibility from MARC record (100$a in MARC21) =head2 title data_type: 'longtext' is_nullable: 1 title (without the subtitle) from the MARC record (245$a in MARC21) =head2 medium data_type: 'longtext' is_nullable: 1 medium from the MARC record (245$h in MARC21) =head2 subtitle data_type: 'longtext' is_nullable: 1 remainder of the title from the MARC record (245$b in MARC21) =head2 part_number data_type: 'longtext' is_nullable: 1 part number from the MARC record (245$n in MARC21) =head2 part_name data_type: 'longtext' is_nullable: 1 part name from the MARC record (245$p in MARC21) =head2 unititle data_type: 'longtext' is_nullable: 1 uniform title (without the subtitle) from the MARC record (240$a in MARC21) =head2 notes data_type: 'longtext' is_nullable: 1 values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) =head2 serial data_type: 'tinyint' is_nullable: 1 Boolean indicating whether biblio is for a serial =head2 seriestitle data_type: 'longtext' is_nullable: 1 =head2 copyrightdate data_type: 'smallint' is_nullable: 1 publication or copyright date from the MARC record =head2 timestamp data_type: 'timestamp' datetime_undef_if_invalid: 1 default_value: current_timestamp is_nullable: 0 date and time this record was last touched =head2 datecreated data_type: 'date' datetime_undef_if_invalid: 1 is_nullable: 0 the date this record was added to Koha =head2 abstract data_type: 'longtext' is_nullable: 1 summary from the MARC record (520$a in MARC21) =cut __PACKAGE__->add_columns( "biblionumber", { data_type => "integer", is_auto_increment => 1, is_nullable => 0 }, "frameworkcode", { data_type => "varchar", default_value => "", is_nullable => 0, size => 4 }, "author", { data_type => "longtext", is_nullable => 1 }, "title", { data_type => "longtext", is_nullable => 1 }, "medium", { data_type => "longtext", is_nullable => 1 }, "subtitle", { data_type => "longtext", is_nullable => 1 }, "part_number", { data_type => "longtext", is_nullable => 1 }, "part_name", { data_type => "longtext", is_nullable => 1 }, "unititle", { data_type => "longtext", is_nullable => 1 }, "notes", { data_type => "longtext", is_nullable => 1 }, "serial", { data_type => "tinyint", is_nullable => 1 }, "seriestitle", { data_type => "longtext", is_nullable => 1 }, "copyrightdate", { data_type => "smallint", is_nullable => 1 }, "timestamp", { data_type => "timestamp", datetime_undef_if_invalid => 1, default_value => \"current_timestamp", is_nullable => 0, }, "datecreated", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 }, "abstract", { data_type => "longtext", is_nullable => 1 }, ); =head1 PRIMARY KEY =over 4 =item * L =back =cut __PACKAGE__->set_primary_key("biblionumber"); =head1 RELATIONS =head2 aqorders Type: has_many Related object: L =cut __PACKAGE__->has_many( "aqorders", "Koha::Schema::Result::Aqorder", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 article_requests Type: has_many Related object: L =cut __PACKAGE__->has_many( "article_requests", "Koha::Schema::Result::ArticleRequest", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 biblio_metadatas Type: has_many Related object: L =cut __PACKAGE__->has_many( "biblio_metadatas", "Koha::Schema::Result::BiblioMetadata", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 biblioitems Type: has_many Related object: L =cut __PACKAGE__->has_many( "biblioitems", "Koha::Schema::Result::Biblioitem", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 bookings Type: has_many Related object: L =cut __PACKAGE__->has_many( "bookings", "Koha::Schema::Result::Booking", { "foreign.biblio_id" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 club_holds Type: has_many Related object: L =cut __PACKAGE__->has_many( "club_holds", "Koha::Schema::Result::ClubHold", { "foreign.biblio_id" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 course_items Type: has_many Related object: L =cut __PACKAGE__->has_many( "course_items", "Koha::Schema::Result::CourseItem", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 cover_images Type: has_many Related object: L =cut __PACKAGE__->has_many( "cover_images", "Koha::Schema::Result::CoverImage", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 erm_eholdings_titles Type: has_many Related object: L =cut __PACKAGE__->has_many( "erm_eholdings_titles", "Koha::Schema::Result::ErmEholdingsTitle", { "foreign.biblio_id" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 hold_fill_targets Type: has_many Related object: L =cut __PACKAGE__->has_many( "hold_fill_targets", "Koha::Schema::Result::HoldFillTarget", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 illrequests Type: has_many Related object: L =cut __PACKAGE__->has_many( "illrequests", "Koha::Schema::Result::Illrequest", { "foreign.biblio_id" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 item_groups Type: has_many Related object: L =cut __PACKAGE__->has_many( "item_groups", "Koha::Schema::Result::ItemGroup", { "foreign.biblio_id" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 items Type: has_many Related object: L =cut __PACKAGE__->has_many( "items", "Koha::Schema::Result::Item", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 linktrackers Type: has_many Related object: L =cut __PACKAGE__->has_many( "linktrackers", "Koha::Schema::Result::Linktracker", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 old_reserves Type: has_many Related object: L =cut __PACKAGE__->has_many( "old_reserves", "Koha::Schema::Result::OldReserve", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 ratings Type: has_many Related object: L =cut __PACKAGE__->has_many( "ratings", "Koha::Schema::Result::Rating", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 recalls Type: has_many Related object: L =cut __PACKAGE__->has_many( "recalls", "Koha::Schema::Result::Recall", { "foreign.biblio_id" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 reserves Type: has_many Related object: L =cut __PACKAGE__->has_many( "reserves", "Koha::Schema::Result::Reserve", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 reviews Type: has_many Related object: L =cut __PACKAGE__->has_many( "reviews", "Koha::Schema::Result::Review", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 serials Type: has_many Related object: L =cut __PACKAGE__->has_many( "serials", "Koha::Schema::Result::Serial", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 subscriptionhistories Type: has_many Related object: L =cut __PACKAGE__->has_many( "subscriptionhistories", "Koha::Schema::Result::Subscriptionhistory", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 subscriptions Type: has_many Related object: L =cut __PACKAGE__->has_many( "subscriptions", "Koha::Schema::Result::Subscription", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 suggestions Type: has_many Related object: L =cut __PACKAGE__->has_many( "suggestions", "Koha::Schema::Result::Suggestion", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 tags_all Type: has_many Related object: L =cut __PACKAGE__->has_many( "tags_all", "Koha::Schema::Result::TagAll", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 tags_indexes Type: has_many Related object: L =cut __PACKAGE__->has_many( "tags_indexes", "Koha::Schema::Result::TagsIndex", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 tickets Type: has_many Related object: L =cut __PACKAGE__->has_many( "tickets", "Koha::Schema::Result::Ticket", { "foreign.biblio_id" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 tmp_holdsqueues Type: has_many Related object: L =cut __PACKAGE__->has_many( "tmp_holdsqueues", "Koha::Schema::Result::TmpHoldsqueue", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); =head2 virtualshelfcontents Type: has_many Related object: L =cut __PACKAGE__->has_many( "virtualshelfcontents", "Koha::Schema::Result::Virtualshelfcontent", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); # Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-05-09 07:11:30 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AZgt+4mVV/QYtSsdhxmaBQ __PACKAGE__->has_many( "biblioitem", "Koha::Schema::Result::Biblioitem", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); __PACKAGE__->has_many( "ill_requests", "Koha::Schema::Result::Illrequest", { "foreign.biblio_id" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); __PACKAGE__->has_one( "metadata", "Koha::Schema::Result::BiblioMetadata", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); __PACKAGE__->has_many( "orders", "Koha::Schema::Result::Aqorder", { "foreign.biblionumber" => "self.biblionumber" }, { cascade_copy => 0, cascade_delete => 0 }, ); __PACKAGE__->add_columns( "+serial" => { is_boolean => 1 } ); 1;