ALTER TABLE "public"."transcription_template"
DROP CONSTRAINT "fk_transTemp_Modality",
ALTER COLUMN "id_modality" TYPE varchar(10) COLLATE "default",
ADD CONSTRAINT "fk_transTemp_Modality" FOREIGN KEY ("id_modality") REFERENCES "public"."modality" ("id_modality") ON DELETE RESTRICT ON UPDATE CASCADE;



ALTER TABLE "public"."room"
DROP CONSTRAINT "room_id_modality_fkey",
ADD CONSTRAINT "room_id_modality_fkey" FOREIGN KEY ("id_modality") REFERENCES "public"."modality" ("id_modality") ON DELETE RESTRICT ON UPDATE CASCADE;

