Koha/Schema/Result/Borrower.pm

   1 use utf8;
   2 package Koha::Schema::Result::Borrower;
   3
   4 # Created by DBIx::Class::Schema::Loader
   5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
   6
   7 =head1 NAME
   8
   9 Koha::Schema::Result::Borrower
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<borrowers>
  19
  20 =cut
  21
  22 __PACKAGE__->table("borrowers");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 borrowernumber
  27
  28   data_type: 'integer'
  29   is_auto_increment: 1
  30   is_nullable: 0
  31
  32 =head2 cardnumber
  33
  34   data_type: 'varchar'
  35   is_nullable: 1
  36   size: 32
  37
  38 =head2 surname
  39
  40   data_type: 'longtext'
  41   is_nullable: 1
  42
  43 =head2 firstname
  44
  45   data_type: 'mediumtext'
  46   is_nullable: 1
  47
  48 =head2 title
  49
  50   data_type: 'longtext'
  51   is_nullable: 1
  52
  53 =head2 othernames
  54
  55   data_type: 'longtext'
  56   is_nullable: 1
  57
  58 =head2 initials
  59
  60   data_type: 'mediumtext'
  61   is_nullable: 1
  62
  63 =head2 streetnumber
  64
  65   data_type: 'varchar'
  66   is_nullable: 1
  67   size: 10
  68
  69 =head2 streettype
  70
  71   data_type: 'varchar'
  72   is_nullable: 1
  73   size: 50
  74
  75 =head2 address
  76
  77   data_type: 'longtext'
  78   is_nullable: 1
  79
  80 =head2 address2
  81
  82   data_type: 'mediumtext'
  83   is_nullable: 1
  84
  85 =head2 city
  86
  87   data_type: 'longtext'
  88   is_nullable: 1
  89
  90 =head2 state
  91
  92   data_type: 'mediumtext'
  93   is_nullable: 1
  94
  95 =head2 zipcode
  96
  97   data_type: 'varchar'
  98   is_nullable: 1
  99   size: 25
 100
 101 =head2 country
 102
 103   data_type: 'mediumtext'
 104   is_nullable: 1
 105
 106 =head2 email
 107
 108   data_type: 'longtext'
 109   is_nullable: 1
 110
 111 =head2 phone
 112
 113   data_type: 'mediumtext'
 114   is_nullable: 1
 115
 116 =head2 mobile
 117
 118   data_type: 'varchar'
 119   is_nullable: 1
 120   size: 50
 121
 122 =head2 fax
 123
 124   data_type: 'longtext'
 125   is_nullable: 1
 126
 127 =head2 emailpro
 128
 129   data_type: 'mediumtext'
 130   is_nullable: 1
 131
 132 =head2 phonepro
 133
 134   data_type: 'mediumtext'
 135   is_nullable: 1
 136
 137 =head2 B_streetnumber
 138
 139   accessor: 'b_streetnumber'
 140   data_type: 'varchar'
 141   is_nullable: 1
 142   size: 10
 143
 144 =head2 B_streettype
 145
 146   accessor: 'b_streettype'
 147   data_type: 'varchar'
 148   is_nullable: 1
 149   size: 50
 150
 151 =head2 B_address
 152
 153   accessor: 'b_address'
 154   data_type: 'varchar'
 155   is_nullable: 1
 156   size: 100
 157
 158 =head2 B_address2
 159
 160   accessor: 'b_address2'
 161   data_type: 'mediumtext'
 162   is_nullable: 1
 163
 164 =head2 B_city
 165
 166   accessor: 'b_city'
 167   data_type: 'longtext'
 168   is_nullable: 1
 169
 170 =head2 B_state
 171
 172   accessor: 'b_state'
 173   data_type: 'mediumtext'
 174   is_nullable: 1
 175
 176 =head2 B_zipcode
 177
 178   accessor: 'b_zipcode'
 179   data_type: 'varchar'
 180   is_nullable: 1
 181   size: 25
 182
 183 =head2 B_country
 184
 185   accessor: 'b_country'
 186   data_type: 'mediumtext'
 187   is_nullable: 1
 188
 189 =head2 B_email
 190
 191   accessor: 'b_email'
 192   data_type: 'mediumtext'
 193   is_nullable: 1
 194
 195 =head2 B_phone
 196
 197   accessor: 'b_phone'
 198   data_type: 'longtext'
 199   is_nullable: 1
 200
 201 =head2 dateofbirth
 202
 203   data_type: 'date'
 204   datetime_undef_if_invalid: 1
 205   is_nullable: 1
 206
 207 =head2 branchcode
 208
 209   data_type: 'varchar'
 210   default_value: (empty string)
 211   is_foreign_key: 1
 212   is_nullable: 0
 213   size: 10
 214
 215 =head2 categorycode
 216
 217   data_type: 'varchar'
 218   default_value: (empty string)
 219   is_foreign_key: 1
 220   is_nullable: 0
 221   size: 10
 222
 223 =head2 dateenrolled
 224
 225   data_type: 'date'
 226   datetime_undef_if_invalid: 1
 227   is_nullable: 1
 228
 229 =head2 dateexpiry
 230
 231   data_type: 'date'
 232   datetime_undef_if_invalid: 1
 233   is_nullable: 1
 234
 235 =head2 date_renewed
 236
 237   data_type: 'date'
 238   datetime_undef_if_invalid: 1
 239   is_nullable: 1
 240
 241 =head2 gonenoaddress
 242
 243   data_type: 'tinyint'
 244   is_nullable: 1
 245
 246 =head2 lost
 247
 248   data_type: 'tinyint'
 249   is_nullable: 1
 250
 251 =head2 debarred
 252
 253   data_type: 'date'
 254   datetime_undef_if_invalid: 1
 255   is_nullable: 1
 256
 257 =head2 debarredcomment
 258
 259   data_type: 'varchar'
 260   is_nullable: 1
 261   size: 255
 262
 263 =head2 contactname
 264
 265   data_type: 'longtext'
 266   is_nullable: 1
 267
 268 =head2 contactfirstname
 269
 270   data_type: 'mediumtext'
 271   is_nullable: 1
 272
 273 =head2 contacttitle
 274
 275   data_type: 'mediumtext'
 276   is_nullable: 1
 277
 278 =head2 guarantorid
 279
 280   data_type: 'integer'
 281   is_nullable: 1
 282
 283 =head2 borrowernotes
 284
 285   data_type: 'longtext'
 286   is_nullable: 1
 287
 288 =head2 relationship
 289
 290   data_type: 'varchar'
 291   is_nullable: 1
 292   size: 100
 293
 294 =head2 sex
 295
 296   data_type: 'varchar'
 297   is_nullable: 1
 298   size: 1
 299
 300 =head2 password
 301
 302   data_type: 'varchar'
 303   is_nullable: 1
 304   size: 60
 305
 306 =head2 flags
 307
 308   data_type: 'integer'
 309   is_nullable: 1
 310
 311 =head2 userid
 312
 313   data_type: 'varchar'
 314   is_nullable: 1
 315   size: 75
 316
 317 =head2 opacnote
 318
 319   data_type: 'longtext'
 320   is_nullable: 1
 321
 322 =head2 contactnote
 323
 324   data_type: 'varchar'
 325   is_nullable: 1
 326   size: 255
 327
 328 =head2 sort1
 329
 330   data_type: 'varchar'
 331   is_nullable: 1
 332   size: 80
 333
 334 =head2 sort2
 335
 336   data_type: 'varchar'
 337   is_nullable: 1
 338   size: 80
 339
 340 =head2 altcontactfirstname
 341
 342   data_type: 'varchar'
 343   is_nullable: 1
 344   size: 255
 345
 346 =head2 altcontactsurname
 347
 348   data_type: 'varchar'
 349   is_nullable: 1
 350   size: 255
 351
 352 =head2 altcontactaddress1
 353
 354   data_type: 'varchar'
 355   is_nullable: 1
 356   size: 255
 357
 358 =head2 altcontactaddress2
 359
 360   data_type: 'varchar'
 361   is_nullable: 1
 362   size: 255
 363
 364 =head2 altcontactaddress3
 365
 366   data_type: 'varchar'
 367   is_nullable: 1
 368   size: 255
 369
 370 =head2 altcontactstate
 371
 372   data_type: 'mediumtext'
 373   is_nullable: 1
 374
 375 =head2 altcontactzipcode
 376
 377   data_type: 'varchar'
 378   is_nullable: 1
 379   size: 50
 380
 381 =head2 altcontactcountry
 382
 383   data_type: 'mediumtext'
 384   is_nullable: 1
 385
 386 =head2 altcontactphone
 387
 388   data_type: 'varchar'
 389   is_nullable: 1
 390   size: 50
 391
 392 =head2 smsalertnumber
 393
 394   data_type: 'varchar'
 395   is_nullable: 1
 396   size: 50
 397
 398 =head2 sms_provider_id
 399
 400   data_type: 'integer'
 401   is_foreign_key: 1
 402   is_nullable: 1
 403
 404 =head2 privacy
 405
 406   data_type: 'integer'
 407   default_value: 1
 408   is_nullable: 0
 409
 410 =head2 privacy_guarantor_checkouts
 411
 412   data_type: 'tinyint'
 413   default_value: 0
 414   is_nullable: 0
 415
 416 =head2 checkprevcheckout
 417
 418   data_type: 'varchar'
 419   default_value: 'inherit'
 420   is_nullable: 0
 421   size: 7
 422
 423 =head2 updated_on
 424
 425   data_type: 'timestamp'
 426   datetime_undef_if_invalid: 1
 427   default_value: current_timestamp
 428   is_nullable: 0
 429
 430 =head2 lastseen
 431
 432   data_type: 'datetime'
 433   datetime_undef_if_invalid: 1
 434   is_nullable: 1
 435
 436 =head2 lang
 437
 438   data_type: 'varchar'
 439   default_value: 'default'
 440   is_nullable: 0
 441   size: 25
 442
 443 =head2 login_attempts
 444
 445   data_type: 'integer'
 446   default_value: 0
 447   is_nullable: 1
 448
 449 =head2 overdrive_auth_token
 450
 451   data_type: 'mediumtext'
 452   is_nullable: 1
 453
 454 =cut
 455
 456 __PACKAGE__->add_columns(
 457   "borrowernumber",
 458   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
 459   "cardnumber",
 460   { data_type => "varchar", is_nullable => 1, size => 32 },
 461   "surname",
 462   { data_type => "longtext", is_nullable => 1 },
 463   "firstname",
 464   { data_type => "mediumtext", is_nullable => 1 },
 465   "title",
 466   { data_type => "longtext", is_nullable => 1 },
 467   "othernames",
 468   { data_type => "longtext", is_nullable => 1 },
 469   "initials",
 470   { data_type => "mediumtext", is_nullable => 1 },
 471   "streetnumber",
 472   { data_type => "varchar", is_nullable => 1, size => 10 },
 473   "streettype",
 474   { data_type => "varchar", is_nullable => 1, size => 50 },
 475   "address",
 476   { data_type => "longtext", is_nullable => 1 },
 477   "address2",
 478   { data_type => "mediumtext", is_nullable => 1 },
 479   "city",
 480   { data_type => "longtext", is_nullable => 1 },
 481   "state",
 482   { data_type => "mediumtext", is_nullable => 1 },
 483   "zipcode",
 484   { data_type => "varchar", is_nullable => 1, size => 25 },
 485   "country",
 486   { data_type => "mediumtext", is_nullable => 1 },
 487   "email",
 488   { data_type => "longtext", is_nullable => 1 },
 489   "phone",
 490   { data_type => "mediumtext", is_nullable => 1 },
 491   "mobile",
 492   { data_type => "varchar", is_nullable => 1, size => 50 },
 493   "fax",
 494   { data_type => "longtext", is_nullable => 1 },
 495   "emailpro",
 496   { data_type => "mediumtext", is_nullable => 1 },
 497   "phonepro",
 498   { data_type => "mediumtext", is_nullable => 1 },
 499   "B_streetnumber",
 500   {
 501     accessor => "b_streetnumber",
 502     data_type => "varchar",
 503     is_nullable => 1,
 504     size => 10,
 505   },
 506   "B_streettype",
 507   {
 508     accessor => "b_streettype",
 509     data_type => "varchar",
 510     is_nullable => 1,
 511     size => 50,
 512   },
 513   "B_address",
 514   {
 515     accessor => "b_address",
 516     data_type => "varchar",
 517     is_nullable => 1,
 518     size => 100,
 519   },
 520   "B_address2",
 521   { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 },
 522   "B_city",
 523   { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
 524   "B_state",
 525   { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
 526   "B_zipcode",
 527   {
 528     accessor => "b_zipcode",
 529     data_type => "varchar",
 530     is_nullable => 1,
 531     size => 25,
 532   },
 533   "B_country",
 534   { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 },
 535   "B_email",
 536   { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 },
 537   "B_phone",
 538   { accessor => "b_phone", data_type => "longtext", is_nullable => 1 },
 539   "dateofbirth",
 540   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 541   "branchcode",
 542   {
 543     data_type => "varchar",
 544     default_value => "",
 545     is_foreign_key => 1,
 546     is_nullable => 0,
 547     size => 10,
 548   },
 549   "categorycode",
 550   {
 551     data_type => "varchar",
 552     default_value => "",
 553     is_foreign_key => 1,
 554     is_nullable => 0,
 555     size => 10,
 556   },
 557   "dateenrolled",
 558   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 559   "dateexpiry",
 560   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 561   "date_renewed",
 562   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 563   "gonenoaddress",
 564   { data_type => "tinyint", is_nullable => 1 },
 565   "lost",
 566   { data_type => "tinyint", is_nullable => 1 },
 567   "debarred",
 568   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 569   "debarredcomment",
 570   { data_type => "varchar", is_nullable => 1, size => 255 },
 571   "contactname",
 572   { data_type => "longtext", is_nullable => 1 },
 573   "contactfirstname",
 574   { data_type => "mediumtext", is_nullable => 1 },
 575   "contacttitle",
 576   { data_type => "mediumtext", is_nullable => 1 },
 577   "guarantorid",
 578   { data_type => "integer", is_nullable => 1 },
 579   "borrowernotes",
 580   { data_type => "longtext", is_nullable => 1 },
 581   "relationship",
 582   { data_type => "varchar", is_nullable => 1, size => 100 },
 583   "sex",
 584   { data_type => "varchar", is_nullable => 1, size => 1 },
 585   "password",
 586   { data_type => "varchar", is_nullable => 1, size => 60 },
 587   "flags",
 588   { data_type => "integer", is_nullable => 1 },
 589   "userid",
 590   { data_type => "varchar", is_nullable => 1, size => 75 },
 591   "opacnote",
 592   { data_type => "longtext", is_nullable => 1 },
 593   "contactnote",
 594   { data_type => "varchar", is_nullable => 1, size => 255 },
 595   "sort1",
 596   { data_type => "varchar", is_nullable => 1, size => 80 },
 597   "sort2",
 598   { data_type => "varchar", is_nullable => 1, size => 80 },
 599   "altcontactfirstname",
 600   { data_type => "varchar", is_nullable => 1, size => 255 },
 601   "altcontactsurname",
 602   { data_type => "varchar", is_nullable => 1, size => 255 },
 603   "altcontactaddress1",
 604   { data_type => "varchar", is_nullable => 1, size => 255 },
 605   "altcontactaddress2",
 606   { data_type => "varchar", is_nullable => 1, size => 255 },
 607   "altcontactaddress3",
 608   { data_type => "varchar", is_nullable => 1, size => 255 },
 609   "altcontactstate",
 610   { data_type => "mediumtext", is_nullable => 1 },
 611   "altcontactzipcode",
 612   { data_type => "varchar", is_nullable => 1, size => 50 },
 613   "altcontactcountry",
 614   { data_type => "mediumtext", is_nullable => 1 },
 615   "altcontactphone",
 616   { data_type => "varchar", is_nullable => 1, size => 50 },
 617   "smsalertnumber",
 618   { data_type => "varchar", is_nullable => 1, size => 50 },
 619   "sms_provider_id",
 620   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 621   "privacy",
 622   { data_type => "integer", default_value => 1, is_nullable => 0 },
 623   "privacy_guarantor_checkouts",
 624   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 625   "checkprevcheckout",
 626   {
 627     data_type => "varchar",
 628     default_value => "inherit",
 629     is_nullable => 0,
 630     size => 7,
 631   },
 632   "updated_on",
 633   {
 634     data_type => "timestamp",
 635     datetime_undef_if_invalid => 1,
 636     default_value => \"current_timestamp",
 637     is_nullable => 0,
 638   },
 639   "lastseen",
 640   {
 641     data_type => "datetime",
 642     datetime_undef_if_invalid => 1,
 643     is_nullable => 1,
 644   },
 645   "lang",
 646   {
 647     data_type => "varchar",
 648     default_value => "default",
 649     is_nullable => 0,
 650     size => 25,
 651   },
 652   "login_attempts",
 653   { data_type => "integer", default_value => 0, is_nullable => 1 },
 654   "overdrive_auth_token",
 655   { data_type => "mediumtext", is_nullable => 1 },
 656 );
 657
 658 =head1 PRIMARY KEY
 659
 660 =over 4
 661
 662 =item * L</borrowernumber>
 663
 664 =back
 665
 666 =cut
 667
 668 __PACKAGE__->set_primary_key("borrowernumber");
 669
 670 =head1 UNIQUE CONSTRAINTS
 671
 672 =head2 C<cardnumber>
 673
 674 =over 4
 675
 676 =item * L</cardnumber>
 677
 678 =back
 679
 680 =cut
 681
 682 __PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
 683
 684 =head2 C<userid>
 685
 686 =over 4
 687
 688 =item * L</userid>
 689
 690 =back
 691
 692 =cut
 693
 694 __PACKAGE__->add_unique_constraint("userid", ["userid"]);
 695
 696 =head1 RELATIONS
 697
 698 =head2 accountlines
 699
 700 Type: has_many
 701
 702 Related object: L<Koha::Schema::Result::Accountline>
 703
 704 =cut
 705
 706 __PACKAGE__->has_many(
 707   "accountlines",
 708   "Koha::Schema::Result::Accountline",
 709   { "foreign.borrowernumber" => "self.borrowernumber" },
 710   { cascade_copy => 0, cascade_delete => 0 },
 711 );
 712
 713 =head2 api_keys
 714
 715 Type: has_many
 716
 717 Related object: L<Koha::Schema::Result::ApiKey>
 718
 719 =cut
 720
 721 __PACKAGE__->has_many(
 722   "api_keys",
 723   "Koha::Schema::Result::ApiKey",
 724   { "foreign.patron_id" => "self.borrowernumber" },
 725   { cascade_copy => 0, cascade_delete => 0 },
 726 );
 727
 728 =head2 aqbasketusers
 729
 730 Type: has_many
 731
 732 Related object: L<Koha::Schema::Result::Aqbasketuser>
 733
 734 =cut
 735
 736 __PACKAGE__->has_many(
 737   "aqbasketusers",
 738   "Koha::Schema::Result::Aqbasketuser",
 739   { "foreign.borrowernumber" => "self.borrowernumber" },
 740   { cascade_copy => 0, cascade_delete => 0 },
 741 );
 742
 743 =head2 aqbudgetborrowers
 744
 745 Type: has_many
 746
 747 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
 748
 749 =cut
 750
 751 __PACKAGE__->has_many(
 752   "aqbudgetborrowers",
 753   "Koha::Schema::Result::Aqbudgetborrower",
 754   { "foreign.borrowernumber" => "self.borrowernumber" },
 755   { cascade_copy => 0, cascade_delete => 0 },
 756 );
 757
 758 =head2 aqorder_users
 759
 760 Type: has_many
 761
 762 Related object: L<Koha::Schema::Result::AqorderUser>
 763
 764 =cut
 765
 766 __PACKAGE__->has_many(
 767   "aqorder_users",
 768   "Koha::Schema::Result::AqorderUser",
 769   { "foreign.borrowernumber" => "self.borrowernumber" },
 770   { cascade_copy => 0, cascade_delete => 0 },
 771 );
 772
 773 =head2 aqorders
 774
 775 Type: has_many
 776
 777 Related object: L<Koha::Schema::Result::Aqorder>
 778
 779 =cut
 780
 781 __PACKAGE__->has_many(
 782   "aqorders",
 783   "Koha::Schema::Result::Aqorder",
 784   { "foreign.created_by" => "self.borrowernumber" },
 785   { cascade_copy => 0, cascade_delete => 0 },
 786 );
 787
 788 =head2 article_requests
 789
 790 Type: has_many
 791
 792 Related object: L<Koha::Schema::Result::ArticleRequest>
 793
 794 =cut
 795
 796 __PACKAGE__->has_many(
 797   "article_requests",
 798   "Koha::Schema::Result::ArticleRequest",
 799   { "foreign.borrowernumber" => "self.borrowernumber" },
 800   { cascade_copy => 0, cascade_delete => 0 },
 801 );
 802
 803 =head2 borrower_attributes
 804
 805 Type: has_many
 806
 807 Related object: L<Koha::Schema::Result::BorrowerAttribute>
 808
 809 =cut
 810
 811 __PACKAGE__->has_many(
 812   "borrower_attributes",
 813   "Koha::Schema::Result::BorrowerAttribute",
 814   { "foreign.borrowernumber" => "self.borrowernumber" },
 815   { cascade_copy => 0, cascade_delete => 0 },
 816 );
 817
 818 =head2 borrower_debarments
 819
 820 Type: has_many
 821
 822 Related object: L<Koha::Schema::Result::BorrowerDebarment>
 823
 824 =cut
 825
 826 __PACKAGE__->has_many(
 827   "borrower_debarments",
 828   "Koha::Schema::Result::BorrowerDebarment",
 829   { "foreign.borrowernumber" => "self.borrowernumber" },
 830   { cascade_copy => 0, cascade_delete => 0 },
 831 );
 832
 833 =head2 borrower_files
 834
 835 Type: has_many
 836
 837 Related object: L<Koha::Schema::Result::BorrowerFile>
 838
 839 =cut
 840
 841 __PACKAGE__->has_many(
 842   "borrower_files",
 843   "Koha::Schema::Result::BorrowerFile",
 844   { "foreign.borrowernumber" => "self.borrowernumber" },
 845   { cascade_copy => 0, cascade_delete => 0 },
 846 );
 847
 848 =head2 borrower_message_preferences
 849
 850 Type: has_many
 851
 852 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
 853
 854 =cut
 855
 856 __PACKAGE__->has_many(
 857   "borrower_message_preferences",
 858   "Koha::Schema::Result::BorrowerMessagePreference",
 859   { "foreign.borrowernumber" => "self.borrowernumber" },
 860   { cascade_copy => 0, cascade_delete => 0 },
 861 );
 862
 863 =head2 branchcode
 864
 865 Type: belongs_to
 866
 867 Related object: L<Koha::Schema::Result::Branch>
 868
 869 =cut
 870
 871 __PACKAGE__->belongs_to(
 872   "branchcode",
 873   "Koha::Schema::Result::Branch",
 874   { branchcode => "branchcode" },
 875   { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
 876 );
 877
 878 =head2 categorycode
 879
 880 Type: belongs_to
 881
 882 Related object: L<Koha::Schema::Result::Category>
 883
 884 =cut
 885
 886 __PACKAGE__->belongs_to(
 887   "categorycode",
 888   "Koha::Schema::Result::Category",
 889   { categorycode => "categorycode" },
 890   { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
 891 );
 892
 893 =head2 club_enrollments
 894
 895 Type: has_many
 896
 897 Related object: L<Koha::Schema::Result::ClubEnrollment>
 898
 899 =cut
 900
 901 __PACKAGE__->has_many(
 902   "club_enrollments",
 903   "Koha::Schema::Result::ClubEnrollment",
 904   { "foreign.borrowernumber" => "self.borrowernumber" },
 905   { cascade_copy => 0, cascade_delete => 0 },
 906 );
 907
 908 =head2 course_instructors
 909
 910 Type: has_many
 911
 912 Related object: L<Koha::Schema::Result::CourseInstructor>
 913
 914 =cut
 915
 916 __PACKAGE__->has_many(
 917   "course_instructors",
 918   "Koha::Schema::Result::CourseInstructor",
 919   { "foreign.borrowernumber" => "self.borrowernumber" },
 920   { cascade_copy => 0, cascade_delete => 0 },
 921 );
 922
 923 =head2 creator_batches
 924
 925 Type: has_many
 926
 927 Related object: L<Koha::Schema::Result::CreatorBatch>
 928
 929 =cut
 930
 931 __PACKAGE__->has_many(
 932   "creator_batches",
 933   "Koha::Schema::Result::CreatorBatch",
 934   { "foreign.borrower_number" => "self.borrowernumber" },
 935   { cascade_copy => 0, cascade_delete => 0 },
 936 );
 937
 938 =head2 discharges
 939
 940 Type: has_many
 941
 942 Related object: L<Koha::Schema::Result::Discharge>
 943
 944 =cut
 945
 946 __PACKAGE__->has_many(
 947   "discharges",
 948   "Koha::Schema::Result::Discharge",
 949   { "foreign.borrower" => "self.borrowernumber" },
 950   { cascade_copy => 0, cascade_delete => 0 },
 951 );
 952
 953 =head2 hold_fill_targets
 954
 955 Type: has_many
 956
 957 Related object: L<Koha::Schema::Result::HoldFillTarget>
 958
 959 =cut
 960
 961 __PACKAGE__->has_many(
 962   "hold_fill_targets",
 963   "Koha::Schema::Result::HoldFillTarget",
 964   { "foreign.borrowernumber" => "self.borrowernumber" },
 965   { cascade_copy => 0, cascade_delete => 0 },
 966 );
 967
 968 =head2 housebound_profile
 969
 970 Type: might_have
 971
 972 Related object: L<Koha::Schema::Result::HouseboundProfile>
 973
 974 =cut
 975
 976 __PACKAGE__->might_have(
 977   "housebound_profile",
 978   "Koha::Schema::Result::HouseboundProfile",
 979   { "foreign.borrowernumber" => "self.borrowernumber" },
 980   { cascade_copy => 0, cascade_delete => 0 },
 981 );
 982
 983 =head2 housebound_role
 984
 985 Type: might_have
 986
 987 Related object: L<Koha::Schema::Result::HouseboundRole>
 988
 989 =cut
 990
 991 __PACKAGE__->might_have(
 992   "housebound_role",
 993   "Koha::Schema::Result::HouseboundRole",
 994   { "foreign.borrowernumber_id" => "self.borrowernumber" },
 995   { cascade_copy => 0, cascade_delete => 0 },
 996 );
 997
 998 =head2 housebound_visit_chooser_brwnumbers
 999
1000 Type: has_many
1001
1002 Related object: L<Koha::Schema::Result::HouseboundVisit>
1003
1004 =cut
1005
1006 __PACKAGE__->has_many(
1007   "housebound_visit_chooser_brwnumbers",
1008   "Koha::Schema::Result::HouseboundVisit",
1009   { "foreign.chooser_brwnumber" => "self.borrowernumber" },
1010   { cascade_copy => 0, cascade_delete => 0 },
1011 );
1012
1013 =head2 housebound_visit_deliverer_brwnumbers
1014
1015 Type: has_many
1016
1017 Related object: L<Koha::Schema::Result::HouseboundVisit>
1018
1019 =cut
1020
1021 __PACKAGE__->has_many(
1022   "housebound_visit_deliverer_brwnumbers",
1023   "Koha::Schema::Result::HouseboundVisit",
1024   { "foreign.deliverer_brwnumber" => "self.borrowernumber" },
1025   { cascade_copy => 0, cascade_delete => 0 },
1026 );
1027
1028 =head2 illcomments
1029
1030 Type: has_many
1031
1032 Related object: L<Koha::Schema::Result::Illcomment>
1033
1034 =cut
1035
1036 __PACKAGE__->has_many(
1037   "illcomments",
1038   "Koha::Schema::Result::Illcomment",
1039   { "foreign.borrowernumber" => "self.borrowernumber" },
1040   { cascade_copy => 0, cascade_delete => 0 },
1041 );
1042
1043 =head2 illrequests
1044
1045 Type: has_many
1046
1047 Related object: L<Koha::Schema::Result::Illrequest>
1048
1049 =cut
1050
1051 __PACKAGE__->has_many(
1052   "illrequests",
1053   "Koha::Schema::Result::Illrequest",
1054   { "foreign.borrowernumber" => "self.borrowernumber" },
1055   { cascade_copy => 0, cascade_delete => 0 },
1056 );
1057
1058 =head2 issues
1059
1060 Type: has_many
1061
1062 Related object: L<Koha::Schema::Result::Issue>
1063
1064 =cut
1065
1066 __PACKAGE__->has_many(
1067   "issues",
1068   "Koha::Schema::Result::Issue",
1069   { "foreign.borrowernumber" => "self.borrowernumber" },
1070   { cascade_copy => 0, cascade_delete => 0 },
1071 );
1072
1073 =head2 items_last_borrowers
1074
1075 Type: has_many
1076
1077 Related object: L<Koha::Schema::Result::ItemsLastBorrower>
1078
1079 =cut
1080
1081 __PACKAGE__->has_many(
1082   "items_last_borrowers",
1083   "Koha::Schema::Result::ItemsLastBorrower",
1084   { "foreign.borrowernumber" => "self.borrowernumber" },
1085   { cascade_copy => 0, cascade_delete => 0 },
1086 );
1087
1088 =head2 message_queues
1089
1090 Type: has_many
1091
1092 Related object: L<Koha::Schema::Result::MessageQueue>
1093
1094 =cut
1095
1096 __PACKAGE__->has_many(
1097   "message_queues",
1098   "Koha::Schema::Result::MessageQueue",
1099   { "foreign.borrowernumber" => "self.borrowernumber" },
1100   { cascade_copy => 0, cascade_delete => 0 },
1101 );
1102
1103 =head2 messages
1104
1105 Type: has_many
1106
1107 Related object: L<Koha::Schema::Result::Message>
1108
1109 =cut
1110
1111 __PACKAGE__->has_many(
1112   "messages",
1113   "Koha::Schema::Result::Message",
1114   { "foreign.manager_id" => "self.borrowernumber" },
1115   { cascade_copy => 0, cascade_delete => 0 },
1116 );
1117
1118 =head2 old_issues
1119
1120 Type: has_many
1121
1122 Related object: L<Koha::Schema::Result::OldIssue>
1123
1124 =cut
1125
1126 __PACKAGE__->has_many(
1127   "old_issues",
1128   "Koha::Schema::Result::OldIssue",
1129   { "foreign.borrowernumber" => "self.borrowernumber" },
1130   { cascade_copy => 0, cascade_delete => 0 },
1131 );
1132
1133 =head2 old_reserves
1134
1135 Type: has_many
1136
1137 Related object: L<Koha::Schema::Result::OldReserve>
1138
1139 =cut
1140
1141 __PACKAGE__->has_many(
1142   "old_reserves",
1143   "Koha::Schema::Result::OldReserve",
1144   { "foreign.borrowernumber" => "self.borrowernumber" },
1145   { cascade_copy => 0, cascade_delete => 0 },
1146 );
1147
1148 =head2 opac_news
1149
1150 Type: has_many
1151
1152 Related object: L<Koha::Schema::Result::OpacNews>
1153
1154 =cut
1155
1156 __PACKAGE__->has_many(
1157   "opac_news",
1158   "Koha::Schema::Result::OpacNews",
1159   { "foreign.borrowernumber" => "self.borrowernumber" },
1160   { cascade_copy => 0, cascade_delete => 0 },
1161 );
1162
1163 =head2 patron_consents
1164
1165 Type: has_many
1166
1167 Related object: L<Koha::Schema::Result::PatronConsent>
1168
1169 =cut
1170
1171 __PACKAGE__->has_many(
1172   "patron_consents",
1173   "Koha::Schema::Result::PatronConsent",
1174   { "foreign.borrowernumber" => "self.borrowernumber" },
1175   { cascade_copy => 0, cascade_delete => 0 },
1176 );
1177
1178 =head2 patron_list_patrons
1179
1180 Type: has_many
1181
1182 Related object: L<Koha::Schema::Result::PatronListPatron>
1183
1184 =cut
1185
1186 __PACKAGE__->has_many(
1187   "patron_list_patrons",
1188   "Koha::Schema::Result::PatronListPatron",
1189   { "foreign.borrowernumber" => "self.borrowernumber" },
1190   { cascade_copy => 0, cascade_delete => 0 },
1191 );
1192
1193 =head2 patron_lists
1194
1195 Type: has_many
1196
1197 Related object: L<Koha::Schema::Result::PatronList>
1198
1199 =cut
1200
1201 __PACKAGE__->has_many(
1202   "patron_lists",
1203   "Koha::Schema::Result::PatronList",
1204   { "foreign.owner" => "self.borrowernumber" },
1205   { cascade_copy => 0, cascade_delete => 0 },
1206 );
1207
1208 =head2 patronimage
1209
1210 Type: might_have
1211
1212 Related object: L<Koha::Schema::Result::Patronimage>
1213
1214 =cut
1215
1216 __PACKAGE__->might_have(
1217   "patronimage",
1218   "Koha::Schema::Result::Patronimage",
1219   { "foreign.borrowernumber" => "self.borrowernumber" },
1220   { cascade_copy => 0, cascade_delete => 0 },
1221 );
1222
1223 =head2 ratings
1224
1225 Type: has_many
1226
1227 Related object: L<Koha::Schema::Result::Rating>
1228
1229 =cut
1230
1231 __PACKAGE__->has_many(
1232   "ratings",
1233   "Koha::Schema::Result::Rating",
1234   { "foreign.borrowernumber" => "self.borrowernumber" },
1235   { cascade_copy => 0, cascade_delete => 0 },
1236 );
1237
1238 =head2 reserves
1239
1240 Type: has_many
1241
1242 Related object: L<Koha::Schema::Result::Reserve>
1243
1244 =cut
1245
1246 __PACKAGE__->has_many(
1247   "reserves",
1248   "Koha::Schema::Result::Reserve",
1249   { "foreign.borrowernumber" => "self.borrowernumber" },
1250   { cascade_copy => 0, cascade_delete => 0 },
1251 );
1252
1253 =head2 reviews
1254
1255 Type: has_many
1256
1257 Related object: L<Koha::Schema::Result::Review>
1258
1259 =cut
1260
1261 __PACKAGE__->has_many(
1262   "reviews",
1263   "Koha::Schema::Result::Review",
1264   { "foreign.borrowernumber" => "self.borrowernumber" },
1265   { cascade_copy => 0, cascade_delete => 0 },
1266 );
1267
1268 =head2 sms_provider
1269
1270 Type: belongs_to
1271
1272 Related object: L<Koha::Schema::Result::SmsProvider>
1273
1274 =cut
1275
1276 __PACKAGE__->belongs_to(
1277   "sms_provider",
1278   "Koha::Schema::Result::SmsProvider",
1279   { id => "sms_provider_id" },
1280   {
1281     is_deferrable => 1,
1282     join_type     => "LEFT",
1283     on_delete     => "SET NULL",
1284     on_update     => "CASCADE",
1285   },
1286 );
1287
1288 =head2 subscriptionroutinglists
1289
1290 Type: has_many
1291
1292 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
1293
1294 =cut
1295
1296 __PACKAGE__->has_many(
1297   "subscriptionroutinglists",
1298   "Koha::Schema::Result::Subscriptionroutinglist",
1299   { "foreign.borrowernumber" => "self.borrowernumber" },
1300   { cascade_copy => 0, cascade_delete => 0 },
1301 );
1302
1303 =head2 tags_all
1304
1305 Type: has_many
1306
1307 Related object: L<Koha::Schema::Result::TagAll>
1308
1309 =cut
1310
1311 __PACKAGE__->has_many(
1312   "tags_all",
1313   "Koha::Schema::Result::TagAll",
1314   { "foreign.borrowernumber" => "self.borrowernumber" },
1315   { cascade_copy => 0, cascade_delete => 0 },
1316 );
1317
1318 =head2 tags_approvals
1319
1320 Type: has_many
1321
1322 Related object: L<Koha::Schema::Result::TagsApproval>
1323
1324 =cut
1325
1326 __PACKAGE__->has_many(
1327   "tags_approvals",
1328   "Koha::Schema::Result::TagsApproval",
1329   { "foreign.approved_by" => "self.borrowernumber" },
1330   { cascade_copy => 0, cascade_delete => 0 },
1331 );
1332
1333 =head2 user_permissions
1334
1335 Type: has_many
1336
1337 Related object: L<Koha::Schema::Result::UserPermission>
1338
1339 =cut
1340
1341 __PACKAGE__->has_many(
1342   "user_permissions",
1343   "Koha::Schema::Result::UserPermission",
1344   { "foreign.borrowernumber" => "self.borrowernumber" },
1345   { cascade_copy => 0, cascade_delete => 0 },
1346 );
1347
1348 =head2 virtualshelfcontents
1349
1350 Type: has_many
1351
1352 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
1353
1354 =cut
1355
1356 __PACKAGE__->has_many(
1357   "virtualshelfcontents",
1358   "Koha::Schema::Result::Virtualshelfcontent",
1359   { "foreign.borrowernumber" => "self.borrowernumber" },
1360   { cascade_copy => 0, cascade_delete => 0 },
1361 );
1362
1363 =head2 virtualshelfshares
1364
1365 Type: has_many
1366
1367 Related object: L<Koha::Schema::Result::Virtualshelfshare>
1368
1369 =cut
1370
1371 __PACKAGE__->has_many(
1372   "virtualshelfshares",
1373   "Koha::Schema::Result::Virtualshelfshare",
1374   { "foreign.borrowernumber" => "self.borrowernumber" },
1375   { cascade_copy => 0, cascade_delete => 0 },
1376 );
1377
1378 =head2 virtualshelves
1379
1380 Type: has_many
1381
1382 Related object: L<Koha::Schema::Result::Virtualshelve>
1383
1384 =cut
1385
1386 __PACKAGE__->has_many(
1387   "virtualshelves",
1388   "Koha::Schema::Result::Virtualshelve",
1389   { "foreign.owner" => "self.borrowernumber" },
1390   { cascade_copy => 0, cascade_delete => 0 },
1391 );
1392
1393 =head2 basketnoes
1394
1395 Type: many_to_many
1396
1397 Composing rels: L</aqbasketusers> -> basketno
1398
1399 =cut
1400
1401 __PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
1402
1403 =head2 budgets
1404
1405 Type: many_to_many
1406
1407 Composing rels: L</aqbudgetborrowers> -> budget
1408
1409 =cut
1410
1411 __PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget");
1412
1413 =head2 courses
1414
1415 Type: many_to_many
1416
1417 Composing rels: L</course_instructors> -> course
1418
1419 =cut
1420
1421 __PACKAGE__->many_to_many("courses", "course_instructors", "course");
1422
1423 =head2 ordernumbers
1424
1425 Type: many_to_many
1426
1427 Composing rels: L</aqorder_users> -> ordernumber
1428
1429 =cut
1430
1431 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1432
1433
1434 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-10-27 13:16:48
1435 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:c3Tb59Kku0Hh+tsVV5eCDg
1436
1437 __PACKAGE__->belongs_to(
1438     "guarantor",
1439     "Koha::Schema::Result::Borrower",
1440     { borrowernumber => "guarantorid" },
1441 );
1442
1443 __PACKAGE__->add_columns(
1444     '+lost' => { is_boolean => 1 },
1445     '+gonenoaddress' => { is_boolean => 1 }
1446 );
1447
1448 sub koha_objects_class {
1449     'Koha::Patrons';
1450 }
1451 sub koha_object_class {
1452     'Koha::Patron';
1453 }
1454
1455 1;