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");
45 data_type: 'mediumtext'
60 data_type: 'mediumtext'
80 data_type: 'mediumtext'
90 data_type: 'mediumtext'
100 data_type: 'mediumtext'
105 data_type: 'longtext'
110 data_type: 'mediumtext'
115 data_type: 'tinytext'
120 data_type: 'longtext'
125 data_type: 'mediumtext'
130 data_type: 'mediumtext'
133 =head2 B_streetnumber
135 accessor: 'b_streetnumber'
136 data_type: 'tinytext'
141 accessor: 'b_streettype'
142 data_type: 'tinytext'
147 accessor: 'b_address'
148 data_type: 'mediumtext'
153 accessor: 'b_address2'
154 data_type: 'mediumtext'
160 data_type: 'longtext'
166 data_type: 'mediumtext'
171 accessor: 'b_zipcode'
172 data_type: 'tinytext'
177 accessor: 'b_country'
178 data_type: 'mediumtext'
184 data_type: 'mediumtext'
190 data_type: 'longtext'
196 datetime_undef_if_invalid: 1
202 default_value: (empty string)
210 default_value: (empty string)
218 datetime_undef_if_invalid: 1
224 datetime_undef_if_invalid: 1
230 datetime_undef_if_invalid: 1
246 datetime_undef_if_invalid: 1
249 =head2 debarredcomment
257 data_type: 'longtext'
260 =head2 contactfirstname
262 data_type: 'mediumtext'
267 data_type: 'mediumtext'
272 data_type: 'longtext'
306 data_type: 'longtext'
327 =head2 altcontactfirstname
329 data_type: 'mediumtext'
332 =head2 altcontactsurname
334 data_type: 'mediumtext'
337 =head2 altcontactaddress1
339 data_type: 'mediumtext'
342 =head2 altcontactaddress2
344 data_type: 'mediumtext'
347 =head2 altcontactaddress3
349 data_type: 'mediumtext'
352 =head2 altcontactstate
354 data_type: 'mediumtext'
357 =head2 altcontactzipcode
359 data_type: 'mediumtext'
362 =head2 altcontactcountry
364 data_type: 'mediumtext'
367 =head2 altcontactphone
369 data_type: 'mediumtext'
372 =head2 smsalertnumber
378 =head2 sms_provider_id
390 =head2 privacy_guarantor_fines
396 =head2 privacy_guarantor_checkouts
402 =head2 checkprevcheckout
405 default_value: 'inherit'
411 data_type: 'timestamp'
412 datetime_undef_if_invalid: 1
413 default_value: current_timestamp
418 data_type: 'datetime'
419 datetime_undef_if_invalid: 1
425 default_value: 'default'
429 =head2 login_attempts
435 =head2 overdrive_auth_token
437 data_type: 'mediumtext'
446 =head2 autorenew_checkouts
454 __PACKAGE__->add_columns(
456 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
458 { data_type => "varchar", is_nullable => 1, size => 32 },
460 { data_type => "longtext", is_nullable => 1 },
462 { data_type => "mediumtext", is_nullable => 1 },
464 { data_type => "longtext", is_nullable => 1 },
466 { data_type => "longtext", is_nullable => 1 },
468 { data_type => "mediumtext", is_nullable => 1 },
470 { data_type => "tinytext", is_nullable => 1 },
472 { data_type => "tinytext", is_nullable => 1 },
474 { data_type => "longtext", is_nullable => 1 },
476 { data_type => "mediumtext", is_nullable => 1 },
478 { data_type => "longtext", is_nullable => 1 },
480 { data_type => "mediumtext", is_nullable => 1 },
482 { data_type => "tinytext", is_nullable => 1 },
484 { data_type => "mediumtext", is_nullable => 1 },
486 { data_type => "longtext", is_nullable => 1 },
488 { data_type => "mediumtext", is_nullable => 1 },
490 { data_type => "tinytext", is_nullable => 1 },
492 { data_type => "longtext", is_nullable => 1 },
494 { data_type => "mediumtext", is_nullable => 1 },
496 { data_type => "mediumtext", is_nullable => 1 },
498 { accessor => "b_streetnumber", data_type => "tinytext", is_nullable => 1 },
500 { accessor => "b_streettype", data_type => "tinytext", is_nullable => 1 },
502 { accessor => "b_address", data_type => "mediumtext", is_nullable => 1 },
504 { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 },
506 { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
508 { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
510 { accessor => "b_zipcode", data_type => "tinytext", is_nullable => 1 },
512 { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 },
514 { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 },
516 { accessor => "b_phone", data_type => "longtext", is_nullable => 1 },
518 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
521 data_type => "varchar",
529 data_type => "varchar",
536 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
538 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
540 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
542 { data_type => "tinyint", is_nullable => 1 },
544 { data_type => "tinyint", is_nullable => 1 },
546 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
548 { data_type => "varchar", is_nullable => 1, size => 255 },
550 { data_type => "longtext", is_nullable => 1 },
552 { data_type => "mediumtext", is_nullable => 1 },
554 { data_type => "mediumtext", is_nullable => 1 },
556 { data_type => "longtext", is_nullable => 1 },
558 { data_type => "varchar", is_nullable => 1, size => 100 },
560 { data_type => "varchar", is_nullable => 1, size => 1 },
562 { data_type => "varchar", is_nullable => 1, size => 60 },
564 { data_type => "integer", is_nullable => 1 },
566 { data_type => "varchar", is_nullable => 1, size => 75 },
568 { data_type => "longtext", is_nullable => 1 },
570 { data_type => "varchar", is_nullable => 1, size => 255 },
572 { data_type => "varchar", is_nullable => 1, size => 80 },
574 { data_type => "varchar", is_nullable => 1, size => 80 },
575 "altcontactfirstname",
576 { data_type => "mediumtext", is_nullable => 1 },
578 { data_type => "mediumtext", is_nullable => 1 },
579 "altcontactaddress1",
580 { data_type => "mediumtext", is_nullable => 1 },
581 "altcontactaddress2",
582 { data_type => "mediumtext", is_nullable => 1 },
583 "altcontactaddress3",
584 { data_type => "mediumtext", is_nullable => 1 },
586 { data_type => "mediumtext", is_nullable => 1 },
588 { data_type => "mediumtext", is_nullable => 1 },
590 { data_type => "mediumtext", is_nullable => 1 },
592 { data_type => "mediumtext", is_nullable => 1 },
594 { data_type => "varchar", is_nullable => 1, size => 50 },
596 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
598 { data_type => "integer", default_value => 1, is_nullable => 0 },
599 "privacy_guarantor_fines",
600 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
601 "privacy_guarantor_checkouts",
602 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
605 data_type => "varchar",
606 default_value => "inherit",
612 data_type => "timestamp",
613 datetime_undef_if_invalid => 1,
614 default_value => \"current_timestamp",
619 data_type => "datetime",
620 datetime_undef_if_invalid => 1,
625 data_type => "varchar",
626 default_value => "default",
631 { data_type => "integer", default_value => 0, is_nullable => 1 },
632 "overdrive_auth_token",
633 { data_type => "mediumtext", is_nullable => 1 },
635 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
636 "autorenew_checkouts",
637 { data_type => "tinyint", default_value => 1, is_nullable => 0 },
644 =item * L</borrowernumber>
650 __PACKAGE__->set_primary_key("borrowernumber");
652 =head1 UNIQUE CONSTRAINTS
658 =item * L</cardnumber>
664 __PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
676 __PACKAGE__->add_unique_constraint("userid", ["userid"]);
684 Related object: L<Koha::Schema::Result::Accountline>
688 __PACKAGE__->has_many(
690 "Koha::Schema::Result::Accountline",
691 { "foreign.borrowernumber" => "self.borrowernumber" },
692 { cascade_copy => 0, cascade_delete => 0 },
695 =head2 accountlines_managers
699 Related object: L<Koha::Schema::Result::Accountline>
703 __PACKAGE__->has_many(
704 "accountlines_managers",
705 "Koha::Schema::Result::Accountline",
706 { "foreign.manager_id" => "self.borrowernumber" },
707 { cascade_copy => 0, cascade_delete => 0 },
710 =head2 advanced_editor_macros
714 Related object: L<Koha::Schema::Result::AdvancedEditorMacro>
718 __PACKAGE__->has_many(
719 "advanced_editor_macros",
720 "Koha::Schema::Result::AdvancedEditorMacro",
721 { "foreign.borrowernumber" => "self.borrowernumber" },
722 { cascade_copy => 0, cascade_delete => 0 },
729 Related object: L<Koha::Schema::Result::ApiKey>
733 __PACKAGE__->has_many(
735 "Koha::Schema::Result::ApiKey",
736 { "foreign.patron_id" => "self.borrowernumber" },
737 { cascade_copy => 0, cascade_delete => 0 },
744 Related object: L<Koha::Schema::Result::Aqbasketuser>
748 __PACKAGE__->has_many(
750 "Koha::Schema::Result::Aqbasketuser",
751 { "foreign.borrowernumber" => "self.borrowernumber" },
752 { cascade_copy => 0, cascade_delete => 0 },
755 =head2 aqbudgetborrowers
759 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
763 __PACKAGE__->has_many(
765 "Koha::Schema::Result::Aqbudgetborrower",
766 { "foreign.borrowernumber" => "self.borrowernumber" },
767 { cascade_copy => 0, cascade_delete => 0 },
774 Related object: L<Koha::Schema::Result::AqorderUser>
778 __PACKAGE__->has_many(
780 "Koha::Schema::Result::AqorderUser",
781 { "foreign.borrowernumber" => "self.borrowernumber" },
782 { cascade_copy => 0, cascade_delete => 0 },
789 Related object: L<Koha::Schema::Result::Aqorder>
793 __PACKAGE__->has_many(
795 "Koha::Schema::Result::Aqorder",
796 { "foreign.created_by" => "self.borrowernumber" },
797 { cascade_copy => 0, cascade_delete => 0 },
800 =head2 article_requests
804 Related object: L<Koha::Schema::Result::ArticleRequest>
808 __PACKAGE__->has_many(
810 "Koha::Schema::Result::ArticleRequest",
811 { "foreign.borrowernumber" => "self.borrowernumber" },
812 { cascade_copy => 0, cascade_delete => 0 },
815 =head2 borrower_attributes
819 Related object: L<Koha::Schema::Result::BorrowerAttribute>
823 __PACKAGE__->has_many(
824 "borrower_attributes",
825 "Koha::Schema::Result::BorrowerAttribute",
826 { "foreign.borrowernumber" => "self.borrowernumber" },
827 { cascade_copy => 0, cascade_delete => 0 },
830 =head2 borrower_debarments
834 Related object: L<Koha::Schema::Result::BorrowerDebarment>
838 __PACKAGE__->has_many(
839 "borrower_debarments",
840 "Koha::Schema::Result::BorrowerDebarment",
841 { "foreign.borrowernumber" => "self.borrowernumber" },
842 { cascade_copy => 0, cascade_delete => 0 },
845 =head2 borrower_files
849 Related object: L<Koha::Schema::Result::BorrowerFile>
853 __PACKAGE__->has_many(
855 "Koha::Schema::Result::BorrowerFile",
856 { "foreign.borrowernumber" => "self.borrowernumber" },
857 { cascade_copy => 0, cascade_delete => 0 },
860 =head2 borrower_message_preferences
864 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
868 __PACKAGE__->has_many(
869 "borrower_message_preferences",
870 "Koha::Schema::Result::BorrowerMessagePreference",
871 { "foreign.borrowernumber" => "self.borrowernumber" },
872 { cascade_copy => 0, cascade_delete => 0 },
875 =head2 borrower_relationships_guarantees
879 Related object: L<Koha::Schema::Result::BorrowerRelationship>
883 __PACKAGE__->has_many(
884 "borrower_relationships_guarantees",
885 "Koha::Schema::Result::BorrowerRelationship",
886 { "foreign.guarantee_id" => "self.borrowernumber" },
887 { cascade_copy => 0, cascade_delete => 0 },
890 =head2 borrower_relationships_guarantors
894 Related object: L<Koha::Schema::Result::BorrowerRelationship>
898 __PACKAGE__->has_many(
899 "borrower_relationships_guarantors",
900 "Koha::Schema::Result::BorrowerRelationship",
901 { "foreign.guarantor_id" => "self.borrowernumber" },
902 { cascade_copy => 0, cascade_delete => 0 },
909 Related object: L<Koha::Schema::Result::Branch>
913 __PACKAGE__->belongs_to(
915 "Koha::Schema::Result::Branch",
916 { branchcode => "branchcode" },
917 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
920 =head2 cash_register_actions
924 Related object: L<Koha::Schema::Result::CashRegisterAction>
928 __PACKAGE__->has_many(
929 "cash_register_actions",
930 "Koha::Schema::Result::CashRegisterAction",
931 { "foreign.manager_id" => "self.borrowernumber" },
932 { cascade_copy => 0, cascade_delete => 0 },
939 Related object: L<Koha::Schema::Result::Category>
943 __PACKAGE__->belongs_to(
945 "Koha::Schema::Result::Category",
946 { categorycode => "categorycode" },
947 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
950 =head2 club_enrollments
954 Related object: L<Koha::Schema::Result::ClubEnrollment>
958 __PACKAGE__->has_many(
960 "Koha::Schema::Result::ClubEnrollment",
961 { "foreign.borrowernumber" => "self.borrowernumber" },
962 { cascade_copy => 0, cascade_delete => 0 },
965 =head2 club_holds_to_patron_holds
969 Related object: L<Koha::Schema::Result::ClubHoldsToPatronHold>
973 __PACKAGE__->has_many(
974 "club_holds_to_patron_holds",
975 "Koha::Schema::Result::ClubHoldsToPatronHold",
976 { "foreign.patron_id" => "self.borrowernumber" },
977 { cascade_copy => 0, cascade_delete => 0 },
980 =head2 course_instructors
984 Related object: L<Koha::Schema::Result::CourseInstructor>
988 __PACKAGE__->has_many(
989 "course_instructors",
990 "Koha::Schema::Result::CourseInstructor",
991 { "foreign.borrowernumber" => "self.borrowernumber" },
992 { cascade_copy => 0, cascade_delete => 0 },
995 =head2 creator_batches
999 Related object: L<Koha::Schema::Result::CreatorBatch>
1003 __PACKAGE__->has_many(
1005 "Koha::Schema::Result::CreatorBatch",
1006 { "foreign.borrower_number" => "self.borrowernumber" },
1007 { cascade_copy => 0, cascade_delete => 0 },
1014 Related object: L<Koha::Schema::Result::Discharge>
1018 __PACKAGE__->has_many(
1020 "Koha::Schema::Result::Discharge",
1021 { "foreign.borrower" => "self.borrowernumber" },
1022 { cascade_copy => 0, cascade_delete => 0 },
1025 =head2 hold_fill_targets
1029 Related object: L<Koha::Schema::Result::HoldFillTarget>
1033 __PACKAGE__->has_many(
1034 "hold_fill_targets",
1035 "Koha::Schema::Result::HoldFillTarget",
1036 { "foreign.borrowernumber" => "self.borrowernumber" },
1037 { cascade_copy => 0, cascade_delete => 0 },
1040 =head2 housebound_profile
1044 Related object: L<Koha::Schema::Result::HouseboundProfile>
1048 __PACKAGE__->might_have(
1049 "housebound_profile",
1050 "Koha::Schema::Result::HouseboundProfile",
1051 { "foreign.borrowernumber" => "self.borrowernumber" },
1052 { cascade_copy => 0, cascade_delete => 0 },
1055 =head2 housebound_role
1059 Related object: L<Koha::Schema::Result::HouseboundRole>
1063 __PACKAGE__->might_have(
1065 "Koha::Schema::Result::HouseboundRole",
1066 { "foreign.borrowernumber_id" => "self.borrowernumber" },
1067 { cascade_copy => 0, cascade_delete => 0 },
1070 =head2 housebound_visit_chooser_brwnumbers
1074 Related object: L<Koha::Schema::Result::HouseboundVisit>
1078 __PACKAGE__->has_many(
1079 "housebound_visit_chooser_brwnumbers",
1080 "Koha::Schema::Result::HouseboundVisit",
1081 { "foreign.chooser_brwnumber" => "self.borrowernumber" },
1082 { cascade_copy => 0, cascade_delete => 0 },
1085 =head2 housebound_visit_deliverer_brwnumbers
1089 Related object: L<Koha::Schema::Result::HouseboundVisit>
1093 __PACKAGE__->has_many(
1094 "housebound_visit_deliverer_brwnumbers",
1095 "Koha::Schema::Result::HouseboundVisit",
1096 { "foreign.deliverer_brwnumber" => "self.borrowernumber" },
1097 { cascade_copy => 0, cascade_delete => 0 },
1104 Related object: L<Koha::Schema::Result::Illcomment>
1108 __PACKAGE__->has_many(
1110 "Koha::Schema::Result::Illcomment",
1111 { "foreign.borrowernumber" => "self.borrowernumber" },
1112 { cascade_copy => 0, cascade_delete => 0 },
1119 Related object: L<Koha::Schema::Result::Illrequest>
1123 __PACKAGE__->has_many(
1125 "Koha::Schema::Result::Illrequest",
1126 { "foreign.borrowernumber" => "self.borrowernumber" },
1127 { cascade_copy => 0, cascade_delete => 0 },
1134 Related object: L<Koha::Schema::Result::Issue>
1138 __PACKAGE__->has_many(
1140 "Koha::Schema::Result::Issue",
1141 { "foreign.borrowernumber" => "self.borrowernumber" },
1142 { cascade_copy => 0, cascade_delete => 0 },
1145 =head2 items_last_borrowers
1149 Related object: L<Koha::Schema::Result::ItemsLastBorrower>
1153 __PACKAGE__->has_many(
1154 "items_last_borrowers",
1155 "Koha::Schema::Result::ItemsLastBorrower",
1156 { "foreign.borrowernumber" => "self.borrowernumber" },
1157 { cascade_copy => 0, cascade_delete => 0 },
1160 =head2 message_queues
1164 Related object: L<Koha::Schema::Result::MessageQueue>
1168 __PACKAGE__->has_many(
1170 "Koha::Schema::Result::MessageQueue",
1171 { "foreign.borrowernumber" => "self.borrowernumber" },
1172 { cascade_copy => 0, cascade_delete => 0 },
1179 Related object: L<Koha::Schema::Result::Message>
1183 __PACKAGE__->has_many(
1185 "Koha::Schema::Result::Message",
1186 { "foreign.manager_id" => "self.borrowernumber" },
1187 { cascade_copy => 0, cascade_delete => 0 },
1190 =head2 messages_borrowernumbers
1194 Related object: L<Koha::Schema::Result::Message>
1198 __PACKAGE__->has_many(
1199 "messages_borrowernumbers",
1200 "Koha::Schema::Result::Message",
1201 { "foreign.borrowernumber" => "self.borrowernumber" },
1202 { cascade_copy => 0, cascade_delete => 0 },
1209 Related object: L<Koha::Schema::Result::OldIssue>
1213 __PACKAGE__->has_many(
1215 "Koha::Schema::Result::OldIssue",
1216 { "foreign.borrowernumber" => "self.borrowernumber" },
1217 { cascade_copy => 0, cascade_delete => 0 },
1224 Related object: L<Koha::Schema::Result::OldReserve>
1228 __PACKAGE__->has_many(
1230 "Koha::Schema::Result::OldReserve",
1231 { "foreign.borrowernumber" => "self.borrowernumber" },
1232 { cascade_copy => 0, cascade_delete => 0 },
1239 Related object: L<Koha::Schema::Result::OpacNews>
1243 __PACKAGE__->has_many(
1245 "Koha::Schema::Result::OpacNews",
1246 { "foreign.borrowernumber" => "self.borrowernumber" },
1247 { cascade_copy => 0, cascade_delete => 0 },
1250 =head2 patron_consents
1254 Related object: L<Koha::Schema::Result::PatronConsent>
1258 __PACKAGE__->has_many(
1260 "Koha::Schema::Result::PatronConsent",
1261 { "foreign.borrowernumber" => "self.borrowernumber" },
1262 { cascade_copy => 0, cascade_delete => 0 },
1265 =head2 patron_list_patrons
1269 Related object: L<Koha::Schema::Result::PatronListPatron>
1273 __PACKAGE__->has_many(
1274 "patron_list_patrons",
1275 "Koha::Schema::Result::PatronListPatron",
1276 { "foreign.borrowernumber" => "self.borrowernumber" },
1277 { cascade_copy => 0, cascade_delete => 0 },
1284 Related object: L<Koha::Schema::Result::PatronList>
1288 __PACKAGE__->has_many(
1290 "Koha::Schema::Result::PatronList",
1291 { "foreign.owner" => "self.borrowernumber" },
1292 { cascade_copy => 0, cascade_delete => 0 },
1299 Related object: L<Koha::Schema::Result::Patronimage>
1303 __PACKAGE__->might_have(
1305 "Koha::Schema::Result::Patronimage",
1306 { "foreign.borrowernumber" => "self.borrowernumber" },
1307 { cascade_copy => 0, cascade_delete => 0 },
1310 =head2 problem_reports
1314 Related object: L<Koha::Schema::Result::ProblemReport>
1318 __PACKAGE__->has_many(
1320 "Koha::Schema::Result::ProblemReport",
1321 { "foreign.borrowernumber" => "self.borrowernumber" },
1322 { cascade_copy => 0, cascade_delete => 0 },
1329 Related object: L<Koha::Schema::Result::Rating>
1333 __PACKAGE__->has_many(
1335 "Koha::Schema::Result::Rating",
1336 { "foreign.borrowernumber" => "self.borrowernumber" },
1337 { cascade_copy => 0, cascade_delete => 0 },
1344 Related object: L<Koha::Schema::Result::Reserve>
1348 __PACKAGE__->has_many(
1350 "Koha::Schema::Result::Reserve",
1351 { "foreign.borrowernumber" => "self.borrowernumber" },
1352 { cascade_copy => 0, cascade_delete => 0 },
1355 =head2 return_claims_borrowernumbers
1359 Related object: L<Koha::Schema::Result::ReturnClaim>
1363 __PACKAGE__->has_many(
1364 "return_claims_borrowernumbers",
1365 "Koha::Schema::Result::ReturnClaim",
1366 { "foreign.borrowernumber" => "self.borrowernumber" },
1367 { cascade_copy => 0, cascade_delete => 0 },
1370 =head2 return_claims_created_by
1374 Related object: L<Koha::Schema::Result::ReturnClaim>
1378 __PACKAGE__->has_many(
1379 "return_claims_created_by",
1380 "Koha::Schema::Result::ReturnClaim",
1381 { "foreign.created_by" => "self.borrowernumber" },
1382 { cascade_copy => 0, cascade_delete => 0 },
1385 =head2 return_claims_resolved_by
1389 Related object: L<Koha::Schema::Result::ReturnClaim>
1393 __PACKAGE__->has_many(
1394 "return_claims_resolved_by",
1395 "Koha::Schema::Result::ReturnClaim",
1396 { "foreign.resolved_by" => "self.borrowernumber" },
1397 { cascade_copy => 0, cascade_delete => 0 },
1400 =head2 return_claims_updated_by
1404 Related object: L<Koha::Schema::Result::ReturnClaim>
1408 __PACKAGE__->has_many(
1409 "return_claims_updated_by",
1410 "Koha::Schema::Result::ReturnClaim",
1411 { "foreign.updated_by" => "self.borrowernumber" },
1412 { cascade_copy => 0, cascade_delete => 0 },
1419 Related object: L<Koha::Schema::Result::Review>
1423 __PACKAGE__->has_many(
1425 "Koha::Schema::Result::Review",
1426 { "foreign.borrowernumber" => "self.borrowernumber" },
1427 { cascade_copy => 0, cascade_delete => 0 },
1434 Related object: L<Koha::Schema::Result::SmsProvider>
1438 __PACKAGE__->belongs_to(
1440 "Koha::Schema::Result::SmsProvider",
1441 { id => "sms_provider_id" },
1444 join_type => "LEFT",
1445 on_delete => "SET NULL",
1446 on_update => "CASCADE",
1450 =head2 subscriptionroutinglists
1454 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
1458 __PACKAGE__->has_many(
1459 "subscriptionroutinglists",
1460 "Koha::Schema::Result::Subscriptionroutinglist",
1461 { "foreign.borrowernumber" => "self.borrowernumber" },
1462 { cascade_copy => 0, cascade_delete => 0 },
1465 =head2 suggestions_acceptedbies
1469 Related object: L<Koha::Schema::Result::Suggestion>
1473 __PACKAGE__->has_many(
1474 "suggestions_acceptedbies",
1475 "Koha::Schema::Result::Suggestion",
1476 { "foreign.acceptedby" => "self.borrowernumber" },
1477 { cascade_copy => 0, cascade_delete => 0 },
1480 =head2 suggestions_lastmodificationbies
1484 Related object: L<Koha::Schema::Result::Suggestion>
1488 __PACKAGE__->has_many(
1489 "suggestions_lastmodificationbies",
1490 "Koha::Schema::Result::Suggestion",
1491 { "foreign.lastmodificationby" => "self.borrowernumber" },
1492 { cascade_copy => 0, cascade_delete => 0 },
1495 =head2 suggestions_managedbies
1499 Related object: L<Koha::Schema::Result::Suggestion>
1503 __PACKAGE__->has_many(
1504 "suggestions_managedbies",
1505 "Koha::Schema::Result::Suggestion",
1506 { "foreign.managedby" => "self.borrowernumber" },
1507 { cascade_copy => 0, cascade_delete => 0 },
1510 =head2 suggestions_rejectedbies
1514 Related object: L<Koha::Schema::Result::Suggestion>
1518 __PACKAGE__->has_many(
1519 "suggestions_rejectedbies",
1520 "Koha::Schema::Result::Suggestion",
1521 { "foreign.rejectedby" => "self.borrowernumber" },
1522 { cascade_copy => 0, cascade_delete => 0 },
1525 =head2 suggestions_suggestedbies
1529 Related object: L<Koha::Schema::Result::Suggestion>
1533 __PACKAGE__->has_many(
1534 "suggestions_suggestedbies",
1535 "Koha::Schema::Result::Suggestion",
1536 { "foreign.suggestedby" => "self.borrowernumber" },
1537 { cascade_copy => 0, cascade_delete => 0 },
1544 Related object: L<Koha::Schema::Result::TagAll>
1548 __PACKAGE__->has_many(
1550 "Koha::Schema::Result::TagAll",
1551 { "foreign.borrowernumber" => "self.borrowernumber" },
1552 { cascade_copy => 0, cascade_delete => 0 },
1555 =head2 tags_approvals
1559 Related object: L<Koha::Schema::Result::TagsApproval>
1563 __PACKAGE__->has_many(
1565 "Koha::Schema::Result::TagsApproval",
1566 { "foreign.approved_by" => "self.borrowernumber" },
1567 { cascade_copy => 0, cascade_delete => 0 },
1570 =head2 user_permissions
1574 Related object: L<Koha::Schema::Result::UserPermission>
1578 __PACKAGE__->has_many(
1580 "Koha::Schema::Result::UserPermission",
1581 { "foreign.borrowernumber" => "self.borrowernumber" },
1582 { cascade_copy => 0, cascade_delete => 0 },
1585 =head2 virtualshelfcontents
1589 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
1593 __PACKAGE__->has_many(
1594 "virtualshelfcontents",
1595 "Koha::Schema::Result::Virtualshelfcontent",
1596 { "foreign.borrowernumber" => "self.borrowernumber" },
1597 { cascade_copy => 0, cascade_delete => 0 },
1600 =head2 virtualshelfshares
1604 Related object: L<Koha::Schema::Result::Virtualshelfshare>
1608 __PACKAGE__->has_many(
1609 "virtualshelfshares",
1610 "Koha::Schema::Result::Virtualshelfshare",
1611 { "foreign.borrowernumber" => "self.borrowernumber" },
1612 { cascade_copy => 0, cascade_delete => 0 },
1615 =head2 virtualshelves
1619 Related object: L<Koha::Schema::Result::Virtualshelve>
1623 __PACKAGE__->has_many(
1625 "Koha::Schema::Result::Virtualshelve",
1626 { "foreign.owner" => "self.borrowernumber" },
1627 { cascade_copy => 0, cascade_delete => 0 },
1634 Composing rels: L</aqbasketusers> -> basketno
1638 __PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
1644 Composing rels: L</aqbudgetborrowers> -> budget
1648 __PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget");
1654 Composing rels: L</course_instructors> -> course
1658 __PACKAGE__->many_to_many("courses", "course_instructors", "course");
1664 Composing rels: L</aqorder_users> -> ordernumber
1668 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1671 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-06-25 08:47:42
1672 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:o+gWN0ND3K07hqLwAoNmMA
1674 __PACKAGE__->add_columns(
1675 '+anonymized' => { is_boolean => 1 },
1676 '+lost' => { is_boolean => 1 },
1677 '+gonenoaddress' => { is_boolean => 1 },
1678 '+privacy_guarantor_fines' => { is_boolean => 1 },
1679 '+autorenew_checkouts' => { is_boolean => 1 }
1682 sub koha_objects_class {
1685 sub koha_object_class {