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
430 =head2 overdrive_auth_token
437 __PACKAGE__->add_columns(
439 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
441 { data_type => "varchar", is_nullable => 1, size => 16 },
443 { data_type => "mediumtext", is_nullable => 0 },
445 { data_type => "text", is_nullable => 1 },
447 { data_type => "mediumtext", is_nullable => 1 },
449 { data_type => "mediumtext", is_nullable => 1 },
451 { data_type => "text", is_nullable => 1 },
453 { data_type => "varchar", is_nullable => 1, size => 10 },
455 { data_type => "varchar", is_nullable => 1, size => 50 },
457 { data_type => "mediumtext", is_nullable => 0 },
459 { data_type => "text", is_nullable => 1 },
461 { data_type => "mediumtext", is_nullable => 0 },
463 { data_type => "text", is_nullable => 1 },
465 { data_type => "varchar", is_nullable => 1, size => 25 },
467 { data_type => "text", is_nullable => 1 },
469 { data_type => "mediumtext", is_nullable => 1 },
471 { data_type => "text", is_nullable => 1 },
473 { data_type => "varchar", is_nullable => 1, size => 50 },
475 { data_type => "mediumtext", is_nullable => 1 },
477 { data_type => "text", is_nullable => 1 },
479 { data_type => "text", is_nullable => 1 },
482 accessor => "b_streetnumber",
483 data_type => "varchar",
489 accessor => "b_streettype",
490 data_type => "varchar",
496 accessor => "b_address",
497 data_type => "varchar",
502 { accessor => "b_address2", data_type => "text", is_nullable => 1 },
504 { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
506 { accessor => "b_state", data_type => "text", is_nullable => 1 },
509 accessor => "b_zipcode",
510 data_type => "varchar",
515 { accessor => "b_country", data_type => "text", is_nullable => 1 },
517 { accessor => "b_email", data_type => "text", is_nullable => 1 },
519 { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
521 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
524 data_type => "varchar",
532 data_type => "varchar",
539 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
541 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
543 { data_type => "tinyint", is_nullable => 1 },
545 { data_type => "tinyint", is_nullable => 1 },
547 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
549 { data_type => "varchar", is_nullable => 1, size => 255 },
551 { data_type => "mediumtext", is_nullable => 1 },
553 { data_type => "text", is_nullable => 1 },
555 { data_type => "text", is_nullable => 1 },
557 { data_type => "integer", is_nullable => 1 },
559 { data_type => "mediumtext", is_nullable => 1 },
561 { data_type => "varchar", is_nullable => 1, size => 100 },
563 { data_type => "varchar", is_nullable => 1, size => 1 },
565 { data_type => "varchar", is_nullable => 1, size => 60 },
567 { data_type => "integer", is_nullable => 1 },
569 { data_type => "varchar", is_nullable => 1, size => 75 },
571 { data_type => "mediumtext", is_nullable => 1 },
573 { data_type => "varchar", is_nullable => 1, size => 255 },
575 { data_type => "varchar", is_nullable => 1, size => 80 },
577 { data_type => "varchar", is_nullable => 1, size => 80 },
578 "altcontactfirstname",
579 { data_type => "varchar", is_nullable => 1, size => 255 },
581 { data_type => "varchar", is_nullable => 1, size => 255 },
582 "altcontactaddress1",
583 { data_type => "varchar", is_nullable => 1, size => 255 },
584 "altcontactaddress2",
585 { data_type => "varchar", is_nullable => 1, size => 255 },
586 "altcontactaddress3",
587 { data_type => "varchar", is_nullable => 1, size => 255 },
589 { data_type => "text", is_nullable => 1 },
591 { data_type => "varchar", is_nullable => 1, size => 50 },
593 { data_type => "text", is_nullable => 1 },
595 { data_type => "varchar", is_nullable => 1, size => 50 },
597 { data_type => "varchar", is_nullable => 1, size => 50 },
599 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
601 { data_type => "integer", default_value => 1, is_nullable => 0 },
602 "privacy_guarantor_checkouts",
603 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
606 data_type => "varchar",
607 default_value => "inherit",
613 data_type => "timestamp",
614 datetime_undef_if_invalid => 1,
615 default_value => \"current_timestamp",
620 data_type => "datetime",
621 datetime_undef_if_invalid => 1,
624 "overdrive_auth_token",
625 { data_type => "text", is_nullable => 1 },
632 =item * L</borrowernumber>
638 __PACKAGE__->set_primary_key("borrowernumber");
640 =head1 UNIQUE CONSTRAINTS
646 =item * L</cardnumber>
652 __PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
664 __PACKAGE__->add_unique_constraint("userid", ["userid"]);
672 Related object: L<Koha::Schema::Result::Accountline>
676 __PACKAGE__->has_many(
678 "Koha::Schema::Result::Accountline",
679 { "foreign.borrowernumber" => "self.borrowernumber" },
680 { cascade_copy => 0, cascade_delete => 0 },
683 =head2 accountoffsets
687 Related object: L<Koha::Schema::Result::Accountoffset>
691 __PACKAGE__->has_many(
693 "Koha::Schema::Result::Accountoffset",
694 { "foreign.borrowernumber" => "self.borrowernumber" },
695 { cascade_copy => 0, cascade_delete => 0 },
702 Related object: L<Koha::Schema::Result::Aqbasketuser>
706 __PACKAGE__->has_many(
708 "Koha::Schema::Result::Aqbasketuser",
709 { "foreign.borrowernumber" => "self.borrowernumber" },
710 { cascade_copy => 0, cascade_delete => 0 },
713 =head2 aqbudgetborrowers
717 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
721 __PACKAGE__->has_many(
723 "Koha::Schema::Result::Aqbudgetborrower",
724 { "foreign.borrowernumber" => "self.borrowernumber" },
725 { cascade_copy => 0, cascade_delete => 0 },
732 Related object: L<Koha::Schema::Result::AqorderUser>
736 __PACKAGE__->has_many(
738 "Koha::Schema::Result::AqorderUser",
739 { "foreign.borrowernumber" => "self.borrowernumber" },
740 { cascade_copy => 0, cascade_delete => 0 },
743 =head2 article_requests
747 Related object: L<Koha::Schema::Result::ArticleRequest>
751 __PACKAGE__->has_many(
753 "Koha::Schema::Result::ArticleRequest",
754 { "foreign.borrowernumber" => "self.borrowernumber" },
755 { cascade_copy => 0, cascade_delete => 0 },
758 =head2 borrower_attributes
762 Related object: L<Koha::Schema::Result::BorrowerAttribute>
766 __PACKAGE__->has_many(
767 "borrower_attributes",
768 "Koha::Schema::Result::BorrowerAttribute",
769 { "foreign.borrowernumber" => "self.borrowernumber" },
770 { cascade_copy => 0, cascade_delete => 0 },
773 =head2 borrower_debarments
777 Related object: L<Koha::Schema::Result::BorrowerDebarment>
781 __PACKAGE__->has_many(
782 "borrower_debarments",
783 "Koha::Schema::Result::BorrowerDebarment",
784 { "foreign.borrowernumber" => "self.borrowernumber" },
785 { cascade_copy => 0, cascade_delete => 0 },
788 =head2 borrower_files
792 Related object: L<Koha::Schema::Result::BorrowerFile>
796 __PACKAGE__->has_many(
798 "Koha::Schema::Result::BorrowerFile",
799 { "foreign.borrowernumber" => "self.borrowernumber" },
800 { cascade_copy => 0, cascade_delete => 0 },
803 =head2 borrower_message_preferences
807 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
811 __PACKAGE__->has_many(
812 "borrower_message_preferences",
813 "Koha::Schema::Result::BorrowerMessagePreference",
814 { "foreign.borrowernumber" => "self.borrowernumber" },
815 { cascade_copy => 0, cascade_delete => 0 },
818 =head2 borrower_syncs
822 Related object: L<Koha::Schema::Result::BorrowerSync>
826 __PACKAGE__->has_many(
828 "Koha::Schema::Result::BorrowerSync",
829 { "foreign.borrowernumber" => "self.borrowernumber" },
830 { cascade_copy => 0, cascade_delete => 0 },
837 Related object: L<Koha::Schema::Result::Branch>
841 __PACKAGE__->belongs_to(
843 "Koha::Schema::Result::Branch",
844 { branchcode => "branchcode" },
845 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
852 Related object: L<Koha::Schema::Result::Category>
856 __PACKAGE__->belongs_to(
858 "Koha::Schema::Result::Category",
859 { categorycode => "categorycode" },
860 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
863 =head2 club_enrollments
867 Related object: L<Koha::Schema::Result::ClubEnrollment>
871 __PACKAGE__->has_many(
873 "Koha::Schema::Result::ClubEnrollment",
874 { "foreign.borrowernumber" => "self.borrowernumber" },
875 { cascade_copy => 0, cascade_delete => 0 },
878 =head2 course_instructors
882 Related object: L<Koha::Schema::Result::CourseInstructor>
886 __PACKAGE__->has_many(
887 "course_instructors",
888 "Koha::Schema::Result::CourseInstructor",
889 { "foreign.borrowernumber" => "self.borrowernumber" },
890 { cascade_copy => 0, cascade_delete => 0 },
893 =head2 creator_batches
897 Related object: L<Koha::Schema::Result::CreatorBatch>
901 __PACKAGE__->has_many(
903 "Koha::Schema::Result::CreatorBatch",
904 { "foreign.borrower_number" => "self.borrowernumber" },
905 { cascade_copy => 0, cascade_delete => 0 },
912 Related object: L<Koha::Schema::Result::Discharge>
916 __PACKAGE__->has_many(
918 "Koha::Schema::Result::Discharge",
919 { "foreign.borrower" => "self.borrowernumber" },
920 { cascade_copy => 0, cascade_delete => 0 },
923 =head2 hold_fill_targets
927 Related object: L<Koha::Schema::Result::HoldFillTarget>
931 __PACKAGE__->has_many(
933 "Koha::Schema::Result::HoldFillTarget",
934 { "foreign.borrowernumber" => "self.borrowernumber" },
935 { cascade_copy => 0, cascade_delete => 0 },
938 =head2 housebound_profile
942 Related object: L<Koha::Schema::Result::HouseboundProfile>
946 __PACKAGE__->might_have(
947 "housebound_profile",
948 "Koha::Schema::Result::HouseboundProfile",
949 { "foreign.borrowernumber" => "self.borrowernumber" },
950 { cascade_copy => 0, cascade_delete => 0 },
953 =head2 housebound_role
957 Related object: L<Koha::Schema::Result::HouseboundRole>
961 __PACKAGE__->might_have(
963 "Koha::Schema::Result::HouseboundRole",
964 { "foreign.borrowernumber_id" => "self.borrowernumber" },
965 { cascade_copy => 0, cascade_delete => 0 },
968 =head2 housebound_visit_chooser_brwnumbers
972 Related object: L<Koha::Schema::Result::HouseboundVisit>
976 __PACKAGE__->has_many(
977 "housebound_visit_chooser_brwnumbers",
978 "Koha::Schema::Result::HouseboundVisit",
979 { "foreign.chooser_brwnumber" => "self.borrowernumber" },
980 { cascade_copy => 0, cascade_delete => 0 },
983 =head2 housebound_visit_deliverer_brwnumbers
987 Related object: L<Koha::Schema::Result::HouseboundVisit>
991 __PACKAGE__->has_many(
992 "housebound_visit_deliverer_brwnumbers",
993 "Koha::Schema::Result::HouseboundVisit",
994 { "foreign.deliverer_brwnumber" => "self.borrowernumber" },
995 { cascade_copy => 0, cascade_delete => 0 },
1002 Related object: L<Koha::Schema::Result::Issue>
1006 __PACKAGE__->has_many(
1008 "Koha::Schema::Result::Issue",
1009 { "foreign.borrowernumber" => "self.borrowernumber" },
1010 { cascade_copy => 0, cascade_delete => 0 },
1013 =head2 items_last_borrowers
1017 Related object: L<Koha::Schema::Result::ItemsLastBorrower>
1021 __PACKAGE__->has_many(
1022 "items_last_borrowers",
1023 "Koha::Schema::Result::ItemsLastBorrower",
1024 { "foreign.borrowernumber" => "self.borrowernumber" },
1025 { cascade_copy => 0, cascade_delete => 0 },
1028 =head2 message_queues
1032 Related object: L<Koha::Schema::Result::MessageQueue>
1036 __PACKAGE__->has_many(
1038 "Koha::Schema::Result::MessageQueue",
1039 { "foreign.borrowernumber" => "self.borrowernumber" },
1040 { cascade_copy => 0, cascade_delete => 0 },
1047 Related object: L<Koha::Schema::Result::Message>
1051 __PACKAGE__->has_many(
1053 "Koha::Schema::Result::Message",
1054 { "foreign.manager_id" => "self.borrowernumber" },
1055 { cascade_copy => 0, cascade_delete => 0 },
1062 Related object: L<Koha::Schema::Result::OldIssue>
1066 __PACKAGE__->has_many(
1068 "Koha::Schema::Result::OldIssue",
1069 { "foreign.borrowernumber" => "self.borrowernumber" },
1070 { cascade_copy => 0, cascade_delete => 0 },
1077 Related object: L<Koha::Schema::Result::OldReserve>
1081 __PACKAGE__->has_many(
1083 "Koha::Schema::Result::OldReserve",
1084 { "foreign.borrowernumber" => "self.borrowernumber" },
1085 { cascade_copy => 0, cascade_delete => 0 },
1092 Related object: L<Koha::Schema::Result::OpacNews>
1096 __PACKAGE__->has_many(
1098 "Koha::Schema::Result::OpacNews",
1099 { "foreign.borrowernumber" => "self.borrowernumber" },
1100 { cascade_copy => 0, cascade_delete => 0 },
1103 =head2 patron_list_patrons
1107 Related object: L<Koha::Schema::Result::PatronListPatron>
1111 __PACKAGE__->has_many(
1112 "patron_list_patrons",
1113 "Koha::Schema::Result::PatronListPatron",
1114 { "foreign.borrowernumber" => "self.borrowernumber" },
1115 { cascade_copy => 0, cascade_delete => 0 },
1122 Related object: L<Koha::Schema::Result::PatronList>
1126 __PACKAGE__->has_many(
1128 "Koha::Schema::Result::PatronList",
1129 { "foreign.owner" => "self.borrowernumber" },
1130 { cascade_copy => 0, cascade_delete => 0 },
1137 Related object: L<Koha::Schema::Result::Patronimage>
1141 __PACKAGE__->might_have(
1143 "Koha::Schema::Result::Patronimage",
1144 { "foreign.borrowernumber" => "self.borrowernumber" },
1145 { cascade_copy => 0, cascade_delete => 0 },
1152 Related object: L<Koha::Schema::Result::Rating>
1156 __PACKAGE__->has_many(
1158 "Koha::Schema::Result::Rating",
1159 { "foreign.borrowernumber" => "self.borrowernumber" },
1160 { cascade_copy => 0, cascade_delete => 0 },
1167 Related object: L<Koha::Schema::Result::Reserve>
1171 __PACKAGE__->has_many(
1173 "Koha::Schema::Result::Reserve",
1174 { "foreign.borrowernumber" => "self.borrowernumber" },
1175 { cascade_copy => 0, cascade_delete => 0 },
1182 Related object: L<Koha::Schema::Result::Review>
1186 __PACKAGE__->has_many(
1188 "Koha::Schema::Result::Review",
1189 { "foreign.borrowernumber" => "self.borrowernumber" },
1190 { cascade_copy => 0, cascade_delete => 0 },
1197 Related object: L<Koha::Schema::Result::SmsProvider>
1201 __PACKAGE__->belongs_to(
1203 "Koha::Schema::Result::SmsProvider",
1204 { id => "sms_provider_id" },
1207 join_type => "LEFT",
1208 on_delete => "SET NULL",
1209 on_update => "CASCADE",
1213 =head2 subscriptionroutinglists
1217 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
1221 __PACKAGE__->has_many(
1222 "subscriptionroutinglists",
1223 "Koha::Schema::Result::Subscriptionroutinglist",
1224 { "foreign.borrowernumber" => "self.borrowernumber" },
1225 { cascade_copy => 0, cascade_delete => 0 },
1232 Related object: L<Koha::Schema::Result::TagAll>
1236 __PACKAGE__->has_many(
1238 "Koha::Schema::Result::TagAll",
1239 { "foreign.borrowernumber" => "self.borrowernumber" },
1240 { cascade_copy => 0, cascade_delete => 0 },
1243 =head2 tags_approvals
1247 Related object: L<Koha::Schema::Result::TagsApproval>
1251 __PACKAGE__->has_many(
1253 "Koha::Schema::Result::TagsApproval",
1254 { "foreign.approved_by" => "self.borrowernumber" },
1255 { cascade_copy => 0, cascade_delete => 0 },
1258 =head2 user_permissions
1262 Related object: L<Koha::Schema::Result::UserPermission>
1266 __PACKAGE__->has_many(
1268 "Koha::Schema::Result::UserPermission",
1269 { "foreign.borrowernumber" => "self.borrowernumber" },
1270 { cascade_copy => 0, cascade_delete => 0 },
1273 =head2 virtualshelfcontents
1277 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
1281 __PACKAGE__->has_many(
1282 "virtualshelfcontents",
1283 "Koha::Schema::Result::Virtualshelfcontent",
1284 { "foreign.borrowernumber" => "self.borrowernumber" },
1285 { cascade_copy => 0, cascade_delete => 0 },
1288 =head2 virtualshelfshares
1292 Related object: L<Koha::Schema::Result::Virtualshelfshare>
1296 __PACKAGE__->has_many(
1297 "virtualshelfshares",
1298 "Koha::Schema::Result::Virtualshelfshare",
1299 { "foreign.borrowernumber" => "self.borrowernumber" },
1300 { cascade_copy => 0, cascade_delete => 0 },
1303 =head2 virtualshelves
1307 Related object: L<Koha::Schema::Result::Virtualshelve>
1311 __PACKAGE__->has_many(
1313 "Koha::Schema::Result::Virtualshelve",
1314 { "foreign.owner" => "self.borrowernumber" },
1315 { cascade_copy => 0, cascade_delete => 0 },
1322 Composing rels: L</aqbasketusers> -> basketno
1326 __PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
1332 Composing rels: L</aqbudgetborrowers> -> budget
1336 __PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget");
1342 Composing rels: L</course_instructors> -> course
1346 __PACKAGE__->many_to_many("courses", "course_instructors", "course");
1352 Composing rels: L</aqorder_users> -> ordernumber
1356 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1359 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-04-26 16:17:25
1360 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Qq3fmJ73x8Qv+Pqbs7zkow
1362 __PACKAGE__->belongs_to(
1364 "Koha::Schema::Result::Borrower",
1365 { borrowernumber => "guarantorid" },
1368 __PACKAGE__->add_columns(
1369 '+lost' => { is_boolean => 1 },
1370 '+gonenoaddress' => { is_boolean => 1 }
1373 sub koha_objects_class {