transaction_description => { type => 'text' },
marge_total => { type => 'numeric', precision => 5, scale => 15 },
marge_percent => { type => 'numeric', precision => 5, scale => 15 },
- notes_bottom => { type => 'text' },
- project_manager_id => { type => 'integer' },
],
primary_key_columns => [ 'id' ],
allow_inline_column_values => 1,
foreign_keys => [
+ customer => {
+ class => 'SL::DB::Customer',
+ key_columns => { customer_id => 'id' },
+ },
+
employee => {
class => 'SL::DB::Employee',
key_columns => { employee_id => 'id' },
key_columns => { globalproject_id => 'id' },
},
- project_manager => {
- class => 'SL::DB::Employee',
- key_columns => { project_manager_id => 'id' },
- },
-
salesman => {
class => 'SL::DB::Employee',
key_columns => { salesman_id => 'id' },
},
+
+ vendor => {
+ class => 'SL::DB::Vendor',
+ key_columns => { vendor_id => 'id' },
+ },
],
);