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

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

model Product {
  id          Int      @id @default(autoincrement())
  barcode     String   @unique
  name        String
  cleanName   String
  amountRaw   String?
  amount      Float?
  unit        String?
  image       String?  @db.VarChar(1000)
  category    String?
  subcategory String?
  company     String?
  url         String   @unique @db.VarChar(500)
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt

  @@index([barcode])
  @@index([name])
}

model ScrapeQueue {
  id          Int      @id @default(autoincrement())
  url         String   @unique @db.VarChar(500)
  status      String   @default("pending") // pending, processing, completed, failed
  error       String?  @db.Text
  retryCount  Int      @default(0)
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt

  @@index([status])
}