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
52 datetime_undef_if_invalid: 1
63 datetime_undef_if_invalid: 1
74 datetime_undef_if_invalid: 1
81 default_value: (empty string)
87 data_type: 'mediumtext'
104 data_type: 'smallint'
115 data_type: 'timestamp'
116 datetime_undef_if_invalid: 1
117 default_value: current_timestamp
126 =head2 publicationyear
128 data_type: 'smallint'
144 =head2 mailoverseeing
146 data_type: 'smallint'
177 =head2 collectiontitle
190 data_type: 'smallint'
213 __PACKAGE__->add_columns(
215 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
217 { data_type => "integer", default_value => 0, is_nullable => 0 },
219 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
221 { data_type => "integer", is_nullable => 1 },
223 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
225 { data_type => "integer", is_nullable => 1 },
227 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
229 { data_type => "integer", is_nullable => 1 },
231 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
234 accessor => "status",
235 data_type => "varchar",
241 { data_type => "mediumtext", is_nullable => 1 },
243 { data_type => "varchar", is_nullable => 1, size => 80 },
245 { data_type => "varchar", is_nullable => 1, size => 255 },
247 { data_type => "smallint", is_nullable => 1 },
249 { data_type => "varchar", is_nullable => 1, size => 255 },
252 data_type => "timestamp",
253 datetime_undef_if_invalid => 1,
254 default_value => \"current_timestamp",
258 { data_type => "varchar", is_nullable => 1, size => 255 },
260 { data_type => "smallint", default_value => 0, is_nullable => 1 },
262 { data_type => "varchar", is_nullable => 1, size => 255 },
264 { data_type => "varchar", is_nullable => 1, size => 30 },
266 { data_type => "smallint", default_value => 0, is_nullable => 1 },
268 { data_type => "integer", is_nullable => 1 },
270 { data_type => "text", is_nullable => 1 },
272 { data_type => "text", is_nullable => 1 },
274 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
276 { data_type => "varchar", is_nullable => 1, size => 10 },
278 { data_type => "text", is_nullable => 1 },
280 { data_type => "varchar", is_nullable => 1, size => 30 },
282 { data_type => "smallint", is_nullable => 1 },
284 { data_type => "varchar", is_nullable => 1, size => 3 },
286 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
288 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
295 =item * L</suggestionid>
301 __PACKAGE__->set_primary_key("suggestionid");
309 Related object: L<Koha::Schema::Result::Aqbudget>
313 __PACKAGE__->belongs_to(
315 "Koha::Schema::Result::Aqbudget",
316 { budget_id => "budgetid" },
320 on_delete => "SET NULL",
321 on_update => "CASCADE",
326 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-02-09 15:51:54
327 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:k7YUEiU7g+VxpMsEuOiizg
330 # You can replace this text with custom content, and it will be preserved on regeneration