1 # This file has been auto-generated. Do not modify it; it will be overwritten
2 # by rose_auto_create_model.pl automatically.
3 package SL::DB::DeliveryOrderItemsStock;
7 use base qw(SL::DB::Object);
9 __PACKAGE__->meta->setup(
10 table => 'delivery_order_items_stock',
13 id => { type => 'integer', not_null => 1, sequence => 'id' },
14 delivery_order_item_id => { type => 'integer', not_null => 1 },
15 qty => { type => 'numeric', not_null => 1, precision => 5, scale => 15 },
16 unit => { type => 'varchar', length => 20, not_null => 1 },
17 warehouse_id => { type => 'integer', not_null => 1 },
18 bin_id => { type => 'integer', not_null => 1 },
19 chargenumber => { type => 'text' },
20 itime => { type => 'timestamp', default => 'now()' },
21 mtime => { type => 'timestamp' },
22 bestbefore => { type => 'date' },
25 primary_key_columns => [ 'id' ],
27 allow_inline_column_values => 1,
31 class => 'SL::DB::Bin',
32 key_columns => { bin_id => 'id' },
35 delivery_order_item => {
36 class => 'SL::DB::DeliveryOrderItem',
37 key_columns => { delivery_order_item_id => 'id' },
41 class => 'SL::DB::Warehouse',
42 key_columns => { warehouse_id => 'id' },