| 1 | generator client {
|
|---|
| 2 | provider = "prisma-client-js"
|
|---|
| 3 | }
|
|---|
| 4 |
|
|---|
| 5 | datasource db {
|
|---|
| 6 | provider = "postgresql"
|
|---|
| 7 | url = env("DATABASE_URL")
|
|---|
| 8 | }
|
|---|
| 9 |
|
|---|
| 10 | model Client {
|
|---|
| 11 | id String @id @default(uuid())
|
|---|
| 12 | tenantId String // Tenant identifier
|
|---|
| 13 | name String
|
|---|
| 14 | email String @unique
|
|---|
| 15 | address Json
|
|---|
| 16 | logoUrl String?
|
|---|
| 17 | phoneNumber String?
|
|---|
| 18 | vatNumber String?
|
|---|
| 19 | companyNumber String?
|
|---|
| 20 | representative String
|
|---|
| 21 | status CustomerStatus @default(active)
|
|---|
| 22 |
|
|---|
| 23 | tenant Tenant @relation(fields: [tenantId], references: [id], onDelete: Cascade)
|
|---|
| 24 | invoicesReceived Invoice[] @relation("InvoiceTo")
|
|---|
| 25 | }
|
|---|
| 26 |
|
|---|
| 27 | model Service {
|
|---|
| 28 | id String @id @default(uuid())
|
|---|
| 29 | name String
|
|---|
| 30 | sprint Float
|
|---|
| 31 | hour Float
|
|---|
| 32 | month Float
|
|---|
| 33 | tenantId String
|
|---|
| 34 | tenant Tenant @relation(fields: [tenantId], references: [id], onDelete: Cascade)
|
|---|
| 35 |
|
|---|
| 36 | lineItems LineItem[]
|
|---|
| 37 | }
|
|---|
| 38 |
|
|---|
| 39 | model Invoice {
|
|---|
| 40 | id String @id @default(uuid())
|
|---|
| 41 | sent Int? // Number of times sent
|
|---|
| 42 | dueDate DateTime
|
|---|
| 43 | status InvoiceStatus
|
|---|
| 44 | currency Currency
|
|---|
| 45 | quantityType QuantityType
|
|---|
| 46 | subTotal Float
|
|---|
| 47 | createDate DateTime
|
|---|
| 48 | month Month
|
|---|
| 49 | discount Float?
|
|---|
| 50 | taxes Float?
|
|---|
| 51 | totalAmount Float
|
|---|
| 52 | invoiceNumber String @unique
|
|---|
| 53 | pdfRef String?
|
|---|
| 54 |
|
|---|
| 55 | invoiceFromId String
|
|---|
| 56 | invoiceFrom Tenant @relation(fields: [invoiceFromId], references: [id], onDelete: Cascade)
|
|---|
| 57 |
|
|---|
| 58 | invoiceToId String
|
|---|
| 59 | invoiceTo Client @relation("InvoiceTo", fields: [invoiceToId], references: [id], onDelete: Cascade)
|
|---|
| 60 |
|
|---|
| 61 | items LineItem[]
|
|---|
| 62 | }
|
|---|
| 63 |
|
|---|
| 64 | model LineItem {
|
|---|
| 65 | id String @id @default(uuid())
|
|---|
| 66 | title String
|
|---|
| 67 | price Float
|
|---|
| 68 | total Float
|
|---|
| 69 | quantity Int
|
|---|
| 70 | description String?
|
|---|
| 71 | serviceId String
|
|---|
| 72 | service Service @relation(fields: [serviceId], references: [id], onDelete: Cascade)
|
|---|
| 73 | invoiceId String
|
|---|
| 74 | invoice Invoice @relation(fields: [invoiceId], references: [id], onDelete: Cascade)
|
|---|
| 75 | }
|
|---|
| 76 |
|
|---|
| 77 | model Tenant {
|
|---|
| 78 | id String @id @default(cuid())
|
|---|
| 79 | name String
|
|---|
| 80 | email String @unique
|
|---|
| 81 | address Json
|
|---|
| 82 | bankAccounts Json?
|
|---|
| 83 | logoUrl String?
|
|---|
| 84 | phoneNumber String?
|
|---|
| 85 | vatNumber String?
|
|---|
| 86 | companyNumber String?
|
|---|
| 87 | representative String
|
|---|
| 88 | lastInvoiceNumber String @default("0")
|
|---|
| 89 | createdAt DateTime @default(now())
|
|---|
| 90 | updatedAt DateTime @updatedAt
|
|---|
| 91 | invoicesSent Invoice[]
|
|---|
| 92 | services Service[]
|
|---|
| 93 | employees Employee[]
|
|---|
| 94 | clients Client[] // Add the relation to clients
|
|---|
| 95 | }
|
|---|
| 96 |
|
|---|
| 97 | model Employee {
|
|---|
| 98 | id String @id @default(uuid())
|
|---|
| 99 | name String
|
|---|
| 100 | email String @unique
|
|---|
| 101 | status EmployeeStatus @default(active)
|
|---|
| 102 | iban String?
|
|---|
| 103 | cv String?
|
|---|
| 104 | photo String?
|
|---|
| 105 | project String?
|
|---|
| 106 | tenantId String
|
|---|
| 107 | tenant Tenant @relation(fields: [tenantId], references: [id], onDelete: Cascade)
|
|---|
| 108 | }
|
|---|
| 109 |
|
|---|
| 110 | // Enums
|
|---|
| 111 | enum CustomerStatus {
|
|---|
| 112 | active
|
|---|
| 113 | banned
|
|---|
| 114 | inactive
|
|---|
| 115 | }
|
|---|
| 116 |
|
|---|
| 117 | enum InvoiceStatus {
|
|---|
| 118 | draft
|
|---|
| 119 | processing
|
|---|
| 120 | pending
|
|---|
| 121 | overdue
|
|---|
| 122 | paid
|
|---|
| 123 | }
|
|---|
| 124 |
|
|---|
| 125 | enum Currency {
|
|---|
| 126 | EUR
|
|---|
| 127 | USD
|
|---|
| 128 | }
|
|---|
| 129 |
|
|---|
| 130 | enum QuantityType {
|
|---|
| 131 | Unit
|
|---|
| 132 | Hour
|
|---|
| 133 | Sprint
|
|---|
| 134 | Month
|
|---|
| 135 | }
|
|---|
| 136 |
|
|---|
| 137 | enum Month {
|
|---|
| 138 | January
|
|---|
| 139 | February
|
|---|
| 140 | March
|
|---|
| 141 | April
|
|---|
| 142 | May
|
|---|
| 143 | June
|
|---|
| 144 | July
|
|---|
| 145 | August
|
|---|
| 146 | September
|
|---|
| 147 | October
|
|---|
| 148 | November
|
|---|
| 149 | December
|
|---|
| 150 | }
|
|---|
| 151 |
|
|---|
| 152 | enum EmployeeStatus {
|
|---|
| 153 | active
|
|---|
| 154 | inactive
|
|---|
| 155 | }
|
|---|
