2 package Koha::Schema::Result::Deletedborrower;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Deletedborrower
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<deletedborrowers>
22 __PACKAGE__->table("deletedborrowers");
32 primary key, Koha assigned ID number for patrons/borrowers
40 unique key, library assigned ID number for patrons/borrowers
47 patron/borrower's last name (surname)
51 data_type: 'mediumtext'
54 patron/borrower's first name
61 patron/borrower's title, for example: Mr. or Mrs.
68 any other names associated with the patron/borrower
72 data_type: 'mediumtext'
75 initials for your patron/borrower
82 the house number for your patron/borrower's primary address
89 the street type (Rd., Blvd, etc) for your patron/borrower's primary address
96 the first address line for your patron/borrower's primary address
100 data_type: 'mediumtext'
103 the second address line for your patron/borrower's primary address
107 data_type: 'longtext'
110 the city or town for your patron/borrower's primary address
114 data_type: 'mediumtext'
117 the state or province for your patron/borrower's primary address
121 data_type: 'tinytext'
124 the zip or postal code for your patron/borrower's primary address
128 data_type: 'mediumtext'
131 the country for your patron/borrower's primary address
135 data_type: 'longtext'
138 the primary email address for your patron/borrower's primary address
142 data_type: 'mediumtext'
145 the primary phone number for your patron/borrower's primary address
149 data_type: 'tinytext'
152 the other phone number for your patron/borrower's primary address
156 data_type: 'longtext'
159 the fax number for your patron/borrower's primary address
163 data_type: 'mediumtext'
166 the secondary email addres for your patron/borrower's primary address
170 data_type: 'mediumtext'
173 the secondary phone number for your patron/borrower's primary address
175 =head2 B_streetnumber
177 accessor: 'b_streetnumber'
178 data_type: 'tinytext'
181 the house number for your patron/borrower's alternate address
185 accessor: 'b_streettype'
186 data_type: 'tinytext'
189 the street type (Rd., Blvd, etc) for your patron/borrower's alternate address
193 accessor: 'b_address'
194 data_type: 'mediumtext'
197 the first address line for your patron/borrower's alternate address
201 accessor: 'b_address2'
202 data_type: 'mediumtext'
205 the second address line for your patron/borrower's alternate address
210 data_type: 'longtext'
213 the city or town for your patron/borrower's alternate address
218 data_type: 'mediumtext'
221 the state for your patron/borrower's alternate address
225 accessor: 'b_zipcode'
226 data_type: 'tinytext'
229 the zip or postal code for your patron/borrower's alternate address
233 accessor: 'b_country'
234 data_type: 'mediumtext'
237 the country for your patron/borrower's alternate address
242 data_type: 'mediumtext'
245 the patron/borrower's alternate email address
250 data_type: 'longtext'
253 the patron/borrower's alternate phone number
258 datetime_undef_if_invalid: 1
261 the patron/borrower's date of birth (YYYY-MM-DD)
266 default_value: (empty string)
270 foreign key from the branches table, includes the code of the patron/borrower's home branch
275 default_value: (empty string)
279 foreign key from the categories table, includes the code of the patron category
284 datetime_undef_if_invalid: 1
287 date the patron was added to Koha (YYYY-MM-DD)
292 datetime_undef_if_invalid: 1
295 date the patron/borrower's card is set to expire (YYYY-MM-DD)
300 datetime_undef_if_invalid: 1
303 date the patron/borrower's card was last renewed
310 set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address
317 set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card
322 datetime_undef_if_invalid: 1
325 until this date the patron can only check-in (no loans, no holds, etc.), is a fine based on days instead of money (YYYY-MM-DD)
327 =head2 debarredcomment
333 comment on the stop of patron
337 data_type: 'longtext'
340 used for children and profesionals to include surname or last name of guarantor or organization name
342 =head2 contactfirstname
344 data_type: 'mediumtext'
347 used for children to include first name of guarantor
351 data_type: 'mediumtext'
354 used for children to include title (Mr., Mrs., etc) of guarantor
358 data_type: 'longtext'
361 a note on the patron/borrower's account that is only visible in the staff interface
369 used for children to include the relationship to their guarantor
377 patron/borrower's gender
385 patron/borrower's encrypted password
392 will include a number associated with the staff member's permissions
400 patron/borrower's opac and/or staff interface log in
404 data_type: 'longtext'
407 a note on the patron/borrower's account that is visible in the OPAC and staff interface
415 a note related to the patron/borrower's alternate address
423 a field that can be used for any information unique to the library
431 a field that can be used for any information unique to the library
433 =head2 altcontactfirstname
435 data_type: 'mediumtext'
438 first name of alternate contact for the patron/borrower
440 =head2 altcontactsurname
442 data_type: 'mediumtext'
445 surname or last name of the alternate contact for the patron/borrower
447 =head2 altcontactaddress1
449 data_type: 'mediumtext'
452 the first address line for the alternate contact for the patron/borrower
454 =head2 altcontactaddress2
456 data_type: 'mediumtext'
459 the second address line for the alternate contact for the patron/borrower
461 =head2 altcontactaddress3
463 data_type: 'mediumtext'
466 the city for the alternate contact for the patron/borrower
468 =head2 altcontactstate
470 data_type: 'mediumtext'
473 the state for the alternate contact for the patron/borrower
475 =head2 altcontactzipcode
477 data_type: 'mediumtext'
480 the zipcode for the alternate contact for the patron/borrower
482 =head2 altcontactcountry
484 data_type: 'mediumtext'
487 the country for the alternate contact for the patron/borrower
489 =head2 altcontactphone
491 data_type: 'mediumtext'
494 the phone number for the alternate contact for the patron/borrower
496 =head2 smsalertnumber
502 the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on)
504 =head2 sms_provider_id
509 the provider of the mobile phone number defined in smsalertnumber
517 patron/borrower's privacy settings related to their checkout history KEY `borrowernumber` (`borrowernumber`),
519 =head2 privacy_guarantor_fines
525 controls if relatives can see this patron's fines
527 =head2 privacy_guarantor_checkouts
533 controls if relatives can see this patron's checkouts
535 =head2 checkprevcheckout
538 default_value: 'inherit'
542 produce a warning for this patron if this item has previously been checked out to this patron if 'yes', not if 'no', defer to category setting if 'inherit'.
546 data_type: 'timestamp'
547 datetime_undef_if_invalid: 1
548 default_value: current_timestamp
551 time of last change could be useful for synchronization with external systems (among others)
555 data_type: 'datetime'
556 datetime_undef_if_invalid: 1
559 last time a patron has been seen (connected at the OPAC or staff interface)
564 default_value: 'default'
568 lang to use to send notices to this patron
570 =head2 login_attempts
576 number of failed login attemps
578 =head2 overdrive_auth_token
580 data_type: 'mediumtext'
583 persist OverDrive auth token
591 flag for data anonymization
593 =head2 autorenew_checkouts
599 flag for allowing auto-renewal
603 __PACKAGE__->add_columns(
605 { data_type => "integer", default_value => 0, is_nullable => 0 },
607 { data_type => "varchar", is_nullable => 1, size => 32 },
609 { data_type => "longtext", is_nullable => 1 },
611 { data_type => "mediumtext", is_nullable => 1 },
613 { data_type => "longtext", is_nullable => 1 },
615 { data_type => "longtext", is_nullable => 1 },
617 { data_type => "mediumtext", is_nullable => 1 },
619 { data_type => "tinytext", is_nullable => 1 },
621 { data_type => "tinytext", is_nullable => 1 },
623 { data_type => "longtext", is_nullable => 1 },
625 { data_type => "mediumtext", is_nullable => 1 },
627 { data_type => "longtext", is_nullable => 1 },
629 { data_type => "mediumtext", is_nullable => 1 },
631 { data_type => "tinytext", is_nullable => 1 },
633 { data_type => "mediumtext", is_nullable => 1 },
635 { data_type => "longtext", is_nullable => 1 },
637 { data_type => "mediumtext", is_nullable => 1 },
639 { data_type => "tinytext", is_nullable => 1 },
641 { data_type => "longtext", is_nullable => 1 },
643 { data_type => "mediumtext", is_nullable => 1 },
645 { data_type => "mediumtext", is_nullable => 1 },
647 { accessor => "b_streetnumber", data_type => "tinytext", is_nullable => 1 },
649 { accessor => "b_streettype", data_type => "tinytext", is_nullable => 1 },
651 { accessor => "b_address", data_type => "mediumtext", is_nullable => 1 },
653 { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 },
655 { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
657 { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
659 { accessor => "b_zipcode", data_type => "tinytext", is_nullable => 1 },
661 { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 },
663 { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 },
665 { accessor => "b_phone", data_type => "longtext", is_nullable => 1 },
667 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
669 { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
671 { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
673 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
675 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
677 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
679 { data_type => "tinyint", is_nullable => 1 },
681 { data_type => "tinyint", is_nullable => 1 },
683 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
685 { data_type => "varchar", is_nullable => 1, size => 255 },
687 { data_type => "longtext", is_nullable => 1 },
689 { data_type => "mediumtext", is_nullable => 1 },
691 { data_type => "mediumtext", is_nullable => 1 },
693 { data_type => "longtext", is_nullable => 1 },
695 { data_type => "varchar", is_nullable => 1, size => 100 },
697 { data_type => "varchar", is_nullable => 1, size => 1 },
699 { data_type => "varchar", is_nullable => 1, size => 60 },
701 { data_type => "integer", is_nullable => 1 },
703 { data_type => "varchar", is_nullable => 1, size => 75 },
705 { data_type => "longtext", is_nullable => 1 },
707 { data_type => "varchar", is_nullable => 1, size => 255 },
709 { data_type => "varchar", is_nullable => 1, size => 80 },
711 { data_type => "varchar", is_nullable => 1, size => 80 },
712 "altcontactfirstname",
713 { data_type => "mediumtext", is_nullable => 1 },
715 { data_type => "mediumtext", is_nullable => 1 },
716 "altcontactaddress1",
717 { data_type => "mediumtext", is_nullable => 1 },
718 "altcontactaddress2",
719 { data_type => "mediumtext", is_nullable => 1 },
720 "altcontactaddress3",
721 { data_type => "mediumtext", is_nullable => 1 },
723 { data_type => "mediumtext", is_nullable => 1 },
725 { data_type => "mediumtext", is_nullable => 1 },
727 { data_type => "mediumtext", is_nullable => 1 },
729 { data_type => "mediumtext", is_nullable => 1 },
731 { data_type => "varchar", is_nullable => 1, size => 50 },
733 { data_type => "integer", is_nullable => 1 },
735 { data_type => "integer", default_value => 1, is_nullable => 0 },
736 "privacy_guarantor_fines",
737 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
738 "privacy_guarantor_checkouts",
739 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
742 data_type => "varchar",
743 default_value => "inherit",
749 data_type => "timestamp",
750 datetime_undef_if_invalid => 1,
751 default_value => \"current_timestamp",
756 data_type => "datetime",
757 datetime_undef_if_invalid => 1,
762 data_type => "varchar",
763 default_value => "default",
768 { data_type => "integer", default_value => 0, is_nullable => 0 },
769 "overdrive_auth_token",
770 { data_type => "mediumtext", is_nullable => 1 },
772 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
773 "autorenew_checkouts",
774 { data_type => "tinyint", default_value => 1, is_nullable => 0 },
778 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-06-07 05:28:04
779 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/9VjUuilKGDwV/pLlf/4ew
781 __PACKAGE__->add_columns(
782 '+anonymized' => { is_boolean => 1 },
783 '+lost' => { is_boolean => 1 },
784 '+gonenoaddress' => { is_boolean => 1 },
785 '+privacy_guarantor_fines' => { is_boolean => 1 },
786 '+autorenew_checkouts' => { is_boolean => 1 }
789 sub koha_objects_class {
790 'Koha::Old::Patrons';
792 sub koha_object_class {