migration.sql 864 B

1234567891011121314151617181920212223
  1. -- CreateTable
  2. CREATE TABLE "QualificationQuestion" (
  3. "id" TEXT NOT NULL,
  4. "ideaId" TEXT NOT NULL,
  5. "workspaceId" TEXT NOT NULL,
  6. "questionText" TEXT NOT NULL,
  7. "responseToken" TEXT NOT NULL,
  8. "askedAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  9. CONSTRAINT "QualificationQuestion_pkey" PRIMARY KEY ("id")
  10. );
  11. -- CreateIndex
  12. CREATE UNIQUE INDEX "QualificationQuestion_responseToken_key" ON "QualificationQuestion"("responseToken");
  13. -- CreateIndex
  14. CREATE INDEX "QualificationQuestion_ideaId_idx" ON "QualificationQuestion"("ideaId");
  15. -- CreateIndex
  16. CREATE INDEX "QualificationQuestion_workspaceId_idx" ON "QualificationQuestion"("workspaceId");
  17. -- AddForeignKey
  18. ALTER TABLE "QualificationQuestion" ADD CONSTRAINT "QualificationQuestion_ideaId_fkey" FOREIGN KEY ("ideaId") REFERENCES "Idea"("id") ON DELETE CASCADE ON UPDATE CASCADE;