schema.prisma

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

datasource db {
  provider  = "postgresql"
  url       = env("STARC_POSTGRES_PRISMA_URL") // Uses connection pooling
  directUrl = env("STARC_POSTGRES_URL_NON_POOLING") // Uses direct connection
}

model Merchant {
  id            String   @id @default(cuid())
  slug          String   @unique // e.g. "starbucks", "tesla"
  name          String
  description   String?
  walletAddress String   // Circle Wallet ID or EVM Address
  logoUrl       String?
  createdAt     DateTime @default(now())
  updatedAt     DateTime @updatedAt

  @@index([slug])
  paymentRequests PaymentRequest[]
}

model PaymentRequest {
  id          String   @id @default(cuid())
  merchantId  String
  merchant    Merchant @relation(fields: [merchantId], references: [id])
  amount      Decimal  @db.Decimal(18, 6)
  currency    String   @default("USDC")
  status      String   @default("PENDING") // PENDING, COMPLETED, FAILED
  txHash      String?
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt

  @@index([merchantId])
}

model Employee {
  id                String               @id @default(cuid())
  name              String
  walletAddress     String               @unique
  position          String?
  payrollAmount     Decimal              @db.Decimal(18, 6) @default(0.25)
  active            Boolean              @default(true)
  createdAt         DateTime             @default(now())
  updatedAt         DateTime             @updatedAt
  payrollReceipts   PayrollReceipt[]

  @@index([walletAddress])
  @@index([active])
}

model PayrollReceipt {
  id              String    @id @default(cuid())
  employeeId      String
  employee        Employee  @relation(fields: [employeeId], references: [id])
  amount          Decimal   @db.Decimal(18, 6)
  currency        String    @default("USDC")
  status          String    @default("PENDING") // PENDING, COMPLETED, FAILED
  txHash          String?
  paidAt          DateTime?
  createdAt       DateTime  @default(now())
  updatedAt       DateTime  @updatedAt

  @@index([employeeId])
  @@index([status])
  @@index([createdAt])
}