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   default_value: 0
  71   is_nullable: 0
  72
  73 =head2 auto_renew
  74
  75   data_type: 'tinyint'
  76   default_value: 0
  77   is_nullable: 1
  78
  79 =head2 auto_renew_error
  80
  81   data_type: 'varchar'
  82   is_nullable: 1
  83   size: 32
  84
  85 =head2 timestamp
  86
  87   data_type: 'timestamp'
  88   datetime_undef_if_invalid: 1
  89   default_value: current_timestamp
  90   is_nullable: 0
  91
  92 =head2 issuedate
  93
  94   data_type: 'datetime'
  95   datetime_undef_if_invalid: 1
  96   is_nullable: 1
  97
  98 =head2 onsite_checkout
  99
 100   data_type: 'integer'
 101   default_value: 0
 102   is_nullable: 0
 103
 104 =head2 note
 105
 106   data_type: 'longtext'
 107   is_nullable: 1
 108
 109 =head2 notedate
 110
 111   data_type: 'datetime'
 112   datetime_undef_if_invalid: 1
 113   is_nullable: 1
 114
 115 =head2 noteseen
 116
 117   data_type: 'integer'
 118   is_nullable: 1
 119
 120 =cut
 121
 122 __PACKAGE__->add_columns(
 123   "issue_id",
 124   { data_type => "integer", is_nullable => 0 },
 125   "borrowernumber",
 126   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 127   "itemnumber",
 128   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 129   "date_due",
 130   {
 131     data_type => "datetime",
 132     datetime_undef_if_invalid => 1,
 133     is_nullable => 1,
 134   },
 135   "branchcode",
 136   { data_type => "varchar", is_nullable => 1, size => 10 },
 137   "returndate",
 138   {
 139     data_type => "datetime",
 140     datetime_undef_if_invalid => 1,
 141     is_nullable => 1,
 142   },
 143   "lastreneweddate",
 144   {
 145     data_type => "datetime",
 146     datetime_undef_if_invalid => 1,
 147     is_nullable => 1,
 148   },
 149   "renewals",
 150   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 151   "auto_renew",
 152   { data_type => "tinyint", default_value => 0, is_nullable => 1 },
 153   "auto_renew_error",
 154   { data_type => "varchar", is_nullable => 1, size => 32 },
 155   "timestamp",
 156   {
 157     data_type => "timestamp",
 158     datetime_undef_if_invalid => 1,
 159     default_value => \"current_timestamp",
 160     is_nullable => 0,
 161   },
 162   "issuedate",
 163   {
 164     data_type => "datetime",
 165     datetime_undef_if_invalid => 1,
 166     is_nullable => 1,
 167   },
 168   "onsite_checkout",
 169   { data_type => "integer", default_value => 0, is_nullable => 0 },
 170   "note",
 171   { data_type => "longtext", is_nullable => 1 },
 172   "notedate",
 173   {
 174     data_type => "datetime",
 175     datetime_undef_if_invalid => 1,
 176     is_nullable => 1,
 177   },
 178   "noteseen",
 179   { data_type => "integer", is_nullable => 1 },
 180 );
 181
 182 =head1 PRIMARY KEY
 183
 184 =over 4
 185
 186 =item * L</issue_id>
 187
 188 =back
 189
 190 =cut
 191
 192 __PACKAGE__->set_primary_key("issue_id");
 193
 194 =head1 RELATIONS
 195
 196 =head2 borrowernumber
 197
 198 Type: belongs_to
 199
 200 Related object: L<Koha::Schema::Result::Borrower>
 201
 202 =cut
 203
 204 __PACKAGE__->belongs_to(
 205   "borrowernumber",
 206   "Koha::Schema::Result::Borrower",
 207   { borrowernumber => "borrowernumber" },
 208   {
 209     is_deferrable => 1,
 210     join_type     => "LEFT",
 211     on_delete     => "SET NULL",
 212     on_update     => "SET NULL",
 213   },
 214 );
 215
 216 =head2 itemnumber
 217
 218 Type: belongs_to
 219
 220 Related object: L<Koha::Schema::Result::Item>
 221
 222 =cut
 223
 224 __PACKAGE__->belongs_to(
 225   "itemnumber",
 226   "Koha::Schema::Result::Item",
 227   { itemnumber => "itemnumber" },
 228   {
 229     is_deferrable => 1,
 230     join_type     => "LEFT",
 231     on_delete     => "SET NULL",
 232     on_update     => "SET NULL",
 233   },
 234 );
 235
 236
 237 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-04-10 19:55:44
 238 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:E2N2paWcCHg916100ry+2A
 239
 240 __PACKAGE__->add_columns(
 241     '+auto_renew'      => { is_boolean => 1 },
 242     '+onsite_checkout' => { is_boolean => 1 }
 243 );
 244
 245 __PACKAGE__->belongs_to(
 246     "borrower",
 247     "Koha::Schema::Result::Borrower",
 248     { borrowernumber => "borrowernumber" },
 249     { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
 250 );
 251
 252 __PACKAGE__->belongs_to(
 253   "item",
 254   "Koha::Schema::Result::Item",
 255   { itemnumber => "itemnumber" },
 256   {
 257     is_deferrable => 1,
 258     join_type     => "LEFT",
 259     on_delete     => "CASCADE",
 260     on_update     => "CASCADE",
 261   },
 262 );
 263
 264 __PACKAGE__->belongs_to(
 265   "library",
 266   "Koha::Schema::Result::Branch",
 267   { "foreign.branchcode" => "self.branchcode" },
 268   {
 269     is_deferrable => 1,
 270     join_type     => "LEFT",
 271   },
 272 );
 273
 274 sub koha_object_class {
 275     'Koha::Old::Checkout';
 276 }
 277 sub koha_objects_class {
 278     'Koha::Old::Checkouts';
 279 }
 280
 281 1;