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: 16
  37
  38 =head2 surname
  39
  40   data_type: 'mediumtext'
  41   is_nullable: 0
  42
  43 =head2 firstname
  44
  45   data_type: 'text'
  46   is_nullable: 1
  47
  48 =head2 title
  49
  50   data_type: 'mediumtext'
  51   is_nullable: 1
  52
  53 =head2 othernames
  54
  55   data_type: 'mediumtext'
  56   is_nullable: 1
  57
  58 =head2 initials
  59
  60   data_type: 'text'
  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: 'mediumtext'
  78   is_nullable: 0
  79
  80 =head2 address2
  81
  82   data_type: 'text'
  83   is_nullable: 1
  84
  85 =head2 city
  86
  87   data_type: 'mediumtext'
  88   is_nullable: 0
  89
  90 =head2 state
  91
  92   data_type: 'text'
  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: 'text'
 104   is_nullable: 1
 105
 106 =head2 email
 107
 108   data_type: 'mediumtext'
 109   is_nullable: 1
 110
 111 =head2 phone
 112
 113   data_type: 'text'
 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: 'mediumtext'
 125   is_nullable: 1
 126
 127 =head2 emailpro
 128
 129   data_type: 'text'
 130   is_nullable: 1
 131
 132 =head2 phonepro
 133
 134   data_type: 'text'
 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: 'text'
 162   is_nullable: 1
 163
 164 =head2 B_city
 165
 166   accessor: 'b_city'
 167   data_type: 'mediumtext'
 168   is_nullable: 1
 169
 170 =head2 B_state
 171
 172   accessor: 'b_state'
 173   data_type: 'text'
 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: 'text'
 187   is_nullable: 1
 188
 189 =head2 B_email
 190
 191   accessor: 'b_email'
 192   data_type: 'text'
 193   is_nullable: 1
 194
 195 =head2 B_phone
 196
 197   accessor: 'b_phone'
 198   data_type: 'mediumtext'
 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_nullable: 0
 212   size: 10
 213
 214 =head2 categorycode
 215
 216   data_type: 'varchar'
 217   default_value: (empty string)
 218   is_nullable: 0
 219   size: 10
 220
 221 =head2 dateenrolled
 222
 223   data_type: 'date'
 224   datetime_undef_if_invalid: 1
 225   is_nullable: 1
 226
 227 =head2 dateexpiry
 228
 229   data_type: 'date'
 230   datetime_undef_if_invalid: 1
 231   is_nullable: 1
 232
 233 =head2 gonenoaddress
 234
 235   data_type: 'tinyint'
 236   is_nullable: 1
 237
 238 =head2 lost
 239
 240   data_type: 'tinyint'
 241   is_nullable: 1
 242
 243 =head2 debarred
 244
 245   data_type: 'date'
 246   datetime_undef_if_invalid: 1
 247   is_nullable: 1
 248
 249 =head2 debarredcomment
 250
 251   data_type: 'varchar'
 252   is_nullable: 1
 253   size: 255
 254
 255 =head2 contactname
 256
 257   data_type: 'mediumtext'
 258   is_nullable: 1
 259
 260 =head2 contactfirstname
 261
 262   data_type: 'text'
 263   is_nullable: 1
 264
 265 =head2 contacttitle
 266
 267   data_type: 'text'
 268   is_nullable: 1
 269
 270 =head2 guarantorid
 271
 272   data_type: 'integer'
 273   is_nullable: 1
 274
 275 =head2 borrowernotes
 276
 277   data_type: 'mediumtext'
 278   is_nullable: 1
 279
 280 =head2 relationship
 281
 282   data_type: 'varchar'
 283   is_nullable: 1
 284   size: 100
 285
 286 =head2 sex
 287
 288   data_type: 'varchar'
 289   is_nullable: 1
 290   size: 1
 291
 292 =head2 password
 293
 294   data_type: 'varchar'
 295   is_nullable: 1
 296   size: 60
 297
 298 =head2 flags
 299
 300   data_type: 'integer'
 301   is_nullable: 1
 302
 303 =head2 userid
 304
 305   data_type: 'varchar'
 306   is_nullable: 1
 307   size: 75
 308
 309 =head2 opacnote
 310
 311   data_type: 'mediumtext'
 312   is_nullable: 1
 313
 314 =head2 contactnote
 315
 316   data_type: 'varchar'
 317   is_nullable: 1
 318   size: 255
 319
 320 =head2 sort1
 321
 322   data_type: 'varchar'
 323   is_nullable: 1
 324   size: 80
 325
 326 =head2 sort2
 327
 328   data_type: 'varchar'
 329   is_nullable: 1
 330   size: 80
 331
 332 =head2 altcontactfirstname
 333
 334   data_type: 'varchar'
 335   is_nullable: 1
 336   size: 255
 337
 338 =head2 altcontactsurname
 339
 340   data_type: 'varchar'
 341   is_nullable: 1
 342   size: 255
 343
 344 =head2 altcontactaddress1
 345
 346   data_type: 'varchar'
 347   is_nullable: 1
 348   size: 255
 349
 350 =head2 altcontactaddress2
 351
 352   data_type: 'varchar'
 353   is_nullable: 1
 354   size: 255
 355
 356 =head2 altcontactaddress3
 357
 358   data_type: 'varchar'
 359   is_nullable: 1
 360   size: 255
 361
 362 =head2 altcontactstate
 363
 364   data_type: 'text'
 365   is_nullable: 1
 366
 367 =head2 altcontactzipcode
 368
 369   data_type: 'varchar'
 370   is_nullable: 1
 371   size: 50
 372
 373 =head2 altcontactcountry
 374
 375   data_type: 'text'
 376   is_nullable: 1
 377
 378 =head2 altcontactphone
 379
 380   data_type: 'varchar'
 381   is_nullable: 1
 382   size: 50
 383
 384 =head2 smsalertnumber
 385
 386   data_type: 'varchar'
 387   is_nullable: 1
 388   size: 50
 389
 390 =head2 sms_provider_id
 391
 392   data_type: 'integer'
 393   is_nullable: 1
 394
 395 =head2 privacy
 396
 397   data_type: 'integer'
 398   default_value: 1
 399   is_nullable: 0
 400
 401 =head2 privacy_guarantor_checkouts
 402
 403   data_type: 'tinyint'
 404   default_value: 0
 405   is_nullable: 0
 406
 407 =head2 checkprevcheckout
 408
 409   data_type: 'varchar'
 410   default_value: 'inherit'
 411   is_nullable: 0
 412   size: 7
 413
 414 =head2 updated_on
 415
 416   data_type: 'timestamp'
 417   datetime_undef_if_invalid: 1
 418   default_value: current_timestamp
 419   is_nullable: 0
 420
 421 =head2 lastseen
 422
 423   data_type: 'datetime'
 424   datetime_undef_if_invalid: 1
 425   is_nullable: 1
 426
 427 =head2 lang
 428
 429   data_type: 'varchar'
 430   default_value: 'default'
 431   is_nullable: 0
 432   size: 25
 433
 434 =head2 login_attempts
 435
 436   data_type: 'integer'
 437   default_value: 0
 438   is_nullable: 1
 439
 440 =head2 overdrive_auth_token
 441
 442   data_type: 'text'
 443   is_nullable: 1
 444
 445 =cut
 446
 447 __PACKAGE__->add_columns(
 448   "borrowernumber",
 449   { data_type => "integer", default_value => 0, is_nullable => 0 },
 450   "cardnumber",
 451   { data_type => "varchar", is_nullable => 1, size => 16 },
 452   "surname",
 453   { data_type => "mediumtext", is_nullable => 0 },
 454   "firstname",
 455   { data_type => "text", is_nullable => 1 },
 456   "title",
 457   { data_type => "mediumtext", is_nullable => 1 },
 458   "othernames",
 459   { data_type => "mediumtext", is_nullable => 1 },
 460   "initials",
 461   { data_type => "text", is_nullable => 1 },
 462   "streetnumber",
 463   { data_type => "varchar", is_nullable => 1, size => 10 },
 464   "streettype",
 465   { data_type => "varchar", is_nullable => 1, size => 50 },
 466   "address",
 467   { data_type => "mediumtext", is_nullable => 0 },
 468   "address2",
 469   { data_type => "text", is_nullable => 1 },
 470   "city",
 471   { data_type => "mediumtext", is_nullable => 0 },
 472   "state",
 473   { data_type => "text", is_nullable => 1 },
 474   "zipcode",
 475   { data_type => "varchar", is_nullable => 1, size => 25 },
 476   "country",
 477   { data_type => "text", is_nullable => 1 },
 478   "email",
 479   { data_type => "mediumtext", is_nullable => 1 },
 480   "phone",
 481   { data_type => "text", is_nullable => 1 },
 482   "mobile",
 483   { data_type => "varchar", is_nullable => 1, size => 50 },
 484   "fax",
 485   { data_type => "mediumtext", is_nullable => 1 },
 486   "emailpro",
 487   { data_type => "text", is_nullable => 1 },
 488   "phonepro",
 489   { data_type => "text", is_nullable => 1 },
 490   "B_streetnumber",
 491   {
 492     accessor => "b_streetnumber",
 493     data_type => "varchar",
 494     is_nullable => 1,
 495     size => 10,
 496   },
 497   "B_streettype",
 498   {
 499     accessor => "b_streettype",
 500     data_type => "varchar",
 501     is_nullable => 1,
 502     size => 50,
 503   },
 504   "B_address",
 505   {
 506     accessor => "b_address",
 507     data_type => "varchar",
 508     is_nullable => 1,
 509     size => 100,
 510   },
 511   "B_address2",
 512   { accessor => "b_address2", data_type => "text", is_nullable => 1 },
 513   "B_city",
 514   { accessor => "b_city", data_type => "mediumtext", is_nullable => 1 },
 515   "B_state",
 516   { accessor => "b_state", data_type => "text", is_nullable => 1 },
 517   "B_zipcode",
 518   {
 519     accessor => "b_zipcode",
 520     data_type => "varchar",
 521     is_nullable => 1,
 522     size => 25,
 523   },
 524   "B_country",
 525   { accessor => "b_country", data_type => "text", is_nullable => 1 },
 526   "B_email",
 527   { accessor => "b_email", data_type => "text", is_nullable => 1 },
 528   "B_phone",
 529   { accessor => "b_phone", data_type => "mediumtext", is_nullable => 1 },
 530   "dateofbirth",
 531   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 532   "branchcode",
 533   { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
 534   "categorycode",
 535   { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
 536   "dateenrolled",
 537   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 538   "dateexpiry",
 539   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 540   "gonenoaddress",
 541   { data_type => "tinyint", is_nullable => 1 },
 542   "lost",
 543   { data_type => "tinyint", is_nullable => 1 },
 544   "debarred",
 545   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 546   "debarredcomment",
 547   { data_type => "varchar", is_nullable => 1, size => 255 },
 548   "contactname",
 549   { data_type => "mediumtext", is_nullable => 1 },
 550   "contactfirstname",
 551   { data_type => "text", is_nullable => 1 },
 552   "contacttitle",
 553   { data_type => "text", is_nullable => 1 },
 554   "guarantorid",
 555   { data_type => "integer", is_nullable => 1 },
 556   "borrowernotes",
 557   { data_type => "mediumtext", is_nullable => 1 },
 558   "relationship",
 559   { data_type => "varchar", is_nullable => 1, size => 100 },
 560   "sex",
 561   { data_type => "varchar", is_nullable => 1, size => 1 },
 562   "password",
 563   { data_type => "varchar", is_nullable => 1, size => 60 },
 564   "flags",
 565   { data_type => "integer", is_nullable => 1 },
 566   "userid",
 567   { data_type => "varchar", is_nullable => 1, size => 75 },
 568   "opacnote",
 569   { data_type => "mediumtext", is_nullable => 1 },
 570   "contactnote",
 571   { data_type => "varchar", is_nullable => 1, size => 255 },
 572   "sort1",
 573   { data_type => "varchar", is_nullable => 1, size => 80 },
 574   "sort2",
 575   { data_type => "varchar", is_nullable => 1, size => 80 },
 576   "altcontactfirstname",
 577   { data_type => "varchar", is_nullable => 1, size => 255 },
 578   "altcontactsurname",
 579   { data_type => "varchar", is_nullable => 1, size => 255 },
 580   "altcontactaddress1",
 581   { data_type => "varchar", is_nullable => 1, size => 255 },
 582   "altcontactaddress2",
 583   { data_type => "varchar", is_nullable => 1, size => 255 },
 584   "altcontactaddress3",
 585   { data_type => "varchar", is_nullable => 1, size => 255 },
 586   "altcontactstate",
 587   { data_type => "text", is_nullable => 1 },
 588   "altcontactzipcode",
 589   { data_type => "varchar", is_nullable => 1, size => 50 },
 590   "altcontactcountry",
 591   { data_type => "text", is_nullable => 1 },
 592   "altcontactphone",
 593   { data_type => "varchar", is_nullable => 1, size => 50 },
 594   "smsalertnumber",
 595   { data_type => "varchar", is_nullable => 1, size => 50 },
 596   "sms_provider_id",
 597   { data_type => "integer", is_nullable => 1 },
 598   "privacy",
 599   { data_type => "integer", default_value => 1, is_nullable => 0 },
 600   "privacy_guarantor_checkouts",
 601   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 602   "checkprevcheckout",
 603   {
 604     data_type => "varchar",
 605     default_value => "inherit",
 606     is_nullable => 0,
 607     size => 7,
 608   },
 609   "updated_on",
 610   {
 611     data_type => "timestamp",
 612     datetime_undef_if_invalid => 1,
 613     default_value => \"current_timestamp",
 614     is_nullable => 0,
 615   },
 616   "lastseen",
 617   {
 618     data_type => "datetime",
 619     datetime_undef_if_invalid => 1,
 620     is_nullable => 1,
 621   },
 622   "lang",
 623   {
 624     data_type => "varchar",
 625     default_value => "default",
 626     is_nullable => 0,
 627     size => 25,
 628   },
 629   "login_attempts",
 630   { data_type => "integer", default_value => 0, is_nullable => 1 },
 631   "overdrive_auth_token",
 632   { data_type => "text", is_nullable => 1 },
 633 );
 634
 635
 636 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2017-05-09 21:24:03
 637 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SpP0xoSTFIweqTp1muUwvg
 638
 639
 640 # You can replace this text with custom code or comments, and it will be preserved on regeneration
 641 1;