schema.prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

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

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

model scrapeProgress {
  category      String @id
  newestScraped String @default("2000-01-01 00:00:00")
  oldestScraped String @default("9999-12-31 23:59:59")
}

model PixivArticle {
  tag_name           String  @id
  summary            String
  updated_at         String
  main_illst_url     String
  view_count         Int
  illust_count       Int
  check_count        Int
  related_tags       String
  parent             String?
  lastScraped        String
  reading            String?
  header             String?
  mainText           String?
  lastScrapedReading String? // Unused
  lastScrapedArticle String?
}