schema.prisma 9.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296
  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 String?
  70. status ContributorStatus @default(INVITED)
  71. invitedAt DateTime @default(now())
  72. lastRemindedAt DateTime? // Story 2.10 : date de la relance J+21 (null = jamais relancé)
  73. createdAt DateTime @default(now())
  74. ideas Idea[]
  75. @@unique([workspaceId, email])
  76. @@index([workspaceId])
  77. @@index([workspaceId, service])
  78. }
  79. // Story 2.2: Formulaire de soumission contributeur (FR8, FR14)
  80. enum IdeaStatus {
  81. SUBMITTED // Envoyé (statut initial)
  82. IN_REVIEW // En traitement
  83. ON_AGENDA // Mis à l'ordre du jour
  84. IN_PROGRESS // En cours
  85. NOT_PRIORITY // Non prioritaire (filtrable, non supprimé - FR26)
  86. }
  87. enum ImpactLevel {
  88. FAIBLE
  89. MODERE
  90. ELEVE
  91. CRITIQUE
  92. }
  93. enum Frequency {
  94. QUOTIDIENNE
  95. HEBDOMADAIRE
  96. MENSUELLE
  97. TRIMESTRIELLE
  98. PONCTUELLE
  99. }
  100. model Idea {
  101. id String @id @default(cuid())
  102. workspaceId String
  103. workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  104. // Données contributeur
  105. contributorEmail String
  106. contributorId String?
  107. contributor Contributor? @relation(fields: [contributorId], references: [id], onDelete: SetNull)
  108. // Champs formulaire FR14
  109. department String
  110. problemDescription String @db.Text
  111. estimatedImpact ImpactLevel
  112. frequency Frequency
  113. optionalWhoAffected String? @db.Text
  114. optionalAlreadyTried String? @db.Text
  115. optionalSuccessLooksLike String? @db.Text
  116. // Statut
  117. status IdeaStatus @default(SUBMITTED)
  118. // Enrichissement LLM - rempli par Story 3.1 (api/llm/enrich)
  119. llmTitle String?
  120. llmDomain String?
  121. llmAiType String?
  122. llmExplanation String? @db.Text
  123. llmScoreImpact Int? // 1–5 (NFR18)
  124. llmScoreFeasibility Int? // 1–5
  125. llmScoreUrgency Int? // 1–5
  126. llmEnrichedAt DateTime?
  127. llmEnrichFailed Boolean @default(false) // FR21 : fallback "À qualifier manuellement"
  128. // Scores manuels - Story 3.4 (FR20)
  129. manualScoreImpact Int?
  130. manualScoreFeasibility Int?
  131. manualScoreUrgency Int?
  132. // Ordre priorisation - Story 4.3 (FR33)
  133. priorityOrder Int?
  134. // Story 2.5 : idempotence webhook Resend Inbound (éviter doublons sur replay)
  135. emailMessageId String? @unique
  136. // Story 2.6 : pièces jointes (FR17)
  137. attachments IdeaAttachment[]
  138. // Story 4.1 : questions de qualification (FR29, FR30)
  139. qualificationQuestions QualificationQuestion[]
  140. createdAt DateTime @default(now())
  141. updatedAt DateTime @updatedAt
  142. @@index([workspaceId, createdAt])
  143. @@index([workspaceId, status])
  144. @@index([workspaceId, contributorEmail])
  145. @@index([workspaceId, priorityOrder]) // Story 4.3 : tri par priorité (FR33, FR34)
  146. }
  147. model Post {
  148. id Int @id @default(autoincrement())
  149. name String
  150. createdAt DateTime @default(now())
  151. updatedAt DateTime @updatedAt
  152. createdBy User @relation(fields: [createdById], references: [id])
  153. createdById String
  154. @@index([name])
  155. }
  156. // Necessary for Next auth
  157. model Account {
  158. id String @id @default(cuid())
  159. userId String
  160. type String
  161. provider String
  162. providerAccountId String
  163. refresh_token String? // @db.Text
  164. access_token String? // @db.Text
  165. expires_at Int?
  166. token_type String?
  167. scope String?
  168. id_token String? // @db.Text
  169. session_state String?
  170. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  171. refresh_token_expires_in Int?
  172. @@unique([provider, providerAccountId])
  173. }
  174. model Session {
  175. id String @id @default(cuid())
  176. sessionToken String @unique
  177. userId String
  178. expires DateTime
  179. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  180. }
  181. model User {
  182. id String @id @default(cuid())
  183. name String?
  184. email String? @unique
  185. emailVerified DateTime?
  186. password String? // hash bcrypt - auth Credentials (Story 1.2b)
  187. image String?
  188. accounts Account[]
  189. sessions Session[]
  190. posts Post[]
  191. workspace Workspace?
  192. }
  193. model VerificationToken {
  194. identifier String
  195. token String @unique
  196. expires DateTime
  197. @@unique([identifier, token])
  198. }
  199. // Story 2.6 : Pièces jointes à la soumission (FR17)
  200. model IdeaAttachment {
  201. id String @id @default(cuid())
  202. ideaId String
  203. idea Idea @relation(fields: [ideaId], references: [id], onDelete: Cascade)
  204. workspaceId String // dénormalisé pour isolation multi-tenant
  205. filename String // nom original sanitisé
  206. contentType String // MIME type
  207. size Int // taille en bytes
  208. url String // URL Vercel Blob
  209. blobPath String // path convention : {workspaceId}/attachments/{ideaId}/{filename}
  210. createdAt DateTime @default(now())
  211. @@index([ideaId])
  212. @@index([workspaceId])
  213. }
  214. // Story 4.1 : Questions de qualification (FR29, FR30)
  215. // Story 4.2 : réponse du contributeur (FR31)
  216. model QualificationQuestion {
  217. id String @id @default(cuid())
  218. ideaId String
  219. idea Idea @relation(fields: [ideaId], references: [id], onDelete: Cascade)
  220. workspaceId String // dénormalisé pour isolation multi-tenant
  221. questionText String @db.Text
  222. responseToken String @unique @default(cuid()) // utilisé par Story 4.2 pour l'URL de réponse
  223. askedAt DateTime @default(now())
  224. responseText String? @db.Text // Story 4.2 : null = pas encore répondu
  225. answeredAt DateTime? // Story 4.2 : null = pas encore répondu
  226. @@index([ideaId])
  227. @@index([workspaceId])
  228. }
  229. // Story 2.4a: Bibliothèque de cas d'usage IA (FR14-IA3, FR14-IA4, FR14-IA5)
  230. // Bibliothèque globale partagée - pas de workspaceId
  231. model LibraryCase {
  232. id String @id @default(cuid())
  233. sector String // distribution | industrie | services | sante | finance
  234. department String // rh | finance | supply-chain | commercial | operations
  235. title String
  236. description String @db.Text
  237. createdAt DateTime @default(now())
  238. updatedAt DateTime @updatedAt
  239. @@index([sector])
  240. @@index([department])
  241. @@index([sector, department])
  242. }
  243. // Story 4.5 : Lien partageable lecture seule (FR36)
  244. model ShareLink {
  245. id String @id @default(cuid())
  246. workspaceId String @unique // 1 lien actif par workspace (MVP)
  247. workspace Workspace @relation(fields: [workspaceId], references: [id], onDelete: Cascade)
  248. token String @unique @default(cuid())
  249. expiresAt DateTime? // null = illimité | sinon date d'expiration
  250. createdAt DateTime @default(now())
  251. @@index([token]) // lookup rapide page publique
  252. }