---

-- Order → Client
ALTER TABLE [Order]
ADD CONSTRAINT FK_Order_Client
FOREIGN KEY (id_client)
REFERENCES Client(id_client);


-- OrderPosition → Order
ALTER TABLE OrderPosition
ADD CONSTRAINT FK_OrderPosition_Order
FOREIGN KEY (id_order)
REFERENCES [Order](id_order);


-- OrderPosition → Product
ALTER TABLE OrderPosition
ADD CONSTRAINT FK_OrderPosition_Product
FOREIGN KEY (id_product)
REFERENCES Product(id_product);


-- OrderPosition → Warehouse
ALTER TABLE OrderPosition
ADD CONSTRAINT FK_OrderPosition_Warehouse
FOREIGN KEY (id_warehouse)
REFERENCES Warehouse(id_warehouse);


-- Delivery → Order
ALTER TABLE Delivery
ADD CONSTRAINT FK_Delivery_Order
FOREIGN KEY (id_order)
REFERENCES [Order](id_order);


-- Invoice → Order
ALTER TABLE Invoice
ADD CONSTRAINT FK_Invoice_Order
FOREIGN KEY (id_order)
REFERENCES [Order](id_order);


-- Payment → Invoice
ALTER TABLE Payment
ADD CONSTRAINT FK_Payment_Invoice
FOREIGN KEY (id_invoice)
REFERENCES Invoice(id_invoice);