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
432 __PACKAGE__
->add_columns(
434 { data_type
=> "integer", is_auto_increment
=> 1, is_nullable
=> 0 },
436 { data_type
=> "varchar", is_nullable
=> 1, size
=> 16 },
438 { data_type
=> "mediumtext", is_nullable
=> 0 },
440 { data_type
=> "text", is_nullable
=> 1 },
442 { data_type
=> "mediumtext", is_nullable
=> 1 },
444 { data_type
=> "mediumtext", is_nullable
=> 1 },
446 { data_type
=> "text", is_nullable
=> 1 },
448 { data_type
=> "varchar", is_nullable
=> 1, size
=> 10 },
450 { data_type
=> "varchar", is_nullable
=> 1, size
=> 50 },
452 { data_type
=> "mediumtext", is_nullable
=> 0 },
454 { data_type
=> "text", is_nullable
=> 1 },
456 { data_type
=> "mediumtext", is_nullable
=> 0 },
458 { data_type
=> "text", is_nullable
=> 1 },
460 { data_type
=> "varchar", is_nullable
=> 1, size
=> 25 },
462 { data_type
=> "text", is_nullable
=> 1 },
464 { data_type
=> "mediumtext", is_nullable
=> 1 },
466 { data_type
=> "text", is_nullable
=> 1 },
468 { data_type
=> "varchar", is_nullable
=> 1, size
=> 50 },
470 { data_type
=> "mediumtext", is_nullable
=> 1 },
472 { data_type
=> "text", is_nullable
=> 1 },
474 { data_type
=> "text", is_nullable
=> 1 },
477 accessor
=> "b_streetnumber",
478 data_type
=> "varchar",
484 accessor
=> "b_streettype",
485 data_type
=> "varchar",
491 accessor
=> "b_address",
492 data_type
=> "varchar",
497 { accessor
=> "b_address2", data_type
=> "text", is_nullable
=> 1 },
499 { accessor
=> "b_city", data_type
=> "mediumtext", is_nullable
=> 1 },
501 { accessor
=> "b_state", data_type
=> "text", is_nullable
=> 1 },
504 accessor
=> "b_zipcode",
505 data_type
=> "varchar",
510 { accessor
=> "b_country", data_type
=> "text", is_nullable
=> 1 },
512 { accessor
=> "b_email", data_type
=> "text", is_nullable
=> 1 },
514 { accessor
=> "b_phone", data_type
=> "mediumtext", is_nullable
=> 1 },
516 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
519 data_type
=> "varchar",
527 data_type
=> "varchar",
534 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
536 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
538 { data_type
=> "tinyint", is_nullable
=> 1 },
540 { data_type
=> "tinyint", is_nullable
=> 1 },
542 { data_type
=> "date", datetime_undef_if_invalid
=> 1, is_nullable
=> 1 },
544 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
546 { data_type
=> "mediumtext", is_nullable
=> 1 },
548 { data_type
=> "text", is_nullable
=> 1 },
550 { data_type
=> "text", is_nullable
=> 1 },
552 { data_type
=> "integer", is_nullable
=> 1 },
554 { data_type
=> "mediumtext", is_nullable
=> 1 },
556 { data_type
=> "varchar", is_nullable
=> 1, size
=> 100 },
558 { data_type
=> "varchar", is_nullable
=> 1, size
=> 1 },
560 { data_type
=> "varchar", is_nullable
=> 1, size
=> 60 },
562 { data_type
=> "integer", is_nullable
=> 1 },
564 { data_type
=> "varchar", is_nullable
=> 1, size
=> 75 },
566 { data_type
=> "mediumtext", is_nullable
=> 1 },
568 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
570 { data_type
=> "varchar", is_nullable
=> 1, size
=> 80 },
572 { data_type
=> "varchar", is_nullable
=> 1, size
=> 80 },
573 "altcontactfirstname",
574 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
576 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
577 "altcontactaddress1",
578 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
579 "altcontactaddress2",
580 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
581 "altcontactaddress3",
582 { data_type
=> "varchar", is_nullable
=> 1, size
=> 255 },
584 { data_type
=> "text", is_nullable
=> 1 },
586 { data_type
=> "varchar", is_nullable
=> 1, size
=> 50 },
588 { data_type
=> "text", is_nullable
=> 1 },
590 { data_type
=> "varchar", is_nullable
=> 1, size
=> 50 },
592 { data_type
=> "varchar", is_nullable
=> 1, size
=> 50 },
594 { data_type
=> "integer", is_foreign_key
=> 1, is_nullable
=> 1 },
596 { data_type
=> "integer", default_value
=> 1, is_nullable
=> 0 },
597 "privacy_guarantor_checkouts",
598 { data_type
=> "tinyint", default_value
=> 0, is_nullable
=> 0 },
601 data_type
=> "varchar",
602 default_value
=> "inherit",
608 data_type
=> "timestamp",
609 datetime_undef_if_invalid
=> 1,
610 default_value
=> \"current_timestamp
",
615 data_type => "datetime
",
616 datetime_undef_if_invalid => 1,
625 =item * L</borrowernumber>
631 __PACKAGE__->set_primary_key("borrowernumber
");
633 =head1 UNIQUE CONSTRAINTS
639 =item * L</cardnumber>
645 __PACKAGE__->add_unique_constraint("cardnumber
", ["cardnumber
"]);
657 __PACKAGE__->add_unique_constraint("userid
", ["userid
"]);
665 Related object: L<Koha::Schema::Result::Accountline>
669 __PACKAGE__->has_many(
671 "Koha
::Schema
::Result
::Accountline
",
672 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
673 { cascade_copy => 0, cascade_delete => 0 },
676 =head2 accountoffsets
680 Related object: L<Koha::Schema::Result::Accountoffset>
684 __PACKAGE__->has_many(
686 "Koha
::Schema
::Result
::Accountoffset
",
687 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
688 { cascade_copy => 0, cascade_delete => 0 },
695 Related object: L<Koha::Schema::Result::Aqbasketuser>
699 __PACKAGE__->has_many(
701 "Koha
::Schema
::Result
::Aqbasketuser
",
702 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
703 { cascade_copy => 0, cascade_delete => 0 },
706 =head2 aqbudgetborrowers
710 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
714 __PACKAGE__->has_many(
716 "Koha
::Schema
::Result
::Aqbudgetborrower
",
717 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
718 { cascade_copy => 0, cascade_delete => 0 },
725 Related object: L<Koha::Schema::Result::AqorderUser>
729 __PACKAGE__->has_many(
731 "Koha
::Schema
::Result
::AqorderUser
",
732 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
733 { cascade_copy => 0, cascade_delete => 0 },
736 =head2 borrower_attributes
740 Related object: L<Koha::Schema::Result::BorrowerAttribute>
744 __PACKAGE__->has_many(
745 "borrower_attributes
",
746 "Koha
::Schema
::Result
::BorrowerAttribute
",
747 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
748 { cascade_copy => 0, cascade_delete => 0 },
751 =head2 borrower_debarments
755 Related object: L<Koha::Schema::Result::BorrowerDebarment>
759 __PACKAGE__->has_many(
760 "borrower_debarments
",
761 "Koha
::Schema
::Result
::BorrowerDebarment
",
762 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
763 { cascade_copy => 0, cascade_delete => 0 },
766 =head2 borrower_files
770 Related object: L<Koha::Schema::Result::BorrowerFile>
774 __PACKAGE__->has_many(
776 "Koha
::Schema
::Result
::BorrowerFile
",
777 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
778 { cascade_copy => 0, cascade_delete => 0 },
781 =head2 borrower_message_preferences
785 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
789 __PACKAGE__->has_many(
790 "borrower_message_preferences
",
791 "Koha
::Schema
::Result
::BorrowerMessagePreference
",
792 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
793 { cascade_copy => 0, cascade_delete => 0 },
796 =head2 borrower_syncs
800 Related object: L<Koha::Schema::Result::BorrowerSync>
804 __PACKAGE__->has_many(
806 "Koha
::Schema
::Result
::BorrowerSync
",
807 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
808 { cascade_copy => 0, cascade_delete => 0 },
815 Related object: L<Koha::Schema::Result::Branch>
819 __PACKAGE__->belongs_to(
821 "Koha
::Schema
::Result
::Branch
",
822 { branchcode => "branchcode
" },
823 { is_deferrable => 1, on_delete => "RESTRICT
", on_update => "RESTRICT
" },
830 Related object: L<Koha::Schema::Result::Category>
834 __PACKAGE__->belongs_to(
836 "Koha
::Schema
::Result
::Category
",
837 { categorycode => "categorycode
" },
838 { is_deferrable => 1, on_delete => "RESTRICT
", on_update => "RESTRICT
" },
841 =head2 course_instructors
845 Related object: L<Koha::Schema::Result::CourseInstructor>
849 __PACKAGE__->has_many(
850 "course_instructors
",
851 "Koha
::Schema
::Result
::CourseInstructor
",
852 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
853 { cascade_copy => 0, cascade_delete => 0 },
856 =head2 creator_batches
860 Related object: L<Koha::Schema::Result::CreatorBatch>
864 __PACKAGE__->has_many(
866 "Koha
::Schema
::Result
::CreatorBatch
",
867 { "foreign
.borrower_number
" => "self
.borrowernumber
" },
868 { cascade_copy => 0, cascade_delete => 0 },
875 Related object: L<Koha::Schema::Result::Discharge>
879 __PACKAGE__->has_many(
881 "Koha
::Schema
::Result
::Discharge
",
882 { "foreign
.borrower
" => "self
.borrowernumber
" },
883 { cascade_copy => 0, cascade_delete => 0 },
886 =head2 hold_fill_targets
890 Related object: L<Koha::Schema::Result::HoldFillTarget>
894 __PACKAGE__->has_many(
896 "Koha
::Schema
::Result
::HoldFillTarget
",
897 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
898 { cascade_copy => 0, cascade_delete => 0 },
901 =head2 housebound_profile
905 Related object: L<Koha::Schema::Result::HouseboundProfile>
909 __PACKAGE__->might_have(
910 "housebound_profile
",
911 "Koha
::Schema
::Result
::HouseboundProfile
",
912 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
913 { cascade_copy => 0, cascade_delete => 0 },
916 =head2 housebound_role
920 Related object: L<Koha::Schema::Result::HouseboundRole>
924 __PACKAGE__->might_have(
926 "Koha
::Schema
::Result
::HouseboundRole
",
927 { "foreign
.borrowernumber_id
" => "self
.borrowernumber
" },
928 { cascade_copy => 0, cascade_delete => 0 },
931 =head2 housebound_visit_chooser_brwnumbers
935 Related object: L<Koha::Schema::Result::HouseboundVisit>
939 __PACKAGE__->has_many(
940 "housebound_visit_chooser_brwnumbers
",
941 "Koha
::Schema
::Result
::HouseboundVisit
",
942 { "foreign
.chooser_brwnumber
" => "self
.borrowernumber
" },
943 { cascade_copy => 0, cascade_delete => 0 },
946 =head2 housebound_visit_deliverer_brwnumbers
950 Related object: L<Koha::Schema::Result::HouseboundVisit>
954 __PACKAGE__->has_many(
955 "housebound_visit_deliverer_brwnumbers
",
956 "Koha
::Schema
::Result
::HouseboundVisit
",
957 { "foreign
.deliverer_brwnumber
" => "self
.borrowernumber
" },
958 { cascade_copy => 0, cascade_delete => 0 },
965 Related object: L<Koha::Schema::Result::Issue>
969 __PACKAGE__->has_many(
971 "Koha
::Schema
::Result
::Issue
",
972 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
973 { cascade_copy => 0, cascade_delete => 0 },
976 =head2 items_last_borrowers
980 Related object: L<Koha::Schema::Result::ItemsLastBorrower>
984 __PACKAGE__->has_many(
985 "items_last_borrowers
",
986 "Koha
::Schema
::Result
::ItemsLastBorrower
",
987 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
988 { cascade_copy => 0, cascade_delete => 0 },
991 =head2 message_queues
995 Related object: L<Koha::Schema::Result::MessageQueue>
999 __PACKAGE__->has_many(
1001 "Koha
::Schema
::Result
::MessageQueue
",
1002 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1003 { cascade_copy => 0, cascade_delete => 0 },
1010 Related object: L<Koha::Schema::Result::OldIssue>
1014 __PACKAGE__->has_many(
1016 "Koha
::Schema
::Result
::OldIssue
",
1017 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1018 { cascade_copy => 0, cascade_delete => 0 },
1025 Related object: L<Koha::Schema::Result::OldReserve>
1029 __PACKAGE__->has_many(
1031 "Koha
::Schema
::Result
::OldReserve
",
1032 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1033 { cascade_copy => 0, cascade_delete => 0 },
1040 Related object: L<Koha::Schema::Result::OpacNews>
1044 __PACKAGE__->has_many(
1046 "Koha
::Schema
::Result
::OpacNews
",
1047 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1048 { cascade_copy => 0, cascade_delete => 0 },
1051 =head2 patron_list_patrons
1055 Related object: L<Koha::Schema::Result::PatronListPatron>
1059 __PACKAGE__->has_many(
1060 "patron_list_patrons
",
1061 "Koha
::Schema
::Result
::PatronListPatron
",
1062 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1063 { cascade_copy => 0, cascade_delete => 0 },
1070 Related object: L<Koha::Schema::Result::PatronList>
1074 __PACKAGE__->has_many(
1076 "Koha
::Schema
::Result
::PatronList
",
1077 { "foreign
.owner
" => "self
.borrowernumber
" },
1078 { cascade_copy => 0, cascade_delete => 0 },
1085 Related object: L<Koha::Schema::Result::Patronimage>
1089 __PACKAGE__->might_have(
1091 "Koha
::Schema
::Result
::Patronimage
",
1092 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1093 { cascade_copy => 0, cascade_delete => 0 },
1100 Related object: L<Koha::Schema::Result::Rating>
1104 __PACKAGE__->has_many(
1106 "Koha
::Schema
::Result
::Rating
",
1107 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1108 { cascade_copy => 0, cascade_delete => 0 },
1115 Related object: L<Koha::Schema::Result::Reserve>
1119 __PACKAGE__->has_many(
1121 "Koha
::Schema
::Result
::Reserve
",
1122 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1123 { cascade_copy => 0, cascade_delete => 0 },
1130 Related object: L<Koha::Schema::Result::Review>
1134 __PACKAGE__->has_many(
1136 "Koha
::Schema
::Result
::Review
",
1137 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1138 { cascade_copy => 0, cascade_delete => 0 },
1145 Related object: L<Koha::Schema::Result::SmsProvider>
1149 __PACKAGE__->belongs_to(
1151 "Koha
::Schema
::Result
::SmsProvider
",
1152 { id => "sms_provider_id
" },
1155 join_type => "LEFT
",
1156 on_delete => "SET NULL
",
1157 on_update => "CASCADE
",
1161 =head2 subscriptionroutinglists
1165 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
1169 __PACKAGE__->has_many(
1170 "subscriptionroutinglists
",
1171 "Koha
::Schema
::Result
::Subscriptionroutinglist
",
1172 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1173 { cascade_copy => 0, cascade_delete => 0 },
1180 Related object: L<Koha::Schema::Result::TagAll>
1184 __PACKAGE__->has_many(
1186 "Koha
::Schema
::Result
::TagAll
",
1187 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1188 { cascade_copy => 0, cascade_delete => 0 },
1191 =head2 tags_approvals
1195 Related object: L<Koha::Schema::Result::TagsApproval>
1199 __PACKAGE__->has_many(
1201 "Koha
::Schema
::Result
::TagsApproval
",
1202 { "foreign
.approved_by
" => "self
.borrowernumber
" },
1203 { cascade_copy => 0, cascade_delete => 0 },
1206 =head2 user_permissions
1210 Related object: L<Koha::Schema::Result::UserPermission>
1214 __PACKAGE__->has_many(
1216 "Koha
::Schema
::Result
::UserPermission
",
1217 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1218 { cascade_copy => 0, cascade_delete => 0 },
1221 =head2 virtualshelfcontents
1225 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
1229 __PACKAGE__->has_many(
1230 "virtualshelfcontents
",
1231 "Koha
::Schema
::Result
::Virtualshelfcontent
",
1232 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1233 { cascade_copy => 0, cascade_delete => 0 },
1236 =head2 virtualshelfshares
1240 Related object: L<Koha::Schema::Result::Virtualshelfshare>
1244 __PACKAGE__->has_many(
1245 "virtualshelfshares
",
1246 "Koha
::Schema
::Result
::Virtualshelfshare
",
1247 { "foreign
.borrowernumber
" => "self
.borrowernumber
" },
1248 { cascade_copy => 0, cascade_delete => 0 },
1251 =head2 virtualshelves
1255 Related object: L<Koha::Schema::Result::Virtualshelve>
1259 __PACKAGE__->has_many(
1261 "Koha
::Schema
::Result
::Virtualshelve
",
1262 { "foreign
.owner
" => "self
.borrowernumber
" },
1263 { cascade_copy => 0, cascade_delete => 0 },
1270 Composing rels: L</aqbasketusers> -> basketno
1274 __PACKAGE__->many_to_many("basketnoes
", "aqbasketusers
", "basketno
");
1280 Composing rels: L</aqbudgetborrowers> -> budget
1284 __PACKAGE__->many_to_many("budgets
", "aqbudgetborrowers
", "budget
");
1290 Composing rels: L</course_instructors> -> course
1294 __PACKAGE__->many_to_many("courses
", "course_instructors
", "course
");
1300 Composing rels: L</aqorder_users> -> ordernumber
1304 __PACKAGE__->many_to_many("ordernumbers
", "aqorder_users
", "ordernumber
");
1307 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-10-21 18:19:46
1308 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:rbkXombY7fZnZJ3CvHruUA
1310 __PACKAGE__->belongs_to(
1312 "Koha
::Schema
::Result
::Borrower
",
1313 { borrowernumber => "guarantorid
" },
1316 sub koha_objects_class {