backend/prisma/schema.prisma

generator client {
  provider = "prisma-client-py"
  interface = "asyncio"
  recursive_type_depth = 5
}

datasource db {
  provider = "sqlite"
  url      = "file:./dev.db"
}

model Shop {
  id        String   @id @default(cuid())
  name      String
  url       String   @unique
  optOut    Boolean  @default(false)
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  products  Product[]
}

model Product {
  id           String   @id @default(cuid())
  shopId       String
  title        String
  price        Int
  thumbnailUrl String
  createdAt    DateTime @default(now())
  updatedAt    DateTime @updatedAt
  shop         Shop     @relation(fields: [shopId], references: [id])
  images       Image[]
}

model Image {
  id        String   @id @default(cuid())
  productId String
  imageUrl  String
  vectorId  String?  // ID in Qdrant
  createdAt DateTime @default(now())
  product   Product  @relation(fields: [productId], references: [id])
}

model User {
  id          String   @id @default(cuid())
  email       String   @unique
  stripeId    String?
  searchCount Int      @default(0)
  plan        String   @default("FREE")
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
}