| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556 |
- -- Story 2.2: Formulaire de soumission contributeur (FR8, FR14)
- -- Ajoute les enums IdeaStatus, ImpactLevel, Frequency et le modèle Idea
- -- CreateEnum
- CREATE TYPE "IdeaStatus" AS ENUM ('SUBMITTED', 'IN_REVIEW', 'ON_AGENDA', 'IN_PROGRESS', 'NOT_PRIORITY');
- -- CreateEnum
- CREATE TYPE "ImpactLevel" AS ENUM ('FAIBLE', 'MODERE', 'ELEVE', 'CRITIQUE');
- -- CreateEnum
- CREATE TYPE "Frequency" AS ENUM ('QUOTIDIENNE', 'HEBDOMADAIRE', 'MENSUELLE', 'TRIMESTRIELLE', 'PONCTUELLE');
- -- CreateTable
- CREATE TABLE "Idea" (
- "id" TEXT NOT NULL,
- "workspaceId" TEXT NOT NULL,
- "contributorEmail" TEXT NOT NULL,
- "contributorId" TEXT,
- "department" TEXT NOT NULL,
- "problemDescription" TEXT NOT NULL,
- "estimatedImpact" "ImpactLevel" NOT NULL,
- "frequency" "Frequency" NOT NULL,
- "status" "IdeaStatus" NOT NULL DEFAULT 'SUBMITTED',
- "llmTitle" TEXT,
- "llmDomain" TEXT,
- "llmAiType" TEXT,
- "llmExplanation" TEXT,
- "llmScoreImpact" INTEGER,
- "llmScoreFeasibility" INTEGER,
- "llmScoreUrgency" INTEGER,
- "llmEnrichedAt" TIMESTAMP(3),
- "llmEnrichFailed" BOOLEAN NOT NULL DEFAULT false,
- "manualScoreImpact" INTEGER,
- "manualScoreFeasibility" INTEGER,
- "manualScoreUrgency" INTEGER,
- "priorityOrder" INTEGER,
- "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
- "updatedAt" TIMESTAMP(3) NOT NULL,
- CONSTRAINT "Idea_pkey" PRIMARY KEY ("id")
- );
- -- CreateIndex
- CREATE INDEX "Idea_workspaceId_createdAt_idx" ON "Idea"("workspaceId", "createdAt");
- -- CreateIndex
- CREATE INDEX "Idea_workspaceId_status_idx" ON "Idea"("workspaceId", "status");
- -- CreateIndex
- CREATE INDEX "Idea_workspaceId_contributorEmail_idx" ON "Idea"("workspaceId", "contributorEmail");
- -- AddForeignKey
- ALTER TABLE "Idea" ADD CONSTRAINT "Idea_workspaceId_fkey" FOREIGN KEY ("workspaceId") REFERENCES "Workspace"("id") ON DELETE CASCADE ON UPDATE CASCADE;
- -- AddForeignKey
- ALTER TABLE "Idea" ADD CONSTRAINT "Idea_contributorId_fkey" FOREIGN KEY ("contributorId") REFERENCES "Contributor"("id") ON DELETE SET NULL ON UPDATE CASCADE;
|