2 package Koha::Schema::Result::Suggestion;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Suggestion
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<suggestions>
22 __PACKAGE__->table("suggestions");
41 datetime_undef_if_invalid: 1
53 datetime_undef_if_invalid: 1
65 datetime_undef_if_invalid: 1
77 datetime_undef_if_invalid: 1
80 =head2 lastmodificationby
86 =head2 lastmodificationdate
89 datetime_undef_if_invalid: 1
96 default_value: (empty string)
108 data_type: 'longtext'
125 data_type: 'smallint'
136 data_type: 'timestamp'
137 datetime_undef_if_invalid: 1
138 default_value: current_timestamp
147 =head2 publicationyear
149 data_type: 'smallint'
173 data_type: 'mediumtext'
178 data_type: 'mediumtext'
194 =head2 collectiontitle
196 data_type: 'mediumtext'
207 data_type: 'smallint'
230 __PACKAGE__->add_columns(
232 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
234 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
236 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
238 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
240 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
242 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
244 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
246 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
248 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
249 "lastmodificationby",
250 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
251 "lastmodificationdate",
252 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
255 accessor => "status",
256 data_type => "varchar",
262 { data_type => "integer", default_value => 0, is_nullable => 0 },
264 { data_type => "longtext", is_nullable => 1 },
266 { data_type => "varchar", is_nullable => 1, size => 80 },
268 { data_type => "varchar", is_nullable => 1, size => 255 },
270 { data_type => "smallint", is_nullable => 1 },
272 { data_type => "varchar", is_nullable => 1, size => 255 },
275 data_type => "timestamp",
276 datetime_undef_if_invalid => 1,
277 default_value => \"current_timestamp",
281 { data_type => "varchar", is_nullable => 1, size => 255 },
283 { data_type => "smallint", default_value => 0, is_nullable => 1 },
285 { data_type => "varchar", is_nullable => 1, size => 255 },
287 { data_type => "varchar", is_nullable => 1, size => 30 },
289 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
291 { data_type => "mediumtext", is_nullable => 1 },
293 { data_type => "mediumtext", is_nullable => 1 },
295 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
297 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
299 { data_type => "mediumtext", is_nullable => 1 },
301 { data_type => "varchar", is_nullable => 1, size => 30 },
303 { data_type => "smallint", is_nullable => 1 },
305 { data_type => "varchar", is_nullable => 1, size => 10 },
307 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
309 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
316 =item * L</suggestionid>
322 __PACKAGE__->set_primary_key("suggestionid");
330 Related object: L<Koha::Schema::Result::Borrower>
334 __PACKAGE__->belongs_to(
336 "Koha::Schema::Result::Borrower",
337 { borrowernumber => "acceptedby" },
341 on_delete => "SET NULL",
342 on_update => "CASCADE",
350 Related object: L<Koha::Schema::Result::Biblio>
354 __PACKAGE__->belongs_to(
356 "Koha::Schema::Result::Biblio",
357 { biblionumber => "biblionumber" },
361 on_delete => "SET NULL",
362 on_update => "CASCADE",
370 Related object: L<Koha::Schema::Result::Branch>
374 __PACKAGE__->belongs_to(
376 "Koha::Schema::Result::Branch",
377 { branchcode => "branchcode" },
381 on_delete => "SET NULL",
382 on_update => "CASCADE",
390 Related object: L<Koha::Schema::Result::Aqbudget>
394 __PACKAGE__->belongs_to(
396 "Koha::Schema::Result::Aqbudget",
397 { budget_id => "budgetid" },
401 on_delete => "SET NULL",
402 on_update => "CASCADE",
406 =head2 lastmodificationby
410 Related object: L<Koha::Schema::Result::Borrower>
414 __PACKAGE__->belongs_to(
415 "lastmodificationby",
416 "Koha::Schema::Result::Borrower",
417 { borrowernumber => "lastmodificationby" },
421 on_delete => "SET NULL",
422 on_update => "CASCADE",
430 Related object: L<Koha::Schema::Result::Borrower>
434 __PACKAGE__->belongs_to(
436 "Koha::Schema::Result::Borrower",
437 { borrowernumber => "managedby" },
441 on_delete => "SET NULL",
442 on_update => "CASCADE",
450 Related object: L<Koha::Schema::Result::Borrower>
454 __PACKAGE__->belongs_to(
456 "Koha::Schema::Result::Borrower",
457 { borrowernumber => "rejectedby" },
461 on_delete => "SET NULL",
462 on_update => "CASCADE",
470 Related object: L<Koha::Schema::Result::Borrower>
474 __PACKAGE__->belongs_to(
476 "Koha::Schema::Result::Borrower",
477 { borrowernumber => "suggestedby" },
481 on_delete => "SET NULL",
482 on_update => "CASCADE",
487 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2020-03-27 06:55:24
488 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:shHAnURjxdagQdgu90WQuw
490 __PACKAGE__->belongs_to(
492 "Koha::Schema::Result::Borrower",
493 { "foreign.borrowernumber" => "self.suggestedby" },
497 on_delete => "SET NULL",
498 on_update => "CASCADE",
502 __PACKAGE__->add_columns(
503 '+archived' => { is_boolean => 1 },
506 sub koha_objects_class {
510 sub koha_object_class {