-- DropForeignKey ALTER TABLE "Invoice" DROP CONSTRAINT "Invoice_quotationId_fkey"; -- DropForeignKey ALTER TABLE "Payment" DROP CONSTRAINT "Payment_invoiceId_fkey"; -- AddForeignKey ALTER TABLE "Invoice" ADD CONSTRAINT "Invoice_quotationId_fkey" FOREIGN KEY ("quotationId") REFERENCES "Quotation"("id") ON DELETE CASCADE ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "Payment" ADD CONSTRAINT "Payment_invoiceId_fkey" FOREIGN KEY ("invoiceId") REFERENCES "Invoice"("id") ON DELETE CASCADE ON UPDATE CASCADE;