2 package Koha::Schema::Result::Aqorder;
4 # Created by DBIx::Class::Schema::Loader
5 # DO NOT MODIFY THE FIRST PART OF THIS FILE
9 Koha::Schema::Result::Aqorder
16 use base 'DBIx::Class::Core';
18 =head1 TABLE: C<aqorders>
22 __PACKAGE__->table("aqorders");
41 datetime_undef_if_invalid: 1
70 datetime_undef_if_invalid: 1
91 =head2 quantityreceived
103 =head2 datecancellationprinted
106 datetime_undef_if_invalid: 1
111 data_type: 'mediumtext'
114 =head2 supplierreference
116 data_type: 'mediumtext'
119 =head2 purchaseordernumber
121 data_type: 'mediumtext'
132 data_type: 'timestamp'
133 datetime_undef_if_invalid: 1
134 default_value: current_timestamp
166 =head2 budgetgroup_id
174 datetime_undef_if_invalid: 1
201 =head2 uncertainprice
215 datetime_undef_if_invalid: 1
218 =head2 subscriptionid
224 =head2 parent_ordernumber
231 __PACKAGE__->add_columns(
233 { data_type => "integer", is_auto_increment => 1, is_nullable => 0 },
235 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
237 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
239 { data_type => "smallint", is_nullable => 1 },
241 { data_type => "varchar", is_nullable => 1, size => 3 },
243 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
245 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
247 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
249 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
251 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
253 { data_type => "decimal", is_nullable => 1, size => [28, 6] },
255 { data_type => "smallint", default_value => 0, is_nullable => 0 },
257 { data_type => "varchar", is_nullable => 1, size => 10 },
258 "datecancellationprinted",
259 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
261 { data_type => "mediumtext", is_nullable => 1 },
263 { data_type => "mediumtext", is_nullable => 1 },
264 "purchaseordernumber",
265 { data_type => "mediumtext", is_nullable => 1 },
267 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
270 data_type => "timestamp",
271 datetime_undef_if_invalid => 1,
272 default_value => \"current_timestamp",
276 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
278 { data_type => "decimal", is_nullable => 1, size => [13, 2] },
280 { data_type => "decimal", is_nullable => 1, size => [6, 4] },
282 { data_type => "float", is_nullable => 1, size => [6, 4] },
284 { data_type => "integer", is_nullable => 0 },
286 { data_type => "integer", is_nullable => 0 },
288 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
290 { data_type => "varchar", is_nullable => 1, size => 80 },
292 { data_type => "varchar", is_nullable => 1, size => 80 },
294 { data_type => "varchar", is_nullable => 1, size => 10 },
296 { data_type => "varchar", is_nullable => 1, size => 10 },
298 { data_type => "tinyint", is_nullable => 1 },
300 { data_type => "integer", default_value => 0, is_nullable => 1 },
302 { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 },
304 { data_type => "integer", is_foreign_key => 1, is_nullable => 1 },
305 "parent_ordernumber",
306 { data_type => "integer", is_nullable => 1 },
313 =item * L</ordernumber>
319 __PACKAGE__->set_primary_key("ordernumber");
323 =head2 aqorders_items
327 Related object: L<Koha::Schema::Result::AqordersItem>
331 __PACKAGE__->has_many(
333 "Koha::Schema::Result::AqordersItem",
334 { "foreign.ordernumber" => "self.ordernumber" },
335 { cascade_copy => 0, cascade_delete => 0 },
338 =head2 aqorders_transfers_ordernumber_from
342 Related object: L<Koha::Schema::Result::AqordersTransfer>
346 __PACKAGE__->might_have(
347 "aqorders_transfers_ordernumber_from",
348 "Koha::Schema::Result::AqordersTransfer",
349 { "foreign.ordernumber_from" => "self.ordernumber" },
350 { cascade_copy => 0, cascade_delete => 0 },
353 =head2 aqorders_transfers_ordernumber_to
357 Related object: L<Koha::Schema::Result::AqordersTransfer>
361 __PACKAGE__->might_have(
362 "aqorders_transfers_ordernumber_to",
363 "Koha::Schema::Result::AqordersTransfer",
364 { "foreign.ordernumber_to" => "self.ordernumber" },
365 { cascade_copy => 0, cascade_delete => 0 },
372 Related object: L<Koha::Schema::Result::Aqbasket>
376 __PACKAGE__->belongs_to(
378 "Koha::Schema::Result::Aqbasket",
379 { basketno => "basketno" },
383 on_delete => "CASCADE",
384 on_update => "CASCADE",
392 Related object: L<Koha::Schema::Result::Biblio>
396 __PACKAGE__->belongs_to(
398 "Koha::Schema::Result::Biblio",
399 { biblionumber => "biblionumber" },
403 on_delete => "CASCADE",
404 on_update => "CASCADE",
412 Related object: L<Koha::Schema::Result::Aqinvoice>
416 __PACKAGE__->belongs_to(
418 "Koha::Schema::Result::Aqinvoice",
419 { invoiceid => "invoiceid" },
423 on_delete => "CASCADE",
424 on_update => "CASCADE",
428 =head2 subscriptionid
432 Related object: L<Koha::Schema::Result::Subscription>
436 __PACKAGE__->belongs_to(
438 "Koha::Schema::Result::Subscription",
439 { subscriptionid => "subscriptionid" },
443 on_delete => "CASCADE",
444 on_update => "CASCADE",
449 # Created by DBIx::Class::Schema::Loader v0.07025 @ 2013-10-14 20:56:21
450 # DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:C8LjmTtbnozNV2pA0sCbtg
453 # You can replace this text with custom content, and it will be preserved on regeneration