|
Lines 1-21
Link Here
|
| 1 |
use utf8; |
|
|
| 2 |
package Koha::Schema::Result::Borrower; |
1 |
package Koha::Schema::Result::Borrower; |
| 3 |
|
2 |
|
| 4 |
# Created by DBIx::Class::Schema::Loader |
3 |
# Created by DBIx::Class::Schema::Loader |
| 5 |
# DO NOT MODIFY THE FIRST PART OF THIS FILE |
4 |
# DO NOT MODIFY THE FIRST PART OF THIS FILE |
| 6 |
|
5 |
|
| 7 |
=head1 NAME |
|
|
| 8 |
|
| 9 |
Koha::Schema::Result::Borrower |
| 10 |
|
| 11 |
=cut |
| 12 |
|
| 13 |
use strict; |
6 |
use strict; |
| 14 |
use warnings; |
7 |
use warnings; |
| 15 |
|
8 |
|
| 16 |
use base 'DBIx::Class::Core'; |
9 |
use base 'DBIx::Class::Core'; |
| 17 |
|
10 |
|
| 18 |
=head1 TABLE: C<borrowers> |
11 |
|
|
|
12 |
=head1 NAME |
| 13 |
|
| 14 |
Koha::Schema::Result::Borrower |
| 19 |
|
15 |
|
| 20 |
=cut |
16 |
=cut |
| 21 |
|
17 |
|
|
Lines 191-197
__PACKAGE__->table("borrowers");
Link Here
|
| 191 |
=head2 dateofbirth |
187 |
=head2 dateofbirth |
| 192 |
|
188 |
|
| 193 |
data_type: 'date' |
189 |
data_type: 'date' |
| 194 |
datetime_undef_if_invalid: 1 |
|
|
| 195 |
is_nullable: 1 |
190 |
is_nullable: 1 |
| 196 |
|
191 |
|
| 197 |
=head2 branchcode |
192 |
=head2 branchcode |
|
Lines 213-225
__PACKAGE__->table("borrowers");
Link Here
|
| 213 |
=head2 dateenrolled |
208 |
=head2 dateenrolled |
| 214 |
|
209 |
|
| 215 |
data_type: 'date' |
210 |
data_type: 'date' |
| 216 |
datetime_undef_if_invalid: 1 |
|
|
| 217 |
is_nullable: 1 |
211 |
is_nullable: 1 |
| 218 |
|
212 |
|
| 219 |
=head2 dateexpiry |
213 |
=head2 dateexpiry |
| 220 |
|
214 |
|
| 221 |
data_type: 'date' |
215 |
data_type: 'date' |
| 222 |
datetime_undef_if_invalid: 1 |
|
|
| 223 |
is_nullable: 1 |
216 |
is_nullable: 1 |
| 224 |
|
217 |
|
| 225 |
=head2 gonenoaddress |
218 |
=head2 gonenoaddress |
|
Lines 235-241
__PACKAGE__->table("borrowers");
Link Here
|
| 235 |
=head2 debarred |
228 |
=head2 debarred |
| 236 |
|
229 |
|
| 237 |
data_type: 'date' |
230 |
data_type: 'date' |
| 238 |
datetime_undef_if_invalid: 1 |
|
|
| 239 |
is_nullable: 1 |
231 |
is_nullable: 1 |
| 240 |
|
232 |
|
| 241 |
=head2 debarredcomment |
233 |
=head2 debarredcomment |
|
Lines 397-402
__PACKAGE__->table("borrowers");
Link Here
|
| 397 |
default_value: 1 |
389 |
default_value: 1 |
| 398 |
is_nullable: 0 |
390 |
is_nullable: 0 |
| 399 |
|
391 |
|
|
|
392 |
=head2 privacy_relative_checkouts |
| 393 |
|
| 394 |
data_type: 'tinyint' |
| 395 |
default_value: 0 |
| 396 |
is_nullable: 0 |
| 397 |
|
| 400 |
=cut |
398 |
=cut |
| 401 |
|
399 |
|
| 402 |
__PACKAGE__->add_columns( |
400 |
__PACKAGE__->add_columns( |
|
Lines 463-469
__PACKAGE__->add_columns(
Link Here
|
| 463 |
"b_phone", |
461 |
"b_phone", |
| 464 |
{ data_type => "mediumtext", is_nullable => 1 }, |
462 |
{ data_type => "mediumtext", is_nullable => 1 }, |
| 465 |
"dateofbirth", |
463 |
"dateofbirth", |
| 466 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
464 |
{ data_type => "date", is_nullable => 1 }, |
| 467 |
"branchcode", |
465 |
"branchcode", |
| 468 |
{ |
466 |
{ |
| 469 |
data_type => "varchar", |
467 |
data_type => "varchar", |
|
Lines 481-495
__PACKAGE__->add_columns(
Link Here
|
| 481 |
size => 10, |
479 |
size => 10, |
| 482 |
}, |
480 |
}, |
| 483 |
"dateenrolled", |
481 |
"dateenrolled", |
| 484 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
482 |
{ data_type => "date", is_nullable => 1 }, |
| 485 |
"dateexpiry", |
483 |
"dateexpiry", |
| 486 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
484 |
{ data_type => "date", is_nullable => 1 }, |
| 487 |
"gonenoaddress", |
485 |
"gonenoaddress", |
| 488 |
{ data_type => "tinyint", is_nullable => 1 }, |
486 |
{ data_type => "tinyint", is_nullable => 1 }, |
| 489 |
"lost", |
487 |
"lost", |
| 490 |
{ data_type => "tinyint", is_nullable => 1 }, |
488 |
{ data_type => "tinyint", is_nullable => 1 }, |
| 491 |
"debarred", |
489 |
"debarred", |
| 492 |
{ data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, |
490 |
{ data_type => "date", is_nullable => 1 }, |
| 493 |
"debarredcomment", |
491 |
"debarredcomment", |
| 494 |
{ data_type => "varchar", is_nullable => 1, size => 255 }, |
492 |
{ data_type => "varchar", is_nullable => 1, size => 255 }, |
| 495 |
"contactname", |
493 |
"contactname", |
|
Lines 546-577
__PACKAGE__->add_columns(
Link Here
|
| 546 |
{ data_type => "varchar", is_nullable => 1, size => 50 }, |
544 |
{ data_type => "varchar", is_nullable => 1, size => 50 }, |
| 547 |
"privacy", |
545 |
"privacy", |
| 548 |
{ data_type => "integer", default_value => 1, is_nullable => 0 }, |
546 |
{ data_type => "integer", default_value => 1, is_nullable => 0 }, |
|
|
547 |
"privacy_relative_checkouts", |
| 548 |
{ data_type => "tinyint", default_value => 0, is_nullable => 0 }, |
| 549 |
); |
549 |
); |
| 550 |
|
|
|
| 551 |
=head1 PRIMARY KEY |
| 552 |
|
| 553 |
=over 4 |
| 554 |
|
| 555 |
=item * L</borrowernumber> |
| 556 |
|
| 557 |
=back |
| 558 |
|
| 559 |
=cut |
| 560 |
|
| 561 |
__PACKAGE__->set_primary_key("borrowernumber"); |
550 |
__PACKAGE__->set_primary_key("borrowernumber"); |
| 562 |
|
|
|
| 563 |
=head1 UNIQUE CONSTRAINTS |
| 564 |
|
| 565 |
=head2 C<cardnumber> |
| 566 |
|
| 567 |
=over 4 |
| 568 |
|
| 569 |
=item * L</cardnumber> |
| 570 |
|
| 571 |
=back |
| 572 |
|
| 573 |
=cut |
| 574 |
|
| 575 |
__PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]); |
551 |
__PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]); |
| 576 |
|
552 |
|
| 577 |
=head1 RELATIONS |
553 |
=head1 RELATIONS |
|
Lines 696-729
__PACKAGE__->has_many(
Link Here
|
| 696 |
{ cascade_copy => 0, cascade_delete => 0 }, |
672 |
{ cascade_copy => 0, cascade_delete => 0 }, |
| 697 |
); |
673 |
); |
| 698 |
|
674 |
|
| 699 |
=head2 branchcode |
675 |
=head2 categorycode |
| 700 |
|
676 |
|
| 701 |
Type: belongs_to |
677 |
Type: belongs_to |
| 702 |
|
678 |
|
| 703 |
Related object: L<Koha::Schema::Result::Branch> |
679 |
Related object: L<Koha::Schema::Result::Category> |
| 704 |
|
680 |
|
| 705 |
=cut |
681 |
=cut |
| 706 |
|
682 |
|
| 707 |
__PACKAGE__->belongs_to( |
683 |
__PACKAGE__->belongs_to( |
| 708 |
"branchcode", |
684 |
"categorycode", |
| 709 |
"Koha::Schema::Result::Branch", |
685 |
"Koha::Schema::Result::Category", |
| 710 |
{ branchcode => "branchcode" }, |
686 |
{ categorycode => "categorycode" }, |
| 711 |
{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, |
687 |
{ on_delete => "CASCADE", on_update => "CASCADE" }, |
| 712 |
); |
688 |
); |
| 713 |
|
689 |
|
| 714 |
=head2 categorycode |
690 |
=head2 branchcode |
| 715 |
|
691 |
|
| 716 |
Type: belongs_to |
692 |
Type: belongs_to |
| 717 |
|
693 |
|
| 718 |
Related object: L<Koha::Schema::Result::Category> |
694 |
Related object: L<Koha::Schema::Result::Branch> |
| 719 |
|
695 |
|
| 720 |
=cut |
696 |
=cut |
| 721 |
|
697 |
|
| 722 |
__PACKAGE__->belongs_to( |
698 |
__PACKAGE__->belongs_to( |
| 723 |
"categorycode", |
699 |
"branchcode", |
| 724 |
"Koha::Schema::Result::Category", |
700 |
"Koha::Schema::Result::Branch", |
| 725 |
{ categorycode => "categorycode" }, |
701 |
{ branchcode => "branchcode" }, |
| 726 |
{ is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, |
702 |
{ on_delete => "CASCADE", on_update => "CASCADE" }, |
| 727 |
); |
703 |
); |
| 728 |
|
704 |
|
| 729 |
=head2 course_instructors |
705 |
=head2 course_instructors |
|
Lines 1041-1079
__PACKAGE__->has_many(
Link Here
|
| 1041 |
{ cascade_copy => 0, cascade_delete => 0 }, |
1017 |
{ cascade_copy => 0, cascade_delete => 0 }, |
| 1042 |
); |
1018 |
); |
| 1043 |
|
1019 |
|
| 1044 |
=head2 basketnoes |
|
|
| 1045 |
|
| 1046 |
Type: many_to_many |
| 1047 |
|
| 1048 |
Composing rels: L</aqbasketusers> -> basketno |
| 1049 |
|
| 1050 |
=cut |
| 1051 |
|
| 1052 |
__PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno"); |
| 1053 |
|
| 1054 |
=head2 budgets |
| 1055 |
|
| 1056 |
Type: many_to_many |
| 1057 |
|
| 1058 |
Composing rels: L</aqbudgetborrowers> -> budget |
| 1059 |
|
| 1060 |
=cut |
| 1061 |
|
| 1062 |
__PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget"); |
| 1063 |
|
| 1064 |
=head2 courses |
| 1065 |
|
| 1066 |
Type: many_to_many |
| 1067 |
|
| 1068 |
Composing rels: L</course_instructors> -> course |
| 1069 |
|
| 1070 |
=cut |
| 1071 |
|
| 1072 |
__PACKAGE__->many_to_many("courses", "course_instructors", "course"); |
| 1073 |
|
| 1074 |
|
1020 |
|
| 1075 |
# Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-31 16:31:19 |
1021 |
# Created by DBIx::Class::Schema::Loader v0.07000 @ 2013-11-07 08:15:21 |
| 1076 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:z4kW3xYX1CyrwvGdZu32nA |
1022 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TQTGI0fDt+xCFs+8nOarfA |
| 1077 |
|
1023 |
|
| 1078 |
|
1024 |
|
| 1079 |
# You can replace this text with custom content, and it will be preserved on regeneration |
1025 |
# You can replace this text with custom content, and it will be preserved on regeneration |