schema.prisma

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

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

model User {
  id       Int       @id @default(autoincrement())
  email    String    @unique
  name     String?
  posts    Post[]
  comments Comment[]
}

model Post {
  id        Int       @id @default(autoincrement())
  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt
  title     String
  content   String?
  published Boolean   @default(false)
  viewCount Int       @default(0)
  author    User?     @relation(fields: [authorId], references: [id])
  authorId  Int?
  comments  Comment[]
  typing    Boolean?
}

model Comment {
  id         Int      @id @default(autoincrement())
  createedAt DateTime @default(now())
  updatedAt  DateTime @updatedAt
  content    String?
  author     User?    @relation(fields: [authorId], references: [id])
  authorId   Int?
  post       Post?    @relation(fields: [postId], references: [id])
  postId     Int?
}