schema.prisma 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324
  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. /// Débloqué après un partage sur la page parrainage : affiche l'activation Pro.
  38. proModeAvailable Boolean @default(false)
  39. shareLink ShareLink? // Story 4.5 : lien partageable lecture seule (FR36)
  40. feedbacks AppFeedback[]
  41. createdAt DateTime @default(now())
  42. updatedAt DateTime @updatedAt
  43. ownerId String @unique
  44. owner User @relation(fields: [ownerId], references: [id], onDelete: Cascade)
  45. contributors Contributor[]
  46. ideas Idea[]
  47. manualRelanceLogs ManualRelanceLog[]
  48. }
  49. // Story 2.11 : Relance manuelle Transformateur (FR11, FR12, FR13)
  50. model ManualRelanceLog {
  51. id String @id @default(cuid())
  52. workspaceId String
  53. subject String
  54. recipientCount Int
  55. sentCount Int
  56. failedCount Int @default(0)
  57. sentAt DateTime @default(now())
  58. workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  59. @@index([workspaceId])
  60. }
  61. // Story 2.1: Invitation contributeurs (FR6, FR7)
  62. enum ContributorStatus {
  63. INVITED
  64. SUBMITTED
  65. NOT_SUBMITTED
  66. }
  67. model Contributor {
  68. id String @id @default(cuid())
  69. workspaceId String
  70. workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  71. email String
  72. /// Service / direction (optionnel), saisi à l'invitation ou éditable, ciblage des relances manuelles.
  73. service String?
  74. status ContributorStatus @default(INVITED)
  75. invitedAt DateTime @default(now())
  76. lastRemindedAt DateTime? // Story 2.10 : date de la relance J+21 (null = jamais relancé)
  77. createdAt DateTime @default(now())
  78. ideas Idea[]
  79. @@unique([workspaceId, email])
  80. @@index([workspaceId])
  81. @@index([workspaceId, service])
  82. }
  83. // Story 2.2: Formulaire de soumission contributeur (FR8, FR14)
  84. enum IdeaStatus {
  85. SUBMITTED // Envoyé (statut initial)
  86. IN_REVIEW // En traitement
  87. ON_AGENDA // Mis à l'ordre du jour
  88. IN_PROGRESS // En cours
  89. NOT_PRIORITY // Non prioritaire (filtrable, non supprimé - FR26)
  90. }
  91. enum ImpactLevel {
  92. FAIBLE
  93. MODERE
  94. ELEVE
  95. CRITIQUE
  96. }
  97. enum Frequency {
  98. QUOTIDIENNE
  99. HEBDOMADAIRE
  100. MENSUELLE
  101. TRIMESTRIELLE
  102. PONCTUELLE
  103. }
  104. model Idea {
  105. id String @id @default(cuid())
  106. workspaceId String
  107. workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  108. // Données contributeur
  109. contributorEmail String
  110. contributorId String?
  111. contributor Contributor? @relation(fields: [contributorId], references: [id], onDelete: SetNull)
  112. // Champs formulaire FR14
  113. department String
  114. problemDescription String @db.Text
  115. estimatedImpact ImpactLevel
  116. frequency Frequency
  117. /// Réponses optionnelles à la soumission (langage métier), aident le transformateur à trancher
  118. optionalWhoAffected String? @db.Text
  119. optionalAlreadyTried String? @db.Text
  120. optionalSuccessLooksLike String? @db.Text
  121. // Statut
  122. status IdeaStatus @default(SUBMITTED)
  123. // Enrichissement LLM - rempli par Story 3.1 (api/llm/enrich)
  124. llmTitle String?
  125. llmDomain String?
  126. llmAiType String?
  127. llmExplanation String? @db.Text
  128. llmScoreImpact Int? // 1-5 (NFR18)
  129. llmScoreFeasibility Int? // 1-5
  130. llmScoreUrgency Int? // 1-5
  131. llmEnrichedAt DateTime?
  132. llmEnrichFailed Boolean @default(false) // FR21 : fallback "À qualifier manuellement"
  133. // Scores manuels - Story 3.4 (FR20)
  134. manualScoreImpact Int?
  135. manualScoreFeasibility Int?
  136. manualScoreUrgency Int?
  137. // Ordre priorisation - Story 4.3 (FR33)
  138. priorityOrder Int?
  139. // Story 2.5 : idempotence webhook Resend Inbound (éviter doublons sur replay)
  140. emailMessageId String? @unique
  141. // Story 2.6 : pièces jointes (FR17)
  142. attachments IdeaAttachment[]
  143. // Story 4.1 : questions de qualification (FR29, FR30)
  144. qualificationQuestions QualificationQuestion[]
  145. createdAt DateTime @default(now())
  146. updatedAt DateTime @updatedAt
  147. @@index([workspaceId, createdAt])
  148. @@index([workspaceId, status])
  149. @@index([workspaceId, contributorEmail])
  150. @@index([workspaceId, priorityOrder]) // Story 4.3 : tri par priorité (FR33, FR34)
  151. }
  152. model Post {
  153. id Int @id @default(autoincrement())
  154. name String
  155. createdAt DateTime @default(now())
  156. updatedAt DateTime @updatedAt
  157. createdBy User @relation(fields: [createdById], references: [id])
  158. createdById String
  159. @@index([name])
  160. }
  161. // Necessary for Next auth
  162. model Account {
  163. id String @id @default(cuid())
  164. userId String
  165. type String
  166. provider String
  167. providerAccountId String
  168. refresh_token String? // @db.Text
  169. access_token String? // @db.Text
  170. expires_at Int?
  171. token_type String?
  172. scope String?
  173. id_token String? // @db.Text
  174. session_state String?
  175. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  176. refresh_token_expires_in Int?
  177. @@unique([provider, providerAccountId])
  178. }
  179. model Session {
  180. id String @id @default(cuid())
  181. sessionToken String @unique
  182. userId String
  183. expires DateTime
  184. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  185. }
  186. model User {
  187. id String @id @default(cuid())
  188. name String?
  189. email String? @unique
  190. emailVerified DateTime?
  191. password String? // hash bcrypt - auth Credentials (Story 1.2b)
  192. /// Horodatage unique d'acceptation CGU/CGV, confidentialité et annexe RGPD à l'inscription.
  193. legalTermsAcceptedAt DateTime?
  194. image String?
  195. accounts Account[]
  196. sessions Session[]
  197. posts Post[]
  198. workspace Workspace?
  199. feedbacks AppFeedback[]
  200. }
  201. model VerificationToken {
  202. identifier String
  203. token String @unique
  204. expires DateTime
  205. @@unique([identifier, token])
  206. }
  207. // Story 2.6 : Pièces jointes à la soumission (FR17)
  208. model IdeaAttachment {
  209. id String @id @default(cuid())
  210. ideaId String
  211. idea Idea @relation(fields: [ideaId], references: [id], onDelete: Cascade)
  212. workspaceId String // dénormalisé pour isolation multi-tenant
  213. filename String // nom original sanitisé
  214. contentType String // MIME type
  215. size Int // taille en bytes
  216. url String // URL Vercel Blob
  217. blobPath String // path convention : {workspaceId}/attachments/{ideaId}/{filename}
  218. createdAt DateTime @default(now())
  219. @@index([ideaId])
  220. @@index([workspaceId])
  221. }
  222. // Story 4.1 : Questions de qualification (FR29, FR30)
  223. // Story 4.2 : réponse du contributeur (FR31)
  224. model QualificationQuestion {
  225. id String @id @default(cuid())
  226. ideaId String
  227. idea Idea @relation(fields: [ideaId], references: [id], onDelete: Cascade)
  228. workspaceId String // dénormalisé pour isolation multi-tenant
  229. questionText String @db.Text
  230. responseToken String @unique @default(cuid()) // utilisé par Story 4.2 pour l'URL de réponse
  231. askedAt DateTime @default(now())
  232. responseText String? @db.Text // Story 4.2 : null = pas encore répondu
  233. answeredAt DateTime? // Story 4.2 : null = pas encore répondu
  234. @@index([ideaId])
  235. @@index([workspaceId])
  236. }
  237. // Story 2.4a: Bibliothèque de cas d'usage IA (FR14-IA3, FR14-IA4, FR14-IA5)
  238. // Bibliothèque globale partagée - pas de workspaceId
  239. model LibraryCase {
  240. id String @id @default(cuid())
  241. sector String // distribution | industrie | services | sante | finance
  242. department String // rh | finance | supply-chain | commercial | operations
  243. title String
  244. description String @db.Text
  245. createdAt DateTime @default(now())
  246. updatedAt DateTime @updatedAt
  247. @@index([sector])
  248. @@index([department])
  249. @@index([sector, department])
  250. }
  251. // Feedback utilisateur : bug ou idée d'amélioration
  252. enum FeedbackType {
  253. BUG
  254. IMPROVEMENT
  255. }
  256. model AppFeedback {
  257. id String @id @default(cuid())
  258. userId String
  259. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  260. workspaceId String
  261. workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  262. type FeedbackType
  263. message String @db.Text
  264. createdAt DateTime @default(now())
  265. @@index([workspaceId, createdAt])
  266. @@index([userId])
  267. }
  268. // Story 4.5 : Lien partageable lecture seule (FR36)
  269. model ShareLink {
  270. id String @id @default(cuid())
  271. workspaceId String @unique // 1 lien actif par workspace (MVP)
  272. workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  273. token String @unique @default(cuid())
  274. expiresAt DateTime? // null = illimité | sinon date d'expiration
  275. createdAt DateTime @default(now())
  276. @@index([token]) // lookup rapide page publique
  277. }