-- CreateTable
CREATE TABLE "AlertEmailLog" (
    "id" TEXT NOT NULL,
    "subaccountId" TEXT NOT NULL,
    "recipient" TEXT NOT NULL,
    "status" TEXT NOT NULL,
    "error" TEXT,
    "sentAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,

    CONSTRAINT "AlertEmailLog_pkey" PRIMARY KEY ("id")
);

-- CreateIndex
CREATE INDEX "AlertEmailLog_subaccountId_idx" ON "AlertEmailLog"("subaccountId");

-- CreateIndex
CREATE INDEX "AlertEmailLog_sentAt_idx" ON "AlertEmailLog"("sentAt");
