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
433 default_value: 'default'
437 =head2 overdrive_auth_token
444 __PACKAGE__->add_columns(
446 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
448 { data_type => "varchar", is_nullable => 1, size => 16 },
450 { data_type => "mediumtext", is_nullable => 0 },
452 { data_type => "text", is_nullable => 1 },
454 { data_type => "mediumtext", is_nullable => 1 },
456 { data_type => "mediumtext", is_nullable => 1 },
458 { data_type => "text", is_nullable => 1 },
460 { data_type => "varchar", is_nullable => 1, size => 10 },
462 { data_type => "varchar", is_nullable => 1, size => 50 },
464 { data_type => "mediumtext", is_nullable => 0 },
466 { data_type => "text", is_nullable => 1 },
468 { data_type => "mediumtext", is_nullable => 0 },
470 { data_type => "text", is_nullable => 1 },
472 { data_type => "varchar", is_nullable => 1, size => 25 },
474 { data_type => "text", is_nullable => 1 },
476 { data_type => "mediumtext", is_nullable => 1 },
478 { data_type => "text", is_nullable => 1 },
480 { data_type => "varchar", is_nullable => 1, size => 50 },
482 { data_type => "mediumtext", is_nullable => 1 },
484 { data_type => "text", is_nullable => 1 },
486 { data_type => "text", is_nullable => 1 },
489 accessor => "b_streetnumber",
490 data_type => "varchar",
496 accessor => "b_streettype",
497 data_type => "varchar",
503 accessor => "b_address",
504 data_type => "varchar",
509 { accessor => "b_address2", data_type => "text", is_nullable => 1 },
511 { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
513 { accessor => "b_state", data_type => "text", is_nullable => 1 },
516 accessor => "b_zipcode",
517 data_type => "varchar",
522 { accessor => "b_country", data_type => "text", is_nullable => 1 },
524 { accessor => "b_email", data_type => "text", is_nullable => 1 },
526 { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
528 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
531 data_type => "varchar",
539 data_type => "varchar",
546 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
548 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
550 { data_type => "tinyint", is_nullable => 1 },
552 { data_type => "tinyint", is_nullable => 1 },
554 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
556 { data_type => "varchar", is_nullable => 1, size => 255 },
558 { data_type => "mediumtext", is_nullable => 1 },
560 { data_type => "text", is_nullable => 1 },
562 { data_type => "text", is_nullable => 1 },
564 { data_type => "integer", is_nullable => 1 },
566 { data_type => "mediumtext", is_nullable => 1 },
568 { data_type => "varchar", is_nullable => 1, size => 100 },
570 { data_type => "varchar", is_nullable => 1, size => 1 },
572 { data_type => "varchar", is_nullable => 1, size => 60 },
574 { data_type => "integer", is_nullable => 1 },
576 { data_type => "varchar", is_nullable => 1, size => 75 },
578 { data_type => "mediumtext", is_nullable => 1 },
580 { data_type => "varchar", is_nullable => 1, size => 255 },
582 { data_type => "varchar", is_nullable => 1, size => 80 },
584 { data_type => "varchar", is_nullable => 1, size => 80 },
585 "altcontactfirstname",
586 { data_type => "varchar", is_nullable => 1, size => 255 },
588 { data_type => "varchar", is_nullable => 1, size => 255 },
589 "altcontactaddress1",
590 { data_type => "varchar", is_nullable => 1, size => 255 },
591 "altcontactaddress2",
592 { data_type => "varchar", is_nullable => 1, size => 255 },
593 "altcontactaddress3",
594 { data_type => "varchar", is_nullable => 1, size => 255 },
596 { data_type => "text", is_nullable => 1 },
598 { data_type => "varchar", is_nullable => 1, size => 50 },
600 { data_type => "text", is_nullable => 1 },
602 { data_type => "varchar", is_nullable => 1, size => 50 },
604 { data_type => "varchar", is_nullable => 1, size => 50 },
606 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
608 { data_type => "integer", default_value => 1, is_nullable => 0 },
609 "privacy_guarantor_checkouts",
610 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
613 data_type => "varchar",
614 default_value => "inherit",
620 data_type => "timestamp",
621 datetime_undef_if_invalid => 1,
622 default_value => \"current_timestamp",
627 data_type => "datetime",
628 datetime_undef_if_invalid => 1,
633 data_type => "varchar",
634 default_value => "default",
638 "overdrive_auth_token",
639 { data_type => "text", is_nullable => 1 },
646 =item * L</borrowernumber>
652 __PACKAGE__->set_primary_key("borrowernumber");
654 =head1 UNIQUE CONSTRAINTS
660 =item * L</cardnumber>
666 __PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
678 __PACKAGE__->add_unique_constraint("userid", ["userid"]);
686 Related object: L<Koha::Schema::Result::Accountline>
690 __PACKAGE__->has_many(
692 "Koha::Schema::Result::Accountline",
693 { "foreign.borrowernumber" => "self.borrowernumber" },
694 { cascade_copy => 0, cascade_delete => 0 },
697 =head2 accountoffsets
701 Related object: L<Koha::Schema::Result::Accountoffset>
705 __PACKAGE__->has_many(
707 "Koha::Schema::Result::Accountoffset",
708 { "foreign.borrowernumber" => "self.borrowernumber" },
709 { cascade_copy => 0, cascade_delete => 0 },
716 Related object: L<Koha::Schema::Result::Aqbasketuser>
720 __PACKAGE__->has_many(
722 "Koha::Schema::Result::Aqbasketuser",
723 { "foreign.borrowernumber" => "self.borrowernumber" },
724 { cascade_copy => 0, cascade_delete => 0 },
727 =head2 aqbudgetborrowers
731 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
735 __PACKAGE__->has_many(
737 "Koha::Schema::Result::Aqbudgetborrower",
738 { "foreign.borrowernumber" => "self.borrowernumber" },
739 { cascade_copy => 0, cascade_delete => 0 },
746 Related object: L<Koha::Schema::Result::AqorderUser>
750 __PACKAGE__->has_many(
752 "Koha::Schema::Result::AqorderUser",
753 { "foreign.borrowernumber" => "self.borrowernumber" },
754 { cascade_copy => 0, cascade_delete => 0 },
757 =head2 article_requests
761 Related object: L<Koha::Schema::Result::ArticleRequest>
765 __PACKAGE__->has_many(
767 "Koha::Schema::Result::ArticleRequest",
768 { "foreign.borrowernumber" => "self.borrowernumber" },
769 { cascade_copy => 0, cascade_delete => 0 },
772 =head2 borrower_attributes
776 Related object: L<Koha::Schema::Result::BorrowerAttribute>
780 __PACKAGE__->has_many(
781 "borrower_attributes",
782 "Koha::Schema::Result::BorrowerAttribute",
783 { "foreign.borrowernumber" => "self.borrowernumber" },
784 { cascade_copy => 0, cascade_delete => 0 },
787 =head2 borrower_debarments
791 Related object: L<Koha::Schema::Result::BorrowerDebarment>
795 __PACKAGE__->has_many(
796 "borrower_debarments",
797 "Koha::Schema::Result::BorrowerDebarment",
798 { "foreign.borrowernumber" => "self.borrowernumber" },
799 { cascade_copy => 0, cascade_delete => 0 },
802 =head2 borrower_files
806 Related object: L<Koha::Schema::Result::BorrowerFile>
810 __PACKAGE__->has_many(
812 "Koha::Schema::Result::BorrowerFile",
813 { "foreign.borrowernumber" => "self.borrowernumber" },
814 { cascade_copy => 0, cascade_delete => 0 },
817 =head2 borrower_message_preferences
821 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
825 __PACKAGE__->has_many(
826 "borrower_message_preferences",
827 "Koha::Schema::Result::BorrowerMessagePreference",
828 { "foreign.borrowernumber" => "self.borrowernumber" },
829 { cascade_copy => 0, cascade_delete => 0 },
832 =head2 borrower_syncs
836 Related object: L<Koha::Schema::Result::BorrowerSync>
840 __PACKAGE__->has_many(
842 "Koha::Schema::Result::BorrowerSync",
843 { "foreign.borrowernumber" => "self.borrowernumber" },
844 { cascade_copy => 0, cascade_delete => 0 },
851 Related object: L<Koha::Schema::Result::Branch>
855 __PACKAGE__->belongs_to(
857 "Koha::Schema::Result::Branch",
858 { branchcode => "branchcode" },
859 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
866 Related object: L<Koha::Schema::Result::Category>
870 __PACKAGE__->belongs_to(
872 "Koha::Schema::Result::Category",
873 { categorycode => "categorycode" },
874 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
877 =head2 club_enrollments
881 Related object: L<Koha::Schema::Result::ClubEnrollment>
885 __PACKAGE__->has_many(
887 "Koha::Schema::Result::ClubEnrollment",
888 { "foreign.borrowernumber" => "self.borrowernumber" },
889 { cascade_copy => 0, cascade_delete => 0 },
892 =head2 course_instructors
896 Related object: L<Koha::Schema::Result::CourseInstructor>
900 __PACKAGE__->has_many(
901 "course_instructors",
902 "Koha::Schema::Result::CourseInstructor",
903 { "foreign.borrowernumber" => "self.borrowernumber" },
904 { cascade_copy => 0, cascade_delete => 0 },
907 =head2 creator_batches
911 Related object: L<Koha::Schema::Result::CreatorBatch>
915 __PACKAGE__->has_many(
917 "Koha::Schema::Result::CreatorBatch",
918 { "foreign.borrower_number" => "self.borrowernumber" },
919 { cascade_copy => 0, cascade_delete => 0 },
926 Related object: L<Koha::Schema::Result::Discharge>
930 __PACKAGE__->has_many(
932 "Koha::Schema::Result::Discharge",
933 { "foreign.borrower" => "self.borrowernumber" },
934 { cascade_copy => 0, cascade_delete => 0 },
937 =head2 hold_fill_targets
941 Related object: L<Koha::Schema::Result::HoldFillTarget>
945 __PACKAGE__->has_many(
947 "Koha::Schema::Result::HoldFillTarget",
948 { "foreign.borrowernumber" => "self.borrowernumber" },
949 { cascade_copy => 0, cascade_delete => 0 },
952 =head2 housebound_profile
956 Related object: L<Koha::Schema::Result::HouseboundProfile>
960 __PACKAGE__->might_have(
961 "housebound_profile",
962 "Koha::Schema::Result::HouseboundProfile",
963 { "foreign.borrowernumber" => "self.borrowernumber" },
964 { cascade_copy => 0, cascade_delete => 0 },
967 =head2 housebound_role
971 Related object: L<Koha::Schema::Result::HouseboundRole>
975 __PACKAGE__->might_have(
977 "Koha::Schema::Result::HouseboundRole",
978 { "foreign.borrowernumber_id" => "self.borrowernumber" },
979 { cascade_copy => 0, cascade_delete => 0 },
982 =head2 housebound_visit_chooser_brwnumbers
986 Related object: L<Koha::Schema::Result::HouseboundVisit>
990 __PACKAGE__->has_many(
991 "housebound_visit_chooser_brwnumbers",
992 "Koha::Schema::Result::HouseboundVisit",
993 { "foreign.chooser_brwnumber" => "self.borrowernumber" },
994 { cascade_copy => 0, cascade_delete => 0 },
997 =head2 housebound_visit_deliverer_brwnumbers
1001 Related object: L<Koha::Schema::Result::HouseboundVisit>
1005 __PACKAGE__->has_many(
1006 "housebound_visit_deliverer_brwnumbers",
1007 "Koha::Schema::Result::HouseboundVisit",
1008 { "foreign.deliverer_brwnumber" => "self.borrowernumber" },
1009 { cascade_copy => 0, cascade_delete => 0 },
1016 Related object: L<Koha::Schema::Result::Issue>
1020 __PACKAGE__->has_many(
1022 "Koha::Schema::Result::Issue",
1023 { "foreign.borrowernumber" => "self.borrowernumber" },
1024 { cascade_copy => 0, cascade_delete => 0 },
1027 =head2 items_last_borrowers
1031 Related object: L<Koha::Schema::Result::ItemsLastBorrower>
1035 __PACKAGE__->has_many(
1036 "items_last_borrowers",
1037 "Koha::Schema::Result::ItemsLastBorrower",
1038 { "foreign.borrowernumber" => "self.borrowernumber" },
1039 { cascade_copy => 0, cascade_delete => 0 },
1042 =head2 message_queues
1046 Related object: L<Koha::Schema::Result::MessageQueue>
1050 __PACKAGE__->has_many(
1052 "Koha::Schema::Result::MessageQueue",
1053 { "foreign.borrowernumber" => "self.borrowernumber" },
1054 { cascade_copy => 0, cascade_delete => 0 },
1061 Related object: L<Koha::Schema::Result::Message>
1065 __PACKAGE__->has_many(
1067 "Koha::Schema::Result::Message",
1068 { "foreign.manager_id" => "self.borrowernumber" },
1069 { cascade_copy => 0, cascade_delete => 0 },
1076 Related object: L<Koha::Schema::Result::OldIssue>
1080 __PACKAGE__->has_many(
1082 "Koha::Schema::Result::OldIssue",
1083 { "foreign.borrowernumber" => "self.borrowernumber" },
1084 { cascade_copy => 0, cascade_delete => 0 },
1091 Related object: L<Koha::Schema::Result::OldReserve>
1095 __PACKAGE__->has_many(
1097 "Koha::Schema::Result::OldReserve",
1098 { "foreign.borrowernumber" => "self.borrowernumber" },
1099 { cascade_copy => 0, cascade_delete => 0 },
1106 Related object: L<Koha::Schema::Result::OpacNews>
1110 __PACKAGE__->has_many(
1112 "Koha::Schema::Result::OpacNews",
1113 { "foreign.borrowernumber" => "self.borrowernumber" },
1114 { cascade_copy => 0, cascade_delete => 0 },
1117 =head2 patron_list_patrons
1121 Related object: L<Koha::Schema::Result::PatronListPatron>
1125 __PACKAGE__->has_many(
1126 "patron_list_patrons",
1127 "Koha::Schema::Result::PatronListPatron",
1128 { "foreign.borrowernumber" => "self.borrowernumber" },
1129 { cascade_copy => 0, cascade_delete => 0 },
1136 Related object: L<Koha::Schema::Result::PatronList>
1140 __PACKAGE__->has_many(
1142 "Koha::Schema::Result::PatronList",
1143 { "foreign.owner" => "self.borrowernumber" },
1144 { cascade_copy => 0, cascade_delete => 0 },
1151 Related object: L<Koha::Schema::Result::Patronimage>
1155 __PACKAGE__->might_have(
1157 "Koha::Schema::Result::Patronimage",
1158 { "foreign.borrowernumber" => "self.borrowernumber" },
1159 { cascade_copy => 0, cascade_delete => 0 },
1166 Related object: L<Koha::Schema::Result::Rating>
1170 __PACKAGE__->has_many(
1172 "Koha::Schema::Result::Rating",
1173 { "foreign.borrowernumber" => "self.borrowernumber" },
1174 { cascade_copy => 0, cascade_delete => 0 },
1181 Related object: L<Koha::Schema::Result::Reserve>
1185 __PACKAGE__->has_many(
1187 "Koha::Schema::Result::Reserve",
1188 { "foreign.borrowernumber" => "self.borrowernumber" },
1189 { cascade_copy => 0, cascade_delete => 0 },
1196 Related object: L<Koha::Schema::Result::Review>
1200 __PACKAGE__->has_many(
1202 "Koha::Schema::Result::Review",
1203 { "foreign.borrowernumber" => "self.borrowernumber" },
1204 { cascade_copy => 0, cascade_delete => 0 },
1211 Related object: L<Koha::Schema::Result::SmsProvider>
1215 __PACKAGE__->belongs_to(
1217 "Koha::Schema::Result::SmsProvider",
1218 { id => "sms_provider_id" },
1221 join_type => "LEFT",
1222 on_delete => "SET NULL",
1223 on_update => "CASCADE",
1227 =head2 subscriptionroutinglists
1231 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
1235 __PACKAGE__->has_many(
1236 "subscriptionroutinglists",
1237 "Koha::Schema::Result::Subscriptionroutinglist",
1238 { "foreign.borrowernumber" => "self.borrowernumber" },
1239 { cascade_copy => 0, cascade_delete => 0 },
1246 Related object: L<Koha::Schema::Result::TagAll>
1250 __PACKAGE__->has_many(
1252 "Koha::Schema::Result::TagAll",
1253 { "foreign.borrowernumber" => "self.borrowernumber" },
1254 { cascade_copy => 0, cascade_delete => 0 },
1257 =head2 tags_approvals
1261 Related object: L<Koha::Schema::Result::TagsApproval>
1265 __PACKAGE__->has_many(
1267 "Koha::Schema::Result::TagsApproval",
1268 { "foreign.approved_by" => "self.borrowernumber" },
1269 { cascade_copy => 0, cascade_delete => 0 },
1272 =head2 user_permissions
1276 Related object: L<Koha::Schema::Result::UserPermission>
1280 __PACKAGE__->has_many(
1282 "Koha::Schema::Result::UserPermission",
1283 { "foreign.borrowernumber" => "self.borrowernumber" },
1284 { cascade_copy => 0, cascade_delete => 0 },
1287 =head2 virtualshelfcontents
1291 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
1295 __PACKAGE__->has_many(
1296 "virtualshelfcontents",
1297 "Koha::Schema::Result::Virtualshelfcontent",
1298 { "foreign.borrowernumber" => "self.borrowernumber" },
1299 { cascade_copy => 0, cascade_delete => 0 },
1302 =head2 virtualshelfshares
1306 Related object: L<Koha::Schema::Result::Virtualshelfshare>
1310 __PACKAGE__->has_many(
1311 "virtualshelfshares",
1312 "Koha::Schema::Result::Virtualshelfshare",
1313 { "foreign.borrowernumber" => "self.borrowernumber" },
1314 { cascade_copy => 0, cascade_delete => 0 },
1317 =head2 virtualshelves
1321 Related object: L<Koha::Schema::Result::Virtualshelve>
1325 __PACKAGE__->has_many(
1327 "Koha::Schema::Result::Virtualshelve",
1328 { "foreign.owner" => "self.borrowernumber" },
1329 { cascade_copy => 0, cascade_delete => 0 },
1336 Composing rels: L</aqbasketusers> -> basketno
1340 __PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
1346 Composing rels: L</aqbudgetborrowers> -> budget
1350 __PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget");
1356 Composing rels: L</course_instructors> -> course
1360 __PACKAGE__->many_to_many("courses", "course_instructors", "course");
1366 Composing rels: L</aqorder_users> -> ordernumber
1370 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1373 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-05-09 21:01:19
1374 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dc49uW1FevMTWMaWeRVHgA
1376 __PACKAGE__->belongs_to(
1378 "Koha::Schema::Result::Borrower",
1379 { borrowernumber => "guarantorid" },
1382 __PACKAGE__->add_columns(
1383 '+lost' => { is_boolean => 1 },
1384 '+gonenoaddress' => { is_boolean => 1 }
1387 sub koha_objects_class {