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