schema.prisma 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788
  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. maintenanceDismissed Boolean @default(false)
  109. maintenanceDismissedAt DateTime?
  110. createdAt DateTime @default(now())
  111. updatedAt DateTime @updatedAt
  112. userId String
  113. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  114. organizationId String?
  115. organization Organization? @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  116. customerId String?
  117. customer Customer? @relation(fields: [customerId], references: [id], onDelete: SetNull)
  118. serviceRecords ServiceRecord[]
  119. notes Note[]
  120. fuelLogs FuelLog[]
  121. reminders Reminder[]
  122. quotes Quote[]
  123. recurringInvoices RecurringInvoice[]
  124. inspections Inspection[]
  125. @@index([organizationId])
  126. @@map("vehicles")
  127. }
  128. model ServiceRecord {
  129. id String @id @default(cuid())
  130. title String
  131. description String?
  132. type String @default("maintenance")
  133. status String @default("completed")
  134. cost Float @default(0)
  135. mileage Int?
  136. serviceDate DateTime @default(now())
  137. shopName String?
  138. techName String?
  139. parts String?
  140. laborHours Float?
  141. diagnosticNotes String?
  142. invoiceNotes String?
  143. subtotal Float @default(0)
  144. taxRate Float @default(0)
  145. taxAmount Float @default(0)
  146. totalAmount Float @default(0)
  147. invoiceNumber String?
  148. discountType String?
  149. discountValue Float @default(0)
  150. discountAmount Float @default(0)
  151. manuallyPaid Boolean @default(false)
  152. publicToken String? @unique
  153. createdAt DateTime @default(now())
  154. updatedAt DateTime @updatedAt
  155. vehicleId String
  156. vehicle Vehicle @relation(fields: [vehicleId], references: [id], onDelete: Cascade)
  157. partItems ServicePart[]
  158. laborItems ServiceLabor[]
  159. attachments ServiceAttachment[]
  160. payments Payment[]
  161. @@index([vehicleId])
  162. @@map("service_records")
  163. }
  164. model Note {
  165. id String @id @default(cuid())
  166. title String
  167. content String
  168. isPinned Boolean @default(false)
  169. createdAt DateTime @default(now())
  170. updatedAt DateTime @updatedAt
  171. vehicleId String
  172. vehicle Vehicle @relation(fields: [vehicleId], references: [id], onDelete: Cascade)
  173. @@index([vehicleId])
  174. @@map("notes")
  175. }
  176. model FuelLog {
  177. id String @id @default(cuid())
  178. date DateTime @default(now())
  179. mileage Int
  180. gallons Float
  181. pricePerGallon Float
  182. totalCost Float
  183. isFillUp Boolean @default(true)
  184. station String?
  185. notes String?
  186. createdAt DateTime @default(now())
  187. updatedAt DateTime @updatedAt
  188. vehicleId String
  189. vehicle Vehicle @relation(fields: [vehicleId], references: [id], onDelete: Cascade)
  190. @@index([vehicleId])
  191. @@map("fuel_logs")
  192. }
  193. model Reminder {
  194. id String @id @default(cuid())
  195. title String
  196. description String?
  197. dueDate DateTime?
  198. dueMileage Int?
  199. isCompleted Boolean @default(false)
  200. createdAt DateTime @default(now())
  201. updatedAt DateTime @updatedAt
  202. vehicleId String
  203. vehicle Vehicle @relation(fields: [vehicleId], references: [id], onDelete: Cascade)
  204. @@index([vehicleId])
  205. @@map("reminders")
  206. }
  207. model Customer {
  208. id String @id @default(cuid())
  209. name String
  210. email String?
  211. phone String?
  212. address String?
  213. company String?
  214. notes String?
  215. createdAt DateTime @default(now())
  216. updatedAt DateTime @updatedAt
  217. userId String
  218. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  219. organizationId String?
  220. organization Organization? @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  221. vehicles Vehicle[]
  222. quotes Quote[]
  223. @@index([organizationId])
  224. @@map("customers")
  225. }
  226. model Payment {
  227. id String @id @default(cuid())
  228. amount Float
  229. date DateTime @default(now())
  230. method String @default("other")
  231. note String?
  232. provider String?
  233. externalId String?
  234. createdAt DateTime @default(now())
  235. updatedAt DateTime @updatedAt
  236. serviceRecordId String
  237. serviceRecord ServiceRecord @relation(fields: [serviceRecordId], references: [id], onDelete: Cascade)
  238. @@index([serviceRecordId])
  239. @@map("payments")
  240. }
  241. model ServiceAttachment {
  242. id String @id @default(cuid())
  243. fileName String
  244. fileUrl String
  245. fileType String
  246. fileSize Int
  247. category String @default("diagnostic")
  248. description String?
  249. includeInInvoice Boolean @default(true)
  250. createdAt DateTime @default(now())
  251. serviceRecordId String
  252. serviceRecord ServiceRecord @relation(fields: [serviceRecordId], references: [id], onDelete: Cascade)
  253. @@index([serviceRecordId])
  254. @@map("service_attachments")
  255. }
  256. model ServicePart {
  257. id String @id @default(cuid())
  258. partNumber String?
  259. name String
  260. quantity Float @default(1)
  261. unitPrice Float @default(0)
  262. total Float @default(0)
  263. serviceRecordId String
  264. serviceRecord ServiceRecord @relation(fields: [serviceRecordId], references: [id], onDelete: Cascade)
  265. @@index([serviceRecordId])
  266. @@map("service_parts")
  267. }
  268. model ServiceLabor {
  269. id String @id @default(cuid())
  270. description String
  271. hours Float @default(0)
  272. rate Float @default(0)
  273. total Float @default(0)
  274. serviceRecordId String
  275. serviceRecord ServiceRecord @relation(fields: [serviceRecordId], references: [id], onDelete: Cascade)
  276. @@index([serviceRecordId])
  277. @@map("service_labor")
  278. }
  279. model InventoryPart {
  280. id String @id @default(cuid())
  281. partNumber String?
  282. name String
  283. description String?
  284. category String?
  285. quantity Int @default(0)
  286. minQuantity Int @default(0)
  287. unitCost Float @default(0)
  288. sellPrice Float @default(0)
  289. supplier String?
  290. supplierPhone String?
  291. supplierEmail String?
  292. supplierUrl String?
  293. imageUrl String?
  294. location String?
  295. isArchived Boolean @default(false)
  296. createdAt DateTime @default(now())
  297. updatedAt DateTime @updatedAt
  298. userId String
  299. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  300. organizationId String?
  301. organization Organization? @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  302. @@index([organizationId])
  303. @@map("inventory_parts")
  304. }
  305. model Quote {
  306. id String @id @default(cuid())
  307. quoteNumber String?
  308. title String
  309. description String?
  310. status String @default("draft")
  311. validUntil DateTime?
  312. subtotal Float @default(0)
  313. taxRate Float @default(0)
  314. taxAmount Float @default(0)
  315. discountType String?
  316. discountValue Float @default(0)
  317. discountAmount Float @default(0)
  318. totalAmount Float @default(0)
  319. notes String?
  320. publicToken String?
  321. customerMessage String?
  322. convertedToId String?
  323. createdAt DateTime @default(now())
  324. updatedAt DateTime @updatedAt
  325. userId String
  326. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  327. organizationId String?
  328. organization Organization? @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  329. customerId String?
  330. customer Customer? @relation(fields: [customerId], references: [id], onDelete: SetNull)
  331. vehicleId String?
  332. vehicle Vehicle? @relation(fields: [vehicleId], references: [id], onDelete: SetNull)
  333. inspectionId String?
  334. inspection Inspection? @relation(fields: [inspectionId], references: [id], onDelete: SetNull)
  335. partItems QuotePart[]
  336. laborItems QuoteLabor[]
  337. @@index([organizationId])
  338. @@map("quotes")
  339. }
  340. model QuotePart {
  341. id String @id @default(cuid())
  342. partNumber String?
  343. name String
  344. quantity Float @default(1)
  345. unitPrice Float @default(0)
  346. total Float @default(0)
  347. quoteId String
  348. quote Quote @relation(fields: [quoteId], references: [id], onDelete: Cascade)
  349. @@index([quoteId])
  350. @@map("quote_parts")
  351. }
  352. model QuoteLabor {
  353. id String @id @default(cuid())
  354. description String
  355. hours Float @default(0)
  356. rate Float @default(0)
  357. total Float @default(0)
  358. quoteId String
  359. quote Quote @relation(fields: [quoteId], references: [id], onDelete: Cascade)
  360. @@index([quoteId])
  361. @@map("quote_labor")
  362. }
  363. model CustomFieldDefinition {
  364. id String @id @default(cuid())
  365. name String
  366. label String
  367. fieldType String @default("text")
  368. options String?
  369. required Boolean @default(false)
  370. entityType String
  371. sortOrder Int @default(0)
  372. isActive Boolean @default(true)
  373. createdAt DateTime @default(now())
  374. updatedAt DateTime @updatedAt
  375. userId String
  376. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  377. organizationId String?
  378. organization Organization? @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  379. values CustomFieldValue[]
  380. @@unique([organizationId, name, entityType])
  381. @@index([organizationId])
  382. @@map("custom_field_definitions")
  383. }
  384. model CustomFieldValue {
  385. id String @id @default(cuid())
  386. value String
  387. entityId String
  388. entityType String
  389. fieldId String
  390. field CustomFieldDefinition @relation(fields: [fieldId], references: [id], onDelete: Cascade)
  391. @@unique([fieldId, entityId])
  392. @@index([fieldId])
  393. @@map("custom_field_values")
  394. }
  395. model Organization {
  396. id String @id @default(cuid())
  397. name String
  398. createdAt DateTime @default(now())
  399. updatedAt DateTime @updatedAt
  400. members OrganizationMember[]
  401. roles Role[]
  402. vehicles Vehicle[]
  403. customers Customer[]
  404. quotes Quote[]
  405. inventoryParts InventoryPart[]
  406. customFieldDefinitions CustomFieldDefinition[]
  407. settings AppSetting[]
  408. subscription Subscription?
  409. invitations TeamInvitation[]
  410. inspectionTemplates InspectionTemplate[]
  411. @@map("organizations")
  412. }
  413. model OrganizationMember {
  414. id String @id @default(cuid())
  415. role String @default("member")
  416. userId String
  417. user User @relation(fields: [userId], references: [id], onDelete: Cascade)
  418. organizationId String
  419. organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  420. roleId String?
  421. customRole Role? @relation(fields: [roleId], references: [id], onDelete: SetNull)
  422. @@unique([userId, organizationId])
  423. @@map("organization_members")
  424. }
  425. model Role {
  426. id String @id @default(cuid())
  427. name String
  428. isAdmin Boolean @default(false)
  429. createdAt DateTime @default(now())
  430. updatedAt DateTime @updatedAt
  431. organizationId String
  432. organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  433. permissions Permission[]
  434. members OrganizationMember[]
  435. teamInvitations TeamInvitation[]
  436. @@unique([organizationId, name])
  437. @@map("roles")
  438. }
  439. model Permission {
  440. id String @id @default(cuid())
  441. action String
  442. subject String
  443. roleId String
  444. role Role @relation(fields: [roleId], references: [id], onDelete: Cascade)
  445. @@unique([roleId, action, subject])
  446. @@index([roleId])
  447. @@map("permissions")
  448. }
  449. model SystemSetting {
  450. id String @id @default(cuid())
  451. key String @unique
  452. value String
  453. @@map("system_settings")
  454. }
  455. model TeamInvitation {
  456. id String @id @default(cuid())
  457. email String
  458. role String @default("member")
  459. token String @unique
  460. status String @default("pending") // pending | accepted | cancelled
  461. expiresAt DateTime
  462. createdAt DateTime @default(now())
  463. organizationId String
  464. organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  465. invitedById String
  466. roleId String?
  467. customRole Role? @relation(fields: [roleId], references: [id], onDelete: SetNull)
  468. @@unique([email, organizationId])
  469. @@index([token])
  470. @@map("team_invitations")
  471. }
  472. // Stripe-ready models (implementation in follow-up)
  473. model SubscriptionPlan {
  474. id String @id @default(cuid())
  475. name String
  476. stripePriceId String? @unique
  477. price Float @default(0)
  478. interval String @default("month") // "month" | "year"
  479. maxMembers Int @default(1)
  480. features String? // JSON feature flags
  481. isActive Boolean @default(true)
  482. createdAt DateTime @default(now())
  483. updatedAt DateTime @updatedAt
  484. subscriptions Subscription[]
  485. @@map("subscription_plans")
  486. }
  487. model Subscription {
  488. id String @id @default(cuid())
  489. status String @default("active") // active | canceled | past_due | trialing
  490. stripeSubscriptionId String? @unique
  491. stripeCustomerId String?
  492. currentPeriodStart DateTime?
  493. currentPeriodEnd DateTime?
  494. cancelAtPeriodEnd Boolean @default(false)
  495. createdAt DateTime @default(now())
  496. updatedAt DateTime @updatedAt
  497. organizationId String @unique
  498. organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  499. planId String
  500. plan SubscriptionPlan @relation(fields: [planId], references: [id])
  501. @@map("subscriptions")
  502. }
  503. model RecurringInvoice {
  504. id String @id @default(cuid())
  505. title String
  506. description String?
  507. frequency String // "weekly" | "biweekly" | "monthly" | "quarterly" | "yearly"
  508. nextRunDate DateTime
  509. endDate DateTime?
  510. isActive Boolean @default(true)
  511. lastRunAt DateTime?
  512. runCount Int @default(0)
  513. // Template fields (copied to ServiceRecord on generation)
  514. type String @default("maintenance")
  515. cost Float @default(0)
  516. taxRate Float @default(0)
  517. invoiceNotes String?
  518. vehicleId String
  519. vehicle Vehicle @relation(fields: [vehicleId], references: [id], onDelete: Cascade)
  520. createdAt DateTime @default(now())
  521. updatedAt DateTime @updatedAt
  522. templateParts RecurringPart[]
  523. templateLabor RecurringLabor[]
  524. @@index([vehicleId])
  525. @@index([nextRunDate, isActive])
  526. @@map("recurring_invoices")
  527. }
  528. model RecurringPart {
  529. id String @id @default(cuid())
  530. name String
  531. partNumber String?
  532. quantity Int @default(1)
  533. unitPrice Float @default(0)
  534. recurringInvoiceId String
  535. recurringInvoice RecurringInvoice @relation(fields: [recurringInvoiceId], references: [id], onDelete: Cascade)
  536. @@map("recurring_parts")
  537. }
  538. model RecurringLabor {
  539. id String @id @default(cuid())
  540. description String
  541. hours Float @default(0)
  542. rate Float @default(0)
  543. recurringInvoiceId String
  544. recurringInvoice RecurringInvoice @relation(fields: [recurringInvoiceId], references: [id], onDelete: Cascade)
  545. @@map("recurring_labor")
  546. }
  547. model InspectionTemplate {
  548. id String @id @default(cuid())
  549. name String
  550. description String?
  551. isDefault Boolean @default(false)
  552. createdAt DateTime @default(now())
  553. updatedAt DateTime @updatedAt
  554. organizationId String
  555. organization Organization @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  556. sections InspectionTemplateSection[]
  557. inspections Inspection[]
  558. @@index([organizationId])
  559. @@map("inspection_templates")
  560. }
  561. model InspectionTemplateSection {
  562. id String @id @default(cuid())
  563. name String
  564. sortOrder Int @default(0)
  565. templateId String
  566. template InspectionTemplate @relation(fields: [templateId], references: [id], onDelete: Cascade)
  567. items InspectionTemplateItem[]
  568. @@index([templateId])
  569. @@map("inspection_template_sections")
  570. }
  571. model InspectionTemplateItem {
  572. id String @id @default(cuid())
  573. name String
  574. sortOrder Int @default(0)
  575. sectionId String
  576. section InspectionTemplateSection @relation(fields: [sectionId], references: [id], onDelete: Cascade)
  577. @@index([sectionId])
  578. @@map("inspection_template_items")
  579. }
  580. model Inspection {
  581. id String @id @default(cuid())
  582. status String @default("in_progress")
  583. mileage Int?
  584. notes String?
  585. publicToken String? @unique
  586. completedAt DateTime?
  587. createdAt DateTime @default(now())
  588. updatedAt DateTime @updatedAt
  589. vehicleId String
  590. vehicle Vehicle @relation(fields: [vehicleId], references: [id], onDelete: Cascade)
  591. templateId String
  592. template InspectionTemplate @relation(fields: [templateId], references: [id])
  593. technicianId String
  594. organizationId String
  595. items InspectionItem[]
  596. quoteRequests InspectionQuoteRequest[]
  597. quotes Quote[]
  598. @@index([vehicleId])
  599. @@index([organizationId])
  600. @@map("inspections")
  601. }
  602. model InspectionItem {
  603. id String @id @default(cuid())
  604. name String
  605. section String
  606. sortOrder Int @default(0)
  607. condition String @default("not_inspected")
  608. notes String?
  609. imageUrls String[] @default([])
  610. inspectionId String
  611. inspection Inspection @relation(fields: [inspectionId], references: [id], onDelete: Cascade)
  612. @@index([inspectionId])
  613. @@map("inspection_items")
  614. }
  615. model InspectionQuoteRequest {
  616. id String @id @default(cuid())
  617. status String @default("pending")
  618. message String?
  619. selectedItemIds String[]
  620. createdAt DateTime @default(now())
  621. inspectionId String
  622. inspection Inspection @relation(fields: [inspectionId], references: [id], onDelete: Cascade)
  623. organizationId String
  624. @@index([organizationId])
  625. @@index([inspectionId])
  626. @@map("inspection_quote_requests")
  627. }
  628. model Notification {
  629. id String @id @default(cuid())
  630. type String
  631. title String
  632. message String
  633. entityType String
  634. entityId String
  635. entityUrl String
  636. read Boolean @default(false)
  637. organizationId String
  638. createdAt DateTime @default(now())
  639. @@index([organizationId, createdAt(sort: Desc)])
  640. @@index([organizationId, read])
  641. @@map("notifications")
  642. }