Koha/Schema/Result/Deletedborrower.pm

   1 use utf8;
   2 package Koha::Schema::Result::Deletedborrower;
   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::Deletedborrower
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<deletedborrowers>
  19
  20 =cut
  21
  22 __PACKAGE__->table("deletedborrowers");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 borrowernumber
  27
  28   data_type: 'integer'
  29   default_value: 0
  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: 'tinytext'
  66   is_nullable: 1
  67
  68 =head2 streettype
  69
  70   data_type: 'tinytext'
  71   is_nullable: 1
  72
  73 =head2 address
  74
  75   data_type: 'longtext'
  76   is_nullable: 1
  77
  78 =head2 address2
  79
  80   data_type: 'mediumtext'
  81   is_nullable: 1
  82
  83 =head2 city
  84
  85   data_type: 'longtext'
  86   is_nullable: 1
  87
  88 =head2 state
  89
  90   data_type: 'mediumtext'
  91   is_nullable: 1
  92
  93 =head2 zipcode
  94
  95   data_type: 'tinytext'
  96   is_nullable: 1
  97
  98 =head2 country
  99
 100   data_type: 'mediumtext'
 101   is_nullable: 1
 102
 103 =head2 email
 104
 105   data_type: 'longtext'
 106   is_nullable: 1
 107
 108 =head2 phone
 109
 110   data_type: 'mediumtext'
 111   is_nullable: 1
 112
 113 =head2 mobile
 114
 115   data_type: 'tinytext'
 116   is_nullable: 1
 117
 118 =head2 fax
 119
 120   data_type: 'longtext'
 121   is_nullable: 1
 122
 123 =head2 emailpro
 124
 125   data_type: 'mediumtext'
 126   is_nullable: 1
 127
 128 =head2 phonepro
 129
 130   data_type: 'mediumtext'
 131   is_nullable: 1
 132
 133 =head2 B_streetnumber
 134
 135   accessor: 'b_streetnumber'
 136   data_type: 'tinytext'
 137   is_nullable: 1
 138
 139 =head2 B_streettype
 140
 141   accessor: 'b_streettype'
 142   data_type: 'tinytext'
 143   is_nullable: 1
 144
 145 =head2 B_address
 146
 147   accessor: 'b_address'
 148   data_type: 'mediumtext'
 149   is_nullable: 1
 150
 151 =head2 B_address2
 152
 153   accessor: 'b_address2'
 154   data_type: 'mediumtext'
 155   is_nullable: 1
 156
 157 =head2 B_city
 158
 159   accessor: 'b_city'
 160   data_type: 'longtext'
 161   is_nullable: 1
 162
 163 =head2 B_state
 164
 165   accessor: 'b_state'
 166   data_type: 'mediumtext'
 167   is_nullable: 1
 168
 169 =head2 B_zipcode
 170
 171   accessor: 'b_zipcode'
 172   data_type: 'tinytext'
 173   is_nullable: 1
 174
 175 =head2 B_country
 176
 177   accessor: 'b_country'
 178   data_type: 'mediumtext'
 179   is_nullable: 1
 180
 181 =head2 B_email
 182
 183   accessor: 'b_email'
 184   data_type: 'mediumtext'
 185   is_nullable: 1
 186
 187 =head2 B_phone
 188
 189   accessor: 'b_phone'
 190   data_type: 'longtext'
 191   is_nullable: 1
 192
 193 =head2 dateofbirth
 194
 195   data_type: 'date'
 196   datetime_undef_if_invalid: 1
 197   is_nullable: 1
 198
 199 =head2 branchcode
 200
 201   data_type: 'varchar'
 202   default_value: (empty string)
 203   is_nullable: 0
 204   size: 10
 205
 206 =head2 categorycode
 207
 208   data_type: 'varchar'
 209   default_value: (empty string)
 210   is_nullable: 0
 211   size: 10
 212
 213 =head2 dateenrolled
 214
 215   data_type: 'date'
 216   datetime_undef_if_invalid: 1
 217   is_nullable: 1
 218
 219 =head2 dateexpiry
 220
 221   data_type: 'date'
 222   datetime_undef_if_invalid: 1
 223   is_nullable: 1
 224
 225 =head2 date_renewed
 226
 227   data_type: 'date'
 228   datetime_undef_if_invalid: 1
 229   is_nullable: 1
 230
 231 =head2 gonenoaddress
 232
 233   data_type: 'tinyint'
 234   is_nullable: 1
 235
 236 =head2 lost
 237
 238   data_type: 'tinyint'
 239   is_nullable: 1
 240
 241 =head2 debarred
 242
 243   data_type: 'date'
 244   datetime_undef_if_invalid: 1
 245   is_nullable: 1
 246
 247 =head2 debarredcomment
 248
 249   data_type: 'varchar'
 250   is_nullable: 1
 251   size: 255
 252
 253 =head2 contactname
 254
 255   data_type: 'longtext'
 256   is_nullable: 1
 257
 258 =head2 contactfirstname
 259
 260   data_type: 'mediumtext'
 261   is_nullable: 1
 262
 263 =head2 contacttitle
 264
 265   data_type: 'mediumtext'
 266   is_nullable: 1
 267
 268 =head2 guarantorid
 269
 270   data_type: 'integer'
 271   is_nullable: 1
 272
 273 =head2 borrowernotes
 274
 275   data_type: 'longtext'
 276   is_nullable: 1
 277
 278 =head2 relationship
 279
 280   data_type: 'varchar'
 281   is_nullable: 1
 282   size: 100
 283
 284 =head2 sex
 285
 286   data_type: 'varchar'
 287   is_nullable: 1
 288   size: 1
 289
 290 =head2 password
 291
 292   data_type: 'varchar'
 293   is_nullable: 1
 294   size: 60
 295
 296 =head2 flags
 297
 298   data_type: 'integer'
 299   is_nullable: 1
 300
 301 =head2 userid
 302
 303   data_type: 'varchar'
 304   is_nullable: 1
 305   size: 75
 306
 307 =head2 opacnote
 308
 309   data_type: 'longtext'
 310   is_nullable: 1
 311
 312 =head2 contactnote
 313
 314   data_type: 'varchar'
 315   is_nullable: 1
 316   size: 255
 317
 318 =head2 sort1
 319
 320   data_type: 'varchar'
 321   is_nullable: 1
 322   size: 80
 323
 324 =head2 sort2
 325
 326   data_type: 'varchar'
 327   is_nullable: 1
 328   size: 80
 329
 330 =head2 altcontactfirstname
 331
 332   data_type: 'mediumtext'
 333   is_nullable: 1
 334
 335 =head2 altcontactsurname
 336
 337   data_type: 'mediumtext'
 338   is_nullable: 1
 339
 340 =head2 altcontactaddress1
 341
 342   data_type: 'mediumtext'
 343   is_nullable: 1
 344
 345 =head2 altcontactaddress2
 346
 347   data_type: 'mediumtext'
 348   is_nullable: 1
 349
 350 =head2 altcontactaddress3
 351
 352   data_type: 'mediumtext'
 353   is_nullable: 1
 354
 355 =head2 altcontactstate
 356
 357   data_type: 'mediumtext'
 358   is_nullable: 1
 359
 360 =head2 altcontactzipcode
 361
 362   data_type: 'mediumtext'
 363   is_nullable: 1
 364
 365 =head2 altcontactcountry
 366
 367   data_type: 'mediumtext'
 368   is_nullable: 1
 369
 370 =head2 altcontactphone
 371
 372   data_type: 'mediumtext'
 373   is_nullable: 1
 374
 375 =head2 smsalertnumber
 376
 377   data_type: 'varchar'
 378   is_nullable: 1
 379   size: 50
 380
 381 =head2 sms_provider_id
 382
 383   data_type: 'integer'
 384   is_nullable: 1
 385
 386 =head2 privacy
 387
 388   data_type: 'integer'
 389   default_value: 1
 390   is_nullable: 0
 391
 392 =head2 privacy_guarantor_checkouts
 393
 394   data_type: 'tinyint'
 395   default_value: 0
 396   is_nullable: 0
 397
 398 =head2 checkprevcheckout
 399
 400   data_type: 'varchar'
 401   default_value: 'inherit'
 402   is_nullable: 0
 403   size: 7
 404
 405 =head2 updated_on
 406
 407   data_type: 'timestamp'
 408   datetime_undef_if_invalid: 1
 409   default_value: current_timestamp
 410   is_nullable: 0
 411
 412 =head2 lastseen
 413
 414   data_type: 'datetime'
 415   datetime_undef_if_invalid: 1
 416   is_nullable: 1
 417
 418 =head2 lang
 419
 420   data_type: 'varchar'
 421   default_value: 'default'
 422   is_nullable: 0
 423   size: 25
 424
 425 =head2 login_attempts
 426
 427   data_type: 'integer'
 428   default_value: 0
 429   is_nullable: 1
 430
 431 =head2 overdrive_auth_token
 432
 433   data_type: 'mediumtext'
 434   is_nullable: 1
 435
 436 =head2 anonymized
 437
 438   data_type: 'tinyint'
 439   default_value: 0
 440   is_nullable: 0
 441
 442 =cut
 443
 444 __PACKAGE__->add_columns(
 445   "borrowernumber",
 446   { data_type => "integer", default_value => 0, is_nullable => 0 },
 447   "cardnumber",
 448   { data_type => "varchar", is_nullable => 1, size => 32 },
 449   "surname",
 450   { data_type => "longtext", is_nullable => 1 },
 451   "firstname",
 452   { data_type => "mediumtext", is_nullable => 1 },
 453   "title",
 454   { data_type => "longtext", is_nullable => 1 },
 455   "othernames",
 456   { data_type => "longtext", is_nullable => 1 },
 457   "initials",
 458   { data_type => "mediumtext", is_nullable => 1 },
 459   "streetnumber",
 460   { data_type => "tinytext", is_nullable => 1 },
 461   "streettype",
 462   { data_type => "tinytext", is_nullable => 1 },
 463   "address",
 464   { data_type => "longtext", is_nullable => 1 },
 465   "address2",
 466   { data_type => "mediumtext", is_nullable => 1 },
 467   "city",
 468   { data_type => "longtext", is_nullable => 1 },
 469   "state",
 470   { data_type => "mediumtext", is_nullable => 1 },
 471   "zipcode",
 472   { data_type => "tinytext", is_nullable => 1 },
 473   "country",
 474   { data_type => "mediumtext", is_nullable => 1 },
 475   "email",
 476   { data_type => "longtext", is_nullable => 1 },
 477   "phone",
 478   { data_type => "mediumtext", is_nullable => 1 },
 479   "mobile",
 480   { data_type => "tinytext", is_nullable => 1 },
 481   "fax",
 482   { data_type => "longtext", is_nullable => 1 },
 483   "emailpro",
 484   { data_type => "mediumtext", is_nullable => 1 },
 485   "phonepro",
 486   { data_type => "mediumtext", is_nullable => 1 },
 487   "B_streetnumber",
 488   { accessor => "b_streetnumber", data_type => "tinytext", is_nullable => 1 },
 489   "B_streettype",
 490   { accessor => "b_streettype", data_type => "tinytext", is_nullable => 1 },
 491   "B_address",
 492   { accessor => "b_address", data_type => "mediumtext", is_nullable => 1 },
 493   "B_address2",
 494   { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 },
 495   "B_city",
 496   { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
 497   "B_state",
 498   { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
 499   "B_zipcode",
 500   { accessor => "b_zipcode", data_type => "tinytext", is_nullable => 1 },
 501   "B_country",
 502   { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 },
 503   "B_email",
 504   { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 },
 505   "B_phone",
 506   { accessor => "b_phone", data_type => "longtext", is_nullable => 1 },
 507   "dateofbirth",
 508   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 509   "branchcode",
 510   { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
 511   "categorycode",
 512   { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
 513   "dateenrolled",
 514   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 515   "dateexpiry",
 516   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 517   "date_renewed",
 518   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 519   "gonenoaddress",
 520   { data_type => "tinyint", is_nullable => 1 },
 521   "lost",
 522   { data_type => "tinyint", is_nullable => 1 },
 523   "debarred",
 524   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 525   "debarredcomment",
 526   { data_type => "varchar", is_nullable => 1, size => 255 },
 527   "contactname",
 528   { data_type => "longtext", is_nullable => 1 },
 529   "contactfirstname",
 530   { data_type => "mediumtext", is_nullable => 1 },
 531   "contacttitle",
 532   { data_type => "mediumtext", is_nullable => 1 },
 533   "guarantorid",
 534   { data_type => "integer", is_nullable => 1 },
 535   "borrowernotes",
 536   { data_type => "longtext", is_nullable => 1 },
 537   "relationship",
 538   { data_type => "varchar", is_nullable => 1, size => 100 },
 539   "sex",
 540   { data_type => "varchar", is_nullable => 1, size => 1 },
 541   "password",
 542   { data_type => "varchar", is_nullable => 1, size => 60 },
 543   "flags",
 544   { data_type => "integer", is_nullable => 1 },
 545   "userid",
 546   { data_type => "varchar", is_nullable => 1, size => 75 },
 547   "opacnote",
 548   { data_type => "longtext", is_nullable => 1 },
 549   "contactnote",
 550   { data_type => "varchar", is_nullable => 1, size => 255 },
 551   "sort1",
 552   { data_type => "varchar", is_nullable => 1, size => 80 },
 553   "sort2",
 554   { data_type => "varchar", is_nullable => 1, size => 80 },
 555   "altcontactfirstname",
 556   { data_type => "mediumtext", is_nullable => 1 },
 557   "altcontactsurname",
 558   { data_type => "mediumtext", is_nullable => 1 },
 559   "altcontactaddress1",
 560   { data_type => "mediumtext", is_nullable => 1 },
 561   "altcontactaddress2",
 562   { data_type => "mediumtext", is_nullable => 1 },
 563   "altcontactaddress3",
 564   { data_type => "mediumtext", is_nullable => 1 },
 565   "altcontactstate",
 566   { data_type => "mediumtext", is_nullable => 1 },
 567   "altcontactzipcode",
 568   { data_type => "mediumtext", is_nullable => 1 },
 569   "altcontactcountry",
 570   { data_type => "mediumtext", is_nullable => 1 },
 571   "altcontactphone",
 572   { data_type => "mediumtext", is_nullable => 1 },
 573   "smsalertnumber",
 574   { data_type => "varchar", is_nullable => 1, size => 50 },
 575   "sms_provider_id",
 576   { data_type => "integer", is_nullable => 1 },
 577   "privacy",
 578   { data_type => "integer", default_value => 1, is_nullable => 0 },
 579   "privacy_guarantor_checkouts",
 580   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 581   "checkprevcheckout",
 582   {
 583     data_type => "varchar",
 584     default_value => "inherit",
 585     is_nullable => 0,
 586     size => 7,
 587   },
 588   "updated_on",
 589   {
 590     data_type => "timestamp",
 591     datetime_undef_if_invalid => 1,
 592     default_value => \"current_timestamp",
 593     is_nullable => 0,
 594   },
 595   "lastseen",
 596   {
 597     data_type => "datetime",
 598     datetime_undef_if_invalid => 1,
 599     is_nullable => 1,
 600   },
 601   "lang",
 602   {
 603     data_type => "varchar",
 604     default_value => "default",
 605     is_nullable => 0,
 606     size => 25,
 607   },
 608   "login_attempts",
 609   { data_type => "integer", default_value => 0, is_nullable => 1 },
 610   "overdrive_auth_token",
 611   { data_type => "mediumtext", is_nullable => 1 },
 612   "anonymized",
 613   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 614 );
 615
 616
 617 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-07-22 19:19:25
 618 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:29hi9QI9+xTuI+pl16KhgQ
 619
 620
 621 # You can replace this text with custom code or comments, and it will be preserved on regeneration
 622 1;