User ──┐
       ├──< Post >──< PostTag >──< Tag
       │     │
       │     ├──< Comment (트리 구조)
       │     └──< SeriesPost >──< Series
       └──< Comment

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

datasource db {
  provider = "sqlite"
}

model User {
  id        String    @id @default(cuid())
  name      String?
  email     String    @unique
  password  String?
  role      String    @default("ADMIN")
  bio       String?
  github    String?
  twitter   String?
  image     String?
  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt

  posts    Post[]
  comments Comment[]
}

model Post {
  id          String    @id @default(cuid())
  title       String
  slug        String    @unique
  excerpt     String?
  content     String
  coverImage  String?
  status      String    @default("DRAFT")  // DRAFT | PUBLISHED | ARCHIVED
  featured    Boolean   @default(false)
  pinned      Boolean   @default(false)
  viewCount   Int       @default(0)
  likeCount   Int       @default(0)
  readingTime Int?
  publishedAt DateTime?
  createdAt   DateTime  @default(now())
  updatedAt   DateTime  @updatedAt

  authorId   String
  author     User      @relation(fields: [authorId], references: [id])
  categoryId String?
  category   Category? @relation(fields: [categoryId], references: [id])

  tags     PostTag[]
  comments Comment[]
  series   SeriesPost[]
}

model PostTag {
  postId String
  tagId  String

  post Post @relation(fields: [postId], references: [id], onDelete: Cascade)
  tag  Tag  @relation(fields: [tagId], references: [id], onDelete: Cascade)

  @@id([postId, tagId])
}

model Comment {
  id        String   @id @default(cuid())
  content   String
  status    String   @default("PENDING")  // PENDING | APPROVED | REJECTED

  postId   String
  post     Post     @relation(fields: [postId], references: [id], onDelete: Cascade)
  authorId String?
  author   User?    @relation(fields: [authorId], references: [id], onDelete: SetNull)

  // 셀프 참조로 대댓글 구현
  parentId String?
  parent   Comment?  @relation("CommentReplies", fields: [parentId], references: [id], onDelete: Cascade)
  replies  Comment[] @relation("CommentReplies")
}

# 최초 마이그레이션
npx prisma migrate dev --name init

# 스키마 변경 후
npx prisma migrate dev --name add-series

# Prisma Client 재생성
npx prisma generate

// src/lib/prisma.ts
import { PrismaClient } from '@prisma/client'
import { PrismaBetterSqlite3 } from '@prisma/adapter-better-sqlite3'
import path from 'path'

const globalForPrisma = globalThis as unknown as { prisma: PrismaClient }

function createClient() {
  const url = `file:${path.join(process.cwd(), 'prisma/dev.db')}`
  const adapter = new PrismaBetterSqlite3({ url })
  return new PrismaClient({ adapter } as any)
}

export const prisma = globalForPrisma.prisma ?? createClient()

if (process.env.NODE_ENV !== 'production') {
  globalForPrisma.prisma = prisma
}

export function calcReadingTime(content: string): number {
  const words = content.trim().split(/\s+/).length
  return Math.max(1, Math.round(words / 200)) // 분당 200단어
}