source: prisma/schema.prisma@ 3c5302a

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

model Client {
  id              String        @id @default(uuid())
  tenantId        String       // Tenant identifier
  name            String
  email           String        @unique
  address         Json
  logoUrl         String?
  phoneNumber     String?
  vatNumber       String?
  companyNumber   String?
  representative  String
  status          CustomerStatus @default(active)

  tenant          Tenant        @relation(fields: [tenantId], references: [id], onDelete: Cascade)
  invoicesReceived Invoice[] @relation("InvoiceTo")
}

model Service {
  id          String  @id @default(uuid())
  name        String
  sprint      Float
  hour        Float
  month       Float
  tenantId    String
  tenant      Tenant   @relation(fields: [tenantId], references: [id], onDelete: Cascade)

  lineItems LineItem[]
}

model Invoice {
  id            String         @id @default(uuid())
  sent          Int?           // Number of times sent
  dueDate       DateTime
  status        InvoiceStatus
  currency      Currency
  quantityType  QuantityType
  subTotal      Float
  createDate    DateTime
  month         Month
  discount      Float?
  taxes         Float?
  totalAmount   Float
  invoiceNumber String         @unique
  pdfRef        String?

  invoiceFromId String
  invoiceFrom   Tenant        @relation(fields: [invoiceFromId], references: [id], onDelete: Cascade)

  invoiceToId   String
  invoiceTo     Client       @relation("InvoiceTo", fields: [invoiceToId], references: [id], onDelete: Cascade)

  items         LineItem[]
}

model LineItem {
  id          String   @id @default(uuid())
  title       String
  price       Float
  total       Float
  quantity    Int
  description String?
  serviceId   String
  service     Service   @relation(fields: [serviceId], references: [id], onDelete: Cascade)
  invoiceId   String
  invoice     Invoice   @relation(fields: [invoiceId], references: [id], onDelete: Cascade)
}

model Tenant {
  id                String    @id @default(cuid())
  name              String
  email             String    @unique
  address           Json      
  bankAccounts      Json?     
  logoUrl           String?
  phoneNumber       String?
  vatNumber         String?
  companyNumber     String?
  representative    String
  lastInvoiceNumber String    @default("0")
  createdAt         DateTime  @default(now())
  updatedAt         DateTime  @updatedAt
  invoicesSent      Invoice[]
  services          Service[]
  employees         Employee[]
  clients           Client[]  // Add the relation to clients
}

model Employee {
  id          String         @id @default(uuid())
  name        String
  email       String         @unique
  status      EmployeeStatus @default(active)
  iban        String?
  cv          String?
  photo       String?
  project     String?
  tenantId    String
  tenant      Tenant         @relation(fields: [tenantId], references: [id], onDelete: Cascade)
}

// Enums
enum CustomerStatus {
  active
  banned
  inactive
}

enum InvoiceStatus {
  draft
  processing
  pending
  overdue
  paid
}

enum Currency {
  EUR
  USD
}

enum QuantityType {
  Unit
  Hour
  Sprint
  Month
}

enum Month {
  January
  February
  March
  April
  May
  June
  July
  August
  September
  October
  November
  December
}

enum EmployeeStatus {
  active
  inactive
}