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-03-23 21:42:48
1374 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dchVNO0KEo638glUkcMLkg
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 {