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

datasource db {
  provider = "sqlite"
}

model User {
  id                 String              @id @default(cuid())
  email              String              @unique
  name               String
  password           String
  role               String              @default("gestionnaire")
  createdAt          DateTime            @default(now())
  syncRuns           SyncRun[]
  productCreations   ProductCreation[]
}

model SyncRun {
  id          String   @id @default(cuid())
  createdAt   DateTime @default(now())
  userId      String
  user        User     @relation(fields: [userId], references: [id])
  status      String
  created     Int      @default(0)
  updated     Int      @default(0)
  deactivated Int      @default(0)
  errors      Int      @default(0)
  log         String   @default("[]")
}

model ProductCreation {
  id           String   @id @default(cuid())
  createdAt    DateTime @default(now())
  userId       String
  user         User     @relation(fields: [userId], references: [id])
  sheetTab     String
  sheetRow     Int
  shopifyId    String
  sku          String
  title        String
  status       String   @default("success")
  errorMessage String   @default("")
}