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
412 data_type: 'timestamp'
413 datetime_undef_if_invalid: 1
414 default_value: current_timestamp
419 __PACKAGE__->add_columns(
421 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
423 { data_type => "varchar", is_nullable => 1, size => 16 },
425 { data_type => "mediumtext", is_nullable => 0 },
427 { data_type => "text", is_nullable => 1 },
429 { data_type => "mediumtext", is_nullable => 1 },
431 { data_type => "mediumtext", is_nullable => 1 },
433 { data_type => "text", is_nullable => 1 },
435 { data_type => "varchar", is_nullable => 1, size => 10 },
437 { data_type => "varchar", is_nullable => 1, size => 50 },
439 { data_type => "mediumtext", is_nullable => 0 },
441 { data_type => "text", is_nullable => 1 },
443 { data_type => "mediumtext", is_nullable => 0 },
445 { data_type => "text", is_nullable => 1 },
447 { data_type => "varchar", is_nullable => 1, size => 25 },
449 { data_type => "text", is_nullable => 1 },
451 { data_type => "mediumtext", is_nullable => 1 },
453 { data_type => "text", is_nullable => 1 },
455 { data_type => "varchar", is_nullable => 1, size => 50 },
457 { data_type => "mediumtext", is_nullable => 1 },
459 { data_type => "text", is_nullable => 1 },
461 { data_type => "text", is_nullable => 1 },
464 accessor => "b_streetnumber",
465 data_type => "varchar",
471 accessor => "b_streettype",
472 data_type => "varchar",
478 accessor => "b_address",
479 data_type => "varchar",
484 { accessor => "b_address2", data_type => "text", is_nullable => 1 },
486 { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
488 { accessor => "b_state", data_type => "text", is_nullable => 1 },
491 accessor => "b_zipcode",
492 data_type => "varchar",
497 { accessor => "b_country", data_type => "text", is_nullable => 1 },
499 { accessor => "b_email", data_type => "text", is_nullable => 1 },
501 { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
503 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
506 data_type => "varchar",
514 data_type => "varchar",
521 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
523 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
525 { data_type => "tinyint", is_nullable => 1 },
527 { data_type => "tinyint", is_nullable => 1 },
529 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
531 { data_type => "varchar", is_nullable => 1, size => 255 },
533 { data_type => "mediumtext", is_nullable => 1 },
535 { data_type => "text", is_nullable => 1 },
537 { data_type => "text", is_nullable => 1 },
539 { data_type => "integer", is_nullable => 1 },
541 { data_type => "mediumtext", is_nullable => 1 },
543 { data_type => "varchar", is_nullable => 1, size => 100 },
545 { data_type => "varchar", is_nullable => 1, size => 1 },
547 { data_type => "varchar", is_nullable => 1, size => 60 },
549 { data_type => "integer", is_nullable => 1 },
551 { data_type => "varchar", is_nullable => 1, size => 75 },
553 { data_type => "mediumtext", is_nullable => 1 },
555 { data_type => "varchar", is_nullable => 1, size => 255 },
557 { data_type => "varchar", is_nullable => 1, size => 80 },
559 { data_type => "varchar", is_nullable => 1, size => 80 },
560 "altcontactfirstname",
561 { data_type => "varchar", is_nullable => 1, size => 255 },
563 { data_type => "varchar", is_nullable => 1, size => 255 },
564 "altcontactaddress1",
565 { data_type => "varchar", is_nullable => 1, size => 255 },
566 "altcontactaddress2",
567 { data_type => "varchar", is_nullable => 1, size => 255 },
568 "altcontactaddress3",
569 { data_type => "varchar", is_nullable => 1, size => 255 },
571 { data_type => "text", is_nullable => 1 },
573 { data_type => "varchar", is_nullable => 1, size => 50 },
575 { data_type => "text", is_nullable => 1 },
577 { data_type => "varchar", is_nullable => 1, size => 50 },
579 { data_type => "varchar", is_nullable => 1, size => 50 },
581 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
583 { data_type => "integer", default_value => 1, is_nullable => 0 },
584 "privacy_guarantor_checkouts",
585 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
588 data_type => "timestamp",
589 datetime_undef_if_invalid => 1,
590 default_value => \"current_timestamp",
599 =item * L</borrowernumber>
605 __PACKAGE__->set_primary_key("borrowernumber");
607 =head1 UNIQUE CONSTRAINTS
613 =item * L</cardnumber>
619 __PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
631 __PACKAGE__->add_unique_constraint("userid", ["userid"]);
639 Related object: L<Koha::Schema::Result::Accountline>
643 __PACKAGE__->has_many(
645 "Koha::Schema::Result::Accountline",
646 { "foreign.borrowernumber" => "self.borrowernumber" },
647 { cascade_copy => 0, cascade_delete => 0 },
650 =head2 accountoffsets
654 Related object: L<Koha::Schema::Result::Accountoffset>
658 __PACKAGE__->has_many(
660 "Koha::Schema::Result::Accountoffset",
661 { "foreign.borrowernumber" => "self.borrowernumber" },
662 { cascade_copy => 0, cascade_delete => 0 },
669 Related object: L<Koha::Schema::Result::Aqbasketuser>
673 __PACKAGE__->has_many(
675 "Koha::Schema::Result::Aqbasketuser",
676 { "foreign.borrowernumber" => "self.borrowernumber" },
677 { cascade_copy => 0, cascade_delete => 0 },
680 =head2 aqbudgetborrowers
684 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
688 __PACKAGE__->has_many(
690 "Koha::Schema::Result::Aqbudgetborrower",
691 { "foreign.borrowernumber" => "self.borrowernumber" },
692 { cascade_copy => 0, cascade_delete => 0 },
699 Related object: L<Koha::Schema::Result::AqorderUser>
703 __PACKAGE__->has_many(
705 "Koha::Schema::Result::AqorderUser",
706 { "foreign.borrowernumber" => "self.borrowernumber" },
707 { cascade_copy => 0, cascade_delete => 0 },
710 =head2 borrower_attributes
714 Related object: L<Koha::Schema::Result::BorrowerAttribute>
718 __PACKAGE__->has_many(
719 "borrower_attributes",
720 "Koha::Schema::Result::BorrowerAttribute",
721 { "foreign.borrowernumber" => "self.borrowernumber" },
722 { cascade_copy => 0, cascade_delete => 0 },
725 =head2 borrower_debarments
729 Related object: L<Koha::Schema::Result::BorrowerDebarment>
733 __PACKAGE__->has_many(
734 "borrower_debarments",
735 "Koha::Schema::Result::BorrowerDebarment",
736 { "foreign.borrowernumber" => "self.borrowernumber" },
737 { cascade_copy => 0, cascade_delete => 0 },
740 =head2 borrower_files
744 Related object: L<Koha::Schema::Result::BorrowerFile>
748 __PACKAGE__->has_many(
750 "Koha::Schema::Result::BorrowerFile",
751 { "foreign.borrowernumber" => "self.borrowernumber" },
752 { cascade_copy => 0, cascade_delete => 0 },
755 =head2 borrower_message_preferences
759 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
763 __PACKAGE__->has_many(
764 "borrower_message_preferences",
765 "Koha::Schema::Result::BorrowerMessagePreference",
766 { "foreign.borrowernumber" => "self.borrowernumber" },
767 { cascade_copy => 0, cascade_delete => 0 },
770 =head2 borrower_syncs
774 Related object: L<Koha::Schema::Result::BorrowerSync>
778 __PACKAGE__->has_many(
780 "Koha::Schema::Result::BorrowerSync",
781 { "foreign.borrowernumber" => "self.borrowernumber" },
782 { cascade_copy => 0, cascade_delete => 0 },
789 Related object: L<Koha::Schema::Result::Branch>
793 __PACKAGE__->belongs_to(
795 "Koha::Schema::Result::Branch",
796 { branchcode => "branchcode" },
797 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
804 Related object: L<Koha::Schema::Result::Category>
808 __PACKAGE__->belongs_to(
810 "Koha::Schema::Result::Category",
811 { categorycode => "categorycode" },
812 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
815 =head2 course_instructors
819 Related object: L<Koha::Schema::Result::CourseInstructor>
823 __PACKAGE__->has_many(
824 "course_instructors",
825 "Koha::Schema::Result::CourseInstructor",
826 { "foreign.borrowernumber" => "self.borrowernumber" },
827 { cascade_copy => 0, cascade_delete => 0 },
830 =head2 creator_batches
834 Related object: L<Koha::Schema::Result::CreatorBatch>
838 __PACKAGE__->has_many(
840 "Koha::Schema::Result::CreatorBatch",
841 { "foreign.borrower_number" => "self.borrowernumber" },
842 { cascade_copy => 0, cascade_delete => 0 },
849 Related object: L<Koha::Schema::Result::Discharge>
853 __PACKAGE__->has_many(
855 "Koha::Schema::Result::Discharge",
856 { "foreign.borrower" => "self.borrowernumber" },
857 { cascade_copy => 0, cascade_delete => 0 },
860 =head2 hold_fill_targets
864 Related object: L<Koha::Schema::Result::HoldFillTarget>
868 __PACKAGE__->has_many(
870 "Koha::Schema::Result::HoldFillTarget",
871 { "foreign.borrowernumber" => "self.borrowernumber" },
872 { cascade_copy => 0, cascade_delete => 0 },
879 Related object: L<Koha::Schema::Result::Issue>
883 __PACKAGE__->has_many(
885 "Koha::Schema::Result::Issue",
886 { "foreign.borrowernumber" => "self.borrowernumber" },
887 { cascade_copy => 0, cascade_delete => 0 },
890 =head2 items_last_borrowers
894 Related object: L<Koha::Schema::Result::ItemsLastBorrower>
898 __PACKAGE__->has_many(
899 "items_last_borrowers",
900 "Koha::Schema::Result::ItemsLastBorrower",
901 { "foreign.borrowernumber" => "self.borrowernumber" },
902 { cascade_copy => 0, cascade_delete => 0 },
905 =head2 message_queues
909 Related object: L<Koha::Schema::Result::MessageQueue>
913 __PACKAGE__->has_many(
915 "Koha::Schema::Result::MessageQueue",
916 { "foreign.borrowernumber" => "self.borrowernumber" },
917 { cascade_copy => 0, cascade_delete => 0 },
924 Related object: L<Koha::Schema::Result::OldIssue>
928 __PACKAGE__->has_many(
930 "Koha::Schema::Result::OldIssue",
931 { "foreign.borrowernumber" => "self.borrowernumber" },
932 { cascade_copy => 0, cascade_delete => 0 },
939 Related object: L<Koha::Schema::Result::OldReserve>
943 __PACKAGE__->has_many(
945 "Koha::Schema::Result::OldReserve",
946 { "foreign.borrowernumber" => "self.borrowernumber" },
947 { cascade_copy => 0, cascade_delete => 0 },
954 Related object: L<Koha::Schema::Result::OpacNews>
958 __PACKAGE__->has_many(
960 "Koha::Schema::Result::OpacNews",
961 { "foreign.borrowernumber" => "self.borrowernumber" },
962 { cascade_copy => 0, cascade_delete => 0 },
965 =head2 patron_list_patrons
969 Related object: L<Koha::Schema::Result::PatronListPatron>
973 __PACKAGE__->has_many(
974 "patron_list_patrons",
975 "Koha::Schema::Result::PatronListPatron",
976 { "foreign.borrowernumber" => "self.borrowernumber" },
977 { cascade_copy => 0, cascade_delete => 0 },
984 Related object: L<Koha::Schema::Result::PatronList>
988 __PACKAGE__->has_many(
990 "Koha::Schema::Result::PatronList",
991 { "foreign.owner" => "self.borrowernumber" },
992 { cascade_copy => 0, cascade_delete => 0 },
999 Related object: L<Koha::Schema::Result::Patronimage>
1003 __PACKAGE__->might_have(
1005 "Koha::Schema::Result::Patronimage",
1006 { "foreign.borrowernumber" => "self.borrowernumber" },
1007 { cascade_copy => 0, cascade_delete => 0 },
1014 Related object: L<Koha::Schema::Result::Rating>
1018 __PACKAGE__->has_many(
1020 "Koha::Schema::Result::Rating",
1021 { "foreign.borrowernumber" => "self.borrowernumber" },
1022 { cascade_copy => 0, cascade_delete => 0 },
1029 Related object: L<Koha::Schema::Result::Reserve>
1033 __PACKAGE__->has_many(
1035 "Koha::Schema::Result::Reserve",
1036 { "foreign.borrowernumber" => "self.borrowernumber" },
1037 { cascade_copy => 0, cascade_delete => 0 },
1044 Related object: L<Koha::Schema::Result::Review>
1048 __PACKAGE__->has_many(
1050 "Koha::Schema::Result::Review",
1051 { "foreign.borrowernumber" => "self.borrowernumber" },
1052 { cascade_copy => 0, cascade_delete => 0 },
1059 Related object: L<Koha::Schema::Result::SmsProvider>
1063 __PACKAGE__->belongs_to(
1065 "Koha::Schema::Result::SmsProvider",
1066 { id => "sms_provider_id" },
1069 join_type => "LEFT",
1070 on_delete => "SET NULL",
1071 on_update => "CASCADE",
1075 =head2 subscriptionroutinglists
1079 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
1083 __PACKAGE__->has_many(
1084 "subscriptionroutinglists",
1085 "Koha::Schema::Result::Subscriptionroutinglist",
1086 { "foreign.borrowernumber" => "self.borrowernumber" },
1087 { cascade_copy => 0, cascade_delete => 0 },
1094 Related object: L<Koha::Schema::Result::TagAll>
1098 __PACKAGE__->has_many(
1100 "Koha::Schema::Result::TagAll",
1101 { "foreign.borrowernumber" => "self.borrowernumber" },
1102 { cascade_copy => 0, cascade_delete => 0 },
1105 =head2 tags_approvals
1109 Related object: L<Koha::Schema::Result::TagsApproval>
1113 __PACKAGE__->has_many(
1115 "Koha::Schema::Result::TagsApproval",
1116 { "foreign.approved_by" => "self.borrowernumber" },
1117 { cascade_copy => 0, cascade_delete => 0 },
1120 =head2 user_permissions
1124 Related object: L<Koha::Schema::Result::UserPermission>
1128 __PACKAGE__->has_many(
1130 "Koha::Schema::Result::UserPermission",
1131 { "foreign.borrowernumber" => "self.borrowernumber" },
1132 { cascade_copy => 0, cascade_delete => 0 },
1135 =head2 virtualshelfcontents
1139 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
1143 __PACKAGE__->has_many(
1144 "virtualshelfcontents",
1145 "Koha::Schema::Result::Virtualshelfcontent",
1146 { "foreign.borrowernumber" => "self.borrowernumber" },
1147 { cascade_copy => 0, cascade_delete => 0 },
1150 =head2 virtualshelfshares
1154 Related object: L<Koha::Schema::Result::Virtualshelfshare>
1158 __PACKAGE__->has_many(
1159 "virtualshelfshares",
1160 "Koha::Schema::Result::Virtualshelfshare",
1161 { "foreign.borrowernumber" => "self.borrowernumber" },
1162 { cascade_copy => 0, cascade_delete => 0 },
1165 =head2 virtualshelves
1169 Related object: L<Koha::Schema::Result::Virtualshelve>
1173 __PACKAGE__->has_many(
1175 "Koha::Schema::Result::Virtualshelve",
1176 { "foreign.owner" => "self.borrowernumber" },
1177 { cascade_copy => 0, cascade_delete => 0 },
1184 Composing rels: L</aqbasketusers> -> basketno
1188 __PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
1194 Composing rels: L</aqbudgetborrowers> -> budget
1198 __PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget");
1204 Composing rels: L</course_instructors> -> course
1208 __PACKAGE__->many_to_many("courses", "course_instructors", "course");
1214 Composing rels: L</aqorder_users> -> ordernumber
1218 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1221 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2016-06-14 16:35:12
1222 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Luq1YVrOwtdDvSDWgWNGUg
1224 __PACKAGE__->belongs_to(
1226 "Koha::Schema::Result::Borrower",
1227 { borrowernumber => "guarantorid" },