-- CreateTable CREATE TABLE "QualificationQuestion" ( "id" TEXT NOT NULL, "ideaId" TEXT NOT NULL, "workspaceId" TEXT NOT NULL, "questionText" TEXT NOT NULL, "responseToken" TEXT NOT NULL, "askedAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "QualificationQuestion_pkey" PRIMARY KEY ("id") ); -- CreateIndex CREATE UNIQUE INDEX "QualificationQuestion_responseToken_key" ON "QualificationQuestion"("responseToken"); -- CreateIndex CREATE INDEX "QualificationQuestion_ideaId_idx" ON "QualificationQuestion"("ideaId"); -- CreateIndex CREATE INDEX "QualificationQuestion_workspaceId_idx" ON "QualificationQuestion"("workspaceId"); -- AddForeignKey ALTER TABLE "QualificationQuestion" ADD CONSTRAINT "QualificationQuestion_ideaId_fkey" FOREIGN KEY ("ideaId") REFERENCES "Idea"("id") ON DELETE CASCADE ON UPDATE CASCADE;