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");
45 data_type: 'mediumtext'
60 data_type: 'mediumtext'
82 data_type: 'mediumtext'
92 data_type: 'mediumtext'
103 data_type: 'mediumtext'
108 data_type: 'longtext'
113 data_type: 'mediumtext'
124 data_type: 'longtext'
129 data_type: 'mediumtext'
134 data_type: 'mediumtext'
137 =head2 B_streetnumber
139 accessor: 'b_streetnumber'
146 accessor: 'b_streettype'
153 accessor: 'b_address'
160 accessor: 'b_address2'
161 data_type: 'mediumtext'
167 data_type: 'longtext'
173 data_type: 'mediumtext'
178 accessor: 'b_zipcode'
185 accessor: 'b_country'
186 data_type: 'mediumtext'
192 data_type: 'mediumtext'
198 data_type: 'longtext'
204 datetime_undef_if_invalid: 1
210 default_value: (empty string)
217 default_value: (empty string)
224 datetime_undef_if_invalid: 1
230 datetime_undef_if_invalid: 1
236 datetime_undef_if_invalid: 1
252 datetime_undef_if_invalid: 1
255 =head2 debarredcomment
263 data_type: 'longtext'
266 =head2 contactfirstname
268 data_type: 'mediumtext'
273 data_type: 'mediumtext'
283 data_type: 'longtext'
317 data_type: 'longtext'
338 =head2 altcontactfirstname
344 =head2 altcontactsurname
350 =head2 altcontactaddress1
356 =head2 altcontactaddress2
362 =head2 altcontactaddress3
368 =head2 altcontactstate
370 data_type: 'mediumtext'
373 =head2 altcontactzipcode
379 =head2 altcontactcountry
381 data_type: 'mediumtext'
384 =head2 altcontactphone
390 =head2 smsalertnumber
396 =head2 sms_provider_id
407 =head2 privacy_guarantor_checkouts
413 =head2 checkprevcheckout
416 default_value: 'inherit'
422 data_type: 'timestamp'
423 datetime_undef_if_invalid: 1
424 default_value: current_timestamp
429 data_type: 'datetime'
430 datetime_undef_if_invalid: 1
436 default_value: 'default'
440 =head2 login_attempts
446 =head2 overdrive_auth_token
448 data_type: 'mediumtext'
459 __PACKAGE__->add_columns(
461 { data_type => "integer", default_value => 0, is_nullable => 0 },
463 { data_type => "varchar", is_nullable => 1, size => 32 },
465 { data_type => "longtext", is_nullable => 1 },
467 { data_type => "mediumtext", is_nullable => 1 },
469 { data_type => "longtext", is_nullable => 1 },
471 { data_type => "longtext", is_nullable => 1 },
473 { data_type => "mediumtext", is_nullable => 1 },
475 { data_type => "varchar", is_nullable => 1, size => 10 },
477 { data_type => "varchar", is_nullable => 1, size => 50 },
479 { data_type => "longtext", is_nullable => 1 },
481 { data_type => "mediumtext", is_nullable => 1 },
483 { data_type => "longtext", is_nullable => 1 },
485 { data_type => "mediumtext", is_nullable => 1 },
487 { data_type => "varchar", is_nullable => 1, size => 25 },
489 { data_type => "mediumtext", is_nullable => 1 },
491 { data_type => "longtext", is_nullable => 1 },
493 { data_type => "mediumtext", is_nullable => 1 },
495 { data_type => "varchar", is_nullable => 1, size => 50 },
497 { data_type => "longtext", is_nullable => 1 },
499 { data_type => "mediumtext", is_nullable => 1 },
501 { data_type => "mediumtext", is_nullable => 1 },
504 accessor => "b_streetnumber",
505 data_type => "varchar",
511 accessor => "b_streettype",
512 data_type => "varchar",
518 accessor => "b_address",
519 data_type => "varchar",
524 { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 },
526 { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
528 { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
531 accessor => "b_zipcode",
532 data_type => "varchar",
537 { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 },
539 { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 },
541 { accessor => "b_phone", data_type => "longtext", is_nullable => 1 },
543 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
545 { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
547 { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
549 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
551 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
553 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
555 { data_type => "tinyint", is_nullable => 1 },
557 { data_type => "tinyint", is_nullable => 1 },
559 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
561 { data_type => "varchar", is_nullable => 1, size => 255 },
563 { data_type => "longtext", is_nullable => 1 },
565 { data_type => "mediumtext", is_nullable => 1 },
567 { data_type => "mediumtext", is_nullable => 1 },
569 { data_type => "integer", is_nullable => 1 },
571 { data_type => "longtext", is_nullable => 1 },
573 { data_type => "varchar", is_nullable => 1, size => 100 },
575 { data_type => "varchar", is_nullable => 1, size => 1 },
577 { data_type => "varchar", is_nullable => 1, size => 60 },
579 { data_type => "integer", is_nullable => 1 },
581 { data_type => "varchar", is_nullable => 1, size => 75 },
583 { data_type => "longtext", is_nullable => 1 },
585 { data_type => "varchar", is_nullable => 1, size => 255 },
587 { data_type => "varchar", is_nullable => 1, size => 80 },
589 { data_type => "varchar", is_nullable => 1, size => 80 },
590 "altcontactfirstname",
591 { data_type => "varchar", is_nullable => 1, size => 255 },
593 { data_type => "varchar", is_nullable => 1, size => 255 },
594 "altcontactaddress1",
595 { data_type => "varchar", is_nullable => 1, size => 255 },
596 "altcontactaddress2",
597 { data_type => "varchar", is_nullable => 1, size => 255 },
598 "altcontactaddress3",
599 { data_type => "varchar", is_nullable => 1, size => 255 },
601 { data_type => "mediumtext", is_nullable => 1 },
603 { data_type => "varchar", is_nullable => 1, size => 50 },
605 { data_type => "mediumtext", is_nullable => 1 },
607 { data_type => "varchar", is_nullable => 1, size => 50 },
609 { data_type => "varchar", is_nullable => 1, size => 50 },
611 { data_type => "integer", is_nullable => 1 },
613 { data_type => "integer", default_value => 1, is_nullable => 0 },
614 "privacy_guarantor_checkouts",
615 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
618 data_type => "varchar",
619 default_value => "inherit",
625 data_type => "timestamp",
626 datetime_undef_if_invalid => 1,
627 default_value => \"current_timestamp",
632 data_type => "datetime",
633 datetime_undef_if_invalid => 1,
638 data_type => "varchar",
639 default_value => "default",
644 { data_type => "integer", default_value => 0, is_nullable => 1 },
645 "overdrive_auth_token",
646 { data_type => "mediumtext", is_nullable => 1 },
648 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
652 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-25 10:08:38
653 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hzKeGjtecf3VyEvaBhDmUg
656 # You can replace this text with custom code or comments, and it will be preserved on regeneration