2 package Koha::Schema::Result::BorrowerModification;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::BorrowerModification
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<borrower_modifications>
22 __PACKAGE__->table("borrower_modifications");
28 data_type: 'timestamp'
29 datetime_undef_if_invalid: 1
30 default_value: current_timestamp
33 =head2 verification_token
36 default_value: (empty string)
42 data_type: 'mediumtext'
64 data_type: 'mediumtext'
79 data_type: 'mediumtext'
101 data_type: 'mediumtext'
106 data_type: 'longtext'
111 data_type: 'mediumtext'
122 data_type: 'mediumtext'
127 data_type: 'longtext'
132 data_type: 'mediumtext'
143 data_type: 'longtext'
148 data_type: 'mediumtext'
153 data_type: 'mediumtext'
156 =head2 B_streetnumber
158 accessor: 'b_streetnumber'
165 accessor: 'b_streettype'
172 accessor: 'b_address'
179 accessor: 'b_address2'
180 data_type: 'mediumtext'
186 data_type: 'longtext'
192 data_type: 'mediumtext'
197 accessor: 'b_zipcode'
204 accessor: 'b_country'
205 data_type: 'mediumtext'
211 data_type: 'mediumtext'
217 data_type: 'longtext'
223 datetime_undef_if_invalid: 1
241 datetime_undef_if_invalid: 1
247 datetime_undef_if_invalid: 1
253 datetime_undef_if_invalid: 1
269 datetime_undef_if_invalid: 1
272 =head2 debarredcomment
280 data_type: 'longtext'
283 =head2 contactfirstname
285 data_type: 'mediumtext'
290 data_type: 'mediumtext'
300 data_type: 'longtext'
334 data_type: 'longtext'
355 =head2 altcontactfirstname
361 =head2 altcontactsurname
367 =head2 altcontactaddress1
373 =head2 altcontactaddress2
379 =head2 altcontactaddress3
385 =head2 altcontactstate
387 data_type: 'mediumtext'
390 =head2 altcontactzipcode
396 =head2 altcontactcountry
398 data_type: 'mediumtext'
401 =head2 altcontactphone
407 =head2 smsalertnumber
418 =head2 extended_attributes
420 data_type: 'mediumtext'
423 =head2 gdpr_proc_consent
425 data_type: 'datetime'
426 datetime_undef_if_invalid: 1
431 __PACKAGE__->add_columns(
434 data_type => "timestamp",
435 datetime_undef_if_invalid => 1,
436 default_value => \"current_timestamp",
439 "verification_token",
440 { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
442 { data_type => "mediumtext", is_nullable => 1 },
444 { data_type => "integer", default_value => 0, is_nullable => 0 },
446 { data_type => "varchar", is_nullable => 1, size => 32 },
448 { data_type => "longtext", is_nullable => 1 },
450 { data_type => "mediumtext", is_nullable => 1 },
452 { data_type => "longtext", is_nullable => 1 },
454 { data_type => "longtext", is_nullable => 1 },
456 { data_type => "mediumtext", is_nullable => 1 },
458 { data_type => "varchar", is_nullable => 1, size => 10 },
460 { data_type => "varchar", is_nullable => 1, size => 50 },
462 { data_type => "longtext", is_nullable => 1 },
464 { data_type => "mediumtext", is_nullable => 1 },
466 { data_type => "longtext", is_nullable => 1 },
468 { data_type => "mediumtext", is_nullable => 1 },
470 { data_type => "varchar", is_nullable => 1, size => 25 },
472 { data_type => "mediumtext", is_nullable => 1 },
474 { data_type => "longtext", is_nullable => 1 },
476 { data_type => "mediumtext", is_nullable => 1 },
478 { data_type => "varchar", is_nullable => 1, size => 50 },
480 { data_type => "longtext", is_nullable => 1 },
482 { data_type => "mediumtext", is_nullable => 1 },
484 { data_type => "mediumtext", is_nullable => 1 },
487 accessor => "b_streetnumber",
488 data_type => "varchar",
494 accessor => "b_streettype",
495 data_type => "varchar",
501 accessor => "b_address",
502 data_type => "varchar",
507 { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 },
509 { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
511 { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
514 accessor => "b_zipcode",
515 data_type => "varchar",
520 { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 },
522 { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 },
524 { accessor => "b_phone", data_type => "longtext", is_nullable => 1 },
526 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
528 { data_type => "varchar", is_nullable => 1, size => 10 },
530 { data_type => "varchar", is_nullable => 1, size => 10 },
532 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
534 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
536 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
538 { data_type => "tinyint", is_nullable => 1 },
540 { data_type => "tinyint", is_nullable => 1 },
542 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
544 { data_type => "varchar", is_nullable => 1, size => 255 },
546 { data_type => "longtext", is_nullable => 1 },
548 { data_type => "mediumtext", is_nullable => 1 },
550 { data_type => "mediumtext", is_nullable => 1 },
552 { data_type => "integer", is_nullable => 1 },
554 { data_type => "longtext", is_nullable => 1 },
556 { data_type => "varchar", is_nullable => 1, size => 100 },
558 { data_type => "varchar", is_nullable => 1, size => 1 },
560 { data_type => "varchar", is_nullable => 1, size => 30 },
562 { data_type => "integer", is_nullable => 1 },
564 { data_type => "varchar", is_nullable => 1, size => 75 },
566 { data_type => "longtext", is_nullable => 1 },
568 { data_type => "varchar", is_nullable => 1, size => 255 },
570 { data_type => "varchar", is_nullable => 1, size => 80 },
572 { data_type => "varchar", is_nullable => 1, size => 80 },
573 "altcontactfirstname",
574 { data_type => "varchar", is_nullable => 1, size => 255 },
576 { data_type => "varchar", is_nullable => 1, size => 255 },
577 "altcontactaddress1",
578 { data_type => "varchar", is_nullable => 1, size => 255 },
579 "altcontactaddress2",
580 { data_type => "varchar", is_nullable => 1, size => 255 },
581 "altcontactaddress3",
582 { data_type => "varchar", is_nullable => 1, size => 255 },
584 { data_type => "mediumtext", is_nullable => 1 },
586 { data_type => "varchar", is_nullable => 1, size => 50 },
588 { data_type => "mediumtext", is_nullable => 1 },
590 { data_type => "varchar", is_nullable => 1, size => 50 },
592 { data_type => "varchar", is_nullable => 1, size => 50 },
594 { data_type => "integer", is_nullable => 1 },
595 "extended_attributes",
596 { data_type => "mediumtext", is_nullable => 1 },
599 data_type => "datetime",
600 datetime_undef_if_invalid => 1,
609 =item * L</verification_token>
611 =item * L</borrowernumber>
617 __PACKAGE__->set_primary_key("verification_token", "borrowernumber");
620 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-06-19 15:36:58
621 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j0cpf6F6MHMqFopc+/Wnbw
623 sub koha_object_class {
624 'Koha::Patron::Modification';
626 sub koha_objects_class {
627 'Koha::Patron::Modifications';