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

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

model Customer {
  id              String        @id @default(uuid())
  companyId       String?       // Optional company identifier
  name            String
  email           String        @unique
  address         Json
  logoUrl         String?
  phoneNumber     String?
  vatNumber       String?
  companyNumber   String?
  representative  String
  status          CustomerStatus @default(active)

  bankAccounts    BankAccount[] // One-to-many relation
  invoicesSent    Invoice[] @relation("InvoiceFrom")
  invoicesReceived Invoice[] @relation("InvoiceTo")
}

model BankAccount {
  id             String   @id @default(uuid())
  customerId     String
  customer       Customer @relation(fields: [customerId], references: [id], onDelete: Cascade)
  accountNumber  String?
  bicSwift       String?
  iban           String?
  routingNumber  String?
  currency       Currency
}

model Service {
  id          String  @id @default(uuid())
  name        String
  sprintPrice Float
  hourPrice   Float
  monthPrice  Float

  invoiceItems InvoiceItem[]
}

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   Customer       @relation("InvoiceFrom", fields: [invoiceFromId], references: [id], onDelete: Cascade)

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

  items         InvoiceItem[]
}

model InvoiceItem {
  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)
}

// 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
}