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
238 datetime_undef_if_invalid: 1
254 datetime_undef_if_invalid: 1
257 =head2 debarredcomment
265 data_type: 'mediumtext'
268 =head2 contactfirstname
285 data_type: 'mediumtext'
319 data_type: 'mediumtext'
340 =head2 altcontactfirstname
346 =head2 altcontactsurname
352 =head2 altcontactaddress1
358 =head2 altcontactaddress2
364 =head2 altcontactaddress3
370 =head2 altcontactstate
375 =head2 altcontactzipcode
381 =head2 altcontactcountry
386 =head2 altcontactphone
392 =head2 smsalertnumber
398 =head2 sms_provider_id
410 =head2 privacy_guarantor_checkouts
416 =head2 checkprevcheckout
419 default_value: 'inherit'
425 data_type: 'timestamp'
426 datetime_undef_if_invalid: 1
427 default_value: current_timestamp
432 data_type: 'datetime'
433 datetime_undef_if_invalid: 1
439 default_value: 'default'
443 =head2 login_attempts
449 =head2 overdrive_auth_token
456 __PACKAGE__->add_columns(
458 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
460 { data_type => "varchar", is_nullable => 1, size => 16 },
462 { data_type => "mediumtext", is_nullable => 0 },
464 { data_type => "text", is_nullable => 1 },
466 { data_type => "mediumtext", is_nullable => 1 },
468 { data_type => "mediumtext", is_nullable => 1 },
470 { data_type => "text", is_nullable => 1 },
472 { data_type => "varchar", is_nullable => 1, size => 10 },
474 { data_type => "varchar", is_nullable => 1, size => 50 },
476 { data_type => "mediumtext", is_nullable => 0 },
478 { data_type => "text", is_nullable => 1 },
480 { data_type => "mediumtext", is_nullable => 0 },
482 { data_type => "text", is_nullable => 1 },
484 { data_type => "varchar", is_nullable => 1, size => 25 },
486 { data_type => "text", is_nullable => 1 },
488 { data_type => "mediumtext", is_nullable => 1 },
490 { data_type => "text", is_nullable => 1 },
492 { data_type => "varchar", is_nullable => 1, size => 50 },
494 { data_type => "mediumtext", is_nullable => 1 },
496 { data_type => "text", is_nullable => 1 },
498 { data_type => "text", is_nullable => 1 },
501 accessor => "b_streetnumber",
502 data_type => "varchar",
508 accessor => "b_streettype",
509 data_type => "varchar",
515 accessor => "b_address",
516 data_type => "varchar",
521 { accessor => "b_address2", data_type => "text", is_nullable => 1 },
523 { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
525 { accessor => "b_state", data_type => "text", is_nullable => 1 },
528 accessor => "b_zipcode",
529 data_type => "varchar",
534 { accessor => "b_country", data_type => "text", is_nullable => 1 },
536 { accessor => "b_email", data_type => "text", is_nullable => 1 },
538 { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
540 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
543 data_type => "varchar",
551 data_type => "varchar",
558 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
560 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
562 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
564 { data_type => "tinyint", is_nullable => 1 },
566 { data_type => "tinyint", is_nullable => 1 },
568 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
570 { data_type => "varchar", is_nullable => 1, size => 255 },
572 { data_type => "mediumtext", is_nullable => 1 },
574 { data_type => "text", is_nullable => 1 },
576 { data_type => "text", is_nullable => 1 },
578 { data_type => "integer", is_nullable => 1 },
580 { data_type => "mediumtext", is_nullable => 1 },
582 { data_type => "varchar", is_nullable => 1, size => 100 },
584 { data_type => "varchar", is_nullable => 1, size => 1 },
586 { data_type => "varchar", is_nullable => 1, size => 60 },
588 { data_type => "integer", is_nullable => 1 },
590 { data_type => "varchar", is_nullable => 1, size => 75 },
592 { data_type => "mediumtext", is_nullable => 1 },
594 { data_type => "varchar", is_nullable => 1, size => 255 },
596 { data_type => "varchar", is_nullable => 1, size => 80 },
598 { data_type => "varchar", is_nullable => 1, size => 80 },
599 "altcontactfirstname",
600 { data_type => "varchar", is_nullable => 1, size => 255 },
602 { data_type => "varchar", is_nullable => 1, size => 255 },
603 "altcontactaddress1",
604 { data_type => "varchar", is_nullable => 1, size => 255 },
605 "altcontactaddress2",
606 { data_type => "varchar", is_nullable => 1, size => 255 },
607 "altcontactaddress3",
608 { data_type => "varchar", is_nullable => 1, size => 255 },
610 { data_type => "text", is_nullable => 1 },
612 { data_type => "varchar", is_nullable => 1, size => 50 },
614 { data_type => "text", is_nullable => 1 },
616 { data_type => "varchar", is_nullable => 1, size => 50 },
618 { data_type => "varchar", is_nullable => 1, size => 50 },
620 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
622 { data_type => "integer", default_value => 1, is_nullable => 0 },
623 "privacy_guarantor_checkouts",
624 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
627 data_type => "varchar",
628 default_value => "inherit",
634 data_type => "timestamp",
635 datetime_undef_if_invalid => 1,
636 default_value => \"current_timestamp",
641 data_type => "datetime",
642 datetime_undef_if_invalid => 1,
647 data_type => "varchar",
648 default_value => "default",
653 { data_type => "integer", default_value => 0, is_nullable => 1 },
654 "overdrive_auth_token",
655 { data_type => "text", is_nullable => 1 },
662 =item * L</borrowernumber>
668 __PACKAGE__->set_primary_key("borrowernumber");
670 =head1 UNIQUE CONSTRAINTS
676 =item * L</cardnumber>
682 __PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
694 __PACKAGE__->add_unique_constraint("userid", ["userid"]);
702 Related object: L<Koha::Schema::Result::Accountline>
706 __PACKAGE__->has_many(
708 "Koha::Schema::Result::Accountline",
709 { "foreign.borrowernumber" => "self.borrowernumber" },
710 { cascade_copy => 0, cascade_delete => 0 },
713 =head2 accountoffsets
717 Related object: L<Koha::Schema::Result::Accountoffset>
721 __PACKAGE__->has_many(
723 "Koha::Schema::Result::Accountoffset",
724 { "foreign.borrowernumber" => "self.borrowernumber" },
725 { cascade_copy => 0, cascade_delete => 0 },
732 Related object: L<Koha::Schema::Result::Aqbasketuser>
736 __PACKAGE__->has_many(
738 "Koha::Schema::Result::Aqbasketuser",
739 { "foreign.borrowernumber" => "self.borrowernumber" },
740 { cascade_copy => 0, cascade_delete => 0 },
743 =head2 aqbudgetborrowers
747 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
751 __PACKAGE__->has_many(
753 "Koha::Schema::Result::Aqbudgetborrower",
754 { "foreign.borrowernumber" => "self.borrowernumber" },
755 { cascade_copy => 0, cascade_delete => 0 },
762 Related object: L<Koha::Schema::Result::AqorderUser>
766 __PACKAGE__->has_many(
768 "Koha::Schema::Result::AqorderUser",
769 { "foreign.borrowernumber" => "self.borrowernumber" },
770 { cascade_copy => 0, cascade_delete => 0 },
773 =head2 article_requests
777 Related object: L<Koha::Schema::Result::ArticleRequest>
781 __PACKAGE__->has_many(
783 "Koha::Schema::Result::ArticleRequest",
784 { "foreign.borrowernumber" => "self.borrowernumber" },
785 { cascade_copy => 0, cascade_delete => 0 },
788 =head2 borrower_attributes
792 Related object: L<Koha::Schema::Result::BorrowerAttribute>
796 __PACKAGE__->has_many(
797 "borrower_attributes",
798 "Koha::Schema::Result::BorrowerAttribute",
799 { "foreign.borrowernumber" => "self.borrowernumber" },
800 { cascade_copy => 0, cascade_delete => 0 },
803 =head2 borrower_debarments
807 Related object: L<Koha::Schema::Result::BorrowerDebarment>
811 __PACKAGE__->has_many(
812 "borrower_debarments",
813 "Koha::Schema::Result::BorrowerDebarment",
814 { "foreign.borrowernumber" => "self.borrowernumber" },
815 { cascade_copy => 0, cascade_delete => 0 },
818 =head2 borrower_files
822 Related object: L<Koha::Schema::Result::BorrowerFile>
826 __PACKAGE__->has_many(
828 "Koha::Schema::Result::BorrowerFile",
829 { "foreign.borrowernumber" => "self.borrowernumber" },
830 { cascade_copy => 0, cascade_delete => 0 },
833 =head2 borrower_message_preferences
837 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
841 __PACKAGE__->has_many(
842 "borrower_message_preferences",
843 "Koha::Schema::Result::BorrowerMessagePreference",
844 { "foreign.borrowernumber" => "self.borrowernumber" },
845 { cascade_copy => 0, cascade_delete => 0 },
848 =head2 borrower_syncs
852 Related object: L<Koha::Schema::Result::BorrowerSync>
856 __PACKAGE__->has_many(
858 "Koha::Schema::Result::BorrowerSync",
859 { "foreign.borrowernumber" => "self.borrowernumber" },
860 { cascade_copy => 0, cascade_delete => 0 },
867 Related object: L<Koha::Schema::Result::Branch>
871 __PACKAGE__->belongs_to(
873 "Koha::Schema::Result::Branch",
874 { branchcode => "branchcode" },
875 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
882 Related object: L<Koha::Schema::Result::Category>
886 __PACKAGE__->belongs_to(
888 "Koha::Schema::Result::Category",
889 { categorycode => "categorycode" },
890 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
893 =head2 club_enrollments
897 Related object: L<Koha::Schema::Result::ClubEnrollment>
901 __PACKAGE__->has_many(
903 "Koha::Schema::Result::ClubEnrollment",
904 { "foreign.borrowernumber" => "self.borrowernumber" },
905 { cascade_copy => 0, cascade_delete => 0 },
908 =head2 course_instructors
912 Related object: L<Koha::Schema::Result::CourseInstructor>
916 __PACKAGE__->has_many(
917 "course_instructors",
918 "Koha::Schema::Result::CourseInstructor",
919 { "foreign.borrowernumber" => "self.borrowernumber" },
920 { cascade_copy => 0, cascade_delete => 0 },
923 =head2 creator_batches
927 Related object: L<Koha::Schema::Result::CreatorBatch>
931 __PACKAGE__->has_many(
933 "Koha::Schema::Result::CreatorBatch",
934 { "foreign.borrower_number" => "self.borrowernumber" },
935 { cascade_copy => 0, cascade_delete => 0 },
942 Related object: L<Koha::Schema::Result::Discharge>
946 __PACKAGE__->has_many(
948 "Koha::Schema::Result::Discharge",
949 { "foreign.borrower" => "self.borrowernumber" },
950 { cascade_copy => 0, cascade_delete => 0 },
953 =head2 hold_fill_targets
957 Related object: L<Koha::Schema::Result::HoldFillTarget>
961 __PACKAGE__->has_many(
963 "Koha::Schema::Result::HoldFillTarget",
964 { "foreign.borrowernumber" => "self.borrowernumber" },
965 { cascade_copy => 0, cascade_delete => 0 },
968 =head2 housebound_profile
972 Related object: L<Koha::Schema::Result::HouseboundProfile>
976 __PACKAGE__->might_have(
977 "housebound_profile",
978 "Koha::Schema::Result::HouseboundProfile",
979 { "foreign.borrowernumber" => "self.borrowernumber" },
980 { cascade_copy => 0, cascade_delete => 0 },
983 =head2 housebound_role
987 Related object: L<Koha::Schema::Result::HouseboundRole>
991 __PACKAGE__->might_have(
993 "Koha::Schema::Result::HouseboundRole",
994 { "foreign.borrowernumber_id" => "self.borrowernumber" },
995 { cascade_copy => 0, cascade_delete => 0 },
998 =head2 housebound_visit_chooser_brwnumbers
1002 Related object: L<Koha::Schema::Result::HouseboundVisit>
1006 __PACKAGE__->has_many(
1007 "housebound_visit_chooser_brwnumbers",
1008 "Koha::Schema::Result::HouseboundVisit",
1009 { "foreign.chooser_brwnumber" => "self.borrowernumber" },
1010 { cascade_copy => 0, cascade_delete => 0 },
1013 =head2 housebound_visit_deliverer_brwnumbers
1017 Related object: L<Koha::Schema::Result::HouseboundVisit>
1021 __PACKAGE__->has_many(
1022 "housebound_visit_deliverer_brwnumbers",
1023 "Koha::Schema::Result::HouseboundVisit",
1024 { "foreign.deliverer_brwnumber" => "self.borrowernumber" },
1025 { cascade_copy => 0, cascade_delete => 0 },
1032 Related object: L<Koha::Schema::Result::Issue>
1036 __PACKAGE__->has_many(
1038 "Koha::Schema::Result::Issue",
1039 { "foreign.borrowernumber" => "self.borrowernumber" },
1040 { cascade_copy => 0, cascade_delete => 0 },
1043 =head2 items_last_borrowers
1047 Related object: L<Koha::Schema::Result::ItemsLastBorrower>
1051 __PACKAGE__->has_many(
1052 "items_last_borrowers",
1053 "Koha::Schema::Result::ItemsLastBorrower",
1054 { "foreign.borrowernumber" => "self.borrowernumber" },
1055 { cascade_copy => 0, cascade_delete => 0 },
1058 =head2 message_queues
1062 Related object: L<Koha::Schema::Result::MessageQueue>
1066 __PACKAGE__->has_many(
1068 "Koha::Schema::Result::MessageQueue",
1069 { "foreign.borrowernumber" => "self.borrowernumber" },
1070 { cascade_copy => 0, cascade_delete => 0 },
1077 Related object: L<Koha::Schema::Result::Message>
1081 __PACKAGE__->has_many(
1083 "Koha::Schema::Result::Message",
1084 { "foreign.manager_id" => "self.borrowernumber" },
1085 { cascade_copy => 0, cascade_delete => 0 },
1092 Related object: L<Koha::Schema::Result::OldIssue>
1096 __PACKAGE__->has_many(
1098 "Koha::Schema::Result::OldIssue",
1099 { "foreign.borrowernumber" => "self.borrowernumber" },
1100 { cascade_copy => 0, cascade_delete => 0 },
1107 Related object: L<Koha::Schema::Result::OldReserve>
1111 __PACKAGE__->has_many(
1113 "Koha::Schema::Result::OldReserve",
1114 { "foreign.borrowernumber" => "self.borrowernumber" },
1115 { cascade_copy => 0, cascade_delete => 0 },
1122 Related object: L<Koha::Schema::Result::OpacNews>
1126 __PACKAGE__->has_many(
1128 "Koha::Schema::Result::OpacNews",
1129 { "foreign.borrowernumber" => "self.borrowernumber" },
1130 { cascade_copy => 0, cascade_delete => 0 },
1133 =head2 patron_list_patrons
1137 Related object: L<Koha::Schema::Result::PatronListPatron>
1141 __PACKAGE__->has_many(
1142 "patron_list_patrons",
1143 "Koha::Schema::Result::PatronListPatron",
1144 { "foreign.borrowernumber" => "self.borrowernumber" },
1145 { cascade_copy => 0, cascade_delete => 0 },
1152 Related object: L<Koha::Schema::Result::PatronList>
1156 __PACKAGE__->has_many(
1158 "Koha::Schema::Result::PatronList",
1159 { "foreign.owner" => "self.borrowernumber" },
1160 { cascade_copy => 0, cascade_delete => 0 },
1167 Related object: L<Koha::Schema::Result::Patronimage>
1171 __PACKAGE__->might_have(
1173 "Koha::Schema::Result::Patronimage",
1174 { "foreign.borrowernumber" => "self.borrowernumber" },
1175 { cascade_copy => 0, cascade_delete => 0 },
1182 Related object: L<Koha::Schema::Result::Rating>
1186 __PACKAGE__->has_many(
1188 "Koha::Schema::Result::Rating",
1189 { "foreign.borrowernumber" => "self.borrowernumber" },
1190 { cascade_copy => 0, cascade_delete => 0 },
1197 Related object: L<Koha::Schema::Result::Reserve>
1201 __PACKAGE__->has_many(
1203 "Koha::Schema::Result::Reserve",
1204 { "foreign.borrowernumber" => "self.borrowernumber" },
1205 { cascade_copy => 0, cascade_delete => 0 },
1212 Related object: L<Koha::Schema::Result::Review>
1216 __PACKAGE__->has_many(
1218 "Koha::Schema::Result::Review",
1219 { "foreign.borrowernumber" => "self.borrowernumber" },
1220 { cascade_copy => 0, cascade_delete => 0 },
1227 Related object: L<Koha::Schema::Result::SmsProvider>
1231 __PACKAGE__->belongs_to(
1233 "Koha::Schema::Result::SmsProvider",
1234 { id => "sms_provider_id" },
1237 join_type => "LEFT",
1238 on_delete => "SET NULL",
1239 on_update => "CASCADE",
1243 =head2 subscriptionroutinglists
1247 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
1251 __PACKAGE__->has_many(
1252 "subscriptionroutinglists",
1253 "Koha::Schema::Result::Subscriptionroutinglist",
1254 { "foreign.borrowernumber" => "self.borrowernumber" },
1255 { cascade_copy => 0, cascade_delete => 0 },
1262 Related object: L<Koha::Schema::Result::TagAll>
1266 __PACKAGE__->has_many(
1268 "Koha::Schema::Result::TagAll",
1269 { "foreign.borrowernumber" => "self.borrowernumber" },
1270 { cascade_copy => 0, cascade_delete => 0 },
1273 =head2 tags_approvals
1277 Related object: L<Koha::Schema::Result::TagsApproval>
1281 __PACKAGE__->has_many(
1283 "Koha::Schema::Result::TagsApproval",
1284 { "foreign.approved_by" => "self.borrowernumber" },
1285 { cascade_copy => 0, cascade_delete => 0 },
1288 =head2 user_permissions
1292 Related object: L<Koha::Schema::Result::UserPermission>
1296 __PACKAGE__->has_many(
1298 "Koha::Schema::Result::UserPermission",
1299 { "foreign.borrowernumber" => "self.borrowernumber" },
1300 { cascade_copy => 0, cascade_delete => 0 },
1303 =head2 virtualshelfcontents
1307 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
1311 __PACKAGE__->has_many(
1312 "virtualshelfcontents",
1313 "Koha::Schema::Result::Virtualshelfcontent",
1314 { "foreign.borrowernumber" => "self.borrowernumber" },
1315 { cascade_copy => 0, cascade_delete => 0 },
1318 =head2 virtualshelfshares
1322 Related object: L<Koha::Schema::Result::Virtualshelfshare>
1326 __PACKAGE__->has_many(
1327 "virtualshelfshares",
1328 "Koha::Schema::Result::Virtualshelfshare",
1329 { "foreign.borrowernumber" => "self.borrowernumber" },
1330 { cascade_copy => 0, cascade_delete => 0 },
1333 =head2 virtualshelves
1337 Related object: L<Koha::Schema::Result::Virtualshelve>
1341 __PACKAGE__->has_many(
1343 "Koha::Schema::Result::Virtualshelve",
1344 { "foreign.owner" => "self.borrowernumber" },
1345 { cascade_copy => 0, cascade_delete => 0 },
1352 Composing rels: L</aqbasketusers> -> basketno
1356 __PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
1362 Composing rels: L</aqbudgetborrowers> -> budget
1366 __PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget");
1372 Composing rels: L</course_instructors> -> course
1376 __PACKAGE__->many_to_many("courses", "course_instructors", "course");
1382 Composing rels: L</aqorder_users> -> ordernumber
1386 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1389 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-09-19 03:00:28
1390 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZZDjvikajGC+2s4vkp9stw
1392 __PACKAGE__->belongs_to(
1394 "Koha::Schema::Result::Borrower",
1395 { borrowernumber => "guarantorid" },
1398 __PACKAGE__->add_columns(
1399 '+lost' => { is_boolean => 1 },
1400 '+gonenoaddress' => { is_boolean => 1 }
1403 sub koha_objects_class {