1 package Koha::Schema::Result::Borrower;
3 # Created by DBIx::Class::Schema::Loader
4 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 use base 'DBIx::Class::Core';
14 Koha::Schema::Result::Borrower
18 __PACKAGE__->table("borrowers");
36 data_type: 'mediumtext'
46 data_type: 'mediumtext'
51 data_type: 'mediumtext'
73 data_type: 'mediumtext'
83 data_type: 'mediumtext'
88 data_type: 'mediumtext'
104 data_type: 'mediumtext'
120 data_type: 'mediumtext'
133 =head2 b_streetnumber
158 data_type: 'mediumtext'
163 data_type: 'mediumtext'
184 data_type: 'mediumtext'
195 default_value: (empty string)
203 default_value: (empty string)
233 =head2 debarredcomment
241 data_type: 'mediumtext'
244 =head2 contactfirstname
261 data_type: 'mediumtext'
307 data_type: 'mediumtext'
328 =head2 altcontactfirstname
334 =head2 altcontactsurname
340 =head2 altcontactaddress1
346 =head2 altcontactaddress2
352 =head2 altcontactaddress3
358 =head2 altcontactstate
360 data_type: 'mediumtext'
363 =head2 altcontactzipcode
369 =head2 altcontactcountry
374 =head2 altcontactphone
380 =head2 smsalertnumber
394 __PACKAGE__->add_columns(
396 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
398 { data_type => "varchar", is_nullable => 1, size => 16 },
400 { data_type => "mediumtext", is_nullable => 0 },
402 { data_type => "text", is_nullable => 1 },
404 { data_type => "mediumtext", is_nullable => 1 },
406 { data_type => "mediumtext", is_nullable => 1 },
408 { data_type => "text", is_nullable => 1 },
410 { data_type => "varchar", is_nullable => 1, size => 10 },
412 { data_type => "varchar", is_nullable => 1, size => 50 },
414 { data_type => "mediumtext", is_nullable => 0 },
416 { data_type => "text", is_nullable => 1 },
418 { data_type => "mediumtext", is_nullable => 0 },
420 { data_type => "mediumtext", is_nullable => 1 },
422 { data_type => "varchar", is_nullable => 1, size => 25 },
424 { data_type => "text", is_nullable => 1 },
426 { data_type => "mediumtext", is_nullable => 1 },
428 { data_type => "text", is_nullable => 1 },
430 { data_type => "varchar", is_nullable => 1, size => 50 },
432 { data_type => "mediumtext", is_nullable => 1 },
434 { data_type => "text", is_nullable => 1 },
436 { data_type => "text", is_nullable => 1 },
438 { data_type => "varchar", is_nullable => 1, size => 10 },
440 { data_type => "varchar", is_nullable => 1, size => 50 },
442 { data_type => "varchar", is_nullable => 1, size => 100 },
444 { data_type => "text", is_nullable => 1 },
446 { data_type => "mediumtext", is_nullable => 1 },
448 { data_type => "mediumtext", is_nullable => 1 },
450 { data_type => "varchar", is_nullable => 1, size => 25 },
452 { data_type => "text", is_nullable => 1 },
454 { data_type => "text", is_nullable => 1 },
456 { data_type => "mediumtext", is_nullable => 1 },
458 { data_type => "date", is_nullable => 1 },
461 data_type => "varchar",
469 data_type => "varchar",
476 { data_type => "date", is_nullable => 1 },
478 { data_type => "date", is_nullable => 1 },
480 { data_type => "tinyint", is_nullable => 1 },
482 { data_type => "tinyint", is_nullable => 1 },
484 { data_type => "date", is_nullable => 1 },
486 { data_type => "varchar", is_nullable => 1, size => 255 },
488 { data_type => "mediumtext", is_nullable => 1 },
490 { data_type => "text", is_nullable => 1 },
492 { data_type => "text", is_nullable => 1 },
494 { data_type => "integer", is_nullable => 1 },
496 { data_type => "mediumtext", is_nullable => 1 },
498 { data_type => "varchar", is_nullable => 1, size => 100 },
500 { data_type => "varchar", is_nullable => 1, size => 50 },
502 { data_type => "varchar", is_nullable => 1, size => 255 },
504 { data_type => "varchar", is_nullable => 1, size => 1 },
506 { data_type => "varchar", is_nullable => 1, size => 30 },
508 { data_type => "integer", is_nullable => 1 },
510 { data_type => "varchar", is_nullable => 1, size => 75 },
512 { data_type => "mediumtext", is_nullable => 1 },
514 { data_type => "varchar", is_nullable => 1, size => 255 },
516 { data_type => "varchar", is_nullable => 1, size => 80 },
518 { data_type => "varchar", is_nullable => 1, size => 80 },
519 "altcontactfirstname",
520 { data_type => "varchar", is_nullable => 1, size => 255 },
522 { data_type => "varchar", is_nullable => 1, size => 255 },
523 "altcontactaddress1",
524 { data_type => "varchar", is_nullable => 1, size => 255 },
525 "altcontactaddress2",
526 { data_type => "varchar", is_nullable => 1, size => 255 },
527 "altcontactaddress3",
528 { data_type => "varchar", is_nullable => 1, size => 255 },
530 { data_type => "mediumtext", is_nullable => 1 },
532 { data_type => "varchar", is_nullable => 1, size => 50 },
534 { data_type => "text", is_nullable => 1 },
536 { data_type => "varchar", is_nullable => 1, size => 50 },
538 { data_type => "varchar", is_nullable => 1, size => 50 },
540 { data_type => "integer", default_value => 1, is_nullable => 0 },
542 __PACKAGE__->set_primary_key("borrowernumber");
543 __PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
551 Related object: L<Koha::Schema::Result::Accountline>
555 __PACKAGE__->has_many(
557 "Koha::Schema::Result::Accountline",
558 { "foreign.borrowernumber" => "self.borrowernumber" },
559 { cascade_copy => 0, cascade_delete => 0 },
562 =head2 accountoffsets
566 Related object: L<Koha::Schema::Result::Accountoffset>
570 __PACKAGE__->has_many(
572 "Koha::Schema::Result::Accountoffset",
573 { "foreign.borrowernumber" => "self.borrowernumber" },
574 { cascade_copy => 0, cascade_delete => 0 },
577 =head2 aqbudgetborrowers
581 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
585 __PACKAGE__->has_many(
587 "Koha::Schema::Result::Aqbudgetborrower",
588 { "foreign.borrowernumber" => "self.borrowernumber" },
589 { cascade_copy => 0, cascade_delete => 0 },
592 =head2 borrower_attributes
596 Related object: L<Koha::Schema::Result::BorrowerAttribute>
600 __PACKAGE__->has_many(
601 "borrower_attributes",
602 "Koha::Schema::Result::BorrowerAttribute",
603 { "foreign.borrowernumber" => "self.borrowernumber" },
604 { cascade_copy => 0, cascade_delete => 0 },
607 =head2 borrower_files
611 Related object: L<Koha::Schema::Result::BorrowerFile>
615 __PACKAGE__->has_many(
617 "Koha::Schema::Result::BorrowerFile",
618 { "foreign.borrowernumber" => "self.borrowernumber" },
619 { cascade_copy => 0, cascade_delete => 0 },
622 =head2 borrower_message_preferences
626 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
630 __PACKAGE__->has_many(
631 "borrower_message_preferences",
632 "Koha::Schema::Result::BorrowerMessagePreference",
633 { "foreign.borrowernumber" => "self.borrowernumber" },
634 { cascade_copy => 0, cascade_delete => 0 },
641 Related object: L<Koha::Schema::Result::Category>
645 __PACKAGE__->belongs_to(
647 "Koha::Schema::Result::Category",
648 { categorycode => "categorycode" },
649 { on_delete => "CASCADE", on_update => "CASCADE" },
656 Related object: L<Koha::Schema::Result::Branch>
660 __PACKAGE__->belongs_to(
662 "Koha::Schema::Result::Branch",
663 { branchcode => "branchcode" },
664 { on_delete => "CASCADE", on_update => "CASCADE" },
667 =head2 creator_batches
671 Related object: L<Koha::Schema::Result::CreatorBatch>
675 __PACKAGE__->has_many(
677 "Koha::Schema::Result::CreatorBatch",
678 { "foreign.borrower_number" => "self.borrowernumber" },
679 { cascade_copy => 0, cascade_delete => 0 },
682 =head2 hold_fill_targets
686 Related object: L<Koha::Schema::Result::HoldFillTarget>
690 __PACKAGE__->has_many(
692 "Koha::Schema::Result::HoldFillTarget",
693 { "foreign.borrowernumber" => "self.borrowernumber" },
694 { cascade_copy => 0, cascade_delete => 0 },
701 Related object: L<Koha::Schema::Result::Issue>
705 __PACKAGE__->has_many(
707 "Koha::Schema::Result::Issue",
708 { "foreign.borrowernumber" => "self.borrowernumber" },
709 { cascade_copy => 0, cascade_delete => 0 },
712 =head2 message_queues
716 Related object: L<Koha::Schema::Result::MessageQueue>
720 __PACKAGE__->has_many(
722 "Koha::Schema::Result::MessageQueue",
723 { "foreign.borrowernumber" => "self.borrowernumber" },
724 { cascade_copy => 0, cascade_delete => 0 },
731 Related object: L<Koha::Schema::Result::OldIssue>
735 __PACKAGE__->has_many(
737 "Koha::Schema::Result::OldIssue",
738 { "foreign.borrowernumber" => "self.borrowernumber" },
739 { cascade_copy => 0, cascade_delete => 0 },
746 Related object: L<Koha::Schema::Result::OldReserve>
750 __PACKAGE__->has_many(
752 "Koha::Schema::Result::OldReserve",
753 { "foreign.borrowernumber" => "self.borrowernumber" },
754 { cascade_copy => 0, cascade_delete => 0 },
761 Related object: L<Koha::Schema::Result::Patroncard>
765 __PACKAGE__->has_many(
767 "Koha::Schema::Result::Patroncard",
768 { "foreign.borrowernumber" => "self.borrowernumber" },
769 { cascade_copy => 0, cascade_delete => 0 },
776 Related object: L<Koha::Schema::Result::Patronimage>
780 __PACKAGE__->might_have(
782 "Koha::Schema::Result::Patronimage",
783 { "foreign.cardnumber" => "self.cardnumber" },
784 { cascade_copy => 0, cascade_delete => 0 },
791 Related object: L<Koha::Schema::Result::Rating>
795 __PACKAGE__->has_many(
797 "Koha::Schema::Result::Rating",
798 { "foreign.borrowernumber" => "self.borrowernumber" },
799 { cascade_copy => 0, cascade_delete => 0 },
806 Related object: L<Koha::Schema::Result::Reserve>
810 __PACKAGE__->has_many(
812 "Koha::Schema::Result::Reserve",
813 { "foreign.borrowernumber" => "self.borrowernumber" },
814 { cascade_copy => 0, cascade_delete => 0 },
821 Related object: L<Koha::Schema::Result::Review>
825 __PACKAGE__->has_many(
827 "Koha::Schema::Result::Review",
828 { "foreign.borrowernumber" => "self.borrowernumber" },
829 { cascade_copy => 0, cascade_delete => 0 },
832 =head2 subscriptionroutinglists
836 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
840 __PACKAGE__->has_many(
841 "subscriptionroutinglists",
842 "Koha::Schema::Result::Subscriptionroutinglist",
843 { "foreign.borrowernumber" => "self.borrowernumber" },
844 { cascade_copy => 0, cascade_delete => 0 },
851 Related object: L<Koha::Schema::Result::TagAll>
855 __PACKAGE__->has_many(
857 "Koha::Schema::Result::TagAll",
858 { "foreign.borrowernumber" => "self.borrowernumber" },
859 { cascade_copy => 0, cascade_delete => 0 },
862 =head2 tags_approvals
866 Related object: L<Koha::Schema::Result::TagsApproval>
870 __PACKAGE__->has_many(
872 "Koha::Schema::Result::TagsApproval",
873 { "foreign.approved_by" => "self.borrowernumber" },
874 { cascade_copy => 0, cascade_delete => 0 },
877 =head2 user_permissions
881 Related object: L<Koha::Schema::Result::UserPermission>
885 __PACKAGE__->has_many(
887 "Koha::Schema::Result::UserPermission",
888 { "foreign.borrowernumber" => "self.borrowernumber" },
889 { cascade_copy => 0, cascade_delete => 0 },
892 =head2 virtualshelfcontents
896 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
900 __PACKAGE__->has_many(
901 "virtualshelfcontents",
902 "Koha::Schema::Result::Virtualshelfcontent",
903 { "foreign.borrowernumber" => "self.borrowernumber" },
904 { cascade_copy => 0, cascade_delete => 0 },
907 =head2 virtualshelfshares
911 Related object: L<Koha::Schema::Result::Virtualshelfshare>
915 __PACKAGE__->has_many(
916 "virtualshelfshares",
917 "Koha::Schema::Result::Virtualshelfshare",
918 { "foreign.borrowernumber" => "self.borrowernumber" },
919 { cascade_copy => 0, cascade_delete => 0 },
922 =head2 virtualshelves
926 Related object: L<Koha::Schema::Result::Virtualshelve>
930 __PACKAGE__->has_many(
932 "Koha::Schema::Result::Virtualshelve",
933 { "foreign.owner" => "self.borrowernumber" },
934 { cascade_copy => 0, cascade_delete => 0 },
938 # Created by DBIx::Class::Schema::Loader v0.07000 @ 2012-09-02 08:44:15
939 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:a5PYhuHX3DHlNJqdmIuqTw
942 # You can replace this text with custom content, and it will be preserved on regeneration