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 __PACKAGE__->add_columns(
428 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
430 { data_type => "varchar", is_nullable => 1, size => 16 },
432 { data_type => "mediumtext", is_nullable => 0 },
434 { data_type => "text", is_nullable => 1 },
436 { data_type => "mediumtext", is_nullable => 1 },
438 { data_type => "mediumtext", is_nullable => 1 },
440 { data_type => "text", is_nullable => 1 },
442 { data_type => "varchar", is_nullable => 1, size => 10 },
444 { data_type => "varchar", is_nullable => 1, size => 50 },
446 { data_type => "mediumtext", is_nullable => 0 },
448 { data_type => "text", is_nullable => 1 },
450 { data_type => "mediumtext", is_nullable => 0 },
452 { data_type => "text", is_nullable => 1 },
454 { data_type => "varchar", is_nullable => 1, size => 25 },
456 { data_type => "text", is_nullable => 1 },
458 { data_type => "mediumtext", is_nullable => 1 },
460 { data_type => "text", is_nullable => 1 },
462 { data_type => "varchar", is_nullable => 1, size => 50 },
464 { data_type => "mediumtext", is_nullable => 1 },
466 { data_type => "text", is_nullable => 1 },
468 { data_type => "text", is_nullable => 1 },
471 accessor => "b_streetnumber",
472 data_type => "varchar",
478 accessor => "b_streettype",
479 data_type => "varchar",
485 accessor => "b_address",
486 data_type => "varchar",
491 { accessor => "b_address2", data_type => "text", is_nullable => 1 },
493 { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
495 { accessor => "b_state", data_type => "text", is_nullable => 1 },
498 accessor => "b_zipcode",
499 data_type => "varchar",
504 { accessor => "b_country", data_type => "text", is_nullable => 1 },
506 { accessor => "b_email", data_type => "text", is_nullable => 1 },
508 { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
510 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
513 data_type => "varchar",
521 data_type => "varchar",
528 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
530 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
532 { data_type => "tinyint", is_nullable => 1 },
534 { data_type => "tinyint", is_nullable => 1 },
536 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
538 { data_type => "varchar", is_nullable => 1, size => 255 },
540 { data_type => "mediumtext", is_nullable => 1 },
542 { data_type => "text", is_nullable => 1 },
544 { data_type => "text", is_nullable => 1 },
546 { data_type => "integer", is_nullable => 1 },
548 { data_type => "mediumtext", is_nullable => 1 },
550 { data_type => "varchar", is_nullable => 1, size => 100 },
552 { data_type => "varchar", is_nullable => 1, size => 1 },
554 { data_type => "varchar", is_nullable => 1, size => 60 },
556 { data_type => "integer", is_nullable => 1 },
558 { data_type => "varchar", is_nullable => 1, size => 75 },
560 { data_type => "mediumtext", is_nullable => 1 },
562 { data_type => "varchar", is_nullable => 1, size => 255 },
564 { data_type => "varchar", is_nullable => 1, size => 80 },
566 { data_type => "varchar", is_nullable => 1, size => 80 },
567 "altcontactfirstname",
568 { data_type => "varchar", is_nullable => 1, size => 255 },
570 { data_type => "varchar", is_nullable => 1, size => 255 },
571 "altcontactaddress1",
572 { data_type => "varchar", is_nullable => 1, size => 255 },
573 "altcontactaddress2",
574 { data_type => "varchar", is_nullable => 1, size => 255 },
575 "altcontactaddress3",
576 { data_type => "varchar", is_nullable => 1, size => 255 },
578 { data_type => "text", is_nullable => 1 },
580 { data_type => "varchar", is_nullable => 1, size => 50 },
582 { data_type => "text", is_nullable => 1 },
584 { data_type => "varchar", is_nullable => 1, size => 50 },
586 { data_type => "varchar", is_nullable => 1, size => 50 },
588 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
590 { data_type => "integer", default_value => 1, is_nullable => 0 },
591 "privacy_guarantor_checkouts",
592 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
595 data_type => "varchar",
596 default_value => "inherit",
602 data_type => "timestamp",
603 datetime_undef_if_invalid => 1,
604 default_value => \"current_timestamp",
613 =item * L</borrowernumber>
619 __PACKAGE__->set_primary_key("borrowernumber");
621 =head1 UNIQUE CONSTRAINTS
627 =item * L</cardnumber>
633 __PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
645 __PACKAGE__->add_unique_constraint("userid", ["userid"]);
653 Related object: L<Koha::Schema::Result::Accountline>
657 __PACKAGE__->has_many(
659 "Koha::Schema::Result::Accountline",
660 { "foreign.borrowernumber" => "self.borrowernumber" },
661 { cascade_copy => 0, cascade_delete => 0 },
664 =head2 accountoffsets
668 Related object: L<Koha::Schema::Result::Accountoffset>
672 __PACKAGE__->has_many(
674 "Koha::Schema::Result::Accountoffset",
675 { "foreign.borrowernumber" => "self.borrowernumber" },
676 { cascade_copy => 0, cascade_delete => 0 },
683 Related object: L<Koha::Schema::Result::Aqbasketuser>
687 __PACKAGE__->has_many(
689 "Koha::Schema::Result::Aqbasketuser",
690 { "foreign.borrowernumber" => "self.borrowernumber" },
691 { cascade_copy => 0, cascade_delete => 0 },
694 =head2 aqbudgetborrowers
698 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
702 __PACKAGE__->has_many(
704 "Koha::Schema::Result::Aqbudgetborrower",
705 { "foreign.borrowernumber" => "self.borrowernumber" },
706 { cascade_copy => 0, cascade_delete => 0 },
713 Related object: L<Koha::Schema::Result::AqorderUser>
717 __PACKAGE__->has_many(
719 "Koha::Schema::Result::AqorderUser",
720 { "foreign.borrowernumber" => "self.borrowernumber" },
721 { cascade_copy => 0, cascade_delete => 0 },
724 =head2 borrower_attributes
728 Related object: L<Koha::Schema::Result::BorrowerAttribute>
732 __PACKAGE__->has_many(
733 "borrower_attributes",
734 "Koha::Schema::Result::BorrowerAttribute",
735 { "foreign.borrowernumber" => "self.borrowernumber" },
736 { cascade_copy => 0, cascade_delete => 0 },
739 =head2 borrower_debarments
743 Related object: L<Koha::Schema::Result::BorrowerDebarment>
747 __PACKAGE__->has_many(
748 "borrower_debarments",
749 "Koha::Schema::Result::BorrowerDebarment",
750 { "foreign.borrowernumber" => "self.borrowernumber" },
751 { cascade_copy => 0, cascade_delete => 0 },
754 =head2 borrower_files
758 Related object: L<Koha::Schema::Result::BorrowerFile>
762 __PACKAGE__->has_many(
764 "Koha::Schema::Result::BorrowerFile",
765 { "foreign.borrowernumber" => "self.borrowernumber" },
766 { cascade_copy => 0, cascade_delete => 0 },
769 =head2 borrower_message_preferences
773 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
777 __PACKAGE__->has_many(
778 "borrower_message_preferences",
779 "Koha::Schema::Result::BorrowerMessagePreference",
780 { "foreign.borrowernumber" => "self.borrowernumber" },
781 { cascade_copy => 0, cascade_delete => 0 },
784 =head2 borrower_syncs
788 Related object: L<Koha::Schema::Result::BorrowerSync>
792 __PACKAGE__->has_many(
794 "Koha::Schema::Result::BorrowerSync",
795 { "foreign.borrowernumber" => "self.borrowernumber" },
796 { cascade_copy => 0, cascade_delete => 0 },
803 Related object: L<Koha::Schema::Result::Branch>
807 __PACKAGE__->belongs_to(
809 "Koha::Schema::Result::Branch",
810 { branchcode => "branchcode" },
811 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
818 Related object: L<Koha::Schema::Result::Category>
822 __PACKAGE__->belongs_to(
824 "Koha::Schema::Result::Category",
825 { categorycode => "categorycode" },
826 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
829 =head2 course_instructors
833 Related object: L<Koha::Schema::Result::CourseInstructor>
837 __PACKAGE__->has_many(
838 "course_instructors",
839 "Koha::Schema::Result::CourseInstructor",
840 { "foreign.borrowernumber" => "self.borrowernumber" },
841 { cascade_copy => 0, cascade_delete => 0 },
844 =head2 creator_batches
848 Related object: L<Koha::Schema::Result::CreatorBatch>
852 __PACKAGE__->has_many(
854 "Koha::Schema::Result::CreatorBatch",
855 { "foreign.borrower_number" => "self.borrowernumber" },
856 { cascade_copy => 0, cascade_delete => 0 },
863 Related object: L<Koha::Schema::Result::Discharge>
867 __PACKAGE__->has_many(
869 "Koha::Schema::Result::Discharge",
870 { "foreign.borrower" => "self.borrowernumber" },
871 { cascade_copy => 0, cascade_delete => 0 },
874 =head2 hold_fill_targets
878 Related object: L<Koha::Schema::Result::HoldFillTarget>
882 __PACKAGE__->has_many(
884 "Koha::Schema::Result::HoldFillTarget",
885 { "foreign.borrowernumber" => "self.borrowernumber" },
886 { cascade_copy => 0, cascade_delete => 0 },
893 Related object: L<Koha::Schema::Result::Issue>
897 __PACKAGE__->has_many(
899 "Koha::Schema::Result::Issue",
900 { "foreign.borrowernumber" => "self.borrowernumber" },
901 { cascade_copy => 0, cascade_delete => 0 },
904 =head2 items_last_borrowers
908 Related object: L<Koha::Schema::Result::ItemsLastBorrower>
912 __PACKAGE__->has_many(
913 "items_last_borrowers",
914 "Koha::Schema::Result::ItemsLastBorrower",
915 { "foreign.borrowernumber" => "self.borrowernumber" },
916 { cascade_copy => 0, cascade_delete => 0 },
919 =head2 message_queues
923 Related object: L<Koha::Schema::Result::MessageQueue>
927 __PACKAGE__->has_many(
929 "Koha::Schema::Result::MessageQueue",
930 { "foreign.borrowernumber" => "self.borrowernumber" },
931 { cascade_copy => 0, cascade_delete => 0 },
938 Related object: L<Koha::Schema::Result::OldIssue>
942 __PACKAGE__->has_many(
944 "Koha::Schema::Result::OldIssue",
945 { "foreign.borrowernumber" => "self.borrowernumber" },
946 { cascade_copy => 0, cascade_delete => 0 },
953 Related object: L<Koha::Schema::Result::OldReserve>
957 __PACKAGE__->has_many(
959 "Koha::Schema::Result::OldReserve",
960 { "foreign.borrowernumber" => "self.borrowernumber" },
961 { cascade_copy => 0, cascade_delete => 0 },
968 Related object: L<Koha::Schema::Result::OpacNews>
972 __PACKAGE__->has_many(
974 "Koha::Schema::Result::OpacNews",
975 { "foreign.borrowernumber" => "self.borrowernumber" },
976 { cascade_copy => 0, cascade_delete => 0 },
979 =head2 patron_list_patrons
983 Related object: L<Koha::Schema::Result::PatronListPatron>
987 __PACKAGE__->has_many(
988 "patron_list_patrons",
989 "Koha::Schema::Result::PatronListPatron",
990 { "foreign.borrowernumber" => "self.borrowernumber" },
991 { cascade_copy => 0, cascade_delete => 0 },
998 Related object: L<Koha::Schema::Result::PatronList>
1002 __PACKAGE__->has_many(
1004 "Koha::Schema::Result::PatronList",
1005 { "foreign.owner" => "self.borrowernumber" },
1006 { cascade_copy => 0, cascade_delete => 0 },
1013 Related object: L<Koha::Schema::Result::Patronimage>
1017 __PACKAGE__->might_have(
1019 "Koha::Schema::Result::Patronimage",
1020 { "foreign.borrowernumber" => "self.borrowernumber" },
1021 { cascade_copy => 0, cascade_delete => 0 },
1028 Related object: L<Koha::Schema::Result::Rating>
1032 __PACKAGE__->has_many(
1034 "Koha::Schema::Result::Rating",
1035 { "foreign.borrowernumber" => "self.borrowernumber" },
1036 { cascade_copy => 0, cascade_delete => 0 },
1043 Related object: L<Koha::Schema::Result::Reserve>
1047 __PACKAGE__->has_many(
1049 "Koha::Schema::Result::Reserve",
1050 { "foreign.borrowernumber" => "self.borrowernumber" },
1051 { cascade_copy => 0, cascade_delete => 0 },
1058 Related object: L<Koha::Schema::Result::Review>
1062 __PACKAGE__->has_many(
1064 "Koha::Schema::Result::Review",
1065 { "foreign.borrowernumber" => "self.borrowernumber" },
1066 { cascade_copy => 0, cascade_delete => 0 },
1073 Related object: L<Koha::Schema::Result::SmsProvider>
1077 __PACKAGE__->belongs_to(
1079 "Koha::Schema::Result::SmsProvider",
1080 { id => "sms_provider_id" },
1083 join_type => "LEFT",
1084 on_delete => "SET NULL",
1085 on_update => "CASCADE",
1089 =head2 subscriptionroutinglists
1093 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
1097 __PACKAGE__->has_many(
1098 "subscriptionroutinglists",
1099 "Koha::Schema::Result::Subscriptionroutinglist",
1100 { "foreign.borrowernumber" => "self.borrowernumber" },
1101 { cascade_copy => 0, cascade_delete => 0 },
1108 Related object: L<Koha::Schema::Result::TagAll>
1112 __PACKAGE__->has_many(
1114 "Koha::Schema::Result::TagAll",
1115 { "foreign.borrowernumber" => "self.borrowernumber" },
1116 { cascade_copy => 0, cascade_delete => 0 },
1119 =head2 tags_approvals
1123 Related object: L<Koha::Schema::Result::TagsApproval>
1127 __PACKAGE__->has_many(
1129 "Koha::Schema::Result::TagsApproval",
1130 { "foreign.approved_by" => "self.borrowernumber" },
1131 { cascade_copy => 0, cascade_delete => 0 },
1134 =head2 user_permissions
1138 Related object: L<Koha::Schema::Result::UserPermission>
1142 __PACKAGE__->has_many(
1144 "Koha::Schema::Result::UserPermission",
1145 { "foreign.borrowernumber" => "self.borrowernumber" },
1146 { cascade_copy => 0, cascade_delete => 0 },
1149 =head2 virtualshelfcontents
1153 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
1157 __PACKAGE__->has_many(
1158 "virtualshelfcontents",
1159 "Koha::Schema::Result::Virtualshelfcontent",
1160 { "foreign.borrowernumber" => "self.borrowernumber" },
1161 { cascade_copy => 0, cascade_delete => 0 },
1164 =head2 virtualshelfshares
1168 Related object: L<Koha::Schema::Result::Virtualshelfshare>
1172 __PACKAGE__->has_many(
1173 "virtualshelfshares",
1174 "Koha::Schema::Result::Virtualshelfshare",
1175 { "foreign.borrowernumber" => "self.borrowernumber" },
1176 { cascade_copy => 0, cascade_delete => 0 },
1179 =head2 virtualshelves
1183 Related object: L<Koha::Schema::Result::Virtualshelve>
1187 __PACKAGE__->has_many(
1189 "Koha::Schema::Result::Virtualshelve",
1190 { "foreign.owner" => "self.borrowernumber" },
1191 { cascade_copy => 0, cascade_delete => 0 },
1198 Composing rels: L</aqbasketusers> -> basketno
1202 __PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
1208 Composing rels: L</aqbudgetborrowers> -> budget
1212 __PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget");
1218 Composing rels: L</course_instructors> -> course
1222 __PACKAGE__->many_to_many("courses", "course_instructors", "course");
1228 Composing rels: L</aqorder_users> -> ordernumber
1232 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1235 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-07-08 13:37:33
1236 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GiEcKBFRhzHwXPekj6fSPg
1238 __PACKAGE__->belongs_to(
1240 "Koha::Schema::Result::Borrower",
1241 { borrowernumber => "guarantorid" },