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 =head2 flgAnonymized
 455
 456   accessor: 'flg_anonymized'
 457   data_type: 'tinyint'
 458   default_value: 0
 459   is_nullable: 1
 460
 461 =cut
 462
 463 __PACKAGE__->add_columns(
 464   "borrowernumber",
 465   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
 466   "cardnumber",
 467   { data_type => "varchar", is_nullable => 1, size => 32 },
 468   "surname",
 469   { data_type => "longtext", is_nullable => 1 },
 470   "firstname",
 471   { data_type => "mediumtext", is_nullable => 1 },
 472   "title",
 473   { data_type => "longtext", is_nullable => 1 },
 474   "othernames",
 475   { data_type => "longtext", is_nullable => 1 },
 476   "initials",
 477   { data_type => "mediumtext", is_nullable => 1 },
 478   "streetnumber",
 479   { data_type => "varchar", is_nullable => 1, size => 10 },
 480   "streettype",
 481   { data_type => "varchar", is_nullable => 1, size => 50 },
 482   "address",
 483   { data_type => "longtext", is_nullable => 1 },
 484   "address2",
 485   { data_type => "mediumtext", is_nullable => 1 },
 486   "city",
 487   { data_type => "longtext", is_nullable => 1 },
 488   "state",
 489   { data_type => "mediumtext", is_nullable => 1 },
 490   "zipcode",
 491   { data_type => "varchar", is_nullable => 1, size => 25 },
 492   "country",
 493   { data_type => "mediumtext", is_nullable => 1 },
 494   "email",
 495   { data_type => "longtext", is_nullable => 1 },
 496   "phone",
 497   { data_type => "mediumtext", is_nullable => 1 },
 498   "mobile",
 499   { data_type => "varchar", is_nullable => 1, size => 50 },
 500   "fax",
 501   { data_type => "longtext", is_nullable => 1 },
 502   "emailpro",
 503   { data_type => "mediumtext", is_nullable => 1 },
 504   "phonepro",
 505   { data_type => "mediumtext", is_nullable => 1 },
 506   "B_streetnumber",
 507   {
 508     accessor => "b_streetnumber",
 509     data_type => "varchar",
 510     is_nullable => 1,
 511     size => 10,
 512   },
 513   "B_streettype",
 514   {
 515     accessor => "b_streettype",
 516     data_type => "varchar",
 517     is_nullable => 1,
 518     size => 50,
 519   },
 520   "B_address",
 521   {
 522     accessor => "b_address",
 523     data_type => "varchar",
 524     is_nullable => 1,
 525     size => 100,
 526   },
 527   "B_address2",
 528   { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 },
 529   "B_city",
 530   { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
 531   "B_state",
 532   { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
 533   "B_zipcode",
 534   {
 535     accessor => "b_zipcode",
 536     data_type => "varchar",
 537     is_nullable => 1,
 538     size => 25,
 539   },
 540   "B_country",
 541   { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 },
 542   "B_email",
 543   { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 },
 544   "B_phone",
 545   { accessor => "b_phone", data_type => "longtext", is_nullable => 1 },
 546   "dateofbirth",
 547   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 548   "branchcode",
 549   {
 550     data_type => "varchar",
 551     default_value => "",
 552     is_foreign_key => 1,
 553     is_nullable => 0,
 554     size => 10,
 555   },
 556   "categorycode",
 557   {
 558     data_type => "varchar",
 559     default_value => "",
 560     is_foreign_key => 1,
 561     is_nullable => 0,
 562     size => 10,
 563   },
 564   "dateenrolled",
 565   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 566   "dateexpiry",
 567   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 568   "date_renewed",
 569   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 570   "gonenoaddress",
 571   { data_type => "tinyint", is_nullable => 1 },
 572   "lost",
 573   { data_type => "tinyint", is_nullable => 1 },
 574   "debarred",
 575   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 576   "debarredcomment",
 577   { data_type => "varchar", is_nullable => 1, size => 255 },
 578   "contactname",
 579   { data_type => "longtext", is_nullable => 1 },
 580   "contactfirstname",
 581   { data_type => "mediumtext", is_nullable => 1 },
 582   "contacttitle",
 583   { data_type => "mediumtext", is_nullable => 1 },
 584   "guarantorid",
 585   { data_type => "integer", is_nullable => 1 },
 586   "borrowernotes",
 587   { data_type => "longtext", is_nullable => 1 },
 588   "relationship",
 589   { data_type => "varchar", is_nullable => 1, size => 100 },
 590   "sex",
 591   { data_type => "varchar", is_nullable => 1, size => 1 },
 592   "password",
 593   { data_type => "varchar", is_nullable => 1, size => 60 },
 594   "flags",
 595   { data_type => "integer", is_nullable => 1 },
 596   "userid",
 597   { data_type => "varchar", is_nullable => 1, size => 75 },
 598   "opacnote",
 599   { data_type => "longtext", is_nullable => 1 },
 600   "contactnote",
 601   { data_type => "varchar", is_nullable => 1, size => 255 },
 602   "sort1",
 603   { data_type => "varchar", is_nullable => 1, size => 80 },
 604   "sort2",
 605   { data_type => "varchar", is_nullable => 1, size => 80 },
 606   "altcontactfirstname",
 607   { data_type => "varchar", is_nullable => 1, size => 255 },
 608   "altcontactsurname",
 609   { data_type => "varchar", is_nullable => 1, size => 255 },
 610   "altcontactaddress1",
 611   { data_type => "varchar", is_nullable => 1, size => 255 },
 612   "altcontactaddress2",
 613   { data_type => "varchar", is_nullable => 1, size => 255 },
 614   "altcontactaddress3",
 615   { data_type => "varchar", is_nullable => 1, size => 255 },
 616   "altcontactstate",
 617   { data_type => "mediumtext", is_nullable => 1 },
 618   "altcontactzipcode",
 619   { data_type => "varchar", is_nullable => 1, size => 50 },
 620   "altcontactcountry",
 621   { data_type => "mediumtext", is_nullable => 1 },
 622   "altcontactphone",
 623   { data_type => "varchar", is_nullable => 1, size => 50 },
 624   "smsalertnumber",
 625   { data_type => "varchar", is_nullable => 1, size => 50 },
 626   "sms_provider_id",
 627   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 628   "privacy",
 629   { data_type => "integer", default_value => 1, is_nullable => 0 },
 630   "privacy_guarantor_checkouts",
 631   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 632   "checkprevcheckout",
 633   {
 634     data_type => "varchar",
 635     default_value => "inherit",
 636     is_nullable => 0,
 637     size => 7,
 638   },
 639   "updated_on",
 640   {
 641     data_type => "timestamp",
 642     datetime_undef_if_invalid => 1,
 643     default_value => \"current_timestamp",
 644     is_nullable => 0,
 645   },
 646   "lastseen",
 647   {
 648     data_type => "datetime",
 649     datetime_undef_if_invalid => 1,
 650     is_nullable => 1,
 651   },
 652   "lang",
 653   {
 654     data_type => "varchar",
 655     default_value => "default",
 656     is_nullable => 0,
 657     size => 25,
 658   },
 659   "login_attempts",
 660   { data_type => "integer", default_value => 0, is_nullable => 1 },
 661   "overdrive_auth_token",
 662   { data_type => "mediumtext", is_nullable => 1 },
 663   "flgAnonymized",
 664   {
 665     accessor      => "flg_anonymized",
 666     data_type     => "tinyint",
 667     default_value => 0,
 668     is_nullable   => 1,
 669   },
 670 );
 671
 672 =head1 PRIMARY KEY
 673
 674 =over 4
 675
 676 =item * L</borrowernumber>
 677
 678 =back
 679
 680 =cut
 681
 682 __PACKAGE__->set_primary_key("borrowernumber");
 683
 684 =head1 UNIQUE CONSTRAINTS
 685
 686 =head2 C<cardnumber>
 687
 688 =over 4
 689
 690 =item * L</cardnumber>
 691
 692 =back
 693
 694 =cut
 695
 696 __PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]);
 697
 698 =head2 C<userid>
 699
 700 =over 4
 701
 702 =item * L</userid>
 703
 704 =back
 705
 706 =cut
 707
 708 __PACKAGE__->add_unique_constraint("userid", ["userid"]);
 709
 710 =head1 RELATIONS
 711
 712 =head2 accountlines
 713
 714 Type: has_many
 715
 716 Related object: L<Koha::Schema::Result::Accountline>
 717
 718 =cut
 719
 720 __PACKAGE__->has_many(
 721   "accountlines",
 722   "Koha::Schema::Result::Accountline",
 723   { "foreign.borrowernumber" => "self.borrowernumber" },
 724   { cascade_copy => 0, cascade_delete => 0 },
 725 );
 726
 727 =head2 accountlines_managers
 728
 729 Type: has_many
 730
 731 Related object: L<Koha::Schema::Result::Accountline>
 732
 733 =cut
 734
 735 __PACKAGE__->has_many(
 736   "accountlines_managers",
 737   "Koha::Schema::Result::Accountline",
 738   { "foreign.manager_id" => "self.borrowernumber" },
 739   { cascade_copy => 0, cascade_delete => 0 },
 740 );
 741
 742 =head2 api_keys
 743
 744 Type: has_many
 745
 746 Related object: L<Koha::Schema::Result::ApiKey>
 747
 748 =cut
 749
 750 __PACKAGE__->has_many(
 751   "api_keys",
 752   "Koha::Schema::Result::ApiKey",
 753   { "foreign.patron_id" => "self.borrowernumber" },
 754   { cascade_copy => 0, cascade_delete => 0 },
 755 );
 756
 757 =head2 aqbasketusers
 758
 759 Type: has_many
 760
 761 Related object: L<Koha::Schema::Result::Aqbasketuser>
 762
 763 =cut
 764
 765 __PACKAGE__->has_many(
 766   "aqbasketusers",
 767   "Koha::Schema::Result::Aqbasketuser",
 768   { "foreign.borrowernumber" => "self.borrowernumber" },
 769   { cascade_copy => 0, cascade_delete => 0 },
 770 );
 771
 772 =head2 aqbudgetborrowers
 773
 774 Type: has_many
 775
 776 Related object: L<Koha::Schema::Result::Aqbudgetborrower>
 777
 778 =cut
 779
 780 __PACKAGE__->has_many(
 781   "aqbudgetborrowers",
 782   "Koha::Schema::Result::Aqbudgetborrower",
 783   { "foreign.borrowernumber" => "self.borrowernumber" },
 784   { cascade_copy => 0, cascade_delete => 0 },
 785 );
 786
 787 =head2 aqorder_users
 788
 789 Type: has_many
 790
 791 Related object: L<Koha::Schema::Result::AqorderUser>
 792
 793 =cut
 794
 795 __PACKAGE__->has_many(
 796   "aqorder_users",
 797   "Koha::Schema::Result::AqorderUser",
 798   { "foreign.borrowernumber" => "self.borrowernumber" },
 799   { cascade_copy => 0, cascade_delete => 0 },
 800 );
 801
 802 =head2 aqorders
 803
 804 Type: has_many
 805
 806 Related object: L<Koha::Schema::Result::Aqorder>
 807
 808 =cut
 809
 810 __PACKAGE__->has_many(
 811   "aqorders",
 812   "Koha::Schema::Result::Aqorder",
 813   { "foreign.created_by" => "self.borrowernumber" },
 814   { cascade_copy => 0, cascade_delete => 0 },
 815 );
 816
 817 =head2 article_requests
 818
 819 Type: has_many
 820
 821 Related object: L<Koha::Schema::Result::ArticleRequest>
 822
 823 =cut
 824
 825 __PACKAGE__->has_many(
 826   "article_requests",
 827   "Koha::Schema::Result::ArticleRequest",
 828   { "foreign.borrowernumber" => "self.borrowernumber" },
 829   { cascade_copy => 0, cascade_delete => 0 },
 830 );
 831
 832 =head2 borrower_attributes
 833
 834 Type: has_many
 835
 836 Related object: L<Koha::Schema::Result::BorrowerAttribute>
 837
 838 =cut
 839
 840 __PACKAGE__->has_many(
 841   "borrower_attributes",
 842   "Koha::Schema::Result::BorrowerAttribute",
 843   { "foreign.borrowernumber" => "self.borrowernumber" },
 844   { cascade_copy => 0, cascade_delete => 0 },
 845 );
 846
 847 =head2 borrower_debarments
 848
 849 Type: has_many
 850
 851 Related object: L<Koha::Schema::Result::BorrowerDebarment>
 852
 853 =cut
 854
 855 __PACKAGE__->has_many(
 856   "borrower_debarments",
 857   "Koha::Schema::Result::BorrowerDebarment",
 858   { "foreign.borrowernumber" => "self.borrowernumber" },
 859   { cascade_copy => 0, cascade_delete => 0 },
 860 );
 861
 862 =head2 borrower_files
 863
 864 Type: has_many
 865
 866 Related object: L<Koha::Schema::Result::BorrowerFile>
 867
 868 =cut
 869
 870 __PACKAGE__->has_many(
 871   "borrower_files",
 872   "Koha::Schema::Result::BorrowerFile",
 873   { "foreign.borrowernumber" => "self.borrowernumber" },
 874   { cascade_copy => 0, cascade_delete => 0 },
 875 );
 876
 877 =head2 borrower_message_preferences
 878
 879 Type: has_many
 880
 881 Related object: L<Koha::Schema::Result::BorrowerMessagePreference>
 882
 883 =cut
 884
 885 __PACKAGE__->has_many(
 886   "borrower_message_preferences",
 887   "Koha::Schema::Result::BorrowerMessagePreference",
 888   { "foreign.borrowernumber" => "self.borrowernumber" },
 889   { cascade_copy => 0, cascade_delete => 0 },
 890 );
 891
 892 =head2 branchcode
 893
 894 Type: belongs_to
 895
 896 Related object: L<Koha::Schema::Result::Branch>
 897
 898 =cut
 899
 900 __PACKAGE__->belongs_to(
 901   "branchcode",
 902   "Koha::Schema::Result::Branch",
 903   { branchcode => "branchcode" },
 904   { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
 905 );
 906
 907 =head2 categorycode
 908
 909 Type: belongs_to
 910
 911 Related object: L<Koha::Schema::Result::Category>
 912
 913 =cut
 914
 915 __PACKAGE__->belongs_to(
 916   "categorycode",
 917   "Koha::Schema::Result::Category",
 918   { categorycode => "categorycode" },
 919   { is_deferrable => 1, on_delete => "RESTRICT", on_update => "RESTRICT" },
 920 );
 921
 922 =head2 club_enrollments
 923
 924 Type: has_many
 925
 926 Related object: L<Koha::Schema::Result::ClubEnrollment>
 927
 928 =cut
 929
 930 __PACKAGE__->has_many(
 931   "club_enrollments",
 932   "Koha::Schema::Result::ClubEnrollment",
 933   { "foreign.borrowernumber" => "self.borrowernumber" },
 934   { cascade_copy => 0, cascade_delete => 0 },
 935 );
 936
 937 =head2 course_instructors
 938
 939 Type: has_many
 940
 941 Related object: L<Koha::Schema::Result::CourseInstructor>
 942
 943 =cut
 944
 945 __PACKAGE__->has_many(
 946   "course_instructors",
 947   "Koha::Schema::Result::CourseInstructor",
 948   { "foreign.borrowernumber" => "self.borrowernumber" },
 949   { cascade_copy => 0, cascade_delete => 0 },
 950 );
 951
 952 =head2 creator_batches
 953
 954 Type: has_many
 955
 956 Related object: L<Koha::Schema::Result::CreatorBatch>
 957
 958 =cut
 959
 960 __PACKAGE__->has_many(
 961   "creator_batches",
 962   "Koha::Schema::Result::CreatorBatch",
 963   { "foreign.borrower_number" => "self.borrowernumber" },
 964   { cascade_copy => 0, cascade_delete => 0 },
 965 );
 966
 967 =head2 discharges
 968
 969 Type: has_many
 970
 971 Related object: L<Koha::Schema::Result::Discharge>
 972
 973 =cut
 974
 975 __PACKAGE__->has_many(
 976   "discharges",
 977   "Koha::Schema::Result::Discharge",
 978   { "foreign.borrower" => "self.borrowernumber" },
 979   { cascade_copy => 0, cascade_delete => 0 },
 980 );
 981
 982 =head2 hold_fill_targets
 983
 984 Type: has_many
 985
 986 Related object: L<Koha::Schema::Result::HoldFillTarget>
 987
 988 =cut
 989
 990 __PACKAGE__->has_many(
 991   "hold_fill_targets",
 992   "Koha::Schema::Result::HoldFillTarget",
 993   { "foreign.borrowernumber" => "self.borrowernumber" },
 994   { cascade_copy => 0, cascade_delete => 0 },
 995 );
 996
 997 =head2 housebound_profile
 998
 999 Type: might_have
1000
1001 Related object: L<Koha::Schema::Result::HouseboundProfile>
1002
1003 =cut
1004
1005 __PACKAGE__->might_have(
1006   "housebound_profile",
1007   "Koha::Schema::Result::HouseboundProfile",
1008   { "foreign.borrowernumber" => "self.borrowernumber" },
1009   { cascade_copy => 0, cascade_delete => 0 },
1010 );
1011
1012 =head2 housebound_role
1013
1014 Type: might_have
1015
1016 Related object: L<Koha::Schema::Result::HouseboundRole>
1017
1018 =cut
1019
1020 __PACKAGE__->might_have(
1021   "housebound_role",
1022   "Koha::Schema::Result::HouseboundRole",
1023   { "foreign.borrowernumber_id" => "self.borrowernumber" },
1024   { cascade_copy => 0, cascade_delete => 0 },
1025 );
1026
1027 =head2 housebound_visit_chooser_brwnumbers
1028
1029 Type: has_many
1030
1031 Related object: L<Koha::Schema::Result::HouseboundVisit>
1032
1033 =cut
1034
1035 __PACKAGE__->has_many(
1036   "housebound_visit_chooser_brwnumbers",
1037   "Koha::Schema::Result::HouseboundVisit",
1038   { "foreign.chooser_brwnumber" => "self.borrowernumber" },
1039   { cascade_copy => 0, cascade_delete => 0 },
1040 );
1041
1042 =head2 housebound_visit_deliverer_brwnumbers
1043
1044 Type: has_many
1045
1046 Related object: L<Koha::Schema::Result::HouseboundVisit>
1047
1048 =cut
1049
1050 __PACKAGE__->has_many(
1051   "housebound_visit_deliverer_brwnumbers",
1052   "Koha::Schema::Result::HouseboundVisit",
1053   { "foreign.deliverer_brwnumber" => "self.borrowernumber" },
1054   { cascade_copy => 0, cascade_delete => 0 },
1055 );
1056
1057 =head2 illcomments
1058
1059 Type: has_many
1060
1061 Related object: L<Koha::Schema::Result::Illcomment>
1062
1063 =cut
1064
1065 __PACKAGE__->has_many(
1066   "illcomments",
1067   "Koha::Schema::Result::Illcomment",
1068   { "foreign.borrowernumber" => "self.borrowernumber" },
1069   { cascade_copy => 0, cascade_delete => 0 },
1070 );
1071
1072 =head2 illrequests
1073
1074 Type: has_many
1075
1076 Related object: L<Koha::Schema::Result::Illrequest>
1077
1078 =cut
1079
1080 __PACKAGE__->has_many(
1081   "illrequests",
1082   "Koha::Schema::Result::Illrequest",
1083   { "foreign.borrowernumber" => "self.borrowernumber" },
1084   { cascade_copy => 0, cascade_delete => 0 },
1085 );
1086
1087 =head2 issues
1088
1089 Type: has_many
1090
1091 Related object: L<Koha::Schema::Result::Issue>
1092
1093 =cut
1094
1095 __PACKAGE__->has_many(
1096   "issues",
1097   "Koha::Schema::Result::Issue",
1098   { "foreign.borrowernumber" => "self.borrowernumber" },
1099   { cascade_copy => 0, cascade_delete => 0 },
1100 );
1101
1102 =head2 items_last_borrowers
1103
1104 Type: has_many
1105
1106 Related object: L<Koha::Schema::Result::ItemsLastBorrower>
1107
1108 =cut
1109
1110 __PACKAGE__->has_many(
1111   "items_last_borrowers",
1112   "Koha::Schema::Result::ItemsLastBorrower",
1113   { "foreign.borrowernumber" => "self.borrowernumber" },
1114   { cascade_copy => 0, cascade_delete => 0 },
1115 );
1116
1117 =head2 message_queues
1118
1119 Type: has_many
1120
1121 Related object: L<Koha::Schema::Result::MessageQueue>
1122
1123 =cut
1124
1125 __PACKAGE__->has_many(
1126   "message_queues",
1127   "Koha::Schema::Result::MessageQueue",
1128   { "foreign.borrowernumber" => "self.borrowernumber" },
1129   { cascade_copy => 0, cascade_delete => 0 },
1130 );
1131
1132 =head2 messages
1133
1134 Type: has_many
1135
1136 Related object: L<Koha::Schema::Result::Message>
1137
1138 =cut
1139
1140 __PACKAGE__->has_many(
1141   "messages",
1142   "Koha::Schema::Result::Message",
1143   { "foreign.manager_id" => "self.borrowernumber" },
1144   { cascade_copy => 0, cascade_delete => 0 },
1145 );
1146
1147 =head2 messages_borrowernumbers
1148
1149 Type: has_many
1150
1151 Related object: L<Koha::Schema::Result::Message>
1152
1153 =cut
1154
1155 __PACKAGE__->has_many(
1156   "messages_borrowernumbers",
1157   "Koha::Schema::Result::Message",
1158   { "foreign.borrowernumber" => "self.borrowernumber" },
1159   { cascade_copy => 0, cascade_delete => 0 },
1160 );
1161
1162 =head2 old_issues
1163
1164 Type: has_many
1165
1166 Related object: L<Koha::Schema::Result::OldIssue>
1167
1168 =cut
1169
1170 __PACKAGE__->has_many(
1171   "old_issues",
1172   "Koha::Schema::Result::OldIssue",
1173   { "foreign.borrowernumber" => "self.borrowernumber" },
1174   { cascade_copy => 0, cascade_delete => 0 },
1175 );
1176
1177 =head2 old_reserves
1178
1179 Type: has_many
1180
1181 Related object: L<Koha::Schema::Result::OldReserve>
1182
1183 =cut
1184
1185 __PACKAGE__->has_many(
1186   "old_reserves",
1187   "Koha::Schema::Result::OldReserve",
1188   { "foreign.borrowernumber" => "self.borrowernumber" },
1189   { cascade_copy => 0, cascade_delete => 0 },
1190 );
1191
1192 =head2 opac_news
1193
1194 Type: has_many
1195
1196 Related object: L<Koha::Schema::Result::OpacNews>
1197
1198 =cut
1199
1200 __PACKAGE__->has_many(
1201   "opac_news",
1202   "Koha::Schema::Result::OpacNews",
1203   { "foreign.borrowernumber" => "self.borrowernumber" },
1204   { cascade_copy => 0, cascade_delete => 0 },
1205 );
1206
1207 =head2 patron_consents
1208
1209 Type: has_many
1210
1211 Related object: L<Koha::Schema::Result::PatronConsent>
1212
1213 =cut
1214
1215 __PACKAGE__->has_many(
1216   "patron_consents",
1217   "Koha::Schema::Result::PatronConsent",
1218   { "foreign.borrowernumber" => "self.borrowernumber" },
1219   { cascade_copy => 0, cascade_delete => 0 },
1220 );
1221
1222 =head2 patron_list_patrons
1223
1224 Type: has_many
1225
1226 Related object: L<Koha::Schema::Result::PatronListPatron>
1227
1228 =cut
1229
1230 __PACKAGE__->has_many(
1231   "patron_list_patrons",
1232   "Koha::Schema::Result::PatronListPatron",
1233   { "foreign.borrowernumber" => "self.borrowernumber" },
1234   { cascade_copy => 0, cascade_delete => 0 },
1235 );
1236
1237 =head2 patron_lists
1238
1239 Type: has_many
1240
1241 Related object: L<Koha::Schema::Result::PatronList>
1242
1243 =cut
1244
1245 __PACKAGE__->has_many(
1246   "patron_lists",
1247   "Koha::Schema::Result::PatronList",
1248   { "foreign.owner" => "self.borrowernumber" },
1249   { cascade_copy => 0, cascade_delete => 0 },
1250 );
1251
1252 =head2 patronimage
1253
1254 Type: might_have
1255
1256 Related object: L<Koha::Schema::Result::Patronimage>
1257
1258 =cut
1259
1260 __PACKAGE__->might_have(
1261   "patronimage",
1262   "Koha::Schema::Result::Patronimage",
1263   { "foreign.borrowernumber" => "self.borrowernumber" },
1264   { cascade_copy => 0, cascade_delete => 0 },
1265 );
1266
1267 =head2 ratings
1268
1269 Type: has_many
1270
1271 Related object: L<Koha::Schema::Result::Rating>
1272
1273 =cut
1274
1275 __PACKAGE__->has_many(
1276   "ratings",
1277   "Koha::Schema::Result::Rating",
1278   { "foreign.borrowernumber" => "self.borrowernumber" },
1279   { cascade_copy => 0, cascade_delete => 0 },
1280 );
1281
1282 =head2 reserves
1283
1284 Type: has_many
1285
1286 Related object: L<Koha::Schema::Result::Reserve>
1287
1288 =cut
1289
1290 __PACKAGE__->has_many(
1291   "reserves",
1292   "Koha::Schema::Result::Reserve",
1293   { "foreign.borrowernumber" => "self.borrowernumber" },
1294   { cascade_copy => 0, cascade_delete => 0 },
1295 );
1296
1297 =head2 reviews
1298
1299 Type: has_many
1300
1301 Related object: L<Koha::Schema::Result::Review>
1302
1303 =cut
1304
1305 __PACKAGE__->has_many(
1306   "reviews",
1307   "Koha::Schema::Result::Review",
1308   { "foreign.borrowernumber" => "self.borrowernumber" },
1309   { cascade_copy => 0, cascade_delete => 0 },
1310 );
1311
1312 =head2 sms_provider
1313
1314 Type: belongs_to
1315
1316 Related object: L<Koha::Schema::Result::SmsProvider>
1317
1318 =cut
1319
1320 __PACKAGE__->belongs_to(
1321   "sms_provider",
1322   "Koha::Schema::Result::SmsProvider",
1323   { id => "sms_provider_id" },
1324   {
1325     is_deferrable => 1,
1326     join_type     => "LEFT",
1327     on_delete     => "SET NULL",
1328     on_update     => "CASCADE",
1329   },
1330 );
1331
1332 =head2 subscriptionroutinglists
1333
1334 Type: has_many
1335
1336 Related object: L<Koha::Schema::Result::Subscriptionroutinglist>
1337
1338 =cut
1339
1340 __PACKAGE__->has_many(
1341   "subscriptionroutinglists",
1342   "Koha::Schema::Result::Subscriptionroutinglist",
1343   { "foreign.borrowernumber" => "self.borrowernumber" },
1344   { cascade_copy => 0, cascade_delete => 0 },
1345 );
1346
1347 =head2 suggestions_acceptedbies
1348
1349 Type: has_many
1350
1351 Related object: L<Koha::Schema::Result::Suggestion>
1352
1353 =cut
1354
1355 __PACKAGE__->has_many(
1356   "suggestions_acceptedbies",
1357   "Koha::Schema::Result::Suggestion",
1358   { "foreign.acceptedby" => "self.borrowernumber" },
1359   { cascade_copy => 0, cascade_delete => 0 },
1360 );
1361
1362 =head2 suggestions_managedbies
1363
1364 Type: has_many
1365
1366 Related object: L<Koha::Schema::Result::Suggestion>
1367
1368 =cut
1369
1370 __PACKAGE__->has_many(
1371   "suggestions_managedbies",
1372   "Koha::Schema::Result::Suggestion",
1373   { "foreign.managedby" => "self.borrowernumber" },
1374   { cascade_copy => 0, cascade_delete => 0 },
1375 );
1376
1377 =head2 suggestions_rejectedbies
1378
1379 Type: has_many
1380
1381 Related object: L<Koha::Schema::Result::Suggestion>
1382
1383 =cut
1384
1385 __PACKAGE__->has_many(
1386   "suggestions_rejectedbies",
1387   "Koha::Schema::Result::Suggestion",
1388   { "foreign.rejectedby" => "self.borrowernumber" },
1389   { cascade_copy => 0, cascade_delete => 0 },
1390 );
1391
1392 =head2 suggestions_suggestedbies
1393
1394 Type: has_many
1395
1396 Related object: L<Koha::Schema::Result::Suggestion>
1397
1398 =cut
1399
1400 __PACKAGE__->has_many(
1401   "suggestions_suggestedbies",
1402   "Koha::Schema::Result::Suggestion",
1403   { "foreign.suggestedby" => "self.borrowernumber" },
1404   { cascade_copy => 0, cascade_delete => 0 },
1405 );
1406
1407 =head2 tags_all
1408
1409 Type: has_many
1410
1411 Related object: L<Koha::Schema::Result::TagAll>
1412
1413 =cut
1414
1415 __PACKAGE__->has_many(
1416   "tags_all",
1417   "Koha::Schema::Result::TagAll",
1418   { "foreign.borrowernumber" => "self.borrowernumber" },
1419   { cascade_copy => 0, cascade_delete => 0 },
1420 );
1421
1422 =head2 tags_approvals
1423
1424 Type: has_many
1425
1426 Related object: L<Koha::Schema::Result::TagsApproval>
1427
1428 =cut
1429
1430 __PACKAGE__->has_many(
1431   "tags_approvals",
1432   "Koha::Schema::Result::TagsApproval",
1433   { "foreign.approved_by" => "self.borrowernumber" },
1434   { cascade_copy => 0, cascade_delete => 0 },
1435 );
1436
1437 =head2 user_permissions
1438
1439 Type: has_many
1440
1441 Related object: L<Koha::Schema::Result::UserPermission>
1442
1443 =cut
1444
1445 __PACKAGE__->has_many(
1446   "user_permissions",
1447   "Koha::Schema::Result::UserPermission",
1448   { "foreign.borrowernumber" => "self.borrowernumber" },
1449   { cascade_copy => 0, cascade_delete => 0 },
1450 );
1451
1452 =head2 virtualshelfcontents
1453
1454 Type: has_many
1455
1456 Related object: L<Koha::Schema::Result::Virtualshelfcontent>
1457
1458 =cut
1459
1460 __PACKAGE__->has_many(
1461   "virtualshelfcontents",
1462   "Koha::Schema::Result::Virtualshelfcontent",
1463   { "foreign.borrowernumber" => "self.borrowernumber" },
1464   { cascade_copy => 0, cascade_delete => 0 },
1465 );
1466
1467 =head2 virtualshelfshares
1468
1469 Type: has_many
1470
1471 Related object: L<Koha::Schema::Result::Virtualshelfshare>
1472
1473 =cut
1474
1475 __PACKAGE__->has_many(
1476   "virtualshelfshares",
1477   "Koha::Schema::Result::Virtualshelfshare",
1478   { "foreign.borrowernumber" => "self.borrowernumber" },
1479   { cascade_copy => 0, cascade_delete => 0 },
1480 );
1481
1482 =head2 virtualshelves
1483
1484 Type: has_many
1485
1486 Related object: L<Koha::Schema::Result::Virtualshelve>
1487
1488 =cut
1489
1490 __PACKAGE__->has_many(
1491   "virtualshelves",
1492   "Koha::Schema::Result::Virtualshelve",
1493   { "foreign.owner" => "self.borrowernumber" },
1494   { cascade_copy => 0, cascade_delete => 0 },
1495 );
1496
1497 =head2 basketnoes
1498
1499 Type: many_to_many
1500
1501 Composing rels: L</aqbasketusers> -> basketno
1502
1503 =cut
1504
1505 __PACKAGE__->many_to_many("basketnoes", "aqbasketusers", "basketno");
1506
1507 =head2 budgets
1508
1509 Type: many_to_many
1510
1511 Composing rels: L</aqbudgetborrowers> -> budget
1512
1513 =cut
1514
1515 __PACKAGE__->many_to_many("budgets", "aqbudgetborrowers", "budget");
1516
1517 =head2 courses
1518
1519 Type: many_to_many
1520
1521 Composing rels: L</course_instructors> -> course
1522
1523 =cut
1524
1525 __PACKAGE__->many_to_many("courses", "course_instructors", "course");
1526
1527 =head2 ordernumbers
1528
1529 Type: many_to_many
1530
1531 Composing rels: L</aqorder_users> -> ordernumber
1532
1533 =cut
1534
1535 __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber");
1536
1537
1538 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-17 11:11:33
1539 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZkPU/EUsZVXiRoQ1E8NMbw
1540
1541 __PACKAGE__->belongs_to(
1542     "guarantor",
1543     "Koha::Schema::Result::Borrower",
1544     { borrowernumber => "guarantorid" },
1545 );
1546
1547 __PACKAGE__->add_columns(
1548     '+lost' => { is_boolean => 1 },
1549     '+gonenoaddress' => { is_boolean => 1 }
1550 );
1551
1552 sub koha_objects_class {
1553     'Koha::Patrons';
1554 }
1555 sub koha_object_class {
1556     'Koha::Patron';
1557 }
1558
1559 1;