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
162 data_type: 'mediumtext'
188 data_type: 'mediumtext'
194 datetime_undef_if_invalid: 1
200 default_value: (empty string)
208 default_value: (empty string)
216 datetime_undef_if_invalid: 1
222 datetime_undef_if_invalid: 1
238 datetime_undef_if_invalid: 1
241 =head2 debarredcomment
249 data_type: 'mediumtext'
252 =head2 contactfirstname
269 data_type: 'mediumtext'
315 data_type: 'mediumtext'
336 =head2 altcontactfirstname
342 =head2 altcontactsurname
348 =head2 altcontactaddress1
354 =head2 altcontactaddress2
360 =head2 altcontactaddress3
366 =head2 altcontactstate
371 =head2 altcontactzipcode
377 =head2 altcontactcountry
382 =head2 altcontactphone
388 =head2 smsalertnumber
402 __PACKAGE__->add_columns(
404 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
406 { data_type => "varchar", is_nullable => 1, size => 16 },
408 { data_type => "mediumtext", is_nullable => 0 },
410 { data_type => "text", is_nullable => 1 },
412 { data_type => "mediumtext", is_nullable => 1 },
414 { data_type => "mediumtext", is_nullable => 1 },
416 { data_type => "text", is_nullable => 1 },
418 { data_type => "varchar", is_nullable => 1, size => 10 },
420 { data_type => "varchar", is_nullable => 1, size => 50 },
422 { data_type => "mediumtext", is_nullable => 0 },
424 { data_type => "text", is_nullable => 1 },
426 { data_type => "mediumtext", is_nullable => 0 },
428 { data_type => "text", is_nullable => 1 },
430 { data_type => "varchar", is_nullable => 1, size => 25 },
432 { data_type => "text", is_nullable => 1 },
434 { data_type => "mediumtext", is_nullable => 1 },
436 { data_type => "text", is_nullable => 1 },
438 { data_type => "varchar", is_nullable => 1, size => 50 },
440 { data_type => "mediumtext", is_nullable => 1 },
442 { data_type => "text", is_nullable => 1 },
444 { data_type => "text", is_nullable => 1 },
446 { data_type => "varchar", is_nullable => 1, size => 10 },
448 { data_type => "varchar", is_nullable => 1, size => 50 },
450 { data_type => "varchar", is_nullable => 1, size => 100 },
452 { data_type => "text", is_nullable => 1 },
454 { data_type => "mediumtext", is_nullable => 1 },
456 { data_type => "text", is_nullable => 1 },
458 { data_type => "varchar", is_nullable => 1, size => 25 },
460 { data_type => "text", is_nullable => 1 },
462 { data_type => "text", is_nullable => 1 },
464 { data_type => "mediumtext", is_nullable => 1 },
466 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
469 data_type => "varchar",
477 data_type => "varchar",
484 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
486 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
488 { data_type => "tinyint", is_nullable => 1 },
490 { data_type => "tinyint", is_nullable => 1 },
492 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
494 { data_type => "varchar", is_nullable => 1, size => 255 },
496 { data_type => "mediumtext", is_nullable => 1 },
498 { data_type => "text", is_nullable => 1 },
500 { data_type => "text", is_nullable => 1 },
502 { data_type => "integer", is_nullable => 1 },
504 { data_type => "mediumtext", is_nullable => 1 },
506 { data_type => "varchar", is_nullable => 1, size => 100 },
508 { data_type => "varchar", is_nullable => 1, size => 50 },
510 { data_type => "varchar", is_nullable => 1, size => 255 },
512 { data_type => "varchar", is_nullable => 1, size => 1 },
514 { data_type => "varchar", is_nullable => 1, size => 60 },
516 { data_type => "integer", is_nullable => 1 },
518 { data_type => "varchar", is_nullable => 1, size => 75 },
520 { data_type => "mediumtext", is_nullable => 1 },
522 { data_type => "varchar", is_nullable => 1, size => 255 },
524 { data_type => "varchar", is_nullable => 1, size => 80 },
526 { data_type => "varchar", is_nullable => 1, size => 80 },
527 "altcontactfirstname",
528 { data_type => "varchar", is_nullable => 1, size => 255 },
530 { data_type => "varchar", is_nullable => 1, size => 255 },
531 "altcontactaddress1",
532 { data_type => "varchar", is_nullable => 1, size => 255 },
533 "altcontactaddress2",
534 { data_type => "varchar", is_nullable => 1, size => 255 },
535 "altcontactaddress3",
536 { data_type => "varchar", is_nullable => 1, size => 255 },
538 { data_type => "text", is_nullable => 1 },
540 { data_type => "varchar", is_nullable => 1, size => 50 },
542 { data_type => "text", is_nullable => 1 },
544 { data_type => "varchar", is_nullable => 1, size => 50 },
546 { data_type => "varchar", is_nullable => 1, size => 50 },
548 { data_type => "integer", default_value => 1, is_nullable => 0 },
555 =item * L</borrowernumber>
561 __PACKAGE__->set_primary_key("borrowernumber");
563 =head1 UNIQUE CONSTRAINTS
569 =item * L</cardnumber>
575 __PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
583 Related object: L<Koha::Schema::Result::Accountline>
587 __PACKAGE__->has_many(
589 "Koha::Schema::Result::Accountline",
590 { "foreign.borrowernumber" => "self.borrowernumber" },
591 { cascade_copy => 0, cascade_delete => 0 },
594 =head2 accountoffsets
598 Related object: L<Koha::Schema::Result::Accountoffset>
602 __PACKAGE__->has_many(
604 "Koha::Schema::Result::Accountoffset",
605 { "foreign.borrowernumber" => "self.borrowernumber" },
606 { cascade_copy => 0, cascade_delete => 0 },
613 Related object: L<Koha::Schema::Result::Aqbasketuser>
617 __PACKAGE__->has_many(
619 "Koha::Schema::Result::Aqbasketuser",
620 { "foreign.borrowernumber" => "self.borrowernumber" },
621 { cascade_copy => 0, cascade_delete => 0 },
624 =head2 aqbudgetborrowers
628 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
632 __PACKAGE__->has_many(
634 "Koha::Schema::Result::Aqbudgetborrower",
635 { "foreign.borrowernumber" => "self.borrowernumber" },
636 { cascade_copy => 0, cascade_delete => 0 },
639 =head2 borrower_attributes
643 Related object: L<Koha::Schema::Result::BorrowerAttribute>
647 __PACKAGE__->has_many(
648 "borrower_attributes",
649 "Koha::Schema::Result::BorrowerAttribute",
650 { "foreign.borrowernumber" => "self.borrowernumber" },
651 { cascade_copy => 0, cascade_delete => 0 },
654 =head2 borrower_debarments
658 Related object: L<Koha::Schema::Result::BorrowerDebarment>
662 __PACKAGE__->has_many(
663 "borrower_debarments",
664 "Koha::Schema::Result::BorrowerDebarment",
665 { "foreign.borrowernumber" => "self.borrowernumber" },
666 { cascade_copy => 0, cascade_delete => 0 },
669 =head2 borrower_files
673 Related object: L<Koha::Schema::Result::BorrowerFile>
677 __PACKAGE__->has_many(
679 "Koha::Schema::Result::BorrowerFile",
680 { "foreign.borrowernumber" => "self.borrowernumber" },
681 { cascade_copy => 0, cascade_delete => 0 },
684 =head2 borrower_message_preferences
688 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
692 __PACKAGE__->has_many(
693 "borrower_message_preferences",
694 "Koha::Schema::Result::BorrowerMessagePreference",
695 { "foreign.borrowernumber" => "self.borrowernumber" },
696 { cascade_copy => 0, cascade_delete => 0 },
703 Related object: L<Koha::Schema::Result::Branch>
707 __PACKAGE__->belongs_to(
709 "Koha::Schema::Result::Branch",
710 { branchcode => "branchcode" },
711 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
718 Related object: L<Koha::Schema::Result::Category>
722 __PACKAGE__->belongs_to(
724 "Koha::Schema::Result::Category",
725 { categorycode => "categorycode" },
726 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
729 =head2 course_instructors
733 Related object: L<Koha::Schema::Result::CourseInstructor>
737 __PACKAGE__->has_many(
738 "course_instructors",
739 "Koha::Schema::Result::CourseInstructor",
740 { "foreign.borrowernumber" => "self.borrowernumber" },
741 { cascade_copy => 0, cascade_delete => 0 },
744 =head2 creator_batches
748 Related object: L<Koha::Schema::Result::CreatorBatch>
752 __PACKAGE__->has_many(
754 "Koha::Schema::Result::CreatorBatch",
755 { "foreign.borrower_number" => "self.borrowernumber" },
756 { cascade_copy => 0, cascade_delete => 0 },
759 =head2 hold_fill_targets
763 Related object: L<Koha::Schema::Result::HoldFillTarget>
767 __PACKAGE__->has_many(
769 "Koha::Schema::Result::HoldFillTarget",
770 { "foreign.borrowernumber" => "self.borrowernumber" },
771 { cascade_copy => 0, cascade_delete => 0 },
778 Related object: L<Koha::Schema::Result::Issue>
782 __PACKAGE__->has_many(
784 "Koha::Schema::Result::Issue",
785 { "foreign.borrowernumber" => "self.borrowernumber" },
786 { cascade_copy => 0, cascade_delete => 0 },
789 =head2 message_queues
793 Related object: L<Koha::Schema::Result::MessageQueue>
797 __PACKAGE__->has_many(
799 "Koha::Schema::Result::MessageQueue",
800 { "foreign.borrowernumber" => "self.borrowernumber" },
801 { cascade_copy => 0, cascade_delete => 0 },
808 Related object: L<Koha::Schema::Result::OldIssue>
812 __PACKAGE__->has_many(
814 "Koha::Schema::Result::OldIssue",
815 { "foreign.borrowernumber" => "self.borrowernumber" },
816 { cascade_copy => 0, cascade_delete => 0 },
823 Related object: L<Koha::Schema::Result::OldReserve>
827 __PACKAGE__->has_many(
829 "Koha::Schema::Result::OldReserve",
830 { "foreign.borrowernumber" => "self.borrowernumber" },
831 { cascade_copy => 0, cascade_delete => 0 },
834 =head2 patron_list_patrons
838 Related object: L<Koha::Schema::Result::PatronListPatron>
842 __PACKAGE__->has_many(
843 "patron_list_patrons",
844 "Koha::Schema::Result::PatronListPatron",
845 { "foreign.borrowernumber" => "self.borrowernumber" },
846 { cascade_copy => 0, cascade_delete => 0 },
853 Related object: L<Koha::Schema::Result::PatronList>
857 __PACKAGE__->has_many(
859 "Koha::Schema::Result::PatronList",
860 { "foreign.owner" => "self.borrowernumber" },
861 { cascade_copy => 0, cascade_delete => 0 },
868 Related object: L<Koha::Schema::Result::Patroncard>
872 __PACKAGE__->has_many(
874 "Koha::Schema::Result::Patroncard",
875 { "foreign.borrowernumber" => "self.borrowernumber" },
876 { cascade_copy => 0, cascade_delete => 0 },
883 Related object: L<Koha::Schema::Result::Patronimage>
887 __PACKAGE__->might_have(
889 "Koha::Schema::Result::Patronimage",
890 { "foreign.borrowernumber" => "self.borrowernumber" },
891 { cascade_copy => 0, cascade_delete => 0 },
898 Related object: L<Koha::Schema::Result::Rating>
902 __PACKAGE__->has_many(
904 "Koha::Schema::Result::Rating",
905 { "foreign.borrowernumber" => "self.borrowernumber" },
906 { cascade_copy => 0, cascade_delete => 0 },
913 Related object: L<Koha::Schema::Result::Reserve>
917 __PACKAGE__->has_many(
919 "Koha::Schema::Result::Reserve",
920 { "foreign.borrowernumber" => "self.borrowernumber" },
921 { cascade_copy => 0, cascade_delete => 0 },
928 Related object: L<Koha::Schema::Result::Review>
932 __PACKAGE__->has_many(
934 "Koha::Schema::Result::Review",
935 { "foreign.borrowernumber" => "self.borrowernumber" },
936 { cascade_copy => 0, cascade_delete => 0 },
939 =head2 subscriptionroutinglists
943 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
947 __PACKAGE__->has_many(
948 "subscriptionroutinglists",
949 "Koha::Schema::Result::Subscriptionroutinglist",
950 { "foreign.borrowernumber" => "self.borrowernumber" },
951 { cascade_copy => 0, cascade_delete => 0 },
958 Related object: L<Koha::Schema::Result::TagAll>
962 __PACKAGE__->has_many(
964 "Koha::Schema::Result::TagAll",
965 { "foreign.borrowernumber" => "self.borrowernumber" },
966 { cascade_copy => 0, cascade_delete => 0 },
969 =head2 tags_approvals
973 Related object: L<Koha::Schema::Result::TagsApproval>
977 __PACKAGE__->has_many(
979 "Koha::Schema::Result::TagsApproval",
980 { "foreign.approved_by" => "self.borrowernumber" },
981 { cascade_copy => 0, cascade_delete => 0 },
984 =head2 user_permissions
988 Related object: L<Koha::Schema::Result::UserPermission>
992 __PACKAGE__->has_many(
994 "Koha::Schema::Result::UserPermission",
995 { "foreign.borrowernumber" => "self.borrowernumber" },
996 { cascade_copy => 0, cascade_delete => 0 },
999 =head2 virtualshelfcontents
1003 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
1007 __PACKAGE__->has_many(
1008 "virtualshelfcontents",
1009 "Koha::Schema::Result::Virtualshelfcontent",
1010 { "foreign.borrowernumber" => "self.borrowernumber" },
1011 { cascade_copy => 0, cascade_delete => 0 },
1014 =head2 virtualshelfshares
1018 Related object: L<Koha::Schema::Result::Virtualshelfshare>
1022 __PACKAGE__->has_many(
1023 "virtualshelfshares",
1024 "Koha::Schema::Result::Virtualshelfshare",
1025 { "foreign.borrowernumber" => "self.borrowernumber" },
1026 { cascade_copy => 0, cascade_delete => 0 },
1029 =head2 virtualshelves
1033 Related object: L<Koha::Schema::Result::Virtualshelve>
1037 __PACKAGE__->has_many(
1039 "Koha::Schema::Result::Virtualshelve",
1040 { "foreign.owner" => "self.borrowernumber" },
1041 { cascade_copy => 0, cascade_delete => 0 },
1048 Composing rels: L</aqbasketusers> -> basketno
1052 __PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
1058 Composing rels: L</aqbudgetborrowers> -> budget
1062 __PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget");
1068 Composing rels: L</course_instructors> -> course
1072 __PACKAGE__->many_to_many("courses", "course_instructors", "course");
1075 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
1076 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5cfpOojccKCoVRMj+0mWHg
1079 # You can replace this text with custom content, and it will be preserved on regeneration