// This is your Prisma schema file, // learn more about it in the docs: https://pris.ly/d/prisma-schema generator client { provider = "prisma-client-js" output = "../generated/prisma" } datasource db { provider = "postgresql" // NOTE: When using mysql or sqlserver, uncomment the @db.Text annotations in model Account below // Further reading: // https://next-auth.js.org/adapters/prisma#create-the-prisma-schema // https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#string url = env("DATABASE_URL") } // Workspace - 1 utilisateur = 1 workspace (MVP). Unité de tenant pour AImpact Hub (Story 1.2) // Story 1.6: tier, llmCallsThisMonth, llmCallsResetAt pour limites Free (FR4, FR5) enum WorkspaceTier { FREE PRO } model Workspace { id String @id @default(cuid()) name String slug String @unique sector String? companySize Int? contactEmail String? tier WorkspaceTier @default(FREE) llmCallsThisMonth Int @default(0) llmCallsResetAt DateTime @default(now()) autoRelanceEnabled Boolean @default(true) // Story 2.10 : désactivable par le Transformateur // Story 4.4 : export PDF (FR35) - suivi limite Free (1 export/mois) exportsThisMonth Int @default(0) exportsResetAt DateTime @default(now()) lastVisitedAt DateTime? // Story 3.7 : résumé nouvelles activités (FR28) onboardingDismissed Boolean @default(false) // Story 1.5 : checklist onboarding masquée après la première visite shareLink ShareLink? // Story 4.5 : lien partageable lecture seule (FR36) createdAt DateTime @default(now()) updatedAt DateTime @updatedAt ownerId String @unique owner User @relation(fields: [ownerId], references: [id], onDelete: Cascade) contributors Contributor[] ideas Idea[] manualRelanceLogs ManualRelanceLog[] } // Story 2.11 : Relance manuelle Transformateur (FR11, FR12, FR13) model ManualRelanceLog { id String @id @default(cuid()) workspaceId String subject String recipientCount Int sentCount Int failedCount Int @default(0) sentAt DateTime @default(now()) workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade) @@index([workspaceId]) } // Story 2.1: Invitation contributeurs (FR6, FR7) enum ContributorStatus { INVITED SUBMITTED NOT_SUBMITTED } model Contributor { id String @id @default(cuid()) workspaceId String workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade) email String /// Service / direction (optionnel), saisi à l'invitation ou éditable — ciblage des relances manuelles. service String? status ContributorStatus @default(INVITED) invitedAt DateTime @default(now()) lastRemindedAt DateTime? // Story 2.10 : date de la relance J+21 (null = jamais relancé) createdAt DateTime @default(now()) ideas Idea[] @@unique([workspaceId, email]) @@index([workspaceId]) @@index([workspaceId, service]) } // Story 2.2: Formulaire de soumission contributeur (FR8, FR14) enum IdeaStatus { SUBMITTED // Envoyé (statut initial) IN_REVIEW // En traitement ON_AGENDA // Mis à l'ordre du jour IN_PROGRESS // En cours NOT_PRIORITY // Non prioritaire (filtrable, non supprimé - FR26) } enum ImpactLevel { FAIBLE MODERE ELEVE CRITIQUE } enum Frequency { QUOTIDIENNE HEBDOMADAIRE MENSUELLE TRIMESTRIELLE PONCTUELLE } model Idea { id String @id @default(cuid()) workspaceId String workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade) // Données contributeur contributorEmail String contributorId String? contributor Contributor? @relation(fields: [contributorId], references: [id], onDelete: SetNull) // Champs formulaire FR14 department String problemDescription String @db.Text estimatedImpact ImpactLevel frequency Frequency /// Réponses optionnelles à la soumission (langage métier) — aident le transformateur à trancher optionalWhoAffected String? @db.Text optionalAlreadyTried String? @db.Text optionalSuccessLooksLike String? @db.Text // Statut status IdeaStatus @default(SUBMITTED) // Enrichissement LLM - rempli par Story 3.1 (api/llm/enrich) llmTitle String? llmDomain String? llmAiType String? llmExplanation String? @db.Text llmScoreImpact Int? // 1-5 (NFR18) llmScoreFeasibility Int? // 1-5 llmScoreUrgency Int? // 1-5 llmEnrichedAt DateTime? llmEnrichFailed Boolean @default(false) // FR21 : fallback "À qualifier manuellement" // Scores manuels - Story 3.4 (FR20) manualScoreImpact Int? manualScoreFeasibility Int? manualScoreUrgency Int? // Ordre priorisation - Story 4.3 (FR33) priorityOrder Int? // Story 2.5 : idempotence webhook Resend Inbound (éviter doublons sur replay) emailMessageId String? @unique // Story 2.6 : pièces jointes (FR17) attachments IdeaAttachment[] // Story 4.1 : questions de qualification (FR29, FR30) qualificationQuestions QualificationQuestion[] createdAt DateTime @default(now()) updatedAt DateTime @updatedAt @@index([workspaceId, createdAt]) @@index([workspaceId, status]) @@index([workspaceId, contributorEmail]) @@index([workspaceId, priorityOrder]) // Story 4.3 : tri par priorité (FR33, FR34) } model Post { id Int @id @default(autoincrement()) name String createdAt DateTime @default(now()) updatedAt DateTime @updatedAt createdBy User @relation(fields: [createdById], references: [id]) createdById String @@index([name]) } // Necessary for Next auth model Account { id String @id @default(cuid()) userId String type String provider String providerAccountId String refresh_token String? // @db.Text access_token String? // @db.Text expires_at Int? token_type String? scope String? id_token String? // @db.Text session_state String? user User @relation(fields: [userId], references: [id], onDelete: Cascade) refresh_token_expires_in Int? @@unique([provider, providerAccountId]) } model Session { id String @id @default(cuid()) sessionToken String @unique userId String expires DateTime user User @relation(fields: [userId], references: [id], onDelete: Cascade) } model User { id String @id @default(cuid()) name String? email String? @unique emailVerified DateTime? password String? // hash bcrypt - auth Credentials (Story 1.2b) image String? accounts Account[] sessions Session[] posts Post[] workspace Workspace? } model VerificationToken { identifier String token String @unique expires DateTime @@unique([identifier, token]) } // Story 2.6 : Pièces jointes à la soumission (FR17) model IdeaAttachment { id String @id @default(cuid()) ideaId String idea Idea @relation(fields: [ideaId], references: [id], onDelete: Cascade) workspaceId String // dénormalisé pour isolation multi-tenant filename String // nom original sanitisé contentType String // MIME type size Int // taille en bytes url String // URL Vercel Blob blobPath String // path convention : {workspaceId}/attachments/{ideaId}/{filename} createdAt DateTime @default(now()) @@index([ideaId]) @@index([workspaceId]) } // Story 4.1 : Questions de qualification (FR29, FR30) // Story 4.2 : réponse du contributeur (FR31) model QualificationQuestion { id String @id @default(cuid()) ideaId String idea Idea @relation(fields: [ideaId], references: [id], onDelete: Cascade) workspaceId String // dénormalisé pour isolation multi-tenant questionText String @db.Text responseToken String @unique @default(cuid()) // utilisé par Story 4.2 pour l'URL de réponse askedAt DateTime @default(now()) responseText String? @db.Text // Story 4.2 : null = pas encore répondu answeredAt DateTime? // Story 4.2 : null = pas encore répondu @@index([ideaId]) @@index([workspaceId]) } // Story 2.4a: Bibliothèque de cas d'usage IA (FR14-IA3, FR14-IA4, FR14-IA5) // Bibliothèque globale partagée - pas de workspaceId model LibraryCase { id String @id @default(cuid()) sector String // distribution | industrie | services | sante | finance department String // rh | finance | supply-chain | commercial | operations title String description String @db.Text createdAt DateTime @default(now()) updatedAt DateTime @updatedAt @@index([sector]) @@index([department]) @@index([sector, department]) } // Story 4.5 : Lien partageable lecture seule (FR36) model ShareLink { id String @id @default(cuid()) workspaceId String @unique // 1 lien actif par workspace (MVP) workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade) token String @unique @default(cuid()) expiresAt DateTime? // null = illimité | sinon date d'expiration createdAt DateTime @default(now()) @@index([token]) // lookup rapide page publique }