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)
54 data_type: 'mediumtext'
64 data_type: 'mediumtext'
69 data_type: 'mediumtext'
91 data_type: 'mediumtext'
101 data_type: 'mediumtext'
122 data_type: 'mediumtext'
138 data_type: 'mediumtext'
151 =head2 B_streetnumber
153 accessor: 'b_streetnumber'
160 accessor: 'b_streettype'
167 accessor: 'b_address'
174 accessor: 'b_address2'
181 data_type: 'mediumtext'
192 accessor: 'b_zipcode'
199 accessor: 'b_country'
212 data_type: 'mediumtext'
218 datetime_undef_if_invalid: 1
236 datetime_undef_if_invalid: 1
242 datetime_undef_if_invalid: 1
258 datetime_undef_if_invalid: 1
261 =head2 debarredcomment
269 data_type: 'mediumtext'
272 =head2 contactfirstname
289 data_type: 'mediumtext'
323 data_type: 'mediumtext'
344 =head2 altcontactfirstname
350 =head2 altcontactsurname
356 =head2 altcontactaddress1
362 =head2 altcontactaddress2
368 =head2 altcontactaddress3
374 =head2 altcontactstate
379 =head2 altcontactzipcode
385 =head2 altcontactcountry
390 =head2 altcontactphone
396 =head2 smsalertnumber
409 __PACKAGE__->add_columns(
412 data_type => "timestamp",
413 datetime_undef_if_invalid => 1,
414 default_value => \"current_timestamp",
417 "verification_token",
418 { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
420 { data_type => "integer", default_value => 0, is_nullable => 0 },
422 { data_type => "varchar", is_nullable => 1, size => 16 },
424 { data_type => "mediumtext", is_nullable => 1 },
426 { data_type => "text", is_nullable => 1 },
428 { data_type => "mediumtext", is_nullable => 1 },
430 { data_type => "mediumtext", is_nullable => 1 },
432 { data_type => "text", is_nullable => 1 },
434 { data_type => "varchar", is_nullable => 1, size => 10 },
436 { data_type => "varchar", is_nullable => 1, size => 50 },
438 { data_type => "mediumtext", is_nullable => 1 },
440 { data_type => "text", is_nullable => 1 },
442 { data_type => "mediumtext", is_nullable => 1 },
444 { data_type => "text", is_nullable => 1 },
446 { data_type => "varchar", is_nullable => 1, size => 25 },
448 { data_type => "text", is_nullable => 1 },
450 { data_type => "mediumtext", is_nullable => 1 },
452 { data_type => "text", is_nullable => 1 },
454 { data_type => "varchar", is_nullable => 1, size => 50 },
456 { data_type => "mediumtext", is_nullable => 1 },
458 { data_type => "text", is_nullable => 1 },
460 { data_type => "text", is_nullable => 1 },
463 accessor => "b_streetnumber",
464 data_type => "varchar",
470 accessor => "b_streettype",
471 data_type => "varchar",
477 accessor => "b_address",
478 data_type => "varchar",
483 { accessor => "b_address2", data_type => "text", is_nullable => 1 },
485 { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
487 { accessor => "b_state", data_type => "text", is_nullable => 1 },
490 accessor => "b_zipcode",
491 data_type => "varchar",
496 { accessor => "b_country", data_type => "text", is_nullable => 1 },
498 { accessor => "b_email", data_type => "text", is_nullable => 1 },
500 { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
502 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
504 { data_type => "varchar", is_nullable => 1, size => 10 },
506 { data_type => "varchar", is_nullable => 1, size => 10 },
508 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
510 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
512 { data_type => "tinyint", is_nullable => 1 },
514 { data_type => "tinyint", is_nullable => 1 },
516 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
518 { data_type => "varchar", is_nullable => 1, size => 255 },
520 { data_type => "mediumtext", is_nullable => 1 },
522 { data_type => "text", is_nullable => 1 },
524 { data_type => "text", is_nullable => 1 },
526 { data_type => "integer", is_nullable => 1 },
528 { data_type => "mediumtext", is_nullable => 1 },
530 { data_type => "varchar", is_nullable => 1, size => 100 },
532 { data_type => "varchar", is_nullable => 1, size => 1 },
534 { data_type => "varchar", is_nullable => 1, size => 30 },
536 { data_type => "integer", is_nullable => 1 },
538 { data_type => "varchar", is_nullable => 1, size => 75 },
540 { data_type => "mediumtext", is_nullable => 1 },
542 { data_type => "varchar", is_nullable => 1, size => 255 },
544 { data_type => "varchar", is_nullable => 1, size => 80 },
546 { data_type => "varchar", is_nullable => 1, size => 80 },
547 "altcontactfirstname",
548 { data_type => "varchar", is_nullable => 1, size => 255 },
550 { data_type => "varchar", is_nullable => 1, size => 255 },
551 "altcontactaddress1",
552 { data_type => "varchar", is_nullable => 1, size => 255 },
553 "altcontactaddress2",
554 { data_type => "varchar", is_nullable => 1, size => 255 },
555 "altcontactaddress3",
556 { data_type => "varchar", is_nullable => 1, size => 255 },
558 { data_type => "text", is_nullable => 1 },
560 { data_type => "varchar", is_nullable => 1, size => 50 },
562 { data_type => "text", is_nullable => 1 },
564 { data_type => "varchar", is_nullable => 1, size => 50 },
566 { data_type => "varchar", is_nullable => 1, size => 50 },
568 { data_type => "integer", is_nullable => 1 },
575 =item * L</verification_token>
577 =item * L</borrowernumber>
583 __PACKAGE__->set_primary_key("verification_token", "borrowernumber");
586 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-10-06 10:38:42
587 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vZ9XjkjQv0q6l2kW3KMsLg
590 # You can replace this text with custom content, and it will be preserved on regeneration