5 lines
381 B
SQL
5 lines
381 B
SQL
-- Modify "ProcedureRoomOrder" table
|
|
ALTER TABLE "public"."ProcedureRoomOrder" DROP COLUMN "Infra_Code";
|
|
-- Modify "ProcedureRoomOrderItem" table
|
|
ALTER TABLE "public"."ProcedureRoomOrderItem" ADD CONSTRAINT "fk_ProcedureRoomOrderItem_ProcedureRoomOrder" FOREIGN KEY ("ProcedureRoomOrder_Id") REFERENCES "public"."ProcedureRoomOrder" ("Id") ON UPDATE NO ACTION ON DELETE NO ACTION;
|