Koha/Schema/Result/Issue.pm

   1 use utf8;
   2 package Koha::Schema::Result::Issue;
   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::Issue
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<issues>
  19
  20 =cut
  21
  22 __PACKAGE__->table("issues");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 issue_id
  27
  28   data_type: 'integer'
  29   is_auto_increment: 1
  30   is_nullable: 0
  31
  32 =head2 borrowernumber
  33
  34   data_type: 'integer'
  35   is_foreign_key: 1
  36   is_nullable: 1
  37
  38 =head2 itemnumber
  39
  40   data_type: 'integer'
  41   is_foreign_key: 1
  42   is_nullable: 1
  43
  44 =head2 date_due
  45
  46   data_type: 'datetime'
  47   datetime_undef_if_invalid: 1
  48   is_nullable: 1
  49
  50 =head2 branchcode
  51
  52   data_type: 'varchar'
  53   is_nullable: 1
  54   size: 10
  55
  56 =head2 returndate
  57
  58   data_type: 'datetime'
  59   datetime_undef_if_invalid: 1
  60   is_nullable: 1
  61
  62 =head2 lastreneweddate
  63
  64   data_type: 'datetime'
  65   datetime_undef_if_invalid: 1
  66   is_nullable: 1
  67
  68 =head2 renewals
  69
  70   data_type: 'tinyint'
  71   is_nullable: 1
  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_auto_increment => 1, 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", is_nullable => 1 },
 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 UNIQUE CONSTRAINTS
 195
 196 =head2 C<itemnumber>
 197
 198 =over 4
 199
 200 =item * L</itemnumber>
 201
 202 =back
 203
 204 =cut
 205
 206 __PACKAGE__->add_unique_constraint("itemnumber", ["itemnumber"]);
 207
 208 =head1 RELATIONS
 209
 210 =head2 borrowernumber
 211
 212 Type: belongs_to
 213
 214 Related object: L<Koha::Schema::Result::Borrower>
 215
 216 =cut
 217
 218 __PACKAGE__->belongs_to(
 219   "borrowernumber",
 220   "Koha::Schema::Result::Borrower",
 221   { borrowernumber => "borrowernumber" },
 222   {
 223     is_deferrable => 1,
 224     join_type     => "LEFT",
 225     on_delete     => "RESTRICT",
 226     on_update     => "CASCADE",
 227   },
 228 );
 229
 230 =head2 itemnumber
 231
 232 Type: belongs_to
 233
 234 Related object: L<Koha::Schema::Result::Item>
 235
 236 =cut
 237
 238 __PACKAGE__->belongs_to(
 239   "itemnumber",
 240   "Koha::Schema::Result::Item",
 241   { itemnumber => "itemnumber" },
 242   {
 243     is_deferrable => 1,
 244     join_type     => "LEFT",
 245     on_delete     => "RESTRICT",
 246     on_update     => "CASCADE",
 247   },
 248 );
 249
 250
 251 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-07-23 13:51:40
 252 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+mlcId4odhAFp3HHgV/+tg
 253
 254 __PACKAGE__->belongs_to(
 255     "borrower",
 256     "Koha::Schema::Result::Borrower",
 257     { borrowernumber => "borrowernumber" },
 258     { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
 259 );
 260
 261 __PACKAGE__->belongs_to(
 262   "item",
 263   "Koha::Schema::Result::Item",
 264   { itemnumber => "itemnumber" },
 265   {
 266     is_deferrable => 1,
 267     join_type     => "LEFT",
 268     on_delete     => "CASCADE",
 269     on_update     => "CASCADE",
 270   },
 271 );
 272
 273 __PACKAGE__->belongs_to(
 274   "branch",
 275   "Koha::Schema::Result::Branch",
 276   { branchcode => "branchcode" },
 277   {
 278     is_deferrable => 1,
 279     join_type     => "LEFT",
 280     on_delete     => "CASCADE",
 281     on_update     => "CASCADE",
 282   },
 283 );
 284
 285 1;