-- @tag: unit_foreign_key_for_line_items
-- @description: Fremdschlüssel auf »unit« für Beleg-Positionstabellen
-- @tag: unit_foreign_key_for_line_items
-- @description: Fremdschlüssel auf »unit« für Beleg-Positionstabellen
ALTER TABLE orderitems ADD FOREIGN KEY (unit) REFERENCES units (name);
ALTER TABLE delivery_order_items ADD FOREIGN KEY (unit) REFERENCES units (name);
ALTER TABLE invoice ADD FOREIGN KEY (unit) REFERENCES units (name);
ALTER TABLE orderitems ADD FOREIGN KEY (unit) REFERENCES units (name);
ALTER TABLE delivery_order_items ADD FOREIGN KEY (unit) REFERENCES units (name);
ALTER TABLE invoice ADD FOREIGN KEY (unit) REFERENCES units (name);