2 package Koha::Schema::Result::Borrower;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Borrower
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<borrowers>
22 __PACKAGE__->table("borrowers");
40 data_type: 'mediumtext'
50 data_type: 'mediumtext'
55 data_type: 'mediumtext'
77 data_type: 'mediumtext'
87 data_type: 'mediumtext'
108 data_type: 'mediumtext'
124 data_type: 'mediumtext'
137 =head2 B_streetnumber
139 accessor: 'b_streetnumber'
146 accessor: 'b_streettype'
153 accessor: 'b_address'
160 accessor: 'b_address2'
167 data_type: 'mediumtext'
178 accessor: 'b_zipcode'
185 accessor: 'b_country'
198 data_type: 'mediumtext'
204 datetime_undef_if_invalid: 1
210 default_value: (empty string)
218 default_value: (empty string)
226 datetime_undef_if_invalid: 1
232 datetime_undef_if_invalid: 1
248 datetime_undef_if_invalid: 1
251 =head2 debarredcomment
259 data_type: 'mediumtext'
262 =head2 contactfirstname
279 data_type: 'mediumtext'
313 data_type: 'mediumtext'
334 =head2 altcontactfirstname
340 =head2 altcontactsurname
346 =head2 altcontactaddress1
352 =head2 altcontactaddress2
358 =head2 altcontactaddress3
364 =head2 altcontactstate
369 =head2 altcontactzipcode
375 =head2 altcontactcountry
380 =head2 altcontactphone
386 =head2 smsalertnumber
392 =head2 sms_provider_id
404 =head2 privacy_guarantor_checkouts
410 =head2 checkprevcheckout
413 default_value: 'inherit'
419 data_type: 'timestamp'
420 datetime_undef_if_invalid: 1
421 default_value: current_timestamp
426 data_type: 'datetime'
427 datetime_undef_if_invalid: 1
432 __PACKAGE__->add_columns(
434 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
436 { data_type => "varchar", is_nullable => 1, size => 16 },
438 { data_type => "mediumtext", is_nullable => 0 },
440 { data_type => "text", is_nullable => 1 },
442 { data_type => "mediumtext", is_nullable => 1 },
444 { data_type => "mediumtext", is_nullable => 1 },
446 { data_type => "text", is_nullable => 1 },
448 { data_type => "varchar", is_nullable => 1, size => 10 },
450 { data_type => "varchar", is_nullable => 1, size => 50 },
452 { data_type => "mediumtext", is_nullable => 0 },
454 { data_type => "text", is_nullable => 1 },
456 { data_type => "mediumtext", is_nullable => 0 },
458 { data_type => "text", is_nullable => 1 },
460 { data_type => "varchar", is_nullable => 1, size => 25 },
462 { data_type => "text", is_nullable => 1 },
464 { data_type => "mediumtext", is_nullable => 1 },
466 { data_type => "text", is_nullable => 1 },
468 { data_type => "varchar", is_nullable => 1, size => 50 },
470 { data_type => "mediumtext", is_nullable => 1 },
472 { data_type => "text", is_nullable => 1 },
474 { data_type => "text", is_nullable => 1 },
477 accessor => "b_streetnumber",
478 data_type => "varchar",
484 accessor => "b_streettype",
485 data_type => "varchar",
491 accessor => "b_address",
492 data_type => "varchar",
497 { accessor => "b_address2", data_type => "text", is_nullable => 1 },
499 { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
501 { accessor => "b_state", data_type => "text", is_nullable => 1 },
504 accessor => "b_zipcode",
505 data_type => "varchar",
510 { accessor => "b_country", data_type => "text", is_nullable => 1 },
512 { accessor => "b_email", data_type => "text", is_nullable => 1 },
514 { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
516 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
519 data_type => "varchar",
527 data_type => "varchar",
534 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
536 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
538 { data_type => "tinyint", is_nullable => 1 },
540 { data_type => "tinyint", is_nullable => 1 },
542 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
544 { data_type => "varchar", is_nullable => 1, size => 255 },
546 { data_type => "mediumtext", is_nullable => 1 },
548 { data_type => "text", is_nullable => 1 },
550 { data_type => "text", is_nullable => 1 },
552 { data_type => "integer", is_nullable => 1 },
554 { data_type => "mediumtext", is_nullable => 1 },
556 { data_type => "varchar", is_nullable => 1, size => 100 },
558 { data_type => "varchar", is_nullable => 1, size => 1 },
560 { data_type => "varchar", is_nullable => 1, size => 60 },
562 { data_type => "integer", is_nullable => 1 },
564 { data_type => "varchar", is_nullable => 1, size => 75 },
566 { data_type => "mediumtext", is_nullable => 1 },
568 { data_type => "varchar", is_nullable => 1, size => 255 },
570 { data_type => "varchar", is_nullable => 1, size => 80 },
572 { data_type => "varchar", is_nullable => 1, size => 80 },
573 "altcontactfirstname",
574 { data_type => "varchar", is_nullable => 1, size => 255 },
576 { data_type => "varchar", is_nullable => 1, size => 255 },
577 "altcontactaddress1",
578 { data_type => "varchar", is_nullable => 1, size => 255 },
579 "altcontactaddress2",
580 { data_type => "varchar", is_nullable => 1, size => 255 },
581 "altcontactaddress3",
582 { data_type => "varchar", is_nullable => 1, size => 255 },
584 { data_type => "text", is_nullable => 1 },
586 { data_type => "varchar", is_nullable => 1, size => 50 },
588 { data_type => "text", is_nullable => 1 },
590 { data_type => "varchar", is_nullable => 1, size => 50 },
592 { data_type => "varchar", is_nullable => 1, size => 50 },
594 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
596 { data_type => "integer", default_value => 1, is_nullable => 0 },
597 "privacy_guarantor_checkouts",
598 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
601 data_type => "varchar",
602 default_value => "inherit",
608 data_type => "timestamp",
609 datetime_undef_if_invalid => 1,
610 default_value => \"current_timestamp",
615 data_type => "datetime",
616 datetime_undef_if_invalid => 1,
619 "overdrive_auth_token",
620 { data_type => "text", is_nullable => 1 },
627 =item * L</borrowernumber>
633 __PACKAGE__->set_primary_key("borrowernumber");
635 =head1 UNIQUE CONSTRAINTS
641 =item * L</cardnumber>
647 __PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
659 __PACKAGE__->add_unique_constraint("userid", ["userid"]);
667 Related object: L<Koha::Schema::Result::Accountline>
671 __PACKAGE__->has_many(
673 "Koha::Schema::Result::Accountline",
674 { "foreign.borrowernumber" => "self.borrowernumber" },
675 { cascade_copy => 0, cascade_delete => 0 },
678 =head2 accountoffsets
682 Related object: L<Koha::Schema::Result::Accountoffset>
686 __PACKAGE__->has_many(
688 "Koha::Schema::Result::Accountoffset",
689 { "foreign.borrowernumber" => "self.borrowernumber" },
690 { cascade_copy => 0, cascade_delete => 0 },
697 Related object: L<Koha::Schema::Result::Aqbasketuser>
701 __PACKAGE__->has_many(
703 "Koha::Schema::Result::Aqbasketuser",
704 { "foreign.borrowernumber" => "self.borrowernumber" },
705 { cascade_copy => 0, cascade_delete => 0 },
708 =head2 aqbudgetborrowers
712 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
716 __PACKAGE__->has_many(
718 "Koha::Schema::Result::Aqbudgetborrower",
719 { "foreign.borrowernumber" => "self.borrowernumber" },
720 { cascade_copy => 0, cascade_delete => 0 },
727 Related object: L<Koha::Schema::Result::AqorderUser>
731 __PACKAGE__->has_many(
733 "Koha::Schema::Result::AqorderUser",
734 { "foreign.borrowernumber" => "self.borrowernumber" },
735 { cascade_copy => 0, cascade_delete => 0 },
738 =head2 article_requests
742 Related object: L<Koha::Schema::Result::ArticleRequest>
746 __PACKAGE__->has_many(
748 "Koha::Schema::Result::ArticleRequest",
749 { "foreign.borrowernumber" => "self.borrowernumber" },
750 { cascade_copy => 0, cascade_delete => 0 },
753 =head2 borrower_attributes
757 Related object: L<Koha::Schema::Result::BorrowerAttribute>
761 __PACKAGE__->has_many(
762 "borrower_attributes",
763 "Koha::Schema::Result::BorrowerAttribute",
764 { "foreign.borrowernumber" => "self.borrowernumber" },
765 { cascade_copy => 0, cascade_delete => 0 },
768 =head2 borrower_debarments
772 Related object: L<Koha::Schema::Result::BorrowerDebarment>
776 __PACKAGE__->has_many(
777 "borrower_debarments",
778 "Koha::Schema::Result::BorrowerDebarment",
779 { "foreign.borrowernumber" => "self.borrowernumber" },
780 { cascade_copy => 0, cascade_delete => 0 },
783 =head2 borrower_files
787 Related object: L<Koha::Schema::Result::BorrowerFile>
791 __PACKAGE__->has_many(
793 "Koha::Schema::Result::BorrowerFile",
794 { "foreign.borrowernumber" => "self.borrowernumber" },
795 { cascade_copy => 0, cascade_delete => 0 },
798 =head2 borrower_message_preferences
802 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
806 __PACKAGE__->has_many(
807 "borrower_message_preferences",
808 "Koha::Schema::Result::BorrowerMessagePreference",
809 { "foreign.borrowernumber" => "self.borrowernumber" },
810 { cascade_copy => 0, cascade_delete => 0 },
813 =head2 borrower_syncs
817 Related object: L<Koha::Schema::Result::BorrowerSync>
821 __PACKAGE__->has_many(
823 "Koha::Schema::Result::BorrowerSync",
824 { "foreign.borrowernumber" => "self.borrowernumber" },
825 { cascade_copy => 0, cascade_delete => 0 },
832 Related object: L<Koha::Schema::Result::Branch>
836 __PACKAGE__->belongs_to(
838 "Koha::Schema::Result::Branch",
839 { branchcode => "branchcode" },
840 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
847 Related object: L<Koha::Schema::Result::Category>
851 __PACKAGE__->belongs_to(
853 "Koha::Schema::Result::Category",
854 { categorycode => "categorycode" },
855 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
858 =head2 club_enrollments
862 Related object: L<Koha::Schema::Result::ClubEnrollment>
866 __PACKAGE__->has_many(
868 "Koha::Schema::Result::ClubEnrollment",
869 { "foreign.borrowernumber" => "self.borrowernumber" },
870 { cascade_copy => 0, cascade_delete => 0 },
873 =head2 course_instructors
877 Related object: L<Koha::Schema::Result::CourseInstructor>
881 __PACKAGE__->has_many(
882 "course_instructors",
883 "Koha::Schema::Result::CourseInstructor",
884 { "foreign.borrowernumber" => "self.borrowernumber" },
885 { cascade_copy => 0, cascade_delete => 0 },
888 =head2 creator_batches
892 Related object: L<Koha::Schema::Result::CreatorBatch>
896 __PACKAGE__->has_many(
898 "Koha::Schema::Result::CreatorBatch",
899 { "foreign.borrower_number" => "self.borrowernumber" },
900 { cascade_copy => 0, cascade_delete => 0 },
907 Related object: L<Koha::Schema::Result::Discharge>
911 __PACKAGE__->has_many(
913 "Koha::Schema::Result::Discharge",
914 { "foreign.borrower" => "self.borrowernumber" },
915 { cascade_copy => 0, cascade_delete => 0 },
918 =head2 hold_fill_targets
922 Related object: L<Koha::Schema::Result::HoldFillTarget>
926 __PACKAGE__->has_many(
928 "Koha::Schema::Result::HoldFillTarget",
929 { "foreign.borrowernumber" => "self.borrowernumber" },
930 { cascade_copy => 0, cascade_delete => 0 },
933 =head2 housebound_profile
937 Related object: L<Koha::Schema::Result::HouseboundProfile>
941 __PACKAGE__->might_have(
942 "housebound_profile",
943 "Koha::Schema::Result::HouseboundProfile",
944 { "foreign.borrowernumber" => "self.borrowernumber" },
945 { cascade_copy => 0, cascade_delete => 0 },
948 =head2 housebound_role
952 Related object: L<Koha::Schema::Result::HouseboundRole>
956 __PACKAGE__->might_have(
958 "Koha::Schema::Result::HouseboundRole",
959 { "foreign.borrowernumber_id" => "self.borrowernumber" },
960 { cascade_copy => 0, cascade_delete => 0 },
963 =head2 housebound_visit_chooser_brwnumbers
967 Related object: L<Koha::Schema::Result::HouseboundVisit>
971 __PACKAGE__->has_many(
972 "housebound_visit_chooser_brwnumbers",
973 "Koha::Schema::Result::HouseboundVisit",
974 { "foreign.chooser_brwnumber" => "self.borrowernumber" },
975 { cascade_copy => 0, cascade_delete => 0 },
978 =head2 housebound_visit_deliverer_brwnumbers
982 Related object: L<Koha::Schema::Result::HouseboundVisit>
986 __PACKAGE__->has_many(
987 "housebound_visit_deliverer_brwnumbers",
988 "Koha::Schema::Result::HouseboundVisit",
989 { "foreign.deliverer_brwnumber" => "self.borrowernumber" },
990 { cascade_copy => 0, cascade_delete => 0 },
997 Related object: L<Koha::Schema::Result::Issue>
1001 __PACKAGE__->has_many(
1003 "Koha::Schema::Result::Issue",
1004 { "foreign.borrowernumber" => "self.borrowernumber" },
1005 { cascade_copy => 0, cascade_delete => 0 },
1008 =head2 items_last_borrowers
1012 Related object: L<Koha::Schema::Result::ItemsLastBorrower>
1016 __PACKAGE__->has_many(
1017 "items_last_borrowers",
1018 "Koha::Schema::Result::ItemsLastBorrower",
1019 { "foreign.borrowernumber" => "self.borrowernumber" },
1020 { cascade_copy => 0, cascade_delete => 0 },
1023 =head2 message_queues
1027 Related object: L<Koha::Schema::Result::MessageQueue>
1031 __PACKAGE__->has_many(
1033 "Koha::Schema::Result::MessageQueue",
1034 { "foreign.borrowernumber" => "self.borrowernumber" },
1035 { cascade_copy => 0, cascade_delete => 0 },
1042 Related object: L<Koha::Schema::Result::Message>
1046 __PACKAGE__->has_many(
1048 "Koha::Schema::Result::Message",
1049 { "foreign.manager_id" => "self.borrowernumber" },
1050 { cascade_copy => 0, cascade_delete => 0 },
1057 Related object: L<Koha::Schema::Result::OldIssue>
1061 __PACKAGE__->has_many(
1063 "Koha::Schema::Result::OldIssue",
1064 { "foreign.borrowernumber" => "self.borrowernumber" },
1065 { cascade_copy => 0, cascade_delete => 0 },
1072 Related object: L<Koha::Schema::Result::OldReserve>
1076 __PACKAGE__->has_many(
1078 "Koha::Schema::Result::OldReserve",
1079 { "foreign.borrowernumber" => "self.borrowernumber" },
1080 { cascade_copy => 0, cascade_delete => 0 },
1087 Related object: L<Koha::Schema::Result::OpacNews>
1091 __PACKAGE__->has_many(
1093 "Koha::Schema::Result::OpacNews",
1094 { "foreign.borrowernumber" => "self.borrowernumber" },
1095 { cascade_copy => 0, cascade_delete => 0 },
1098 =head2 patron_list_patrons
1102 Related object: L<Koha::Schema::Result::PatronListPatron>
1106 __PACKAGE__->has_many(
1107 "patron_list_patrons",
1108 "Koha::Schema::Result::PatronListPatron",
1109 { "foreign.borrowernumber" => "self.borrowernumber" },
1110 { cascade_copy => 0, cascade_delete => 0 },
1117 Related object: L<Koha::Schema::Result::PatronList>
1121 __PACKAGE__->has_many(
1123 "Koha::Schema::Result::PatronList",
1124 { "foreign.owner" => "self.borrowernumber" },
1125 { cascade_copy => 0, cascade_delete => 0 },
1132 Related object: L<Koha::Schema::Result::Patronimage>
1136 __PACKAGE__->might_have(
1138 "Koha::Schema::Result::Patronimage",
1139 { "foreign.borrowernumber" => "self.borrowernumber" },
1140 { cascade_copy => 0, cascade_delete => 0 },
1147 Related object: L<Koha::Schema::Result::Rating>
1151 __PACKAGE__->has_many(
1153 "Koha::Schema::Result::Rating",
1154 { "foreign.borrowernumber" => "self.borrowernumber" },
1155 { cascade_copy => 0, cascade_delete => 0 },
1162 Related object: L<Koha::Schema::Result::Reserve>
1166 __PACKAGE__->has_many(
1168 "Koha::Schema::Result::Reserve",
1169 { "foreign.borrowernumber" => "self.borrowernumber" },
1170 { cascade_copy => 0, cascade_delete => 0 },
1177 Related object: L<Koha::Schema::Result::Review>
1181 __PACKAGE__->has_many(
1183 "Koha::Schema::Result::Review",
1184 { "foreign.borrowernumber" => "self.borrowernumber" },
1185 { cascade_copy => 0, cascade_delete => 0 },
1192 Related object: L<Koha::Schema::Result::SmsProvider>
1196 __PACKAGE__->belongs_to(
1198 "Koha::Schema::Result::SmsProvider",
1199 { id => "sms_provider_id" },
1202 join_type => "LEFT",
1203 on_delete => "SET NULL",
1204 on_update => "CASCADE",
1208 =head2 subscriptionroutinglists
1212 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
1216 __PACKAGE__->has_many(
1217 "subscriptionroutinglists",
1218 "Koha::Schema::Result::Subscriptionroutinglist",
1219 { "foreign.borrowernumber" => "self.borrowernumber" },
1220 { cascade_copy => 0, cascade_delete => 0 },
1227 Related object: L<Koha::Schema::Result::TagAll>
1231 __PACKAGE__->has_many(
1233 "Koha::Schema::Result::TagAll",
1234 { "foreign.borrowernumber" => "self.borrowernumber" },
1235 { cascade_copy => 0, cascade_delete => 0 },
1238 =head2 tags_approvals
1242 Related object: L<Koha::Schema::Result::TagsApproval>
1246 __PACKAGE__->has_many(
1248 "Koha::Schema::Result::TagsApproval",
1249 { "foreign.approved_by" => "self.borrowernumber" },
1250 { cascade_copy => 0, cascade_delete => 0 },
1253 =head2 user_permissions
1257 Related object: L<Koha::Schema::Result::UserPermission>
1261 __PACKAGE__->has_many(
1263 "Koha::Schema::Result::UserPermission",
1264 { "foreign.borrowernumber" => "self.borrowernumber" },
1265 { cascade_copy => 0, cascade_delete => 0 },
1268 =head2 virtualshelfcontents
1272 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
1276 __PACKAGE__->has_many(
1277 "virtualshelfcontents",
1278 "Koha::Schema::Result::Virtualshelfcontent",
1279 { "foreign.borrowernumber" => "self.borrowernumber" },
1280 { cascade_copy => 0, cascade_delete => 0 },
1283 =head2 virtualshelfshares
1287 Related object: L<Koha::Schema::Result::Virtualshelfshare>
1291 __PACKAGE__->has_many(
1292 "virtualshelfshares",
1293 "Koha::Schema::Result::Virtualshelfshare",
1294 { "foreign.borrowernumber" => "self.borrowernumber" },
1295 { cascade_copy => 0, cascade_delete => 0 },
1298 =head2 virtualshelves
1302 Related object: L<Koha::Schema::Result::Virtualshelve>
1306 __PACKAGE__->has_many(
1308 "Koha::Schema::Result::Virtualshelve",
1309 { "foreign.owner" => "self.borrowernumber" },
1310 { cascade_copy => 0, cascade_delete => 0 },
1317 Composing rels: L</aqbasketusers> -> basketno
1321 __PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
1327 Composing rels: L</aqbudgetborrowers> -> budget
1331 __PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget");
1337 Composing rels: L</course_instructors> -> course
1341 __PACKAGE__->many_to_many("courses", "course_instructors", "course");
1347 Composing rels: L</aqorder_users> -> ordernumber
1351 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1354 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-31 10:39:35
1355 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Lc6GQ2E7d+tyzTk3v2sWjQ
1357 __PACKAGE__->belongs_to(
1359 "Koha::Schema::Result::Borrower",
1360 { borrowernumber => "guarantorid" },
1363 __PACKAGE__->add_columns(
1364 '+lost' => { is_boolean => 1 },
1365 '+gonenoaddress' => { is_boolean => 1 }
1368 sub koha_objects_class {