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'
335 data_type: 'mediumtext'
356 =head2 altcontactfirstname
362 =head2 altcontactsurname
368 =head2 altcontactaddress1
374 =head2 altcontactaddress2
380 =head2 altcontactaddress3
386 =head2 altcontactstate
391 =head2 altcontactzipcode
397 =head2 altcontactcountry
402 =head2 altcontactphone
408 =head2 smsalertnumber
421 __PACKAGE__->add_columns(
424 data_type => "timestamp",
425 datetime_undef_if_invalid => 1,
426 default_value => \"current_timestamp",
429 "verification_token",
430 { data_type => "varchar", default_value => "", is_nullable => 0, size => 255 },
432 { data_type => "integer", default_value => 0, is_nullable => 0 },
434 { data_type => "varchar", is_nullable => 1, size => 16 },
436 { data_type => "mediumtext", is_nullable => 1 },
438 { data_type => "text", is_nullable => 1 },
440 { data_type => "mediumtext", 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 => 10 },
448 { data_type => "varchar", is_nullable => 1, size => 50 },
450 { data_type => "mediumtext", is_nullable => 1 },
452 { data_type => "text", is_nullable => 1 },
454 { data_type => "mediumtext", is_nullable => 1 },
456 { data_type => "text", is_nullable => 1 },
458 { data_type => "varchar", is_nullable => 1, size => 25 },
460 { data_type => "text", is_nullable => 1 },
462 { data_type => "mediumtext", is_nullable => 1 },
464 { data_type => "text", is_nullable => 1 },
466 { data_type => "varchar", is_nullable => 1, size => 50 },
468 { data_type => "mediumtext", is_nullable => 1 },
470 { data_type => "text", is_nullable => 1 },
472 { data_type => "text", is_nullable => 1 },
475 accessor => "b_streetnumber",
476 data_type => "varchar",
482 accessor => "b_streettype",
483 data_type => "varchar",
489 accessor => "b_address",
490 data_type => "varchar",
495 { accessor => "b_address2", data_type => "text", is_nullable => 1 },
497 { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
499 { accessor => "b_state", data_type => "text", is_nullable => 1 },
502 accessor => "b_zipcode",
503 data_type => "varchar",
508 { accessor => "b_country", data_type => "text", is_nullable => 1 },
510 { accessor => "b_email", data_type => "text", is_nullable => 1 },
512 { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
514 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
516 { data_type => "varchar", is_nullable => 1, size => 10 },
518 { data_type => "varchar", is_nullable => 1, size => 10 },
520 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
522 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
524 { data_type => "tinyint", is_nullable => 1 },
526 { data_type => "tinyint", is_nullable => 1 },
528 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
530 { data_type => "varchar", is_nullable => 1, size => 255 },
532 { data_type => "mediumtext", is_nullable => 1 },
534 { data_type => "text", is_nullable => 1 },
536 { data_type => "text", is_nullable => 1 },
538 { data_type => "integer", is_nullable => 1 },
540 { data_type => "mediumtext", is_nullable => 1 },
542 { data_type => "varchar", is_nullable => 1, size => 100 },
544 { data_type => "varchar", is_nullable => 1, size => 50 },
546 { data_type => "varchar", is_nullable => 1, size => 255 },
548 { data_type => "varchar", is_nullable => 1, size => 1 },
550 { data_type => "varchar", is_nullable => 1, size => 30 },
552 { data_type => "integer", is_nullable => 1 },
554 { data_type => "varchar", is_nullable => 1, size => 75 },
556 { data_type => "mediumtext", is_nullable => 1 },
558 { data_type => "varchar", is_nullable => 1, size => 255 },
560 { data_type => "varchar", is_nullable => 1, size => 80 },
562 { data_type => "varchar", is_nullable => 1, size => 80 },
563 "altcontactfirstname",
564 { data_type => "varchar", is_nullable => 1, size => 255 },
566 { data_type => "varchar", is_nullable => 1, size => 255 },
567 "altcontactaddress1",
568 { data_type => "varchar", is_nullable => 1, size => 255 },
569 "altcontactaddress2",
570 { data_type => "varchar", is_nullable => 1, size => 255 },
571 "altcontactaddress3",
572 { data_type => "varchar", is_nullable => 1, size => 255 },
574 { data_type => "text", is_nullable => 1 },
576 { data_type => "varchar", is_nullable => 1, size => 50 },
578 { data_type => "text", is_nullable => 1 },
580 { data_type => "varchar", is_nullable => 1, size => 50 },
582 { data_type => "varchar", is_nullable => 1, size => 50 },
584 { data_type => "integer", is_nullable => 1 },
591 =item * L</verification_token>
593 =item * L</borrowernumber>
599 __PACKAGE__->set_primary_key("verification_token", "borrowernumber");
602 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-08-18 13:01:05
603 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xUfsaCL/IR4h5U7AKHmFzw
606 # You can replace this text with custom content, and it will be preserved on regeneration