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
84 default_value: (empty string)
107 data_type: 'smallint'
118 data_type: 'timestamp'
119 datetime_undef_if_invalid: 1
120 default_value: current_timestamp
129 =head2 publicationyear
131 data_type: 'smallint'
155 data_type: 'mediumtext'
160 data_type: 'mediumtext'
176 =head2 collectiontitle
178 data_type: 'mediumtext'
189 data_type: 'smallint'
212 __PACKAGE__->add_columns(
214 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
216 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
218 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
220 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
222 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
224 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
226 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
228 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
230 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
233 accessor => "status",
234 data_type => "varchar",
240 { data_type => "longtext", is_nullable => 1 },
242 { data_type => "varchar", is_nullable => 1, size => 80 },
244 { data_type => "varchar", is_nullable => 1, size => 255 },
246 { data_type => "smallint", is_nullable => 1 },
248 { data_type => "varchar", is_nullable => 1, size => 255 },
251 data_type => "timestamp",
252 datetime_undef_if_invalid => 1,
253 default_value => \"current_timestamp",
257 { data_type => "varchar", is_nullable => 1, size => 255 },
259 { data_type => "smallint", default_value => 0, is_nullable => 1 },
261 { data_type => "varchar", is_nullable => 1, size => 255 },
263 { data_type => "varchar", is_nullable => 1, size => 30 },
265 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
267 { data_type => "mediumtext", is_nullable => 1 },
269 { data_type => "mediumtext", is_nullable => 1 },
271 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
273 { data_type => "varchar", is_foreign_key => 1, is_nullable => 1, size => 10 },
275 { data_type => "mediumtext", is_nullable => 1 },
277 { data_type => "varchar", is_nullable => 1, size => 30 },
279 { data_type => "smallint", is_nullable => 1 },
281 { data_type => "varchar", is_nullable => 1, size => 10 },
283 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
285 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
292 =item * L</suggestionid>
298 __PACKAGE__->set_primary_key("suggestionid");
306 Related object: L<Koha::Schema::Result::Borrower>
310 __PACKAGE__->belongs_to(
312 "Koha::Schema::Result::Borrower",
313 { borrowernumber => "acceptedby" },
317 on_delete => "SET NULL",
318 on_update => "CASCADE",
326 Related object: L<Koha::Schema::Result::Biblio>
330 __PACKAGE__->belongs_to(
332 "Koha::Schema::Result::Biblio",
333 { biblionumber => "biblionumber" },
337 on_delete => "SET NULL",
338 on_update => "CASCADE",
346 Related object: L<Koha::Schema::Result::Branch>
350 __PACKAGE__->belongs_to(
352 "Koha::Schema::Result::Branch",
353 { branchcode => "branchcode" },
357 on_delete => "SET NULL",
358 on_update => "CASCADE",
366 Related object: L<Koha::Schema::Result::Aqbudget>
370 __PACKAGE__->belongs_to(
372 "Koha::Schema::Result::Aqbudget",
373 { budget_id => "budgetid" },
377 on_delete => "SET NULL",
378 on_update => "CASCADE",
386 Related object: L<Koha::Schema::Result::Borrower>
390 __PACKAGE__->belongs_to(
392 "Koha::Schema::Result::Borrower",
393 { borrowernumber => "managedby" },
397 on_delete => "SET NULL",
398 on_update => "CASCADE",
406 Related object: L<Koha::Schema::Result::Borrower>
410 __PACKAGE__->belongs_to(
412 "Koha::Schema::Result::Borrower",
413 { borrowernumber => "rejectedby" },
417 on_delete => "SET NULL",
418 on_update => "CASCADE",
426 Related object: L<Koha::Schema::Result::Borrower>
430 __PACKAGE__->belongs_to(
432 "Koha::Schema::Result::Borrower",
433 { borrowernumber => "suggestedby" },
437 on_delete => "SET NULL",
438 on_update => "CASCADE",
443 # Created by DBIx::Class::Schema::Loader v0.07046 @ 2019-03-11 12:56:41
444 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UsG/gxLa0HMMbcpbscV29Q
446 sub koha_objects_class {
450 sub koha_object_class {