1 -- @tag: unit_foreign_key_for_line_items
2 -- @description: Fremdschlüssel auf »unit« für Beleg-Positionstabellen
3 -- @depends: release_3_0_0 oe_do_delete_via_trigger
4 ALTER TABLE orderitems ADD FOREIGN KEY (unit) REFERENCES units (name);
5 ALTER TABLE delivery_order_items ADD FOREIGN KEY (unit) REFERENCES units (name);
6 ALTER TABLE invoice ADD FOREIGN KEY (unit) REFERENCES units (name);