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 =cut
 116
 117 __PACKAGE__->add_columns(
 118   "issue_id",
 119   { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
 120   "borrowernumber",
 121   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 122   "itemnumber",
 123   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 124   "date_due",
 125   {
 126     data_type => "datetime",
 127     datetime_undef_if_invalid => 1,
 128     is_nullable => 1,
 129   },
 130   "branchcode",
 131   { data_type => "varchar", is_nullable => 1, size => 10 },
 132   "returndate",
 133   {
 134     data_type => "datetime",
 135     datetime_undef_if_invalid => 1,
 136     is_nullable => 1,
 137   },
 138   "lastreneweddate",
 139   {
 140     data_type => "datetime",
 141     datetime_undef_if_invalid => 1,
 142     is_nullable => 1,
 143   },
 144   "renewals",
 145   { data_type => "tinyint", is_nullable => 1 },
 146   "auto_renew",
 147   { data_type => "tinyint", default_value => 0, is_nullable => 1 },
 148   "auto_renew_error",
 149   { data_type => "varchar", is_nullable => 1, size => 32 },
 150   "timestamp",
 151   {
 152     data_type => "timestamp",
 153     datetime_undef_if_invalid => 1,
 154     default_value => \"current_timestamp",
 155     is_nullable => 0,
 156   },
 157   "issuedate",
 158   {
 159     data_type => "datetime",
 160     datetime_undef_if_invalid => 1,
 161     is_nullable => 1,
 162   },
 163   "onsite_checkout",
 164   { data_type => "integer", default_value => 0, is_nullable => 0 },
 165   "note",
 166   { data_type => "longtext", is_nullable => 1 },
 167   "notedate",
 168   {
 169     data_type => "datetime",
 170     datetime_undef_if_invalid => 1,
 171     is_nullable => 1,
 172   },
 173 );
 174
 175 =head1 PRIMARY KEY
 176
 177 =over 4
 178
 179 =item * L</issue_id>
 180
 181 =back
 182
 183 =cut
 184
 185 __PACKAGE__->set_primary_key("issue_id");
 186
 187 =head1 UNIQUE CONSTRAINTS
 188
 189 =head2 C<itemnumber>
 190
 191 =over 4
 192
 193 =item * L</itemnumber>
 194
 195 =back
 196
 197 =cut
 198
 199 __PACKAGE__->add_unique_constraint("itemnumber", ["itemnumber"]);
 200
 201 =head1 RELATIONS
 202
 203 =head2 borrowernumber
 204
 205 Type: belongs_to
 206
 207 Related object: L<Koha::Schema::Result::Borrower>
 208
 209 =cut
 210
 211 __PACKAGE__->belongs_to(
 212   "borrowernumber",
 213   "Koha::Schema::Result::Borrower",
 214   { borrowernumber => "borrowernumber" },
 215   {
 216     is_deferrable => 1,
 217     join_type     => "LEFT",
 218     on_delete     => "RESTRICT",
 219     on_update     => "CASCADE",
 220   },
 221 );
 222
 223 =head2 itemnumber
 224
 225 Type: belongs_to
 226
 227 Related object: L<Koha::Schema::Result::Item>
 228
 229 =cut
 230
 231 __PACKAGE__->belongs_to(
 232   "itemnumber",
 233   "Koha::Schema::Result::Item",
 234   { itemnumber => "itemnumber" },
 235   {
 236     is_deferrable => 1,
 237     join_type     => "LEFT",
 238     on_delete     => "RESTRICT",
 239     on_update     => "CASCADE",
 240   },
 241 );
 242
 243
 244 # Created by DBIx::Class::Schema::Loader v0.07042 @ 2018-02-16 17:54:53
 245 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:skFfce3y1eEx3rSdFaLmPg
 246
 247 __PACKAGE__->belongs_to(
 248     "borrower",
 249     "Koha::Schema::Result::Borrower",
 250     { borrowernumber => "borrowernumber" },
 251     { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
 252 );
 253
 254 __PACKAGE__->belongs_to(
 255   "item",
 256   "Koha::Schema::Result::Item",
 257   { itemnumber => "itemnumber" },
 258   {
 259     is_deferrable => 1,
 260     join_type     => "LEFT",
 261     on_delete     => "CASCADE",
 262     on_update     => "CASCADE",
 263   },
 264 );
 265
 266 __PACKAGE__->belongs_to(
 267   "branch",
 268   "Koha::Schema::Result::Branch",
 269   { branchcode => "branchcode" },
 270   {
 271     is_deferrable => 1,
 272     join_type     => "LEFT",
 273     on_delete     => "CASCADE",
 274     on_update     => "CASCADE",
 275   },
 276 );
 277
 278 1;