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 borrowernumber
  27
  28   data_type: 'integer'
  29   is_foreign_key: 1
  30   is_nullable: 1
  31
  32 =head2 itemnumber
  33
  34   data_type: 'integer'
  35   is_foreign_key: 1
  36   is_nullable: 1
  37
  38 =head2 date_due
  39
  40   data_type: 'datetime'
  41   datetime_undef_if_invalid: 1
  42   is_nullable: 1
  43
  44 =head2 branchcode
  45
  46   data_type: 'varchar'
  47   is_nullable: 1
  48   size: 10
  49
  50 =head2 issuingbranch
  51
  52   data_type: 'varchar'
  53   is_nullable: 1
  54   size: 18
  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 return
  69
  70   data_type: 'varchar'
  71   is_nullable: 1
  72   size: 4
  73
  74 =head2 renewals
  75
  76   data_type: 'tinyint'
  77   is_nullable: 1
  78
  79 =head2 timestamp
  80
  81   data_type: 'timestamp'
  82   datetime_undef_if_invalid: 1
  83   default_value: current_timestamp
  84   is_nullable: 0
  85
  86 =head2 issuedate
  87
  88   data_type: 'datetime'
  89   datetime_undef_if_invalid: 1
  90   is_nullable: 1
  91
  92 =cut
  93
  94 __PACKAGE__->add_columns(
  95   "borrowernumber",
  96   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  97   "itemnumber",
  98   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
  99   "date_due",
 100   {
 101     data_type => "datetime",
 102     datetime_undef_if_invalid => 1,
 103     is_nullable => 1,
 104   },
 105   "branchcode",
 106   { data_type => "varchar", is_nullable => 1, size => 10 },
 107   "issuingbranch",
 108   { data_type => "varchar", is_nullable => 1, size => 18 },
 109   "returndate",
 110   {
 111     data_type => "datetime",
 112     datetime_undef_if_invalid => 1,
 113     is_nullable => 1,
 114   },
 115   "lastreneweddate",
 116   {
 117     data_type => "datetime",
 118     datetime_undef_if_invalid => 1,
 119     is_nullable => 1,
 120   },
 121   "return",
 122   { data_type => "varchar", is_nullable => 1, size => 4 },
 123   "renewals",
 124   { data_type => "tinyint", is_nullable => 1 },
 125   "timestamp",
 126   {
 127     data_type => "timestamp",
 128     datetime_undef_if_invalid => 1,
 129     default_value => \"current_timestamp",
 130     is_nullable => 0,
 131   },
 132   "issuedate",
 133   {
 134     data_type => "datetime",
 135     datetime_undef_if_invalid => 1,
 136     is_nullable => 1,
 137   },
 138 );
 139
 140 =head1 RELATIONS
 141
 142 =head2 borrowernumber
 143
 144 Type: belongs_to
 145
 146 Related object: L<Koha::Schema::Result::Borrower>
 147
 148 =cut
 149
 150 __PACKAGE__->belongs_to(
 151   "borrowernumber",
 152   "Koha::Schema::Result::Borrower",
 153   { borrowernumber => "borrowernumber" },
 154   {
 155     is_deferrable => 1,
 156     join_type     => "LEFT",
 157     on_delete     => "RESTRICT",
 158     on_update     => "CASCADE",
 159   },
 160 );
 161
 162 =head2 itemnumber
 163
 164 Type: belongs_to
 165
 166 Related object: L<Koha::Schema::Result::Item>
 167
 168 =cut
 169
 170 __PACKAGE__->belongs_to(
 171   "itemnumber",
 172   "Koha::Schema::Result::Item",
 173   { itemnumber => "itemnumber" },
 174   {
 175     is_deferrable => 1,
 176     join_type     => "LEFT",
 177     on_delete     => "RESTRICT",
 178     on_update     => "CASCADE",
 179   },
 180 );
 181
 182
 183 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2014-07-11 09:26:55
 184 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2SJJ3az4Ml9hKEQvNH3+Kw
 185
 186 __PACKAGE__->belongs_to(
 187     "borrower",
 188     "Koha::Schema::Result::Borrower",
 189     { borrowernumber => "borrowernumber" },
 190     { join_type => "LEFT", on_delete => "CASCADE", on_update => "CASCADE" },
 191 );
 192
 193 __PACKAGE__->belongs_to(
 194   "item",
 195   "Koha::Schema::Result::Item",
 196   { itemnumber => "itemnumber" },
 197   {
 198     is_deferrable => 1,
 199     join_type     => "LEFT",
 200     on_delete     => "CASCADE",
 201     on_update     => "CASCADE",
 202   },
 203 );
 204
 205 __PACKAGE__->belongs_to(
 206   "branch",
 207   "Koha::Schema::Result::Branch",
 208   { branchcode => "branchcode" },
 209   {
 210     is_deferrable => 1,
 211     join_type     => "LEFT",
 212     on_delete     => "CASCADE",
 213     on_update     => "CASCADE",
 214   },
 215 );
 216
 217 1;