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'
171 =head2 collectiontitle
184 data_type: 'smallint'
207 __PACKAGE__->add_columns(
209 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
211 { data_type => "integer", default_value => 0, is_nullable => 0 },
213 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 0 },
215 { data_type => "integer", is_nullable => 1 },
217 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
219 { data_type => "integer", is_nullable => 1 },
221 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
223 { data_type => "integer", is_nullable => 1 },
225 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
228 accessor => "status",
229 data_type => "varchar",
235 { data_type => "mediumtext", is_nullable => 1 },
237 { data_type => "varchar", is_nullable => 1, size => 80 },
239 { data_type => "varchar", is_nullable => 1, size => 255 },
241 { data_type => "smallint", is_nullable => 1 },
243 { data_type => "varchar", is_nullable => 1, size => 255 },
246 data_type => "timestamp",
247 datetime_undef_if_invalid => 1,
248 default_value => \"current_timestamp",
252 { data_type => "varchar", is_nullable => 1, size => 255 },
254 { data_type => "smallint", default_value => 0, is_nullable => 1 },
256 { data_type => "varchar", is_nullable => 1, size => 255 },
258 { data_type => "varchar", is_nullable => 1, size => 30 },
260 { data_type => "integer", is_nullable => 1 },
262 { data_type => "text", is_nullable => 1 },
264 { data_type => "text", is_nullable => 1 },
266 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
268 { data_type => "varchar", is_nullable => 1, size => 10 },
270 { data_type => "text", is_nullable => 1 },
272 { data_type => "varchar", is_nullable => 1, size => 30 },
274 { data_type => "smallint", is_nullable => 1 },
276 { data_type => "varchar", is_nullable => 1, size => 3 },
278 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
280 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
287 =item * L</suggestionid>
293 __PACKAGE__->set_primary_key("suggestionid");
301 Related object: L<Koha::Schema::Result::Aqbudget>
305 __PACKAGE__->belongs_to(
307 "Koha::Schema::Result::Aqbudget",
308 { budget_id => "budgetid" },
312 on_delete => "SET NULL",
313 on_update => "CASCADE",
318 # Created by DBIx::Class::Schema::Loader v0.07039 @ 2015-04-13 11:06:30
319 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zXNCczGjuuyoojx85UcQig
322 # You can replace this text with custom content, and it will be preserved on regeneration