schema.prisma 18 KB

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