| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296 |
- // 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 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
- 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
- }
|