box-nestjs-monorepo/prisma/mysql/schema/main.prisma

// prisma/mysql/schema/main.schema
generator client {
  provider        = "prisma-client-js"
  output          = "./../../../node_modules/@prisma/mysql/client"
  previewFeatures = ["prismaSchemaFolder"]
}

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


model ProviderVideoSync {
  id                   Int     @id @default(autoincrement())
  providerCode         String  // e.g. RVAKC
  providerVideoId      String
  videoMediaId         String  // Mongo ObjectId as plain string
  lastProviderUpdatedAt BigInt
  lastSyncedAt         BigInt
  syncStatus           Int     @default(0) // 0=PENDING, 1=OK, 2=FAILED
  lastError            String? @db.VarChar(500)
}