| 1234567891011121314151617181920212223 |
- -- 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;
|