schema.prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

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

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

model User {
  id             String    @id @default(uuid())
  walletAddress  String    @unique
  nonce          String?
  nonceExpiresAt DateTime?
  createdAt      DateTime  @default(now())
  updatedAt      DateTime  @updatedAt
  invoices       Invoice[]
  payments       Payment[]
  notifications  Notification[]
}

model Invoice {
  id            String     @id @default(uuid())
  userId        String
  user          User       @relation(fields: [userId], references: [id])
  invoiceNumber String     @unique
  clientName    String
  clientEmail   String?
  currency      String?
  status        String     @default("draft")
  items         Json
  subtotal      Decimal
  tax           Decimal
  total         Decimal
  createdAt     DateTime   @default(now())
  updatedAt     DateTime   @updatedAt
  payments      Payment[]
}

model Payment {
  id              String   @id @default(uuid())
  invoiceId       String
  invoice         Invoice  @relation(fields: [invoiceId], references: [id])
  userId          String
  user            User     @relation(fields: [userId], references: [id])
  merchantAddress String?
  token           String
  amount          String
  transactionHash String?
  status          String   @default("pending")
  createdAt       DateTime @default(now())
  updatedAt       DateTime @updatedAt
}

model Notification {
  id          String   @id @default(uuid())
  userId      String
  user        User     @relation(fields: [userId], references: [id])
  title       String
  description String?
  type        String?
  read        Boolean  @default(false)
  metadata    Json?
  createdAt   DateTime @default(now())
}