2 package Koha::Schema::Result::Recall;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Recall
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<recalls>
22 __PACKAGE__->table("recalls");
42 datetime_undef_if_invalid: 1
59 =head2 cancellationdate
62 datetime_undef_if_invalid: 1
67 data_type: 'mediumtext'
78 default_value: 'requested'
79 extra: {list => ["requested","overdue","waiting","in_transit","cancelled","expired","fulfilled"]}
86 data_type: 'timestamp'
87 datetime_undef_if_invalid: 1
88 default_value: current_timestamp
100 datetime_undef_if_invalid: 1
103 =head2 expirationdate
105 data_type: 'datetime'
106 datetime_undef_if_invalid: 1
115 =head2 item_level_recall
123 __PACKAGE__->add_columns(
125 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
128 data_type => "integer",
135 data_type => "datetime",
136 datetime_undef_if_invalid => 1,
141 data_type => "integer",
147 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
150 data_type => "datetime",
151 datetime_undef_if_invalid => 1,
155 { data_type => "mediumtext", is_nullable => 1 },
157 { data_type => "smallint", is_nullable => 1 },
161 default_value => "requested",
177 data_type => "timestamp",
178 datetime_undef_if_invalid => 1,
179 default_value => \"current_timestamp",
183 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
186 data_type => "datetime",
187 datetime_undef_if_invalid => 1,
192 data_type => "datetime",
193 datetime_undef_if_invalid => 1,
197 { data_type => "tinyint", default_value => 0, is_nullable => 1 },
199 { data_type => "tinyint", default_value => 0, is_nullable => 0 },
206 =item * L</recall_id>
212 __PACKAGE__->set_primary_key("recall_id");
220 Related object: L<Koha::Schema::Result::Biblio>
224 __PACKAGE__->belongs_to(
226 "Koha::Schema::Result::Biblio",
227 { biblionumber => "biblionumber" },
228 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
231 =head2 borrowernumber
235 Related object: L<Koha::Schema::Result::Borrower>
239 __PACKAGE__->belongs_to(
241 "Koha::Schema::Result::Borrower",
242 { borrowernumber => "borrowernumber" },
243 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
250 Related object: L<Koha::Schema::Result::Branch>
254 __PACKAGE__->belongs_to(
256 "Koha::Schema::Result::Branch",
257 { branchcode => "branchcode" },
261 on_delete => "CASCADE",
262 on_update => "CASCADE",
270 Related object: L<Koha::Schema::Result::Item>
274 __PACKAGE__->belongs_to(
276 "Koha::Schema::Result::Item",
277 { itemnumber => "itemnumber" },
281 on_delete => "CASCADE",
282 on_update => "CASCADE",
287 # Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-15 06:51:43
288 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nG6sAMWzjgfD+r6aUsITzA
290 __PACKAGE__->add_columns(
291 '+old' => { is_boolean => 1 },
292 '+item_level_recall' => { is_boolean => 1 },
295 __PACKAGE__->belongs_to(
297 "Koha::Schema::Result::Biblio",
298 { biblionumber => "biblionumber" },
299 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
302 __PACKAGE__->belongs_to(
304 "Koha::Schema::Result::Item",
305 { itemnumber => "itemnumber" },
309 on_delete => "CASCADE",
310 on_update => "CASCADE",
314 __PACKAGE__->belongs_to(
316 "Koha::Schema::Result::Borrower",
317 { borrowernumber => "borrowernumber" },
318 { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" },
321 __PACKAGE__->belongs_to(
323 "Koha::Schema::Result::Branch",
324 { branchcode => "branchcode" },
328 on_delete => "CASCADE",
329 on_update => "CASCADE",