Bug 21395: Fix creation of PO file
[koha.git] / Koha / Schema / Result / Borrower.pm
blobc750e63f1da900c2551b34a744e16b26aea23f73
1 use utf8;
2 package Koha::Schema::Result::Borrower;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
7 =head1 NAME
9 Koha::Schema::Result::Borrower
11 =cut
13 use strict;
14 use warnings;
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<borrowers>
20 =cut
22 __PACKAGE__->table("borrowers");
24 =head1 ACCESSORS
26 =head2 borrowernumber
28 data_type: 'integer'
29 is_auto_increment: 1
30 is_nullable: 0
32 =head2 cardnumber
34 data_type: 'varchar'
35 is_nullable: 1
36 size: 32
38 =head2 surname
40 data_type: 'longtext'
41 is_nullable: 1
43 =head2 firstname
45 data_type: 'mediumtext'
46 is_nullable: 1
48 =head2 title
50 data_type: 'longtext'
51 is_nullable: 1
53 =head2 othernames
55 data_type: 'longtext'
56 is_nullable: 1
58 =head2 initials
60 data_type: 'mediumtext'
61 is_nullable: 1
63 =head2 streetnumber
65 data_type: 'tinytext'
66 is_nullable: 1
68 =head2 streettype
70 data_type: 'tinytext'
71 is_nullable: 1
73 =head2 address
75 data_type: 'longtext'
76 is_nullable: 1
78 =head2 address2
80 data_type: 'mediumtext'
81 is_nullable: 1
83 =head2 city
85 data_type: 'longtext'
86 is_nullable: 1
88 =head2 state
90 data_type: 'mediumtext'
91 is_nullable: 1
93 =head2 zipcode
95 data_type: 'tinytext'
96 is_nullable: 1
98 =head2 country
100 data_type: 'mediumtext'
101 is_nullable: 1
103 =head2 email
105 data_type: 'longtext'
106 is_nullable: 1
108 =head2 phone
110 data_type: 'mediumtext'
111 is_nullable: 1
113 =head2 mobile
115 data_type: 'tinytext'
116 is_nullable: 1
118 =head2 fax
120 data_type: 'longtext'
121 is_nullable: 1
123 =head2 emailpro
125 data_type: 'mediumtext'
126 is_nullable: 1
128 =head2 phonepro
130 data_type: 'mediumtext'
131 is_nullable: 1
133 =head2 B_streetnumber
135 accessor: 'b_streetnumber'
136 data_type: 'tinytext'
137 is_nullable: 1
139 =head2 B_streettype
141 accessor: 'b_streettype'
142 data_type: 'tinytext'
143 is_nullable: 1
145 =head2 B_address
147 accessor: 'b_address'
148 data_type: 'mediumtext'
149 is_nullable: 1
151 =head2 B_address2
153 accessor: 'b_address2'
154 data_type: 'mediumtext'
155 is_nullable: 1
157 =head2 B_city
159 accessor: 'b_city'
160 data_type: 'longtext'
161 is_nullable: 1
163 =head2 B_state
165 accessor: 'b_state'
166 data_type: 'mediumtext'
167 is_nullable: 1
169 =head2 B_zipcode
171 accessor: 'b_zipcode'
172 data_type: 'tinytext'
173 is_nullable: 1
175 =head2 B_country
177 accessor: 'b_country'
178 data_type: 'mediumtext'
179 is_nullable: 1
181 =head2 B_email
183 accessor: 'b_email'
184 data_type: 'mediumtext'
185 is_nullable: 1
187 =head2 B_phone
189 accessor: 'b_phone'
190 data_type: 'longtext'
191 is_nullable: 1
193 =head2 dateofbirth
195 data_type: 'date'
196 datetime_undef_if_invalid: 1
197 is_nullable: 1
199 =head2 branchcode
201 data_type: 'varchar'
202 default_value: (empty string)
203 is_foreign_key: 1
204 is_nullable: 0
205 size: 10
207 =head2 categorycode
209 data_type: 'varchar'
210 default_value: (empty string)
211 is_foreign_key: 1
212 is_nullable: 0
213 size: 10
215 =head2 dateenrolled
217 data_type: 'date'
218 datetime_undef_if_invalid: 1
219 is_nullable: 1
221 =head2 dateexpiry
223 data_type: 'date'
224 datetime_undef_if_invalid: 1
225 is_nullable: 1
227 =head2 date_renewed
229 data_type: 'date'
230 datetime_undef_if_invalid: 1
231 is_nullable: 1
233 =head2 gonenoaddress
235 data_type: 'tinyint'
236 is_nullable: 1
238 =head2 lost
240 data_type: 'tinyint'
241 is_nullable: 1
243 =head2 debarred
245 data_type: 'date'
246 datetime_undef_if_invalid: 1
247 is_nullable: 1
249 =head2 debarredcomment
251 data_type: 'varchar'
252 is_nullable: 1
253 size: 255
255 =head2 contactname
257 data_type: 'longtext'
258 is_nullable: 1
260 =head2 contactfirstname
262 data_type: 'mediumtext'
263 is_nullable: 1
265 =head2 contacttitle
267 data_type: 'mediumtext'
268 is_nullable: 1
270 =head2 borrowernotes
272 data_type: 'longtext'
273 is_nullable: 1
275 =head2 relationship
277 data_type: 'varchar'
278 is_nullable: 1
279 size: 100
281 =head2 sex
283 data_type: 'varchar'
284 is_nullable: 1
285 size: 1
287 =head2 password
289 data_type: 'varchar'
290 is_nullable: 1
291 size: 60
293 =head2 flags
295 data_type: 'integer'
296 is_nullable: 1
298 =head2 userid
300 data_type: 'varchar'
301 is_nullable: 1
302 size: 75
304 =head2 opacnote
306 data_type: 'longtext'
307 is_nullable: 1
309 =head2 contactnote
311 data_type: 'varchar'
312 is_nullable: 1
313 size: 255
315 =head2 sort1
317 data_type: 'varchar'
318 is_nullable: 1
319 size: 80
321 =head2 sort2
323 data_type: 'varchar'
324 is_nullable: 1
325 size: 80
327 =head2 altcontactfirstname
329 data_type: 'mediumtext'
330 is_nullable: 1
332 =head2 altcontactsurname
334 data_type: 'mediumtext'
335 is_nullable: 1
337 =head2 altcontactaddress1
339 data_type: 'mediumtext'
340 is_nullable: 1
342 =head2 altcontactaddress2
344 data_type: 'mediumtext'
345 is_nullable: 1
347 =head2 altcontactaddress3
349 data_type: 'mediumtext'
350 is_nullable: 1
352 =head2 altcontactstate
354 data_type: 'mediumtext'
355 is_nullable: 1
357 =head2 altcontactzipcode
359 data_type: 'mediumtext'
360 is_nullable: 1
362 =head2 altcontactcountry
364 data_type: 'mediumtext'
365 is_nullable: 1
367 =head2 altcontactphone
369 data_type: 'mediumtext'
370 is_nullable: 1
372 =head2 smsalertnumber
374 data_type: 'varchar'
375 is_nullable: 1
376 size: 50
378 =head2 sms_provider_id
380 data_type: 'integer'
381 is_foreign_key: 1
382 is_nullable: 1
384 =head2 privacy
386 data_type: 'integer'
387 default_value: 1
388 is_nullable: 0
390 =head2 privacy_guarantor_fines
392 data_type: 'tinyint'
393 default_value: 0
394 is_nullable: 0
396 =head2 privacy_guarantor_checkouts
398 data_type: 'tinyint'
399 default_value: 0
400 is_nullable: 0
402 =head2 checkprevcheckout
404 data_type: 'varchar'
405 default_value: 'inherit'
406 is_nullable: 0
407 size: 7
409 =head2 updated_on
411 data_type: 'timestamp'
412 datetime_undef_if_invalid: 1
413 default_value: current_timestamp
414 is_nullable: 0
416 =head2 lastseen
418 data_type: 'datetime'
419 datetime_undef_if_invalid: 1
420 is_nullable: 1
422 =head2 lang
424 data_type: 'varchar'
425 default_value: 'default'
426 is_nullable: 0
427 size: 25
429 =head2 login_attempts
431 data_type: 'integer'
432 default_value: 0
433 is_nullable: 1
435 =head2 overdrive_auth_token
437 data_type: 'mediumtext'
438 is_nullable: 1
440 =head2 anonymized
442 data_type: 'tinyint'
443 default_value: 0
444 is_nullable: 0
446 =head2 autorenew_checkouts
448 data_type: 'tinyint'
449 default_value: 1
450 is_nullable: 0
452 =cut
454 __PACKAGE__->add_columns(
455 "borrowernumber",
456 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
457 "cardnumber",
458 { data_type => "varchar", is_nullable => 1, size => 32 },
459 "surname",
460 { data_type => "longtext", is_nullable => 1 },
461 "firstname",
462 { data_type => "mediumtext", is_nullable => 1 },
463 "title",
464 { data_type => "longtext", is_nullable => 1 },
465 "othernames",
466 { data_type => "longtext", is_nullable => 1 },
467 "initials",
468 { data_type => "mediumtext", is_nullable => 1 },
469 "streetnumber",
470 { data_type => "tinytext", is_nullable => 1 },
471 "streettype",
472 { data_type => "tinytext", is_nullable => 1 },
473 "address",
474 { data_type => "longtext", is_nullable => 1 },
475 "address2",
476 { data_type => "mediumtext", is_nullable => 1 },
477 "city",
478 { data_type => "longtext", is_nullable => 1 },
479 "state",
480 { data_type => "mediumtext", is_nullable => 1 },
481 "zipcode",
482 { data_type => "tinytext", is_nullable => 1 },
483 "country",
484 { data_type => "mediumtext", is_nullable => 1 },
485 "email",
486 { data_type => "longtext", is_nullable => 1 },
487 "phone",
488 { data_type => "mediumtext", is_nullable => 1 },
489 "mobile",
490 { data_type => "tinytext", is_nullable => 1 },
491 "fax",
492 { data_type => "longtext", is_nullable => 1 },
493 "emailpro",
494 { data_type => "mediumtext", is_nullable => 1 },
495 "phonepro",
496 { data_type => "mediumtext", is_nullable => 1 },
497 "B_streetnumber",
498 { accessor => "b_streetnumber", data_type => "tinytext", is_nullable => 1 },
499 "B_streettype",
500 { accessor => "b_streettype", data_type => "tinytext", is_nullable => 1 },
501 "B_address",
502 { accessor => "b_address", data_type => "mediumtext", is_nullable => 1 },
503 "B_address2",
504 { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 },
505 "B_city",
506 { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
507 "B_state",
508 { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
509 "B_zipcode",
510 { accessor => "b_zipcode", data_type => "tinytext", is_nullable => 1 },
511 "B_country",
512 { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 },
513 "B_email",
514 { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 },
515 "B_phone",
516 { accessor => "b_phone", data_type => "longtext", is_nullable => 1 },
517 "dateofbirth",
518 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
519 "branchcode",
521 data_type => "varchar",
522 default_value => "",
523 is_foreign_key => 1,
524 is_nullable => 0,
525 size => 10,
527 "categorycode",
529 data_type => "varchar",
530 default_value => "",
531 is_foreign_key => 1,
532 is_nullable => 0,
533 size => 10,
535 "dateenrolled",
536 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
537 "dateexpiry",
538 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
539 "date_renewed",
540 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
541 "gonenoaddress",
542 { data_type => "tinyint", is_nullable => 1 },
543 "lost",
544 { data_type => "tinyint", is_nullable => 1 },
545 "debarred",
546 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
547 "debarredcomment",
548 { data_type => "varchar", is_nullable => 1, size => 255 },
549 "contactname",
550 { data_type => "longtext", is_nullable => 1 },
551 "contactfirstname",
552 { data_type => "mediumtext", is_nullable => 1 },
553 "contacttitle",
554 { data_type => "mediumtext", is_nullable => 1 },
555 "borrowernotes",
556 { data_type => "longtext", is_nullable => 1 },
557 "relationship",
558 { data_type => "varchar", is_nullable => 1, size => 100 },
559 "sex",
560 { data_type => "varchar", is_nullable => 1, size => 1 },
561 "password",
562 { data_type => "varchar", is_nullable => 1, size => 60 },
563 "flags",
564 { data_type => "integer", is_nullable => 1 },
565 "userid",
566 { data_type => "varchar", is_nullable => 1, size => 75 },
567 "opacnote",
568 { data_type => "longtext", is_nullable => 1 },
569 "contactnote",
570 { data_type => "varchar", is_nullable => 1, size => 255 },
571 "sort1",
572 { data_type => "varchar", is_nullable => 1, size => 80 },
573 "sort2",
574 { data_type => "varchar", is_nullable => 1, size => 80 },
575 "altcontactfirstname",
576 { data_type => "mediumtext", is_nullable => 1 },
577 "altcontactsurname",
578 { data_type => "mediumtext", is_nullable => 1 },
579 "altcontactaddress1",
580 { data_type => "mediumtext", is_nullable => 1 },
581 "altcontactaddress2",
582 { data_type => "mediumtext", is_nullable => 1 },
583 "altcontactaddress3",
584 { data_type => "mediumtext", is_nullable => 1 },
585 "altcontactstate",
586 { data_type => "mediumtext", is_nullable => 1 },
587 "altcontactzipcode",
588 { data_type => "mediumtext", is_nullable => 1 },
589 "altcontactcountry",
590 { data_type => "mediumtext", is_nullable => 1 },
591 "altcontactphone",
592 { data_type => "mediumtext", is_nullable => 1 },
593 "smsalertnumber",
594 { data_type => "varchar", is_nullable => 1, size => 50 },
595 "sms_provider_id",
596 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
597 "privacy",
598 { data_type => "integer", default_value => 1, is_nullable => 0 },
599 "privacy_guarantor_fines",
600 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
601 "privacy_guarantor_checkouts",
602 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
603 "checkprevcheckout",
605 data_type => "varchar",
606 default_value => "inherit",
607 is_nullable => 0,
608 size => 7,
610 "updated_on",
612 data_type => "timestamp",
613 datetime_undef_if_invalid => 1,
614 default_value => \"current_timestamp",
615 is_nullable => 0,
617 "lastseen",
619 data_type => "datetime",
620 datetime_undef_if_invalid => 1,
621 is_nullable => 1,
623 "lang",
625 data_type => "varchar",
626 default_value => "default",
627 is_nullable => 0,
628 size => 25,
630 "login_attempts",
631 { data_type => "integer", default_value => 0, is_nullable => 1 },
632 "overdrive_auth_token",
633 { data_type => "mediumtext", is_nullable => 1 },
634 "anonymized",
635 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
636 "autorenew_checkouts",
637 { data_type => "tinyint", default_value => 1, is_nullable => 0 },
640 =head1 PRIMARY KEY
642 =over 4
644 =item * L</borrowernumber>
646 =back
648 =cut
650 __PACKAGE__->set_primary_key("borrowernumber");
652 =head1 UNIQUE CONSTRAINTS
654 =head2 C<cardnumber>
656 =over 4
658 =item * L</cardnumber>
660 =back
662 =cut
664 __PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
666 =head2 C<userid>
668 =over 4
670 =item * L</userid>
672 =back
674 =cut
676 __PACKAGE__->add_unique_constraint("userid", ["userid"]);
678 =head1 RELATIONS
680 =head2 accountlines
682 Type: has_many
684 Related object: L<Koha::Schema::Result::Accountline>
686 =cut
688 __PACKAGE__->has_many(
689 "accountlines",
690 "Koha::Schema::Result::Accountline",
691 { "foreign.borrowernumber" => "self.borrowernumber" },
692 { cascade_copy => 0, cascade_delete => 0 },
695 =head2 accountlines_managers
697 Type: has_many
699 Related object: L<Koha::Schema::Result::Accountline>
701 =cut
703 __PACKAGE__->has_many(
704 "accountlines_managers",
705 "Koha::Schema::Result::Accountline",
706 { "foreign.manager_id" => "self.borrowernumber" },
707 { cascade_copy => 0, cascade_delete => 0 },
710 =head2 advanced_editor_macros
712 Type: has_many
714 Related object: L<Koha::Schema::Result::AdvancedEditorMacro>
716 =cut
718 __PACKAGE__->has_many(
719 "advanced_editor_macros",
720 "Koha::Schema::Result::AdvancedEditorMacro",
721 { "foreign.borrowernumber" => "self.borrowernumber" },
722 { cascade_copy => 0, cascade_delete => 0 },
725 =head2 api_keys
727 Type: has_many
729 Related object: L<Koha::Schema::Result::ApiKey>
731 =cut
733 __PACKAGE__->has_many(
734 "api_keys",
735 "Koha::Schema::Result::ApiKey",
736 { "foreign.patron_id" => "self.borrowernumber" },
737 { cascade_copy => 0, cascade_delete => 0 },
740 =head2 aqbasketusers
742 Type: has_many
744 Related object: L<Koha::Schema::Result::Aqbasketuser>
746 =cut
748 __PACKAGE__->has_many(
749 "aqbasketusers",
750 "Koha::Schema::Result::Aqbasketuser",
751 { "foreign.borrowernumber" => "self.borrowernumber" },
752 { cascade_copy => 0, cascade_delete => 0 },
755 =head2 aqbudgetborrowers
757 Type: has_many
759 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
761 =cut
763 __PACKAGE__->has_many(
764 "aqbudgetborrowers",
765 "Koha::Schema::Result::Aqbudgetborrower",
766 { "foreign.borrowernumber" => "self.borrowernumber" },
767 { cascade_copy => 0, cascade_delete => 0 },
770 =head2 aqorder_users
772 Type: has_many
774 Related object: L<Koha::Schema::Result::AqorderUser>
776 =cut
778 __PACKAGE__->has_many(
779 "aqorder_users",
780 "Koha::Schema::Result::AqorderUser",
781 { "foreign.borrowernumber" => "self.borrowernumber" },
782 { cascade_copy => 0, cascade_delete => 0 },
785 =head2 aqorders
787 Type: has_many
789 Related object: L<Koha::Schema::Result::Aqorder>
791 =cut
793 __PACKAGE__->has_many(
794 "aqorders",
795 "Koha::Schema::Result::Aqorder",
796 { "foreign.created_by" => "self.borrowernumber" },
797 { cascade_copy => 0, cascade_delete => 0 },
800 =head2 article_requests
802 Type: has_many
804 Related object: L<Koha::Schema::Result::ArticleRequest>
806 =cut
808 __PACKAGE__->has_many(
809 "article_requests",
810 "Koha::Schema::Result::ArticleRequest",
811 { "foreign.borrowernumber" => "self.borrowernumber" },
812 { cascade_copy => 0, cascade_delete => 0 },
815 =head2 borrower_attributes
817 Type: has_many
819 Related object: L<Koha::Schema::Result::BorrowerAttribute>
821 =cut
823 __PACKAGE__->has_many(
824 "borrower_attributes",
825 "Koha::Schema::Result::BorrowerAttribute",
826 { "foreign.borrowernumber" => "self.borrowernumber" },
827 { cascade_copy => 0, cascade_delete => 0 },
830 =head2 borrower_debarments
832 Type: has_many
834 Related object: L<Koha::Schema::Result::BorrowerDebarment>
836 =cut
838 __PACKAGE__->has_many(
839 "borrower_debarments",
840 "Koha::Schema::Result::BorrowerDebarment",
841 { "foreign.borrowernumber" => "self.borrowernumber" },
842 { cascade_copy => 0, cascade_delete => 0 },
845 =head2 borrower_files
847 Type: has_many
849 Related object: L<Koha::Schema::Result::BorrowerFile>
851 =cut
853 __PACKAGE__->has_many(
854 "borrower_files",
855 "Koha::Schema::Result::BorrowerFile",
856 { "foreign.borrowernumber" => "self.borrowernumber" },
857 { cascade_copy => 0, cascade_delete => 0 },
860 =head2 borrower_message_preferences
862 Type: has_many
864 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
866 =cut
868 __PACKAGE__->has_many(
869 "borrower_message_preferences",
870 "Koha::Schema::Result::BorrowerMessagePreference",
871 { "foreign.borrowernumber" => "self.borrowernumber" },
872 { cascade_copy => 0, cascade_delete => 0 },
875 =head2 borrower_relationships_guarantees
877 Type: has_many
879 Related object: L<Koha::Schema::Result::BorrowerRelationship>
881 =cut
883 __PACKAGE__->has_many(
884 "borrower_relationships_guarantees",
885 "Koha::Schema::Result::BorrowerRelationship",
886 { "foreign.guarantee_id" => "self.borrowernumber" },
887 { cascade_copy => 0, cascade_delete => 0 },
890 =head2 borrower_relationships_guarantors
892 Type: has_many
894 Related object: L<Koha::Schema::Result::BorrowerRelationship>
896 =cut
898 __PACKAGE__->has_many(
899 "borrower_relationships_guarantors",
900 "Koha::Schema::Result::BorrowerRelationship",
901 { "foreign.guarantor_id" => "self.borrowernumber" },
902 { cascade_copy => 0, cascade_delete => 0 },
905 =head2 branchcode
907 Type: belongs_to
909 Related object: L<Koha::Schema::Result::Branch>
911 =cut
913 __PACKAGE__->belongs_to(
914 "branchcode",
915 "Koha::Schema::Result::Branch",
916 { branchcode => "branchcode" },
917 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
920 =head2 cash_register_actions
922 Type: has_many
924 Related object: L<Koha::Schema::Result::CashRegisterAction>
926 =cut
928 __PACKAGE__->has_many(
929 "cash_register_actions",
930 "Koha::Schema::Result::CashRegisterAction",
931 { "foreign.manager_id" => "self.borrowernumber" },
932 { cascade_copy => 0, cascade_delete => 0 },
935 =head2 categorycode
937 Type: belongs_to
939 Related object: L<Koha::Schema::Result::Category>
941 =cut
943 __PACKAGE__->belongs_to(
944 "categorycode",
945 "Koha::Schema::Result::Category",
946 { categorycode => "categorycode" },
947 { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
950 =head2 club_enrollments
952 Type: has_many
954 Related object: L<Koha::Schema::Result::ClubEnrollment>
956 =cut
958 __PACKAGE__->has_many(
959 "club_enrollments",
960 "Koha::Schema::Result::ClubEnrollment",
961 { "foreign.borrowernumber" => "self.borrowernumber" },
962 { cascade_copy => 0, cascade_delete => 0 },
965 =head2 club_holds_to_patron_holds
967 Type: has_many
969 Related object: L<Koha::Schema::Result::ClubHoldsToPatronHold>
971 =cut
973 __PACKAGE__->has_many(
974 "club_holds_to_patron_holds",
975 "Koha::Schema::Result::ClubHoldsToPatronHold",
976 { "foreign.patron_id" => "self.borrowernumber" },
977 { cascade_copy => 0, cascade_delete => 0 },
980 =head2 course_instructors
982 Type: has_many
984 Related object: L<Koha::Schema::Result::CourseInstructor>
986 =cut
988 __PACKAGE__->has_many(
989 "course_instructors",
990 "Koha::Schema::Result::CourseInstructor",
991 { "foreign.borrowernumber" => "self.borrowernumber" },
992 { cascade_copy => 0, cascade_delete => 0 },
995 =head2 creator_batches
997 Type: has_many
999 Related object: L<Koha::Schema::Result::CreatorBatch>
1001 =cut
1003 __PACKAGE__->has_many(
1004 "creator_batches",
1005 "Koha::Schema::Result::CreatorBatch",
1006 { "foreign.borrower_number" => "self.borrowernumber" },
1007 { cascade_copy => 0, cascade_delete => 0 },
1010 =head2 discharges
1012 Type: has_many
1014 Related object: L<Koha::Schema::Result::Discharge>
1016 =cut
1018 __PACKAGE__->has_many(
1019 "discharges",
1020 "Koha::Schema::Result::Discharge",
1021 { "foreign.borrower" => "self.borrowernumber" },
1022 { cascade_copy => 0, cascade_delete => 0 },
1025 =head2 hold_fill_targets
1027 Type: has_many
1029 Related object: L<Koha::Schema::Result::HoldFillTarget>
1031 =cut
1033 __PACKAGE__->has_many(
1034 "hold_fill_targets",
1035 "Koha::Schema::Result::HoldFillTarget",
1036 { "foreign.borrowernumber" => "self.borrowernumber" },
1037 { cascade_copy => 0, cascade_delete => 0 },
1040 =head2 housebound_profile
1042 Type: might_have
1044 Related object: L<Koha::Schema::Result::HouseboundProfile>
1046 =cut
1048 __PACKAGE__->might_have(
1049 "housebound_profile",
1050 "Koha::Schema::Result::HouseboundProfile",
1051 { "foreign.borrowernumber" => "self.borrowernumber" },
1052 { cascade_copy => 0, cascade_delete => 0 },
1055 =head2 housebound_role
1057 Type: might_have
1059 Related object: L<Koha::Schema::Result::HouseboundRole>
1061 =cut
1063 __PACKAGE__->might_have(
1064 "housebound_role",
1065 "Koha::Schema::Result::HouseboundRole",
1066 { "foreign.borrowernumber_id" => "self.borrowernumber" },
1067 { cascade_copy => 0, cascade_delete => 0 },
1070 =head2 housebound_visit_chooser_brwnumbers
1072 Type: has_many
1074 Related object: L<Koha::Schema::Result::HouseboundVisit>
1076 =cut
1078 __PACKAGE__->has_many(
1079 "housebound_visit_chooser_brwnumbers",
1080 "Koha::Schema::Result::HouseboundVisit",
1081 { "foreign.chooser_brwnumber" => "self.borrowernumber" },
1082 { cascade_copy => 0, cascade_delete => 0 },
1085 =head2 housebound_visit_deliverer_brwnumbers
1087 Type: has_many
1089 Related object: L<Koha::Schema::Result::HouseboundVisit>
1091 =cut
1093 __PACKAGE__->has_many(
1094 "housebound_visit_deliverer_brwnumbers",
1095 "Koha::Schema::Result::HouseboundVisit",
1096 { "foreign.deliverer_brwnumber" => "self.borrowernumber" },
1097 { cascade_copy => 0, cascade_delete => 0 },
1100 =head2 illcomments
1102 Type: has_many
1104 Related object: L<Koha::Schema::Result::Illcomment>
1106 =cut
1108 __PACKAGE__->has_many(
1109 "illcomments",
1110 "Koha::Schema::Result::Illcomment",
1111 { "foreign.borrowernumber" => "self.borrowernumber" },
1112 { cascade_copy => 0, cascade_delete => 0 },
1115 =head2 illrequests
1117 Type: has_many
1119 Related object: L<Koha::Schema::Result::Illrequest>
1121 =cut
1123 __PACKAGE__->has_many(
1124 "illrequests",
1125 "Koha::Schema::Result::Illrequest",
1126 { "foreign.borrowernumber" => "self.borrowernumber" },
1127 { cascade_copy => 0, cascade_delete => 0 },
1130 =head2 issues
1132 Type: has_many
1134 Related object: L<Koha::Schema::Result::Issue>
1136 =cut
1138 __PACKAGE__->has_many(
1139 "issues",
1140 "Koha::Schema::Result::Issue",
1141 { "foreign.borrowernumber" => "self.borrowernumber" },
1142 { cascade_copy => 0, cascade_delete => 0 },
1145 =head2 items_last_borrowers
1147 Type: has_many
1149 Related object: L<Koha::Schema::Result::ItemsLastBorrower>
1151 =cut
1153 __PACKAGE__->has_many(
1154 "items_last_borrowers",
1155 "Koha::Schema::Result::ItemsLastBorrower",
1156 { "foreign.borrowernumber" => "self.borrowernumber" },
1157 { cascade_copy => 0, cascade_delete => 0 },
1160 =head2 message_queues
1162 Type: has_many
1164 Related object: L<Koha::Schema::Result::MessageQueue>
1166 =cut
1168 __PACKAGE__->has_many(
1169 "message_queues",
1170 "Koha::Schema::Result::MessageQueue",
1171 { "foreign.borrowernumber" => "self.borrowernumber" },
1172 { cascade_copy => 0, cascade_delete => 0 },
1175 =head2 messages
1177 Type: has_many
1179 Related object: L<Koha::Schema::Result::Message>
1181 =cut
1183 __PACKAGE__->has_many(
1184 "messages",
1185 "Koha::Schema::Result::Message",
1186 { "foreign.manager_id" => "self.borrowernumber" },
1187 { cascade_copy => 0, cascade_delete => 0 },
1190 =head2 messages_borrowernumbers
1192 Type: has_many
1194 Related object: L<Koha::Schema::Result::Message>
1196 =cut
1198 __PACKAGE__->has_many(
1199 "messages_borrowernumbers",
1200 "Koha::Schema::Result::Message",
1201 { "foreign.borrowernumber" => "self.borrowernumber" },
1202 { cascade_copy => 0, cascade_delete => 0 },
1205 =head2 old_issues
1207 Type: has_many
1209 Related object: L<Koha::Schema::Result::OldIssue>
1211 =cut
1213 __PACKAGE__->has_many(
1214 "old_issues",
1215 "Koha::Schema::Result::OldIssue",
1216 { "foreign.borrowernumber" => "self.borrowernumber" },
1217 { cascade_copy => 0, cascade_delete => 0 },
1220 =head2 old_reserves
1222 Type: has_many
1224 Related object: L<Koha::Schema::Result::OldReserve>
1226 =cut
1228 __PACKAGE__->has_many(
1229 "old_reserves",
1230 "Koha::Schema::Result::OldReserve",
1231 { "foreign.borrowernumber" => "self.borrowernumber" },
1232 { cascade_copy => 0, cascade_delete => 0 },
1235 =head2 opac_news
1237 Type: has_many
1239 Related object: L<Koha::Schema::Result::OpacNews>
1241 =cut
1243 __PACKAGE__->has_many(
1244 "opac_news",
1245 "Koha::Schema::Result::OpacNews",
1246 { "foreign.borrowernumber" => "self.borrowernumber" },
1247 { cascade_copy => 0, cascade_delete => 0 },
1250 =head2 patron_consents
1252 Type: has_many
1254 Related object: L<Koha::Schema::Result::PatronConsent>
1256 =cut
1258 __PACKAGE__->has_many(
1259 "patron_consents",
1260 "Koha::Schema::Result::PatronConsent",
1261 { "foreign.borrowernumber" => "self.borrowernumber" },
1262 { cascade_copy => 0, cascade_delete => 0 },
1265 =head2 patron_list_patrons
1267 Type: has_many
1269 Related object: L<Koha::Schema::Result::PatronListPatron>
1271 =cut
1273 __PACKAGE__->has_many(
1274 "patron_list_patrons",
1275 "Koha::Schema::Result::PatronListPatron",
1276 { "foreign.borrowernumber" => "self.borrowernumber" },
1277 { cascade_copy => 0, cascade_delete => 0 },
1280 =head2 patron_lists
1282 Type: has_many
1284 Related object: L<Koha::Schema::Result::PatronList>
1286 =cut
1288 __PACKAGE__->has_many(
1289 "patron_lists",
1290 "Koha::Schema::Result::PatronList",
1291 { "foreign.owner" => "self.borrowernumber" },
1292 { cascade_copy => 0, cascade_delete => 0 },
1295 =head2 patronimage
1297 Type: might_have
1299 Related object: L<Koha::Schema::Result::Patronimage>
1301 =cut
1303 __PACKAGE__->might_have(
1304 "patronimage",
1305 "Koha::Schema::Result::Patronimage",
1306 { "foreign.borrowernumber" => "self.borrowernumber" },
1307 { cascade_copy => 0, cascade_delete => 0 },
1310 =head2 problem_reports
1312 Type: has_many
1314 Related object: L<Koha::Schema::Result::ProblemReport>
1316 =cut
1318 __PACKAGE__->has_many(
1319 "problem_reports",
1320 "Koha::Schema::Result::ProblemReport",
1321 { "foreign.borrowernumber" => "self.borrowernumber" },
1322 { cascade_copy => 0, cascade_delete => 0 },
1325 =head2 ratings
1327 Type: has_many
1329 Related object: L<Koha::Schema::Result::Rating>
1331 =cut
1333 __PACKAGE__->has_many(
1334 "ratings",
1335 "Koha::Schema::Result::Rating",
1336 { "foreign.borrowernumber" => "self.borrowernumber" },
1337 { cascade_copy => 0, cascade_delete => 0 },
1340 =head2 reserves
1342 Type: has_many
1344 Related object: L<Koha::Schema::Result::Reserve>
1346 =cut
1348 __PACKAGE__->has_many(
1349 "reserves",
1350 "Koha::Schema::Result::Reserve",
1351 { "foreign.borrowernumber" => "self.borrowernumber" },
1352 { cascade_copy => 0, cascade_delete => 0 },
1355 =head2 return_claims_borrowernumbers
1357 Type: has_many
1359 Related object: L<Koha::Schema::Result::ReturnClaim>
1361 =cut
1363 __PACKAGE__->has_many(
1364 "return_claims_borrowernumbers",
1365 "Koha::Schema::Result::ReturnClaim",
1366 { "foreign.borrowernumber" => "self.borrowernumber" },
1367 { cascade_copy => 0, cascade_delete => 0 },
1370 =head2 return_claims_created_by
1372 Type: has_many
1374 Related object: L<Koha::Schema::Result::ReturnClaim>
1376 =cut
1378 __PACKAGE__->has_many(
1379 "return_claims_created_by",
1380 "Koha::Schema::Result::ReturnClaim",
1381 { "foreign.created_by" => "self.borrowernumber" },
1382 { cascade_copy => 0, cascade_delete => 0 },
1385 =head2 return_claims_resolved_by
1387 Type: has_many
1389 Related object: L<Koha::Schema::Result::ReturnClaim>
1391 =cut
1393 __PACKAGE__->has_many(
1394 "return_claims_resolved_by",
1395 "Koha::Schema::Result::ReturnClaim",
1396 { "foreign.resolved_by" => "self.borrowernumber" },
1397 { cascade_copy => 0, cascade_delete => 0 },
1400 =head2 return_claims_updated_by
1402 Type: has_many
1404 Related object: L<Koha::Schema::Result::ReturnClaim>
1406 =cut
1408 __PACKAGE__->has_many(
1409 "return_claims_updated_by",
1410 "Koha::Schema::Result::ReturnClaim",
1411 { "foreign.updated_by" => "self.borrowernumber" },
1412 { cascade_copy => 0, cascade_delete => 0 },
1415 =head2 reviews
1417 Type: has_many
1419 Related object: L<Koha::Schema::Result::Review>
1421 =cut
1423 __PACKAGE__->has_many(
1424 "reviews",
1425 "Koha::Schema::Result::Review",
1426 { "foreign.borrowernumber" => "self.borrowernumber" },
1427 { cascade_copy => 0, cascade_delete => 0 },
1430 =head2 sms_provider
1432 Type: belongs_to
1434 Related object: L<Koha::Schema::Result::SmsProvider>
1436 =cut
1438 __PACKAGE__->belongs_to(
1439 "sms_provider",
1440 "Koha::Schema::Result::SmsProvider",
1441 { id => "sms_provider_id" },
1443 is_deferrable => 1,
1444 join_type => "LEFT",
1445 on_delete => "SET NULL",
1446 on_update => "CASCADE",
1450 =head2 subscriptionroutinglists
1452 Type: has_many
1454 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
1456 =cut
1458 __PACKAGE__->has_many(
1459 "subscriptionroutinglists",
1460 "Koha::Schema::Result::Subscriptionroutinglist",
1461 { "foreign.borrowernumber" => "self.borrowernumber" },
1462 { cascade_copy => 0, cascade_delete => 0 },
1465 =head2 suggestions_acceptedbies
1467 Type: has_many
1469 Related object: L<Koha::Schema::Result::Suggestion>
1471 =cut
1473 __PACKAGE__->has_many(
1474 "suggestions_acceptedbies",
1475 "Koha::Schema::Result::Suggestion",
1476 { "foreign.acceptedby" => "self.borrowernumber" },
1477 { cascade_copy => 0, cascade_delete => 0 },
1480 =head2 suggestions_lastmodificationbies
1482 Type: has_many
1484 Related object: L<Koha::Schema::Result::Suggestion>
1486 =cut
1488 __PACKAGE__->has_many(
1489 "suggestions_lastmodificationbies",
1490 "Koha::Schema::Result::Suggestion",
1491 { "foreign.lastmodificationby" => "self.borrowernumber" },
1492 { cascade_copy => 0, cascade_delete => 0 },
1495 =head2 suggestions_managedbies
1497 Type: has_many
1499 Related object: L<Koha::Schema::Result::Suggestion>
1501 =cut
1503 __PACKAGE__->has_many(
1504 "suggestions_managedbies",
1505 "Koha::Schema::Result::Suggestion",
1506 { "foreign.managedby" => "self.borrowernumber" },
1507 { cascade_copy => 0, cascade_delete => 0 },
1510 =head2 suggestions_rejectedbies
1512 Type: has_many
1514 Related object: L<Koha::Schema::Result::Suggestion>
1516 =cut
1518 __PACKAGE__->has_many(
1519 "suggestions_rejectedbies",
1520 "Koha::Schema::Result::Suggestion",
1521 { "foreign.rejectedby" => "self.borrowernumber" },
1522 { cascade_copy => 0, cascade_delete => 0 },
1525 =head2 suggestions_suggestedbies
1527 Type: has_many
1529 Related object: L<Koha::Schema::Result::Suggestion>
1531 =cut
1533 __PACKAGE__->has_many(
1534 "suggestions_suggestedbies",
1535 "Koha::Schema::Result::Suggestion",
1536 { "foreign.suggestedby" => "self.borrowernumber" },
1537 { cascade_copy => 0, cascade_delete => 0 },
1540 =head2 tags_all
1542 Type: has_many
1544 Related object: L<Koha::Schema::Result::TagAll>
1546 =cut
1548 __PACKAGE__->has_many(
1549 "tags_all",
1550 "Koha::Schema::Result::TagAll",
1551 { "foreign.borrowernumber" => "self.borrowernumber" },
1552 { cascade_copy => 0, cascade_delete => 0 },
1555 =head2 tags_approvals
1557 Type: has_many
1559 Related object: L<Koha::Schema::Result::TagsApproval>
1561 =cut
1563 __PACKAGE__->has_many(
1564 "tags_approvals",
1565 "Koha::Schema::Result::TagsApproval",
1566 { "foreign.approved_by" => "self.borrowernumber" },
1567 { cascade_copy => 0, cascade_delete => 0 },
1570 =head2 user_permissions
1572 Type: has_many
1574 Related object: L<Koha::Schema::Result::UserPermission>
1576 =cut
1578 __PACKAGE__->has_many(
1579 "user_permissions",
1580 "Koha::Schema::Result::UserPermission",
1581 { "foreign.borrowernumber" => "self.borrowernumber" },
1582 { cascade_copy => 0, cascade_delete => 0 },
1585 =head2 virtualshelfcontents
1587 Type: has_many
1589 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
1591 =cut
1593 __PACKAGE__->has_many(
1594 "virtualshelfcontents",
1595 "Koha::Schema::Result::Virtualshelfcontent",
1596 { "foreign.borrowernumber" => "self.borrowernumber" },
1597 { cascade_copy => 0, cascade_delete => 0 },
1600 =head2 virtualshelfshares
1602 Type: has_many
1604 Related object: L<Koha::Schema::Result::Virtualshelfshare>
1606 =cut
1608 __PACKAGE__->has_many(
1609 "virtualshelfshares",
1610 "Koha::Schema::Result::Virtualshelfshare",
1611 { "foreign.borrowernumber" => "self.borrowernumber" },
1612 { cascade_copy => 0, cascade_delete => 0 },
1615 =head2 virtualshelves
1617 Type: has_many
1619 Related object: L<Koha::Schema::Result::Virtualshelve>
1621 =cut
1623 __PACKAGE__->has_many(
1624 "virtualshelves",
1625 "Koha::Schema::Result::Virtualshelve",
1626 { "foreign.owner" => "self.borrowernumber" },
1627 { cascade_copy => 0, cascade_delete => 0 },
1630 =head2 basketnoes
1632 Type: many_to_many
1634 Composing rels: L</aqbasketusers> -> basketno
1636 =cut
1638 __PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
1640 =head2 budgets
1642 Type: many_to_many
1644 Composing rels: L</aqbudgetborrowers> -> budget
1646 =cut
1648 __PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget");
1650 =head2 courses
1652 Type: many_to_many
1654 Composing rels: L</course_instructors> -> course
1656 =cut
1658 __PACKAGE__->many_to_many("courses", "course_instructors", "course");
1660 =head2 ordernumbers
1662 Type: many_to_many
1664 Composing rels: L</aqorder_users> -> ordernumber
1666 =cut
1668 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1671 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-06-25 08:47:42
1672 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:o+gWN0ND3K07hqLwAoNmMA
1674 __PACKAGE__->add_columns(
1675 '+anonymized' => { is_boolean => 1 },
1676 '+lost' => { is_boolean => 1 },
1677 '+gonenoaddress' => { is_boolean => 1 },
1678 '+privacy_guarantor_fines' => { is_boolean => 1 },
1679 '+autorenew_checkouts' => { is_boolean => 1 }
1682 sub koha_objects_class {
1683 'Koha::Patrons';
1685 sub koha_object_class {
1686 'Koha::Patron';