schema.prisma 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654
  1. generator client {
  2. provider = "prisma-client-js"
  3. }
  4. datasource db {
  5. provider = "postgresql"
  6. url = env("DATABASE_URL")
  7. }
  8. model User {
  9. id String @id @default(cuid())
  10. name String
  11. email String @unique
  12. emailVerified Boolean @default(false)
  13. image String?
  14. isSuperAdmin Boolean @default(false)
  15. createdAt DateTime @default(now())
  16. updatedAt DateTime @updatedAt
  17. twoFactorEnabled Boolean @default(false)
  18. termsAcceptedAt DateTime?
  19. sessions Session[]
  20. accounts Account[]
  21. vehicles Vehicle[]
  22. customers Customer[]
  23. settings AppSetting[]
  24. inventoryParts InventoryPart[]
  25. quotes Quote[]
  26. customFieldDefinitions CustomFieldDefinition[]
  27. twoFactor TwoFactor?
  28. organizationMembers OrganizationMember[]
  29. @@map("users")
  30. }
  31. model AppSetting {
  32. id String @id @default(cuid())
  33. key String
  34. value String
  35. userId String
  36. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  37. organizationId String?
  38. organization Organization? @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  39. @@unique([organizationId, key])
  40. @@index([organizationId])
  41. @@map("app_settings")
  42. }
  43. model Session {
  44. id String @id @default(cuid())
  45. expiresAt DateTime
  46. token String @unique
  47. createdAt DateTime @default(now())
  48. updatedAt DateTime @updatedAt
  49. ipAddress String?
  50. userAgent String?
  51. userId String
  52. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  53. @@index([userId])
  54. @@map("sessions")
  55. }
  56. model Account {
  57. id String @id @default(cuid())
  58. accountId String
  59. providerId String
  60. userId String
  61. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  62. accessToken String?
  63. refreshToken String?
  64. idToken String?
  65. accessTokenExpiresAt DateTime?
  66. refreshTokenExpiresAt DateTime?
  67. scope String?
  68. password String?
  69. createdAt DateTime @default(now())
  70. updatedAt DateTime @updatedAt
  71. @@index([userId])
  72. @@map("accounts")
  73. }
  74. model Verification {
  75. id String @id @default(cuid())
  76. identifier String
  77. value String
  78. expiresAt DateTime
  79. createdAt DateTime? @default(now())
  80. updatedAt DateTime? @updatedAt
  81. @@map("verifications")
  82. }
  83. model TwoFactor {
  84. id String @id @default(cuid())
  85. secret String
  86. backupCodes String
  87. userId String @unique
  88. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  89. @@map("two_factor")
  90. }
  91. model Vehicle {
  92. id String @id @default(cuid())
  93. make String
  94. model String
  95. year Int
  96. vin String?
  97. licensePlate String?
  98. color String?
  99. mileage Int @default(0)
  100. fuelType String? @default("gasoline")
  101. transmission String? @default("automatic")
  102. engineSize String?
  103. purchaseDate DateTime?
  104. purchasePrice Float?
  105. imageUrl String?
  106. isArchived Boolean @default(false)
  107. archiveReason String?
  108. createdAt DateTime @default(now())
  109. updatedAt DateTime @updatedAt
  110. userId String
  111. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  112. organizationId String?
  113. organization Organization? @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  114. customerId String?
  115. customer Customer? @relation(fields: [customerId], references: [id], onDelete: SetNull)
  116. serviceRecords ServiceRecord[]
  117. notes Note[]
  118. fuelLogs FuelLog[]
  119. reminders Reminder[]
  120. quotes Quote[]
  121. recurringInvoices RecurringInvoice[]
  122. @@index([organizationId])
  123. @@map("vehicles")
  124. }
  125. model ServiceRecord {
  126. id String @id @default(cuid())
  127. title String
  128. description String?
  129. type String @default("maintenance")
  130. status String @default("completed")
  131. cost Float @default(0)
  132. mileage Int?
  133. serviceDate DateTime @default(now())
  134. shopName String?
  135. techName String?
  136. parts String?
  137. laborHours Float?
  138. diagnosticNotes String?
  139. invoiceNotes String?
  140. subtotal Float @default(0)
  141. taxRate Float @default(0)
  142. taxAmount Float @default(0)
  143. totalAmount Float @default(0)
  144. invoiceNumber String?
  145. discountType String?
  146. discountValue Float @default(0)
  147. discountAmount Float @default(0)
  148. publicToken String? @unique
  149. createdAt DateTime @default(now())
  150. updatedAt DateTime @updatedAt
  151. vehicleId String
  152. vehicle Vehicle @relation(fields: [vehicleId], references: [id], onDelete: Cascade)
  153. partItems ServicePart[]
  154. laborItems ServiceLabor[]
  155. attachments ServiceAttachment[]
  156. payments Payment[]
  157. @@index([vehicleId])
  158. @@map("service_records")
  159. }
  160. model Note {
  161. id String @id @default(cuid())
  162. title String
  163. content String
  164. isPinned Boolean @default(false)
  165. createdAt DateTime @default(now())
  166. updatedAt DateTime @updatedAt
  167. vehicleId String
  168. vehicle Vehicle @relation(fields: [vehicleId], references: [id], onDelete: Cascade)
  169. @@index([vehicleId])
  170. @@map("notes")
  171. }
  172. model FuelLog {
  173. id String @id @default(cuid())
  174. date DateTime @default(now())
  175. mileage Int
  176. gallons Float
  177. pricePerGallon Float
  178. totalCost Float
  179. isFillUp Boolean @default(true)
  180. station String?
  181. notes String?
  182. createdAt DateTime @default(now())
  183. updatedAt DateTime @updatedAt
  184. vehicleId String
  185. vehicle Vehicle @relation(fields: [vehicleId], references: [id], onDelete: Cascade)
  186. @@index([vehicleId])
  187. @@map("fuel_logs")
  188. }
  189. model Reminder {
  190. id String @id @default(cuid())
  191. title String
  192. description String?
  193. dueDate DateTime?
  194. dueMileage Int?
  195. isCompleted Boolean @default(false)
  196. createdAt DateTime @default(now())
  197. updatedAt DateTime @updatedAt
  198. vehicleId String
  199. vehicle Vehicle @relation(fields: [vehicleId], references: [id], onDelete: Cascade)
  200. @@index([vehicleId])
  201. @@map("reminders")
  202. }
  203. model Customer {
  204. id String @id @default(cuid())
  205. name String
  206. email String?
  207. phone String?
  208. address String?
  209. company String?
  210. notes String?
  211. createdAt DateTime @default(now())
  212. updatedAt DateTime @updatedAt
  213. userId String
  214. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  215. organizationId String?
  216. organization Organization? @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  217. vehicles Vehicle[]
  218. quotes Quote[]
  219. @@index([organizationId])
  220. @@map("customers")
  221. }
  222. model Payment {
  223. id String @id @default(cuid())
  224. amount Float
  225. date DateTime @default(now())
  226. method String @default("other")
  227. note String?
  228. provider String?
  229. externalId String?
  230. createdAt DateTime @default(now())
  231. updatedAt DateTime @updatedAt
  232. serviceRecordId String
  233. serviceRecord ServiceRecord @relation(fields: [serviceRecordId], references: [id], onDelete: Cascade)
  234. @@index([serviceRecordId])
  235. @@map("payments")
  236. }
  237. model ServiceAttachment {
  238. id String @id @default(cuid())
  239. fileName String
  240. fileUrl String
  241. fileType String
  242. fileSize Int
  243. category String @default("diagnostic")
  244. description String?
  245. includeInInvoice Boolean @default(true)
  246. createdAt DateTime @default(now())
  247. serviceRecordId String
  248. serviceRecord ServiceRecord @relation(fields: [serviceRecordId], references: [id], onDelete: Cascade)
  249. @@index([serviceRecordId])
  250. @@map("service_attachments")
  251. }
  252. model ServicePart {
  253. id String @id @default(cuid())
  254. partNumber String?
  255. name String
  256. quantity Float @default(1)
  257. unitPrice Float @default(0)
  258. total Float @default(0)
  259. serviceRecordId String
  260. serviceRecord ServiceRecord @relation(fields: [serviceRecordId], references: [id], onDelete: Cascade)
  261. @@index([serviceRecordId])
  262. @@map("service_parts")
  263. }
  264. model ServiceLabor {
  265. id String @id @default(cuid())
  266. description String
  267. hours Float @default(0)
  268. rate Float @default(0)
  269. total Float @default(0)
  270. serviceRecordId String
  271. serviceRecord ServiceRecord @relation(fields: [serviceRecordId], references: [id], onDelete: Cascade)
  272. @@index([serviceRecordId])
  273. @@map("service_labor")
  274. }
  275. model InventoryPart {
  276. id String @id @default(cuid())
  277. partNumber String?
  278. name String
  279. description String?
  280. category String?
  281. quantity Int @default(0)
  282. minQuantity Int @default(0)
  283. unitCost Float @default(0)
  284. supplier String?
  285. supplierPhone String?
  286. supplierEmail String?
  287. supplierUrl String?
  288. imageUrl String?
  289. location String?
  290. isArchived Boolean @default(false)
  291. createdAt DateTime @default(now())
  292. updatedAt DateTime @updatedAt
  293. userId String
  294. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  295. organizationId String?
  296. organization Organization? @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  297. @@index([organizationId])
  298. @@map("inventory_parts")
  299. }
  300. model Quote {
  301. id String @id @default(cuid())
  302. quoteNumber String?
  303. title String
  304. description String?
  305. status String @default("draft")
  306. validUntil DateTime?
  307. subtotal Float @default(0)
  308. taxRate Float @default(0)
  309. taxAmount Float @default(0)
  310. discountType String?
  311. discountValue Float @default(0)
  312. discountAmount Float @default(0)
  313. totalAmount Float @default(0)
  314. notes String?
  315. convertedToId String?
  316. createdAt DateTime @default(now())
  317. updatedAt DateTime @updatedAt
  318. userId String
  319. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  320. organizationId String?
  321. organization Organization? @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  322. customerId String?
  323. customer Customer? @relation(fields: [customerId], references: [id], onDelete: SetNull)
  324. vehicleId String?
  325. vehicle Vehicle? @relation(fields: [vehicleId], references: [id], onDelete: SetNull)
  326. partItems QuotePart[]
  327. laborItems QuoteLabor[]
  328. @@index([organizationId])
  329. @@map("quotes")
  330. }
  331. model QuotePart {
  332. id String @id @default(cuid())
  333. partNumber String?
  334. name String
  335. quantity Float @default(1)
  336. unitPrice Float @default(0)
  337. total Float @default(0)
  338. quoteId String
  339. quote Quote @relation(fields: [quoteId], references: [id], onDelete: Cascade)
  340. @@index([quoteId])
  341. @@map("quote_parts")
  342. }
  343. model QuoteLabor {
  344. id String @id @default(cuid())
  345. description String
  346. hours Float @default(0)
  347. rate Float @default(0)
  348. total Float @default(0)
  349. quoteId String
  350. quote Quote @relation(fields: [quoteId], references: [id], onDelete: Cascade)
  351. @@index([quoteId])
  352. @@map("quote_labor")
  353. }
  354. model CustomFieldDefinition {
  355. id String @id @default(cuid())
  356. name String
  357. label String
  358. fieldType String @default("text")
  359. options String?
  360. required Boolean @default(false)
  361. entityType String
  362. sortOrder Int @default(0)
  363. isActive Boolean @default(true)
  364. createdAt DateTime @default(now())
  365. updatedAt DateTime @updatedAt
  366. userId String
  367. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  368. organizationId String?
  369. organization Organization? @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  370. values CustomFieldValue[]
  371. @@unique([organizationId, name, entityType])
  372. @@index([organizationId])
  373. @@map("custom_field_definitions")
  374. }
  375. model CustomFieldValue {
  376. id String @id @default(cuid())
  377. value String
  378. entityId String
  379. entityType String
  380. fieldId String
  381. field CustomFieldDefinition @relation(fields: [fieldId], references: [id], onDelete: Cascade)
  382. @@unique([fieldId, entityId])
  383. @@index([fieldId])
  384. @@map("custom_field_values")
  385. }
  386. model Organization {
  387. id String @id @default(cuid())
  388. name String
  389. createdAt DateTime @default(now())
  390. updatedAt DateTime @updatedAt
  391. members OrganizationMember[]
  392. roles Role[]
  393. vehicles Vehicle[]
  394. customers Customer[]
  395. quotes Quote[]
  396. inventoryParts InventoryPart[]
  397. customFieldDefinitions CustomFieldDefinition[]
  398. settings AppSetting[]
  399. subscription Subscription?
  400. invitations TeamInvitation[]
  401. @@map("organizations")
  402. }
  403. model OrganizationMember {
  404. id String @id @default(cuid())
  405. role String @default("member")
  406. userId String
  407. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  408. organizationId String
  409. organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  410. roleId String?
  411. customRole Role? @relation(fields: [roleId], references: [id], onDelete: SetNull)
  412. @@unique([userId, organizationId])
  413. @@map("organization_members")
  414. }
  415. model Role {
  416. id String @id @default(cuid())
  417. name String
  418. isAdmin Boolean @default(false)
  419. createdAt DateTime @default(now())
  420. updatedAt DateTime @updatedAt
  421. organizationId String
  422. organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  423. permissions Permission[]
  424. members OrganizationMember[]
  425. teamInvitations TeamInvitation[]
  426. @@unique([organizationId, name])
  427. @@map("roles")
  428. }
  429. model Permission {
  430. id String @id @default(cuid())
  431. action String
  432. subject String
  433. roleId String
  434. role Role @relation(fields: [roleId], references: [id], onDelete: Cascade)
  435. @@unique([roleId, action, subject])
  436. @@index([roleId])
  437. @@map("permissions")
  438. }
  439. model SystemSetting {
  440. id String @id @default(cuid())
  441. key String @unique
  442. value String
  443. @@map("system_settings")
  444. }
  445. model TeamInvitation {
  446. id String @id @default(cuid())
  447. email String
  448. role String @default("member")
  449. token String @unique
  450. status String @default("pending") // pending | accepted | cancelled
  451. expiresAt DateTime
  452. createdAt DateTime @default(now())
  453. organizationId String
  454. organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  455. invitedById String
  456. roleId String?
  457. customRole Role? @relation(fields: [roleId], references: [id], onDelete: SetNull)
  458. @@unique([email, organizationId])
  459. @@index([token])
  460. @@map("team_invitations")
  461. }
  462. // Stripe-ready models (implementation in follow-up)
  463. model SubscriptionPlan {
  464. id String @id @default(cuid())
  465. name String
  466. stripePriceId String? @unique
  467. price Float @default(0)
  468. interval String @default("month") // "month" | "year"
  469. maxMembers Int @default(1)
  470. features String? // JSON feature flags
  471. isActive Boolean @default(true)
  472. createdAt DateTime @default(now())
  473. updatedAt DateTime @updatedAt
  474. subscriptions Subscription[]
  475. @@map("subscription_plans")
  476. }
  477. model Subscription {
  478. id String @id @default(cuid())
  479. status String @default("active") // active | canceled | past_due | trialing
  480. stripeSubscriptionId String? @unique
  481. stripeCustomerId String?
  482. currentPeriodStart DateTime?
  483. currentPeriodEnd DateTime?
  484. cancelAtPeriodEnd Boolean @default(false)
  485. createdAt DateTime @default(now())
  486. updatedAt DateTime @updatedAt
  487. organizationId String @unique
  488. organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  489. planId String
  490. plan SubscriptionPlan @relation(fields: [planId], references: [id])
  491. @@map("subscriptions")
  492. }
  493. model RecurringInvoice {
  494. id String @id @default(cuid())
  495. title String
  496. description String?
  497. frequency String // "weekly" | "biweekly" | "monthly" | "quarterly" | "yearly"
  498. nextRunDate DateTime
  499. endDate DateTime?
  500. isActive Boolean @default(true)
  501. lastRunAt DateTime?
  502. runCount Int @default(0)
  503. // Template fields (copied to ServiceRecord on generation)
  504. type String @default("maintenance")
  505. cost Float @default(0)
  506. taxRate Float @default(0)
  507. invoiceNotes String?
  508. vehicleId String
  509. vehicle Vehicle @relation(fields: [vehicleId], references: [id], onDelete: Cascade)
  510. createdAt DateTime @default(now())
  511. updatedAt DateTime @updatedAt
  512. templateParts RecurringPart[]
  513. templateLabor RecurringLabor[]
  514. @@index([vehicleId])
  515. @@index([nextRunDate, isActive])
  516. @@map("recurring_invoices")
  517. }
  518. model RecurringPart {
  519. id String @id @default(cuid())
  520. name String
  521. partNumber String?
  522. quantity Int @default(1)
  523. unitPrice Float @default(0)
  524. recurringInvoiceId String
  525. recurringInvoice RecurringInvoice @relation(fields: [recurringInvoiceId], references: [id], onDelete: Cascade)
  526. @@map("recurring_parts")
  527. }
  528. model RecurringLabor {
  529. id String @id @default(cuid())
  530. description String
  531. hours Float @default(0)
  532. rate Float @default(0)
  533. recurringInvoiceId String
  534. recurringInvoice RecurringInvoice @relation(fields: [recurringInvoiceId], references: [id], onDelete: Cascade)
  535. @@map("recurring_labor")
  536. }