Koha/Schema/Result/OldIssue.pm

   1 use utf8;
   2 package Koha::Schema::Result::OldIssue;
   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::OldIssue
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<old_issues>
  19
  20 =cut
  21
  22 __PACKAGE__->table("old_issues");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 issue_id
  27
  28   data_type: 'integer'
  29   is_nullable: 0
  30
  31 =head2 borrowernumber
  32
  33   data_type: 'integer'
  34   is_foreign_key: 1
  35   is_nullable: 1
  36
  37 =head2 itemnumber
  38
  39   data_type: 'integer'
  40   is_foreign_key: 1
  41   is_nullable: 1
  42
  43 =head2 date_due
  44
  45   data_type: 'datetime'
  46   datetime_undef_if_invalid: 1
  47   is_nullable: 1
  48
  49 =head2 branchcode
  50
  51   data_type: 'varchar'
  52   is_nullable: 1
  53   size: 10
  54
  55 =head2 returndate
  56
  57   data_type: 'datetime'
  58   datetime_undef_if_invalid: 1
  59   is_nullable: 1
  60
  61 =head2 lastreneweddate
  62
  63   data_type: 'datetime'
  64   datetime_undef_if_invalid: 1
  65   is_nullable: 1
  66
  67 =head2 renewals
  68
  69   data_type: 'tinyint'
  70   is_nullable: 1
  71
  72 =head2 auto_renew
  73
  74   data_type: 'tinyint'
  75   default_value: 0
  76   is_nullable: 1
  77
  78 =head2 auto_renew_error
  79
  80   data_type: 'varchar'
  81   is_nullable: 1
  82   size: 32
  83
  84 =head2 timestamp
  85
  86   data_type: 'timestamp'
  87   datetime_undef_if_invalid: 1
  88   default_value: current_timestamp
  89   is_nullable: 0
  90
  91 =head2 issuedate
  92
  93   data_type: 'datetime'
  94   datetime_undef_if_invalid: 1
  95   is_nullable: 1
  96
  97 =head2 onsite_checkout
  98
  99   data_type: 'integer'
 100   default_value: 0
 101   is_nullable: 0
 102
 103 =head2 note
 104
 105   data_type: 'longtext'
 106   is_nullable: 1
 107
 108 =head2 notedate
 109
 110   data_type: 'datetime'
 111   datetime_undef_if_invalid: 1
 112   is_nullable: 1
 113
 114 =head2 noteseen
 115
 116   data_type: 'integer'
 117   is_nullable: 1
 118
 119 =cut
 120
 121 __PACKAGE__->add_columns(
 122   "issue_id",
 123   { data_type => "integer", is_nullable => 0 },
 124   "borrowernumber",
 125   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 126   "itemnumber",
 127   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 128   "date_due",
 129   {
 130     data_type => "datetime",
 131     datetime_undef_if_invalid => 1,
 132     is_nullable => 1,
 133   },
 134   "branchcode",
 135   { data_type => "varchar", is_nullable => 1, size => 10 },
 136   "returndate",
 137   {
 138     data_type => "datetime",
 139     datetime_undef_if_invalid => 1,
 140     is_nullable => 1,
 141   },
 142   "lastreneweddate",
 143   {
 144     data_type => "datetime",
 145     datetime_undef_if_invalid => 1,
 146     is_nullable => 1,
 147   },
 148   "renewals",
 149   { data_type => "tinyint", is_nullable => 1 },
 150   "auto_renew",
 151   { data_type => "tinyint", default_value => 0, is_nullable => 1 },
 152   "auto_renew_error",
 153   { data_type => "varchar", is_nullable => 1, size => 32 },
 154   "timestamp",
 155   {
 156     data_type => "timestamp",
 157     datetime_undef_if_invalid => 1,
 158     default_value => \"current_timestamp",
 159     is_nullable => 0,
 160   },
 161   "issuedate",
 162   {
 163     data_type => "datetime",
 164     datetime_undef_if_invalid => 1,
 165     is_nullable => 1,
 166   },
 167   "onsite_checkout",
 168   { data_type => "integer", default_value => 0, is_nullable => 0 },
 169   "note",
 170   { data_type => "longtext", is_nullable => 1 },
 171   "notedate",
 172   {
 173     data_type => "datetime",
 174     datetime_undef_if_invalid => 1,
 175     is_nullable => 1,
 176   },
 177   "noteseen",
 178   { data_type => "integer", is_nullable => 1 },
 179 );
 180
 181 =head1 PRIMARY KEY
 182
 183 =over 4
 184
 185 =item * L</issue_id>
 186
 187 =back
 188
 189 =cut
 190
 191 __PACKAGE__->set_primary_key("issue_id");
 192
 193 =head1 RELATIONS
 194
 195 =head2 borrowernumber
 196
 197 Type: belongs_to
 198
 199 Related object: L<Koha::Schema::Result::Borrower>
 200
 201 =cut
 202
 203 __PACKAGE__->belongs_to(
 204   "borrowernumber",
 205   "Koha::Schema::Result::Borrower",
 206   { borrowernumber => "borrowernumber" },
 207   {
 208     is_deferrable => 1,
 209     join_type     => "LEFT",
 210     on_delete     => "SET NULL",
 211     on_update     => "SET NULL",
 212   },
 213 );
 214
 215 =head2 itemnumber
 216
 217 Type: belongs_to
 218
 219 Related object: L<Koha::Schema::Result::Item>
 220
 221 =cut
 222
 223 __PACKAGE__->belongs_to(
 224   "itemnumber",
 225   "Koha::Schema::Result::Item",
 226   { itemnumber => "itemnumber" },
 227   {
 228     is_deferrable => 1,
 229     join_type     => "LEFT",
 230     on_delete     => "SET NULL",
 231     on_update     => "SET NULL",
 232   },
 233 );
 234
 235
 236 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-23 13:51:40
 237 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1f688Osvh/sxg2P/qffZ2g
 238
 239 __PACKAGE__->belongs_to(
 240     "borrower",
 241     "Koha::Schema::Result::Borrower",
 242     { borrowernumber => "borrowernumber" },
 243     { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
 244 );
 245
 246 __PACKAGE__->belongs_to(
 247   "item",
 248   "Koha::Schema::Result::Item",
 249   { itemnumber => "itemnumber" },
 250   {
 251     is_deferrable => 1,
 252     join_type     => "LEFT",
 253     on_delete     => "CASCADE",
 254     on_update     => "CASCADE",
 255   },
 256 );
 257
 258 sub koha_objects_class {
 259     'Koha::Old::Checkouts';
 260 }
 261
 262 1;