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
400 __PACKAGE__->add_columns(
402 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
404 { data_type => "varchar", is_nullable => 1, size => 16 },
406 { data_type => "mediumtext", is_nullable => 0 },
408 { data_type => "text", is_nullable => 1 },
410 { data_type => "mediumtext", is_nullable => 1 },
412 { data_type => "mediumtext", is_nullable => 1 },
414 { data_type => "text", is_nullable => 1 },
416 { data_type => "varchar", is_nullable => 1, size => 10 },
418 { data_type => "varchar", is_nullable => 1, size => 50 },
420 { data_type => "mediumtext", is_nullable => 0 },
422 { data_type => "text", is_nullable => 1 },
424 { data_type => "mediumtext", is_nullable => 0 },
426 { data_type => "text", is_nullable => 1 },
428 { data_type => "varchar", is_nullable => 1, size => 25 },
430 { data_type => "text", is_nullable => 1 },
432 { data_type => "mediumtext", is_nullable => 1 },
434 { data_type => "text", is_nullable => 1 },
436 { data_type => "varchar", is_nullable => 1, size => 50 },
438 { data_type => "mediumtext", is_nullable => 1 },
440 { data_type => "text", is_nullable => 1 },
442 { data_type => "text", is_nullable => 1 },
445 accessor => "b_streetnumber",
446 data_type => "varchar",
452 accessor => "b_streettype",
453 data_type => "varchar",
459 accessor => "b_address",
460 data_type => "varchar",
465 { accessor => "b_address2", data_type => "text", is_nullable => 1 },
467 { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
469 { accessor => "b_state", data_type => "text", is_nullable => 1 },
472 accessor => "b_zipcode",
473 data_type => "varchar",
478 { accessor => "b_country", data_type => "text", is_nullable => 1 },
480 { accessor => "b_email", data_type => "text", is_nullable => 1 },
482 { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
484 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
487 data_type => "varchar",
495 data_type => "varchar",
502 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
504 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
506 { data_type => "tinyint", is_nullable => 1 },
508 { data_type => "tinyint", is_nullable => 1 },
510 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
512 { data_type => "varchar", is_nullable => 1, size => 255 },
514 { data_type => "mediumtext", is_nullable => 1 },
516 { data_type => "text", is_nullable => 1 },
518 { data_type => "text", is_nullable => 1 },
520 { data_type => "integer", is_nullable => 1 },
522 { data_type => "mediumtext", is_nullable => 1 },
524 { data_type => "varchar", is_nullable => 1, size => 100 },
526 { data_type => "varchar", is_nullable => 1, size => 1 },
528 { data_type => "varchar", is_nullable => 1, size => 60 },
530 { data_type => "integer", is_nullable => 1 },
532 { data_type => "varchar", is_nullable => 1, size => 75 },
534 { data_type => "mediumtext", is_nullable => 1 },
536 { data_type => "varchar", is_nullable => 1, size => 255 },
538 { data_type => "varchar", is_nullable => 1, size => 80 },
540 { data_type => "varchar", is_nullable => 1, size => 80 },
541 "altcontactfirstname",
542 { data_type => "varchar", is_nullable => 1, size => 255 },
544 { data_type => "varchar", is_nullable => 1, size => 255 },
545 "altcontactaddress1",
546 { data_type => "varchar", is_nullable => 1, size => 255 },
547 "altcontactaddress2",
548 { data_type => "varchar", is_nullable => 1, size => 255 },
549 "altcontactaddress3",
550 { data_type => "varchar", is_nullable => 1, size => 255 },
552 { data_type => "text", is_nullable => 1 },
554 { data_type => "varchar", is_nullable => 1, size => 50 },
556 { data_type => "text", is_nullable => 1 },
558 { data_type => "varchar", is_nullable => 1, size => 50 },
560 { data_type => "varchar", is_nullable => 1, size => 50 },
562 { data_type => "integer", default_value => 1, is_nullable => 0 },
569 =item * L</borrowernumber>
575 __PACKAGE__->set_primary_key("borrowernumber");
577 =head1 UNIQUE CONSTRAINTS
583 =item * L</cardnumber>
589 __PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
601 __PACKAGE__->add_unique_constraint("userid", ["userid"]);
609 Related object: L<Koha::Schema::Result::Accountline>
613 __PACKAGE__->has_many(
615 "Koha::Schema::Result::Accountline",
616 { "foreign.borrowernumber" => "self.borrowernumber" },
617 { cascade_copy => 0, cascade_delete => 0 },
620 =head2 accountoffsets
624 Related object: L<Koha::Schema::Result::Accountoffset>
628 __PACKAGE__->has_many(
630 "Koha::Schema::Result::Accountoffset",
631 { "foreign.borrowernumber" => "self.borrowernumber" },
632 { cascade_copy => 0, cascade_delete => 0 },
639 Related object: L<Koha::Schema::Result::Aqbasketuser>
643 __PACKAGE__->has_many(
645 "Koha::Schema::Result::Aqbasketuser",
646 { "foreign.borrowernumber" => "self.borrowernumber" },
647 { cascade_copy => 0, cascade_delete => 0 },
650 =head2 aqbudgetborrowers
654 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
658 __PACKAGE__->has_many(
660 "Koha::Schema::Result::Aqbudgetborrower",
661 { "foreign.borrowernumber" => "self.borrowernumber" },
662 { cascade_copy => 0, cascade_delete => 0 },
669 Related object: L<Koha::Schema::Result::AqorderUser>
673 __PACKAGE__->has_many(
675 "Koha::Schema::Result::AqorderUser",
676 { "foreign.borrowernumber" => "self.borrowernumber" },
677 { cascade_copy => 0, cascade_delete => 0 },
680 =head2 borrower_attributes
684 Related object: L<Koha::Schema::Result::BorrowerAttribute>
688 __PACKAGE__->has_many(
689 "borrower_attributes",
690 "Koha::Schema::Result::BorrowerAttribute",
691 { "foreign.borrowernumber" => "self.borrowernumber" },
692 { cascade_copy => 0, cascade_delete => 0 },
695 =head2 borrower_debarments
699 Related object: L<Koha::Schema::Result::BorrowerDebarment>
703 __PACKAGE__->has_many(
704 "borrower_debarments",
705 "Koha::Schema::Result::BorrowerDebarment",
706 { "foreign.borrowernumber" => "self.borrowernumber" },
707 { cascade_copy => 0, cascade_delete => 0 },
710 =head2 borrower_files
714 Related object: L<Koha::Schema::Result::BorrowerFile>
718 __PACKAGE__->has_many(
720 "Koha::Schema::Result::BorrowerFile",
721 { "foreign.borrowernumber" => "self.borrowernumber" },
722 { cascade_copy => 0, cascade_delete => 0 },
725 =head2 borrower_message_preferences
729 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
733 __PACKAGE__->has_many(
734 "borrower_message_preferences",
735 "Koha::Schema::Result::BorrowerMessagePreference",
736 { "foreign.borrowernumber" => "self.borrowernumber" },
737 { cascade_copy => 0, cascade_delete => 0 },
740 =head2 borrower_syncs
744 Related object: L<Koha::Schema::Result::BorrowerSync>
748 __PACKAGE__->has_many(
750 "Koha::Schema::Result::BorrowerSync",
751 { "foreign.borrowernumber" => "self.borrowernumber" },
752 { cascade_copy => 0, cascade_delete => 0 },
759 Related object: L<Koha::Schema::Result::Branch>
763 __PACKAGE__->belongs_to(
765 "Koha::Schema::Result::Branch",
766 { branchcode => "branchcode" },
767 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
774 Related object: L<Koha::Schema::Result::Category>
778 __PACKAGE__->belongs_to(
780 "Koha::Schema::Result::Category",
781 { categorycode => "categorycode" },
782 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
785 =head2 course_instructors
789 Related object: L<Koha::Schema::Result::CourseInstructor>
793 __PACKAGE__->has_many(
794 "course_instructors",
795 "Koha::Schema::Result::CourseInstructor",
796 { "foreign.borrowernumber" => "self.borrowernumber" },
797 { cascade_copy => 0, cascade_delete => 0 },
800 =head2 creator_batches
804 Related object: L<Koha::Schema::Result::CreatorBatch>
808 __PACKAGE__->has_many(
810 "Koha::Schema::Result::CreatorBatch",
811 { "foreign.borrower_number" => "self.borrowernumber" },
812 { cascade_copy => 0, cascade_delete => 0 },
819 Related object: L<Koha::Schema::Result::Discharge>
823 __PACKAGE__->has_many(
825 "Koha::Schema::Result::Discharge",
826 { "foreign.borrower" => "self.borrowernumber" },
827 { cascade_copy => 0, cascade_delete => 0 },
830 =head2 hold_fill_targets
834 Related object: L<Koha::Schema::Result::HoldFillTarget>
838 __PACKAGE__->has_many(
840 "Koha::Schema::Result::HoldFillTarget",
841 { "foreign.borrowernumber" => "self.borrowernumber" },
842 { cascade_copy => 0, cascade_delete => 0 },
849 Related object: L<Koha::Schema::Result::Issue>
853 __PACKAGE__->has_many(
855 "Koha::Schema::Result::Issue",
856 { "foreign.borrowernumber" => "self.borrowernumber" },
857 { cascade_copy => 0, cascade_delete => 0 },
860 =head2 message_queues
864 Related object: L<Koha::Schema::Result::MessageQueue>
868 __PACKAGE__->has_many(
870 "Koha::Schema::Result::MessageQueue",
871 { "foreign.borrowernumber" => "self.borrowernumber" },
872 { cascade_copy => 0, cascade_delete => 0 },
879 Related object: L<Koha::Schema::Result::OldIssue>
883 __PACKAGE__->has_many(
885 "Koha::Schema::Result::OldIssue",
886 { "foreign.borrowernumber" => "self.borrowernumber" },
887 { cascade_copy => 0, cascade_delete => 0 },
894 Related object: L<Koha::Schema::Result::OldReserve>
898 __PACKAGE__->has_many(
900 "Koha::Schema::Result::OldReserve",
901 { "foreign.borrowernumber" => "self.borrowernumber" },
902 { cascade_copy => 0, cascade_delete => 0 },
909 Related object: L<Koha::Schema::Result::OpacNews>
913 __PACKAGE__->has_many(
915 "Koha::Schema::Result::OpacNews",
916 { "foreign.borrowernumber" => "self.borrowernumber" },
917 { cascade_copy => 0, cascade_delete => 0 },
920 =head2 patron_list_patrons
924 Related object: L<Koha::Schema::Result::PatronListPatron>
928 __PACKAGE__->has_many(
929 "patron_list_patrons",
930 "Koha::Schema::Result::PatronListPatron",
931 { "foreign.borrowernumber" => "self.borrowernumber" },
932 { cascade_copy => 0, cascade_delete => 0 },
939 Related object: L<Koha::Schema::Result::PatronList>
943 __PACKAGE__->has_many(
945 "Koha::Schema::Result::PatronList",
946 { "foreign.owner" => "self.borrowernumber" },
947 { cascade_copy => 0, cascade_delete => 0 },
954 Related object: L<Koha::Schema::Result::Patronimage>
958 __PACKAGE__->might_have(
960 "Koha::Schema::Result::Patronimage",
961 { "foreign.borrowernumber" => "self.borrowernumber" },
962 { cascade_copy => 0, cascade_delete => 0 },
969 Related object: L<Koha::Schema::Result::Rating>
973 __PACKAGE__->has_many(
975 "Koha::Schema::Result::Rating",
976 { "foreign.borrowernumber" => "self.borrowernumber" },
977 { cascade_copy => 0, cascade_delete => 0 },
984 Related object: L<Koha::Schema::Result::Reserve>
988 __PACKAGE__->has_many(
990 "Koha::Schema::Result::Reserve",
991 { "foreign.borrowernumber" => "self.borrowernumber" },
992 { cascade_copy => 0, cascade_delete => 0 },
999 Related object: L<Koha::Schema::Result::Review>
1003 __PACKAGE__->has_many(
1005 "Koha::Schema::Result::Review",
1006 { "foreign.borrowernumber" => "self.borrowernumber" },
1007 { cascade_copy => 0, cascade_delete => 0 },
1010 =head2 subscriptionroutinglists
1014 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
1018 __PACKAGE__->has_many(
1019 "subscriptionroutinglists",
1020 "Koha::Schema::Result::Subscriptionroutinglist",
1021 { "foreign.borrowernumber" => "self.borrowernumber" },
1022 { cascade_copy => 0, cascade_delete => 0 },
1029 Related object: L<Koha::Schema::Result::TagAll>
1033 __PACKAGE__->has_many(
1035 "Koha::Schema::Result::TagAll",
1036 { "foreign.borrowernumber" => "self.borrowernumber" },
1037 { cascade_copy => 0, cascade_delete => 0 },
1040 =head2 tags_approvals
1044 Related object: L<Koha::Schema::Result::TagsApproval>
1048 __PACKAGE__->has_many(
1050 "Koha::Schema::Result::TagsApproval",
1051 { "foreign.approved_by" => "self.borrowernumber" },
1052 { cascade_copy => 0, cascade_delete => 0 },
1055 =head2 user_permissions
1059 Related object: L<Koha::Schema::Result::UserPermission>
1063 __PACKAGE__->has_many(
1065 "Koha::Schema::Result::UserPermission",
1066 { "foreign.borrowernumber" => "self.borrowernumber" },
1067 { cascade_copy => 0, cascade_delete => 0 },
1070 =head2 virtualshelfcontents
1074 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
1078 __PACKAGE__->has_many(
1079 "virtualshelfcontents",
1080 "Koha::Schema::Result::Virtualshelfcontent",
1081 { "foreign.borrowernumber" => "self.borrowernumber" },
1082 { cascade_copy => 0, cascade_delete => 0 },
1085 =head2 virtualshelfshares
1089 Related object: L<Koha::Schema::Result::Virtualshelfshare>
1093 __PACKAGE__->has_many(
1094 "virtualshelfshares",
1095 "Koha::Schema::Result::Virtualshelfshare",
1096 { "foreign.borrowernumber" => "self.borrowernumber" },
1097 { cascade_copy => 0, cascade_delete => 0 },
1100 =head2 virtualshelves
1104 Related object: L<Koha::Schema::Result::Virtualshelve>
1108 __PACKAGE__->has_many(
1110 "Koha::Schema::Result::Virtualshelve",
1111 { "foreign.owner" => "self.borrowernumber" },
1112 { cascade_copy => 0, cascade_delete => 0 },
1119 Composing rels: L</aqbasketusers> -> basketno
1123 __PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
1129 Composing rels: L</aqbudgetborrowers> -> budget
1133 __PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget");
1139 Composing rels: L</course_instructors> -> course
1143 __PACKAGE__->many_to_many("courses", "course_instructors", "course");
1149 Composing rels: L</aqorder_users> -> ordernumber
1153 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1156 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-10-21 19:50:05
1157 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:QafovaRBnm36nyoyQTGIgQ
1160 # You can replace this text with custom content, and it will be preserved on regeneration