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'
295 data_type: 'longtext'
329 data_type: 'longtext'
350 =head2 altcontactfirstname
356 =head2 altcontactsurname
362 =head2 altcontactaddress1
368 =head2 altcontactaddress2
374 =head2 altcontactaddress3
380 =head2 altcontactstate
382 data_type: 'mediumtext'
385 =head2 altcontactzipcode
391 =head2 altcontactcountry
393 data_type: 'mediumtext'
396 =head2 altcontactphone
402 =head2 smsalertnumber
413 =head2 extended_attributes
415 data_type: 'mediumtext'
418 =head2 gdpr_proc_consent
420 data_type: 'datetime'
421 datetime_undef_if_invalid: 1
426 __PACKAGE__->add_columns(
429 data_type => "timestamp",
430 datetime_undef_if_invalid => 1,
431 default_value => \"current_timestamp",
434 "verification_token",
435 { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
437 { data_type => "mediumtext", is_nullable => 0 },
439 { data_type => "integer", default_value => 0, is_nullable => 0 },
441 { data_type => "varchar", is_nullable => 1, size => 32 },
443 { data_type => "longtext", is_nullable => 1 },
445 { data_type => "mediumtext", is_nullable => 1 },
447 { data_type => "longtext", is_nullable => 1 },
449 { data_type => "longtext", is_nullable => 1 },
451 { data_type => "mediumtext", is_nullable => 1 },
453 { data_type => "varchar", is_nullable => 1, size => 10 },
455 { data_type => "varchar", is_nullable => 1, size => 50 },
457 { data_type => "longtext", is_nullable => 1 },
459 { data_type => "mediumtext", is_nullable => 1 },
461 { data_type => "longtext", is_nullable => 1 },
463 { data_type => "mediumtext", is_nullable => 1 },
465 { data_type => "varchar", is_nullable => 1, size => 25 },
467 { data_type => "mediumtext", is_nullable => 1 },
469 { data_type => "longtext", is_nullable => 1 },
471 { data_type => "mediumtext", is_nullable => 1 },
473 { data_type => "varchar", is_nullable => 1, size => 50 },
475 { data_type => "longtext", is_nullable => 1 },
477 { data_type => "mediumtext", is_nullable => 1 },
479 { data_type => "mediumtext", is_nullable => 1 },
482 accessor => "b_streetnumber",
483 data_type => "varchar",
489 accessor => "b_streettype",
490 data_type => "varchar",
496 accessor => "b_address",
497 data_type => "varchar",
502 { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 },
504 { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
506 { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
509 accessor => "b_zipcode",
510 data_type => "varchar",
515 { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 },
517 { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 },
519 { accessor => "b_phone", data_type => "longtext", is_nullable => 1 },
521 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
523 { data_type => "varchar", is_nullable => 1, size => 10 },
525 { data_type => "varchar", is_nullable => 1, size => 10 },
527 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
529 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
531 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
533 { data_type => "tinyint", is_nullable => 1 },
535 { data_type => "tinyint", is_nullable => 1 },
537 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
539 { data_type => "varchar", is_nullable => 1, size => 255 },
541 { data_type => "longtext", is_nullable => 1 },
543 { data_type => "mediumtext", is_nullable => 1 },
545 { data_type => "mediumtext", is_nullable => 1 },
547 { data_type => "longtext", is_nullable => 1 },
549 { data_type => "varchar", is_nullable => 1, size => 100 },
551 { data_type => "varchar", is_nullable => 1, size => 1 },
553 { data_type => "varchar", is_nullable => 1, size => 30 },
555 { data_type => "integer", is_nullable => 1 },
557 { data_type => "varchar", is_nullable => 1, size => 75 },
559 { data_type => "longtext", is_nullable => 1 },
561 { data_type => "varchar", is_nullable => 1, size => 255 },
563 { data_type => "varchar", is_nullable => 1, size => 80 },
565 { data_type => "varchar", is_nullable => 1, size => 80 },
566 "altcontactfirstname",
567 { data_type => "varchar", is_nullable => 1, size => 255 },
569 { data_type => "varchar", is_nullable => 1, size => 255 },
570 "altcontactaddress1",
571 { data_type => "varchar", is_nullable => 1, size => 255 },
572 "altcontactaddress2",
573 { data_type => "varchar", is_nullable => 1, size => 255 },
574 "altcontactaddress3",
575 { data_type => "varchar", is_nullable => 1, size => 255 },
577 { data_type => "mediumtext", is_nullable => 1 },
579 { data_type => "varchar", is_nullable => 1, size => 50 },
581 { data_type => "mediumtext", is_nullable => 1 },
583 { data_type => "varchar", is_nullable => 1, size => 50 },
585 { data_type => "varchar", is_nullable => 1, size => 50 },
587 { data_type => "integer", is_nullable => 1 },
588 "extended_attributes",
589 { data_type => "mediumtext", is_nullable => 1 },
592 data_type => "datetime",
593 datetime_undef_if_invalid => 1,
602 =item * L</verification_token>
604 =item * L</borrowernumber>
610 __PACKAGE__->set_primary_key("verification_token", "borrowernumber");
613 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-07-22 16:54:42
614 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jkZUTN+mGIdp8ySV0BYNTw
616 sub koha_object_class {
617 'Koha::Patron::Modification';
619 sub koha_objects_class {
620 'Koha::Patron::Modifications';