schema.prisma 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300
  1. // This is your Prisma schema file,
  2. // learn more about it in the docs: https://pris.ly/d/prisma-schema
  3. generator client {
  4. provider = "prisma-client-js"
  5. output = "../generated/prisma"
  6. }
  7. datasource db {
  8. provider = "postgresql"
  9. // NOTE: When using mysql or sqlserver, uncomment the @db.Text annotations in model Account below
  10. // Further reading:
  11. // https://next-auth.js.org/adapters/prisma#create-the-prisma-schema
  12. // https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#string
  13. url = env("DATABASE_URL")
  14. }
  15. // Workspace - 1 utilisateur = 1 workspace (MVP). Unité de tenant pour AImpact Hub (Story 1.2)
  16. // Story 1.6: tier, llmCallsThisMonth, llmCallsResetAt pour limites Free (FR4, FR5)
  17. enum WorkspaceTier {
  18. FREE
  19. PRO
  20. }
  21. model Workspace {
  22. id String @id @default(cuid())
  23. name String
  24. slug String @unique
  25. sector String?
  26. companySize Int?
  27. contactEmail String?
  28. tier WorkspaceTier @default(FREE)
  29. llmCallsThisMonth Int @default(0)
  30. llmCallsResetAt DateTime @default(now())
  31. autoRelanceEnabled Boolean @default(true) // Story 2.10 : désactivable par le Transformateur
  32. // Story 4.4 : export PDF (FR35) - suivi limite Free (1 export/mois)
  33. exportsThisMonth Int @default(0)
  34. exportsResetAt DateTime @default(now())
  35. lastVisitedAt DateTime? // Story 3.7 : résumé nouvelles activités (FR28)
  36. onboardingDismissed Boolean @default(false) // Story 1.5 : checklist onboarding masquée après la première visite
  37. shareLink ShareLink? // Story 4.5 : lien partageable lecture seule (FR36)
  38. createdAt DateTime @default(now())
  39. updatedAt DateTime @updatedAt
  40. ownerId String @unique
  41. owner User @relation(fields: [ownerId], references: [id], onDelete: Cascade)
  42. contributors Contributor[]
  43. ideas Idea[]
  44. manualRelanceLogs ManualRelanceLog[]
  45. }
  46. // Story 2.11 : Relance manuelle Transformateur (FR11, FR12, FR13)
  47. model ManualRelanceLog {
  48. id String @id @default(cuid())
  49. workspaceId String
  50. subject String
  51. recipientCount Int
  52. sentCount Int
  53. failedCount Int @default(0)
  54. sentAt DateTime @default(now())
  55. workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  56. @@index([workspaceId])
  57. }
  58. // Story 2.1: Invitation contributeurs (FR6, FR7)
  59. enum ContributorStatus {
  60. INVITED
  61. SUBMITTED
  62. NOT_SUBMITTED
  63. }
  64. model Contributor {
  65. id String @id @default(cuid())
  66. workspaceId String
  67. workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  68. email String
  69. /// Service / direction (optionnel), saisi à l'invitation ou éditable, ciblage des relances manuelles.
  70. service String?
  71. status ContributorStatus @default(INVITED)
  72. invitedAt DateTime @default(now())
  73. lastRemindedAt DateTime? // Story 2.10 : date de la relance J+21 (null = jamais relancé)
  74. createdAt DateTime @default(now())
  75. ideas Idea[]
  76. @@unique([workspaceId, email])
  77. @@index([workspaceId])
  78. @@index([workspaceId, service])
  79. }
  80. // Story 2.2: Formulaire de soumission contributeur (FR8, FR14)
  81. enum IdeaStatus {
  82. SUBMITTED // Envoyé (statut initial)
  83. IN_REVIEW // En traitement
  84. ON_AGENDA // Mis à l'ordre du jour
  85. IN_PROGRESS // En cours
  86. NOT_PRIORITY // Non prioritaire (filtrable, non supprimé - FR26)
  87. }
  88. enum ImpactLevel {
  89. FAIBLE
  90. MODERE
  91. ELEVE
  92. CRITIQUE
  93. }
  94. enum Frequency {
  95. QUOTIDIENNE
  96. HEBDOMADAIRE
  97. MENSUELLE
  98. TRIMESTRIELLE
  99. PONCTUELLE
  100. }
  101. model Idea {
  102. id String @id @default(cuid())
  103. workspaceId String
  104. workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  105. // Données contributeur
  106. contributorEmail String
  107. contributorId String?
  108. contributor Contributor? @relation(fields: [contributorId], references: [id], onDelete: SetNull)
  109. // Champs formulaire FR14
  110. department String
  111. problemDescription String @db.Text
  112. estimatedImpact ImpactLevel
  113. frequency Frequency
  114. /// Réponses optionnelles à la soumission (langage métier), aident le transformateur à trancher
  115. optionalWhoAffected String? @db.Text
  116. optionalAlreadyTried String? @db.Text
  117. optionalSuccessLooksLike String? @db.Text
  118. // Statut
  119. status IdeaStatus @default(SUBMITTED)
  120. // Enrichissement LLM - rempli par Story 3.1 (api/llm/enrich)
  121. llmTitle String?
  122. llmDomain String?
  123. llmAiType String?
  124. llmExplanation String? @db.Text
  125. llmScoreImpact Int? // 1-5 (NFR18)
  126. llmScoreFeasibility Int? // 1-5
  127. llmScoreUrgency Int? // 1-5
  128. llmEnrichedAt DateTime?
  129. llmEnrichFailed Boolean @default(false) // FR21 : fallback "À qualifier manuellement"
  130. // Scores manuels - Story 3.4 (FR20)
  131. manualScoreImpact Int?
  132. manualScoreFeasibility Int?
  133. manualScoreUrgency Int?
  134. // Ordre priorisation - Story 4.3 (FR33)
  135. priorityOrder Int?
  136. // Story 2.5 : idempotence webhook Resend Inbound (éviter doublons sur replay)
  137. emailMessageId String? @unique
  138. // Story 2.6 : pièces jointes (FR17)
  139. attachments IdeaAttachment[]
  140. // Story 4.1 : questions de qualification (FR29, FR30)
  141. qualificationQuestions QualificationQuestion[]
  142. createdAt DateTime @default(now())
  143. updatedAt DateTime @updatedAt
  144. @@index([workspaceId, createdAt])
  145. @@index([workspaceId, status])
  146. @@index([workspaceId, contributorEmail])
  147. @@index([workspaceId, priorityOrder]) // Story 4.3 : tri par priorité (FR33, FR34)
  148. }
  149. model Post {
  150. id Int @id @default(autoincrement())
  151. name String
  152. createdAt DateTime @default(now())
  153. updatedAt DateTime @updatedAt
  154. createdBy User @relation(fields: [createdById], references: [id])
  155. createdById String
  156. @@index([name])
  157. }
  158. // Necessary for Next auth
  159. model Account {
  160. id String @id @default(cuid())
  161. userId String
  162. type String
  163. provider String
  164. providerAccountId String
  165. refresh_token String? // @db.Text
  166. access_token String? // @db.Text
  167. expires_at Int?
  168. token_type String?
  169. scope String?
  170. id_token String? // @db.Text
  171. session_state String?
  172. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  173. refresh_token_expires_in Int?
  174. @@unique([provider, providerAccountId])
  175. }
  176. model Session {
  177. id String @id @default(cuid())
  178. sessionToken String @unique
  179. userId String
  180. expires DateTime
  181. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  182. }
  183. model User {
  184. id String @id @default(cuid())
  185. name String?
  186. email String? @unique
  187. emailVerified DateTime?
  188. password String? // hash bcrypt - auth Credentials (Story 1.2b)
  189. /// Horodatage unique d'acceptation CGU/CGV, confidentialité et annexe RGPD à l'inscription.
  190. legalTermsAcceptedAt DateTime?
  191. image String?
  192. accounts Account[]
  193. sessions Session[]
  194. posts Post[]
  195. workspace Workspace?
  196. }
  197. model VerificationToken {
  198. identifier String
  199. token String @unique
  200. expires DateTime
  201. @@unique([identifier, token])
  202. }
  203. // Story 2.6 : Pièces jointes à la soumission (FR17)
  204. model IdeaAttachment {
  205. id String @id @default(cuid())
  206. ideaId String
  207. idea Idea @relation(fields: [ideaId], references: [id], onDelete: Cascade)
  208. workspaceId String // dénormalisé pour isolation multi-tenant
  209. filename String // nom original sanitisé
  210. contentType String // MIME type
  211. size Int // taille en bytes
  212. url String // URL Vercel Blob
  213. blobPath String // path convention : {workspaceId}/attachments/{ideaId}/{filename}
  214. createdAt DateTime @default(now())
  215. @@index([ideaId])
  216. @@index([workspaceId])
  217. }
  218. // Story 4.1 : Questions de qualification (FR29, FR30)
  219. // Story 4.2 : réponse du contributeur (FR31)
  220. model QualificationQuestion {
  221. id String @id @default(cuid())
  222. ideaId String
  223. idea Idea @relation(fields: [ideaId], references: [id], onDelete: Cascade)
  224. workspaceId String // dénormalisé pour isolation multi-tenant
  225. questionText String @db.Text
  226. responseToken String @unique @default(cuid()) // utilisé par Story 4.2 pour l'URL de réponse
  227. askedAt DateTime @default(now())
  228. responseText String? @db.Text // Story 4.2 : null = pas encore répondu
  229. answeredAt DateTime? // Story 4.2 : null = pas encore répondu
  230. @@index([ideaId])
  231. @@index([workspaceId])
  232. }
  233. // Story 2.4a: Bibliothèque de cas d'usage IA (FR14-IA3, FR14-IA4, FR14-IA5)
  234. // Bibliothèque globale partagée - pas de workspaceId
  235. model LibraryCase {
  236. id String @id @default(cuid())
  237. sector String // distribution | industrie | services | sante | finance
  238. department String // rh | finance | supply-chain | commercial | operations
  239. title String
  240. description String @db.Text
  241. createdAt DateTime @default(now())
  242. updatedAt DateTime @updatedAt
  243. @@index([sector])
  244. @@index([department])
  245. @@index([sector, department])
  246. }
  247. // Story 4.5 : Lien partageable lecture seule (FR36)
  248. model ShareLink {
  249. id String @id @default(cuid())
  250. workspaceId String @unique // 1 lien actif par workspace (MVP)
  251. workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  252. token String @unique @default(cuid())
  253. expiresAt DateTime? // null = illimité | sinon date d'expiration
  254. createdAt DateTime @default(now())
  255. @@index([token]) // lookup rapide page publique
  256. }