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 {