Koha/Schema/Result/Deleteditem.pm

   1 use utf8;
   2 package Koha::Schema::Result::Deleteditem;
   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::Deleteditem
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<deleteditems>
  19
  20 =cut
  21
  22 __PACKAGE__->table("deleteditems");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 itemnumber
  27
  28   data_type: 'integer'
  29   default_value: 0
  30   is_nullable: 0
  31
  32 =head2 biblionumber
  33
  34   data_type: 'integer'
  35   default_value: 0
  36   is_nullable: 0
  37
  38 =head2 biblioitemnumber
  39
  40   data_type: 'integer'
  41   default_value: 0
  42   is_nullable: 0
  43
  44 =head2 barcode
  45
  46   data_type: 'varchar'
  47   is_nullable: 1
  48   size: 20
  49
  50 =head2 dateaccessioned
  51
  52   data_type: 'date'
  53   datetime_undef_if_invalid: 1
  54   is_nullable: 1
  55
  56 =head2 booksellerid
  57
  58   data_type: 'longtext'
  59   is_nullable: 1
  60
  61 =head2 homebranch
  62
  63   data_type: 'varchar'
  64   is_nullable: 1
  65   size: 10
  66
  67 =head2 price
  68
  69   data_type: 'decimal'
  70   is_nullable: 1
  71   size: [8,2]
  72
  73 =head2 replacementprice
  74
  75   data_type: 'decimal'
  76   is_nullable: 1
  77   size: [8,2]
  78
  79 =head2 replacementpricedate
  80
  81   data_type: 'date'
  82   datetime_undef_if_invalid: 1
  83   is_nullable: 1
  84
  85 =head2 datelastborrowed
  86
  87   data_type: 'date'
  88   datetime_undef_if_invalid: 1
  89   is_nullable: 1
  90
  91 =head2 datelastseen
  92
  93   data_type: 'date'
  94   datetime_undef_if_invalid: 1
  95   is_nullable: 1
  96
  97 =head2 stack
  98
  99   data_type: 'tinyint'
 100   is_nullable: 1
 101
 102 =head2 notforloan
 103
 104   data_type: 'tinyint'
 105   default_value: 0
 106   is_nullable: 0
 107
 108 =head2 damaged
 109
 110   data_type: 'tinyint'
 111   default_value: 0
 112   is_nullable: 0
 113
 114 =head2 damaged_on
 115
 116   data_type: 'datetime'
 117   datetime_undef_if_invalid: 1
 118   is_nullable: 1
 119
 120 =head2 itemlost
 121
 122   data_type: 'tinyint'
 123   default_value: 0
 124   is_nullable: 0
 125
 126 =head2 itemlost_on
 127
 128   data_type: 'datetime'
 129   datetime_undef_if_invalid: 1
 130   is_nullable: 1
 131
 132 =head2 withdrawn
 133
 134   data_type: 'tinyint'
 135   default_value: 0
 136   is_nullable: 0
 137
 138 =head2 withdrawn_on
 139
 140   data_type: 'datetime'
 141   datetime_undef_if_invalid: 1
 142   is_nullable: 1
 143
 144 =head2 itemcallnumber
 145
 146   data_type: 'varchar'
 147   is_nullable: 1
 148   size: 255
 149
 150 =head2 coded_location_qualifier
 151
 152   data_type: 'varchar'
 153   is_nullable: 1
 154   size: 10
 155
 156 =head2 issues
 157
 158   data_type: 'smallint'
 159   default_value: 0
 160   is_nullable: 1
 161
 162 =head2 renewals
 163
 164   data_type: 'smallint'
 165   is_nullable: 1
 166
 167 =head2 reserves
 168
 169   data_type: 'smallint'
 170   is_nullable: 1
 171
 172 =head2 restricted
 173
 174   data_type: 'tinyint'
 175   is_nullable: 1
 176
 177 =head2 itemnotes
 178
 179   data_type: 'longtext'
 180   is_nullable: 1
 181
 182 =head2 itemnotes_nonpublic
 183
 184   data_type: 'longtext'
 185   is_nullable: 1
 186
 187 =head2 holdingbranch
 188
 189   data_type: 'varchar'
 190   is_nullable: 1
 191   size: 10
 192
 193 =head2 timestamp
 194
 195   data_type: 'timestamp'
 196   datetime_undef_if_invalid: 1
 197   default_value: current_timestamp
 198   is_nullable: 0
 199
 200 =head2 location
 201
 202   data_type: 'varchar'
 203   is_nullable: 1
 204   size: 80
 205
 206 =head2 permanent_location
 207
 208   data_type: 'varchar'
 209   is_nullable: 1
 210   size: 80
 211
 212 =head2 onloan
 213
 214   data_type: 'date'
 215   datetime_undef_if_invalid: 1
 216   is_nullable: 1
 217
 218 =head2 cn_source
 219
 220   data_type: 'varchar'
 221   is_nullable: 1
 222   size: 10
 223
 224 =head2 cn_sort
 225
 226   data_type: 'varchar'
 227   is_nullable: 1
 228   size: 255
 229
 230 =head2 ccode
 231
 232   data_type: 'varchar'
 233   is_nullable: 1
 234   size: 80
 235
 236 =head2 materials
 237
 238   data_type: 'mediumtext'
 239   is_nullable: 1
 240
 241 =head2 uri
 242
 243   data_type: 'mediumtext'
 244   is_nullable: 1
 245
 246 =head2 itype
 247
 248   data_type: 'varchar'
 249   is_nullable: 1
 250   size: 10
 251
 252 =head2 more_subfields_xml
 253
 254   data_type: 'longtext'
 255   is_nullable: 1
 256
 257 =head2 enumchron
 258
 259   data_type: 'mediumtext'
 260   is_nullable: 1
 261
 262 =head2 copynumber
 263
 264   data_type: 'varchar'
 265   is_nullable: 1
 266   size: 32
 267
 268 =head2 stocknumber
 269
 270   data_type: 'varchar'
 271   is_nullable: 1
 272   size: 32
 273
 274 =head2 new_status
 275
 276   data_type: 'varchar'
 277   is_nullable: 1
 278   size: 32
 279
 280 =head2 exclude_from_local_holds_priority
 281
 282   data_type: 'tinyint'
 283   is_nullable: 1
 284
 285 =cut
 286
 287 __PACKAGE__->add_columns(
 288   "itemnumber",
 289   { data_type => "integer", default_value => 0, is_nullable => 0 },
 290   "biblionumber",
 291   { data_type => "integer", default_value => 0, is_nullable => 0 },
 292   "biblioitemnumber",
 293   { data_type => "integer", default_value => 0, is_nullable => 0 },
 294   "barcode",
 295   { data_type => "varchar", is_nullable => 1, size => 20 },
 296   "dateaccessioned",
 297   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 298   "booksellerid",
 299   { data_type => "longtext", is_nullable => 1 },
 300   "homebranch",
 301   { data_type => "varchar", is_nullable => 1, size => 10 },
 302   "price",
 303   { data_type => "decimal", is_nullable => 1, size => [8, 2] },
 304   "replacementprice",
 305   { data_type => "decimal", is_nullable => 1, size => [8, 2] },
 306   "replacementpricedate",
 307   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 308   "datelastborrowed",
 309   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 310   "datelastseen",
 311   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 312   "stack",
 313   { data_type => "tinyint", is_nullable => 1 },
 314   "notforloan",
 315   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 316   "damaged",
 317   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 318   "damaged_on",
 319   {
 320     data_type => "datetime",
 321     datetime_undef_if_invalid => 1,
 322     is_nullable => 1,
 323   },
 324   "itemlost",
 325   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 326   "itemlost_on",
 327   {
 328     data_type => "datetime",
 329     datetime_undef_if_invalid => 1,
 330     is_nullable => 1,
 331   },
 332   "withdrawn",
 333   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 334   "withdrawn_on",
 335   {
 336     data_type => "datetime",
 337     datetime_undef_if_invalid => 1,
 338     is_nullable => 1,
 339   },
 340   "itemcallnumber",
 341   { data_type => "varchar", is_nullable => 1, size => 255 },
 342   "coded_location_qualifier",
 343   { data_type => "varchar", is_nullable => 1, size => 10 },
 344   "issues",
 345   { data_type => "smallint", default_value => 0, is_nullable => 1 },
 346   "renewals",
 347   { data_type => "smallint", is_nullable => 1 },
 348   "reserves",
 349   { data_type => "smallint", is_nullable => 1 },
 350   "restricted",
 351   { data_type => "tinyint", is_nullable => 1 },
 352   "itemnotes",
 353   { data_type => "longtext", is_nullable => 1 },
 354   "itemnotes_nonpublic",
 355   { data_type => "longtext", is_nullable => 1 },
 356   "holdingbranch",
 357   { data_type => "varchar", is_nullable => 1, size => 10 },
 358   "timestamp",
 359   {
 360     data_type => "timestamp",
 361     datetime_undef_if_invalid => 1,
 362     default_value => \"current_timestamp",
 363     is_nullable => 0,
 364   },
 365   "location",
 366   { data_type => "varchar", is_nullable => 1, size => 80 },
 367   "permanent_location",
 368   { data_type => "varchar", is_nullable => 1, size => 80 },
 369   "onloan",
 370   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 371   "cn_source",
 372   { data_type => "varchar", is_nullable => 1, size => 10 },
 373   "cn_sort",
 374   { data_type => "varchar", is_nullable => 1, size => 255 },
 375   "ccode",
 376   { data_type => "varchar", is_nullable => 1, size => 80 },
 377   "materials",
 378   { data_type => "mediumtext", is_nullable => 1 },
 379   "uri",
 380   { data_type => "mediumtext", is_nullable => 1 },
 381   "itype",
 382   { data_type => "varchar", is_nullable => 1, size => 10 },
 383   "more_subfields_xml",
 384   { data_type => "longtext", is_nullable => 1 },
 385   "enumchron",
 386   { data_type => "mediumtext", is_nullable => 1 },
 387   "copynumber",
 388   { data_type => "varchar", is_nullable => 1, size => 32 },
 389   "stocknumber",
 390   { data_type => "varchar", is_nullable => 1, size => 32 },
 391   "new_status",
 392   { data_type => "varchar", is_nullable => 1, size => 32 },
 393   "exclude_from_local_holds_priority",
 394   { data_type => "tinyint", is_nullable => 1 },
 395 );
 396
 397 =head1 PRIMARY KEY
 398
 399 =over 4
 400
 401 =item * L</itemnumber>
 402
 403 =back
 404
 405 =cut
 406
 407 __PACKAGE__->set_primary_key("itemnumber");
 408
 409
 410 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2020-09-30 15:31:01
 411 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1l4g7uiQo9gkdrWbNxAsJg
 412
 413 __PACKAGE__->add_columns(
 414     '+exclude_from_local_holds_priority' => { is_boolean => 1 },
 415 );
 416
 417 sub koha_objects_class {
 418     'Koha::Old::Items';
 419 }
 420 sub koha_object_class {
 421     'Koha::Old::Item';
 422 }
 423
 424 1;