schema.prisma 9.5 KB

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