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 middle name
68 patron/borrower's title, for example: Mr. or Mrs.
75 any other names associated with the patron/borrower
79 data_type: 'mediumtext'
82 initials for your patron/borrower
89 patron/borrower pronouns
96 the house number for your patron/borrower's primary address
100 data_type: 'tinytext'
103 the street type (Rd., Blvd, etc) for your patron/borrower's primary address
107 data_type: 'longtext'
110 the first address line for your patron/borrower's primary address
114 data_type: 'mediumtext'
117 the second address line for your patron/borrower's primary address
121 data_type: 'longtext'
124 the city or town for your patron/borrower's primary address
128 data_type: 'mediumtext'
131 the state or province for your patron/borrower's primary address
135 data_type: 'tinytext'
138 the zip or postal code for your patron/borrower's primary address
142 data_type: 'mediumtext'
145 the country for your patron/borrower's primary address
149 data_type: 'longtext'
152 the primary email address for your patron/borrower's primary address
156 data_type: 'mediumtext'
159 the primary phone number for your patron/borrower's primary address
163 data_type: 'tinytext'
166 the other phone number for your patron/borrower's primary address
170 data_type: 'longtext'
173 the fax number for your patron/borrower's primary address
177 data_type: 'mediumtext'
180 the secondary email addres for your patron/borrower's primary address
184 data_type: 'mediumtext'
187 the secondary phone number for your patron/borrower's primary address
189 =head2 B_streetnumber
191 accessor: 'b_streetnumber'
192 data_type: 'tinytext'
195 the house number for your patron/borrower's alternate address
199 accessor: 'b_streettype'
200 data_type: 'tinytext'
203 the street type (Rd., Blvd, etc) for your patron/borrower's alternate address
207 accessor: 'b_address'
208 data_type: 'mediumtext'
211 the first address line for your patron/borrower's alternate address
215 accessor: 'b_address2'
216 data_type: 'mediumtext'
219 the second address line for your patron/borrower's alternate address
224 data_type: 'longtext'
227 the city or town for your patron/borrower's alternate address
232 data_type: 'mediumtext'
235 the state for your patron/borrower's alternate address
239 accessor: 'b_zipcode'
240 data_type: 'tinytext'
243 the zip or postal code for your patron/borrower's alternate address
247 accessor: 'b_country'
248 data_type: 'mediumtext'
251 the country for your patron/borrower's alternate address
256 data_type: 'mediumtext'
259 the patron/borrower's alternate email address
264 data_type: 'longtext'
267 the patron/borrower's alternate phone number
272 datetime_undef_if_invalid: 1
275 the patron/borrower's date of birth (YYYY-MM-DD)
280 default_value: (empty string)
284 foreign key from the branches table, includes the code of the patron/borrower's home branch
289 default_value: (empty string)
293 foreign key from the categories table, includes the code of the patron category
298 datetime_undef_if_invalid: 1
301 date the patron was added to Koha (YYYY-MM-DD)
306 datetime_undef_if_invalid: 1
309 date the patron/borrower's card is set to expire (YYYY-MM-DD)
311 =head2 password_expiration_date
314 datetime_undef_if_invalid: 1
317 date the patron/borrower's password is set to expire (YYYY-MM-DD)
322 datetime_undef_if_invalid: 1
325 date the patron/borrower's card was last renewed
332 set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having an unconfirmed address
339 set to 1 for yes and 0 for no, flag to note that library marked this patron/borrower as having lost their card
344 datetime_undef_if_invalid: 1
347 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)
349 =head2 debarredcomment
355 comment on the stop of patron
359 data_type: 'longtext'
362 used for children and profesionals to include surname or last name of guarantor or organization name
364 =head2 contactfirstname
366 data_type: 'mediumtext'
369 used for children to include first name of guarantor
373 data_type: 'mediumtext'
376 used for children to include title (Mr., Mrs., etc) of guarantor
380 data_type: 'longtext'
383 a note on the patron/borrower's account that is only visible in the staff interface
391 used for children to include the relationship to their guarantor
399 patron/borrower's gender
407 patron/borrower's encrypted password
411 data_type: 'mediumtext'
419 default_value: 'password'
420 extra: {list => ["password","two-factor"]}
423 Authentication method
430 will include a number associated with the staff member's permissions
438 patron/borrower's opac and/or staff interface log in
442 data_type: 'longtext'
445 a note on the patron/borrower's account that is visible in the OPAC and staff interface
453 a note related to the patron/borrower's alternate address
461 a field that can be used for any information unique to the library
469 a field that can be used for any information unique to the library
471 =head2 altcontactfirstname
473 data_type: 'mediumtext'
476 first name of alternate contact for the patron/borrower
478 =head2 altcontactsurname
480 data_type: 'mediumtext'
483 surname or last name of the alternate contact for the patron/borrower
485 =head2 altcontactaddress1
487 data_type: 'mediumtext'
490 the first address line for the alternate contact for the patron/borrower
492 =head2 altcontactaddress2
494 data_type: 'mediumtext'
497 the second address line for the alternate contact for the patron/borrower
499 =head2 altcontactaddress3
501 data_type: 'mediumtext'
504 the city for the alternate contact for the patron/borrower
506 =head2 altcontactstate
508 data_type: 'mediumtext'
511 the state for the alternate contact for the patron/borrower
513 =head2 altcontactzipcode
515 data_type: 'mediumtext'
518 the zipcode for the alternate contact for the patron/borrower
520 =head2 altcontactcountry
522 data_type: 'mediumtext'
525 the country for the alternate contact for the patron/borrower
527 =head2 altcontactphone
529 data_type: 'mediumtext'
532 the phone number for the alternate contact for the patron/borrower
534 =head2 smsalertnumber
540 the mobile phone number where the patron/borrower would like to receive notices (if SMS turned on)
542 =head2 sms_provider_id
547 the provider of the mobile phone number defined in smsalertnumber
555 patron/borrower's privacy settings related to their checkout history KEY `borrowernumber` (`borrowernumber`),
557 =head2 privacy_guarantor_fines
563 controls if relatives can see this patron's fines
565 =head2 privacy_guarantor_checkouts
571 controls if relatives can see this patron's checkouts
573 =head2 checkprevcheckout
576 default_value: 'inherit'
580 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'.
584 data_type: 'timestamp'
585 datetime_undef_if_invalid: 1
586 default_value: current_timestamp
589 time of last change could be useful for synchronization with external systems (among others)
593 data_type: 'datetime'
594 datetime_undef_if_invalid: 1
597 last time a patron has been seen (connected at the OPAC or staff interface)
602 default_value: 'default'
606 lang to use to send notices to this patron
608 =head2 login_attempts
614 number of failed login attemps
616 =head2 overdrive_auth_token
618 data_type: 'mediumtext'
621 persist OverDrive auth token
629 flag for data anonymization
631 =head2 autorenew_checkouts
637 flag for allowing auto-renewal
639 =head2 primary_contact_method
645 useful for reporting purposes
649 __PACKAGE__->add_columns(
651 { data_type => "integer", default_value => 0, is_nullable => 0 },
653 { data_type => "varchar", is_nullable => 1, size => 32 },
655 { data_type => "longtext", is_nullable => 1 },
657 { data_type => "mediumtext", is_nullable => 1 },
659 { data_type => "longtext", is_nullable => 1 },
661 { data_type => "longtext", is_nullable => 1 },
663 { data_type => "longtext", is_nullable => 1 },
665 { data_type => "mediumtext", is_nullable => 1 },
667 { data_type => "longtext", is_nullable => 1 },
669 { data_type => "tinytext", is_nullable => 1 },
671 { data_type => "tinytext", is_nullable => 1 },
673 { data_type => "longtext", is_nullable => 1 },
675 { data_type => "mediumtext", is_nullable => 1 },
677 { data_type => "longtext", is_nullable => 1 },
679 { data_type => "mediumtext", is_nullable => 1 },
681 { data_type => "tinytext", is_nullable => 1 },
683 { data_type => "mediumtext", is_nullable => 1 },
685 { data_type => "longtext", is_nullable => 1 },
687 { data_type => "mediumtext", is_nullable => 1 },
689 { data_type => "tinytext", is_nullable => 1 },
691 { data_type => "longtext", is_nullable => 1 },
693 { data_type => "mediumtext", is_nullable => 1 },
695 { data_type => "mediumtext", is_nullable => 1 },
697 { accessor => "b_streetnumber", data_type => "tinytext", is_nullable => 1 },
699 { accessor => "b_streettype", data_type => "tinytext", is_nullable => 1 },
701 { accessor => "b_address", data_type => "mediumtext", is_nullable => 1 },
703 { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 },
705 { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
707 { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
709 { accessor => "b_zipcode", data_type => "tinytext", is_nullable => 1 },
711 { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 },
713 { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 },
715 { accessor => "b_phone", data_type => "longtext", is_nullable => 1 },
717 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
719 { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
721 { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
723 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
725 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
726 "password_expiration_date",
727 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
729 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
731 { data_type => "tinyint", is_nullable => 1 },
733 { data_type => "tinyint", is_nullable => 1 },
735 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
737 { data_type => "varchar", is_nullable => 1, size => 255 },
739 { data_type => "longtext", is_nullable => 1 },
741 { data_type => "mediumtext", is_nullable => 1 },
743 { data_type => "mediumtext", is_nullable => 1 },
745 { data_type => "longtext", is_nullable => 1 },
747 { data_type => "varchar", is_nullable => 1, size => 100 },
749 { data_type => "varchar", is_nullable => 1, size => 1 },
751 { data_type => "varchar", is_nullable => 1, size => 60 },
753 { data_type => "mediumtext", is_nullable => 1 },
757 default_value => "password",
758 extra => { list => ["password", "two-factor"] },
762 { data_type => "integer", is_nullable => 1 },
764 { data_type => "varchar", is_nullable => 1, size => 75 },
766 { data_type => "longtext", is_nullable => 1 },
768 { data_type => "varchar", is_nullable => 1, size => 255 },
770 { data_type => "varchar", is_nullable => 1, size => 80 },
772 { data_type => "varchar", is_nullable => 1, size => 80 },
773 "altcontactfirstname",
774 { data_type => "mediumtext", is_nullable => 1 },
776 { data_type => "mediumtext", is_nullable => 1 },
777 "altcontactaddress1",
778 { data_type => "mediumtext", is_nullable => 1 },
779 "altcontactaddress2",
780 { data_type => "mediumtext", is_nullable => 1 },
781 "altcontactaddress3",
782 { data_type => "mediumtext", is_nullable => 1 },
784 { data_type => "mediumtext", is_nullable => 1 },
786 { data_type => "mediumtext", is_nullable => 1 },
788 { data_type => "mediumtext", is_nullable => 1 },
790 { data_type => "mediumtext", is_nullable => 1 },
792 { data_type => "varchar", is_nullable => 1, size => 50 },
794 { data_type => "integer", is_nullable => 1 },
796 { data_type => "integer", default_value => 1, is_nullable => 0 },
797 "privacy_guarantor_fines",
798 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
799 "privacy_guarantor_checkouts",
800 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
803 data_type => "varchar",
804 default_value => "inherit",
810 data_type => "timestamp",
811 datetime_undef_if_invalid => 1,
812 default_value => \"current_timestamp",
817 data_type => "datetime",
818 datetime_undef_if_invalid => 1,
823 data_type => "varchar",
824 default_value => "default",
829 { data_type => "integer", default_value => 0, is_nullable => 0 },
830 "overdrive_auth_token",
831 { data_type => "mediumtext", is_nullable => 1 },
833 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
834 "autorenew_checkouts",
835 { data_type => "tinyint", default_value => 1, is_nullable => 0 },
836 "primary_contact_method",
837 { data_type => "varchar", is_nullable => 1, size => 45 },
841 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-10-03 18:03:21
842 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OKIbF7K2KWpEJGbFbetD0w
844 __PACKAGE__->add_columns(
845 '+anonymized' => { is_boolean => 1 },
846 '+lost' => { is_boolean => 1 },
847 '+gonenoaddress' => { is_boolean => 1 },
848 '+privacy_guarantor_fines' => { is_boolean => 1 },
849 '+autorenew_checkouts' => { is_boolean => 1 }
852 sub koha_objects_class {
853 'Koha::Old::Patrons';
855 sub koha_object_class {