-- CreateTable CREATE TABLE "StatusHistory" ( "id" TEXT NOT NULL, "hospital_id" TEXT NOT NULL, "user_id" TEXT NOT NULL, "old_status" "ProgressStatus" NOT NULL, "new_status" "ProgressStatus" NOT NULL, "notes" TEXT, "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, "updatedAt" TIMESTAMP(3) NOT NULL, "deletedAt" TIMESTAMP(3), CONSTRAINT "StatusHistory_pkey" PRIMARY KEY ("id") ); -- AddForeignKey ALTER TABLE "StatusHistory" ADD CONSTRAINT "StatusHistory_hospital_id_fkey" FOREIGN KEY ("hospital_id") REFERENCES "hospitals"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "StatusHistory" ADD CONSTRAINT "StatusHistory_user_id_fkey" FOREIGN KEY ("user_id") REFERENCES "users"("id") ON DELETE RESTRICT ON UPDATE CASCADE;