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: '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_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 date_renewed
 234
 235   data_type: 'date'
 236   datetime_undef_if_invalid: 1
 237   is_nullable: 1
 238
 239 =head2 gonenoaddress
 240
 241   data_type: 'tinyint'
 242   is_nullable: 1
 243
 244 =head2 lost
 245
 246   data_type: 'tinyint'
 247   is_nullable: 1
 248
 249 =head2 debarred
 250
 251   data_type: 'date'
 252   datetime_undef_if_invalid: 1
 253   is_nullable: 1
 254
 255 =head2 debarredcomment
 256
 257   data_type: 'varchar'
 258   is_nullable: 1
 259   size: 255
 260
 261 =head2 contactname
 262
 263   data_type: 'longtext'
 264   is_nullable: 1
 265
 266 =head2 contactfirstname
 267
 268   data_type: 'mediumtext'
 269   is_nullable: 1
 270
 271 =head2 contacttitle
 272
 273   data_type: 'mediumtext'
 274   is_nullable: 1
 275
 276 =head2 borrowernotes
 277
 278   data_type: 'longtext'
 279   is_nullable: 1
 280
 281 =head2 relationship
 282
 283   data_type: 'varchar'
 284   is_nullable: 1
 285   size: 100
 286
 287 =head2 sex
 288
 289   data_type: 'varchar'
 290   is_nullable: 1
 291   size: 1
 292
 293 =head2 password
 294
 295   data_type: 'varchar'
 296   is_nullable: 1
 297   size: 60
 298
 299 =head2 flags
 300
 301   data_type: 'integer'
 302   is_nullable: 1
 303
 304 =head2 userid
 305
 306   data_type: 'varchar'
 307   is_nullable: 1
 308   size: 75
 309
 310 =head2 opacnote
 311
 312   data_type: 'longtext'
 313   is_nullable: 1
 314
 315 =head2 contactnote
 316
 317   data_type: 'varchar'
 318   is_nullable: 1
 319   size: 255
 320
 321 =head2 sort1
 322
 323   data_type: 'varchar'
 324   is_nullable: 1
 325   size: 80
 326
 327 =head2 sort2
 328
 329   data_type: 'varchar'
 330   is_nullable: 1
 331   size: 80
 332
 333 =head2 altcontactfirstname
 334
 335   data_type: 'varchar'
 336   is_nullable: 1
 337   size: 255
 338
 339 =head2 altcontactsurname
 340
 341   data_type: 'varchar'
 342   is_nullable: 1
 343   size: 255
 344
 345 =head2 altcontactaddress1
 346
 347   data_type: 'varchar'
 348   is_nullable: 1
 349   size: 255
 350
 351 =head2 altcontactaddress2
 352
 353   data_type: 'varchar'
 354   is_nullable: 1
 355   size: 255
 356
 357 =head2 altcontactaddress3
 358
 359   data_type: 'varchar'
 360   is_nullable: 1
 361   size: 255
 362
 363 =head2 altcontactstate
 364
 365   data_type: 'mediumtext'
 366   is_nullable: 1
 367
 368 =head2 altcontactzipcode
 369
 370   data_type: 'varchar'
 371   is_nullable: 1
 372   size: 50
 373
 374 =head2 altcontactcountry
 375
 376   data_type: 'mediumtext'
 377   is_nullable: 1
 378
 379 =head2 altcontactphone
 380
 381   data_type: 'varchar'
 382   is_nullable: 1
 383   size: 50
 384
 385 =head2 smsalertnumber
 386
 387   data_type: 'varchar'
 388   is_nullable: 1
 389   size: 50
 390
 391 =head2 sms_provider_id
 392
 393   data_type: 'integer'
 394   is_nullable: 1
 395
 396 =head2 privacy
 397
 398   data_type: 'integer'
 399   default_value: 1
 400   is_nullable: 0
 401
 402 =head2 privacy_guarantor_fines
 403
 404   data_type: 'tinyint'
 405   default_value: 0
 406   is_nullable: 0
 407
 408 =head2 privacy_guarantor_checkouts
 409
 410   data_type: 'tinyint'
 411   default_value: 0
 412   is_nullable: 0
 413
 414 =head2 checkprevcheckout
 415
 416   data_type: 'varchar'
 417   default_value: 'inherit'
 418   is_nullable: 0
 419   size: 7
 420
 421 =head2 updated_on
 422
 423   data_type: 'timestamp'
 424   datetime_undef_if_invalid: 1
 425   default_value: current_timestamp
 426   is_nullable: 0
 427
 428 =head2 lastseen
 429
 430   data_type: 'datetime'
 431   datetime_undef_if_invalid: 1
 432   is_nullable: 1
 433
 434 =head2 lang
 435
 436   data_type: 'varchar'
 437   default_value: 'default'
 438   is_nullable: 0
 439   size: 25
 440
 441 =head2 login_attempts
 442
 443   data_type: 'integer'
 444   default_value: 0
 445   is_nullable: 1
 446
 447 =head2 overdrive_auth_token
 448
 449   data_type: 'mediumtext'
 450   is_nullable: 1
 451
 452 =head2 anonymized
 453
 454   data_type: 'tinyint'
 455   default_value: 0
 456   is_nullable: 0
 457
 458 =cut
 459
 460 __PACKAGE__->add_columns(
 461   "borrowernumber",
 462   { data_type => "integer", default_value => 0, is_nullable => 0 },
 463   "cardnumber",
 464   { data_type => "varchar", is_nullable => 1, size => 32 },
 465   "surname",
 466   { data_type => "longtext", is_nullable => 1 },
 467   "firstname",
 468   { data_type => "mediumtext", is_nullable => 1 },
 469   "title",
 470   { data_type => "longtext", is_nullable => 1 },
 471   "othernames",
 472   { data_type => "longtext", is_nullable => 1 },
 473   "initials",
 474   { data_type => "mediumtext", is_nullable => 1 },
 475   "streetnumber",
 476   { data_type => "varchar", is_nullable => 1, size => 10 },
 477   "streettype",
 478   { data_type => "varchar", is_nullable => 1, size => 50 },
 479   "address",
 480   { data_type => "longtext", is_nullable => 1 },
 481   "address2",
 482   { data_type => "mediumtext", is_nullable => 1 },
 483   "city",
 484   { data_type => "longtext", is_nullable => 1 },
 485   "state",
 486   { data_type => "mediumtext", is_nullable => 1 },
 487   "zipcode",
 488   { data_type => "varchar", is_nullable => 1, size => 25 },
 489   "country",
 490   { data_type => "mediumtext", is_nullable => 1 },
 491   "email",
 492   { data_type => "longtext", is_nullable => 1 },
 493   "phone",
 494   { data_type => "mediumtext", is_nullable => 1 },
 495   "mobile",
 496   { data_type => "varchar", is_nullable => 1, size => 50 },
 497   "fax",
 498   { data_type => "longtext", is_nullable => 1 },
 499   "emailpro",
 500   { data_type => "mediumtext", is_nullable => 1 },
 501   "phonepro",
 502   { data_type => "mediumtext", is_nullable => 1 },
 503   "B_streetnumber",
 504   {
 505     accessor => "b_streetnumber",
 506     data_type => "varchar",
 507     is_nullable => 1,
 508     size => 10,
 509   },
 510   "B_streettype",
 511   {
 512     accessor => "b_streettype",
 513     data_type => "varchar",
 514     is_nullable => 1,
 515     size => 50,
 516   },
 517   "B_address",
 518   {
 519     accessor => "b_address",
 520     data_type => "varchar",
 521     is_nullable => 1,
 522     size => 100,
 523   },
 524   "B_address2",
 525   { accessor => "b_address2", data_type => "mediumtext", is_nullable => 1 },
 526   "B_city",
 527   { accessor => "b_city", data_type => "longtext", is_nullable => 1 },
 528   "B_state",
 529   { accessor => "b_state", data_type => "mediumtext", is_nullable => 1 },
 530   "B_zipcode",
 531   {
 532     accessor => "b_zipcode",
 533     data_type => "varchar",
 534     is_nullable => 1,
 535     size => 25,
 536   },
 537   "B_country",
 538   { accessor => "b_country", data_type => "mediumtext", is_nullable => 1 },
 539   "B_email",
 540   { accessor => "b_email", data_type => "mediumtext", is_nullable => 1 },
 541   "B_phone",
 542   { accessor => "b_phone", data_type => "longtext", is_nullable => 1 },
 543   "dateofbirth",
 544   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 545   "branchcode",
 546   { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
 547   "categorycode",
 548   { data_type => "varchar", default_value => "", is_nullable => 0, size => 10 },
 549   "dateenrolled",
 550   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 551   "dateexpiry",
 552   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 553   "date_renewed",
 554   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 555   "gonenoaddress",
 556   { data_type => "tinyint", is_nullable => 1 },
 557   "lost",
 558   { data_type => "tinyint", is_nullable => 1 },
 559   "debarred",
 560   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 561   "debarredcomment",
 562   { data_type => "varchar", is_nullable => 1, size => 255 },
 563   "contactname",
 564   { data_type => "longtext", is_nullable => 1 },
 565   "contactfirstname",
 566   { data_type => "mediumtext", is_nullable => 1 },
 567   "contacttitle",
 568   { data_type => "mediumtext", is_nullable => 1 },
 569   "borrowernotes",
 570   { data_type => "longtext", is_nullable => 1 },
 571   "relationship",
 572   { data_type => "varchar", is_nullable => 1, size => 100 },
 573   "sex",
 574   { data_type => "varchar", is_nullable => 1, size => 1 },
 575   "password",
 576   { data_type => "varchar", is_nullable => 1, size => 60 },
 577   "flags",
 578   { data_type => "integer", is_nullable => 1 },
 579   "userid",
 580   { data_type => "varchar", is_nullable => 1, size => 75 },
 581   "opacnote",
 582   { data_type => "longtext", is_nullable => 1 },
 583   "contactnote",
 584   { data_type => "varchar", is_nullable => 1, size => 255 },
 585   "sort1",
 586   { data_type => "varchar", is_nullable => 1, size => 80 },
 587   "sort2",
 588   { data_type => "varchar", is_nullable => 1, size => 80 },
 589   "altcontactfirstname",
 590   { data_type => "varchar", is_nullable => 1, size => 255 },
 591   "altcontactsurname",
 592   { data_type => "varchar", is_nullable => 1, size => 255 },
 593   "altcontactaddress1",
 594   { data_type => "varchar", is_nullable => 1, size => 255 },
 595   "altcontactaddress2",
 596   { data_type => "varchar", is_nullable => 1, size => 255 },
 597   "altcontactaddress3",
 598   { data_type => "varchar", is_nullable => 1, size => 255 },
 599   "altcontactstate",
 600   { data_type => "mediumtext", is_nullable => 1 },
 601   "altcontactzipcode",
 602   { data_type => "varchar", is_nullable => 1, size => 50 },
 603   "altcontactcountry",
 604   { data_type => "mediumtext", is_nullable => 1 },
 605   "altcontactphone",
 606   { data_type => "varchar", is_nullable => 1, size => 50 },
 607   "smsalertnumber",
 608   { data_type => "varchar", is_nullable => 1, size => 50 },
 609   "sms_provider_id",
 610   { data_type => "integer", is_nullable => 1 },
 611   "privacy",
 612   { data_type => "integer", default_value => 1, is_nullable => 0 },
 613   "privacy_guarantor_fines",
 614   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 615   "privacy_guarantor_checkouts",
 616   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 617   "checkprevcheckout",
 618   {
 619     data_type => "varchar",
 620     default_value => "inherit",
 621     is_nullable => 0,
 622     size => 7,
 623   },
 624   "updated_on",
 625   {
 626     data_type => "timestamp",
 627     datetime_undef_if_invalid => 1,
 628     default_value => \"current_timestamp",
 629     is_nullable => 0,
 630   },
 631   "lastseen",
 632   {
 633     data_type => "datetime",
 634     datetime_undef_if_invalid => 1,
 635     is_nullable => 1,
 636   },
 637   "lang",
 638   {
 639     data_type => "varchar",
 640     default_value => "default",
 641     is_nullable => 0,
 642     size => 25,
 643   },
 644   "login_attempts",
 645   { data_type => "integer", default_value => 0, is_nullable => 1 },
 646   "overdrive_auth_token",
 647   { data_type => "mediumtext", is_nullable => 1 },
 648   "anonymized",
 649   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 650 );
 651
 652
 653 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-05-22 04:33:29
 654 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zK1jC6Wawwj8B2ch9KFByw
 655
 656
 657 # You can replace this text with custom code or comments, and it will be preserved on regeneration
 658 1;