Koha/Schema/Result/OldReserve.pm

   1 use utf8;
   2 package Koha::Schema::Result::OldReserve;
   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::OldReserve
  10
  11 =cut
  12
  13 use strict;
  14 use warnings;
  15
  16 use base 'DBIx::Class::Core';
  17
  18 =head1 TABLE: C<old_reserves>
  19
  20 =cut
  21
  22 __PACKAGE__->table("old_reserves");
  23
  24 =head1 ACCESSORS
  25
  26 =head2 reserve_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 reservedate
  38
  39   data_type: 'date'
  40   datetime_undef_if_invalid: 1
  41   is_nullable: 1
  42
  43 =head2 biblionumber
  44
  45   data_type: 'integer'
  46   is_foreign_key: 1
  47   is_nullable: 1
  48
  49 =head2 constrainttype
  50
  51   data_type: 'varchar'
  52   is_nullable: 1
  53   size: 1
  54
  55 =head2 branchcode
  56
  57   data_type: 'varchar'
  58   is_nullable: 1
  59   size: 10
  60
  61 =head2 notificationdate
  62
  63   data_type: 'date'
  64   datetime_undef_if_invalid: 1
  65   is_nullable: 1
  66
  67 =head2 reminderdate
  68
  69   data_type: 'date'
  70   datetime_undef_if_invalid: 1
  71   is_nullable: 1
  72
  73 =head2 cancellationdate
  74
  75   data_type: 'date'
  76   datetime_undef_if_invalid: 1
  77   is_nullable: 1
  78
  79 =head2 reservenotes
  80
  81   data_type: 'mediumtext'
  82   is_nullable: 1
  83
  84 =head2 priority
  85
  86   data_type: 'smallint'
  87   is_nullable: 1
  88
  89 =head2 found
  90
  91   data_type: 'varchar'
  92   is_nullable: 1
  93   size: 1
  94
  95 =head2 timestamp
  96
  97   data_type: 'timestamp'
  98   datetime_undef_if_invalid: 1
  99   default_value: current_timestamp
 100   is_nullable: 0
 101
 102 =head2 itemnumber
 103
 104   data_type: 'integer'
 105   is_foreign_key: 1
 106   is_nullable: 1
 107
 108 =head2 waitingdate
 109
 110   data_type: 'date'
 111   datetime_undef_if_invalid: 1
 112   is_nullable: 1
 113
 114 =head2 expirationdate
 115
 116   data_type: 'date'
 117   datetime_undef_if_invalid: 1
 118   is_nullable: 1
 119
 120 =head2 lowestpriority
 121
 122   data_type: 'tinyint'
 123   is_nullable: 0
 124
 125 =head2 suspend
 126
 127   data_type: 'tinyint'
 128   default_value: 0
 129   is_nullable: 0
 130
 131 =head2 suspend_until
 132
 133   data_type: 'datetime'
 134   datetime_undef_if_invalid: 1
 135   is_nullable: 1
 136
 137 =cut
 138
 139 __PACKAGE__->add_columns(
 140   "reserve_id",
 141   { data_type => "integer", is_nullable => 0 },
 142   "borrowernumber",
 143   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 144   "reservedate",
 145   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 146   "biblionumber",
 147   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 148   "constrainttype",
 149   { data_type => "varchar", is_nullable => 1, size => 1 },
 150   "branchcode",
 151   { data_type => "varchar", is_nullable => 1, size => 10 },
 152   "notificationdate",
 153   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 154   "reminderdate",
 155   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 156   "cancellationdate",
 157   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 158   "reservenotes",
 159   { data_type => "mediumtext", is_nullable => 1 },
 160   "priority",
 161   { data_type => "smallint", is_nullable => 1 },
 162   "found",
 163   { data_type => "varchar", is_nullable => 1, size => 1 },
 164   "timestamp",
 165   {
 166     data_type => "timestamp",
 167     datetime_undef_if_invalid => 1,
 168     default_value => \"current_timestamp",
 169     is_nullable => 0,
 170   },
 171   "itemnumber",
 172   { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
 173   "waitingdate",
 174   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 175   "expirationdate",
 176   { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
 177   "lowestpriority",
 178   { data_type => "tinyint", is_nullable => 0 },
 179   "suspend",
 180   { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 181   "suspend_until",
 182   {
 183     data_type => "datetime",
 184     datetime_undef_if_invalid => 1,
 185     is_nullable => 1,
 186   },
 187 );
 188
 189 =head1 PRIMARY KEY
 190
 191 =over 4
 192
 193 =item * L</reserve_id>
 194
 195 =back
 196
 197 =cut
 198
 199 __PACKAGE__->set_primary_key("reserve_id");
 200
 201 =head1 RELATIONS
 202
 203 =head2 biblionumber
 204
 205 Type: belongs_to
 206
 207 Related object: L<Koha::Schema::Result::Biblio>
 208
 209 =cut
 210
 211 __PACKAGE__->belongs_to(
 212   "biblionumber",
 213   "Koha::Schema::Result::Biblio",
 214   { biblionumber => "biblionumber" },
 215   {
 216     is_deferrable => 1,
 217     join_type     => "LEFT",
 218     on_delete     => "CASCADE",
 219     on_update     => "CASCADE",
 220   },
 221 );
 222
 223 =head2 borrowernumber
 224
 225 Type: belongs_to
 226
 227 Related object: L<Koha::Schema::Result::Borrower>
 228
 229 =cut
 230
 231 __PACKAGE__->belongs_to(
 232   "borrowernumber",
 233   "Koha::Schema::Result::Borrower",
 234   { borrowernumber => "borrowernumber" },
 235   {
 236     is_deferrable => 1,
 237     join_type     => "LEFT",
 238     on_delete     => "CASCADE",
 239     on_update     => "CASCADE",
 240   },
 241 );
 242
 243 =head2 itemnumber
 244
 245 Type: belongs_to
 246
 247 Related object: L<Koha::Schema::Result::Item>
 248
 249 =cut
 250
 251 __PACKAGE__->belongs_to(
 252   "itemnumber",
 253   "Koha::Schema::Result::Item",
 254   { itemnumber => "itemnumber" },
 255   {
 256     is_deferrable => 1,
 257     join_type     => "LEFT",
 258     on_delete     => "CASCADE",
 259     on_update     => "CASCADE",
 260   },
 261 );
 262
 263
 264 # Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
 265 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:g/WiYGPOyzJGtMWiAHvIxA
 266
 267
 268 # You can replace this text with custom content, and it will be preserved on regeneration
 269 1;