Revision d482851e
Von Moritz Bunkus vor etwa 12 Jahren hinzugefügt
| SL/DB/MetaSetup/Order.pm | ||
|---|---|---|
|
key_columns => { employee_id => 'id' },
|
||
|
},
|
||
|
|
||
|
employee_obj => {
|
||
|
class => 'SL::DB::Employee',
|
||
|
key_columns => { employee_id => 'id' },
|
||
|
},
|
||
|
|
||
|
globalproject => {
|
||
|
class => 'SL::DB::Project',
|
||
|
key_columns => { globalproject_id => 'id' },
|
||
| sql/Pg-upgrade2/oe_delivery_orders_foreign_keys.sql | ||
|---|---|---|
|
ALTER TABLE oe ADD FOREIGN KEY (delivery_customer_id) REFERENCES customer (id);
|
||
|
ALTER TABLE oe ADD FOREIGN KEY (delivery_vendor_id) REFERENCES vendor (id);
|
||
|
ALTER TABLE oe ADD FOREIGN KEY (department_id) REFERENCES department (id);
|
||
|
ALTER TABLE oe ADD FOREIGN KEY (employee_id) REFERENCES employee (id);
|
||
|
ALTER TABLE oe ADD FOREIGN KEY (language_id) REFERENCES language (id);
|
||
|
ALTER TABLE oe ADD FOREIGN KEY (payment_id) REFERENCES payment_terms (id);
|
||
|
ALTER TABLE oe ADD FOREIGN KEY (shipto_id) REFERENCES shipto (shipto_id);
|
||
Auch abrufbar als: Unified diff
Doppelter foreign key auf oe wieder entfernt