__PACKAGE__->meta->columns(
booked => { type => 'boolean', default => 'false' },
customer_id => { type => 'integer', not_null => 1 },
+ date => { type => 'date', not_null => 1 },
description => { type => 'text', not_null => 1 },
+ duration => { type => 'integer' },
employee_id => { type => 'integer', not_null => 1 },
end_time => { type => 'timestamp' },
id => { type => 'serial', not_null => 1 },
itime => { type => 'timestamp', default => 'now()', not_null => 1 },
mtime => { type => 'timestamp', default => 'now()', not_null => 1 },
+ order_id => { type => 'integer' },
part_id => { type => 'integer' },
payroll => { type => 'boolean', default => 'false' },
project_id => { type => 'integer' },
staff_member_id => { type => 'integer', not_null => 1 },
- start_time => { type => 'timestamp', not_null => 1 },
+ start_time => { type => 'timestamp' },
);
__PACKAGE__->meta->primary_key_columns([ 'id' ]);
key_columns => { employee_id => 'id' },
},
+ order => {
+ class => 'SL::DB::Order',
+ key_columns => { order_id => 'id' },
+ },
+
part => {
class => 'SL::DB::Part',
key_columns => { part_id => 'id' },