schema.prisma

datasource db {
  provider = "mongodb"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
  output   = "./node_modules/.prisma/client"
}

model User {
  id          String @id @default(auto()) @map("_id") @db.ObjectId
  name        String?
  email       String @unique
  password    String
  role        UserRole
  articles    Article[]
  createdAt   DateTime   @default(now())
  updatedAt   DateTime   @updatedAt

  @@map("users")
}

enum UserRole {
  admin
  writer
}

model Article {
  id          String @id @default(auto()) @map("_id") @db.ObjectId
  createdBy   User   @relation(fields: [author], references: [id])
  author      String @db.ObjectId
  title       String
  body        String
  published   Boolean @default(false)
  comments    Comment[]
  createdAt   DateTime   @default(now())
  updatedAt   DateTime   @updatedAt

  @@map("articles")
}

model Comment {
  id          String @id @default(auto()) @map("_id") @db.ObjectId
  articleId   String @db.ObjectId
  article     Article @relation(fields: [articleId], references: [id])
  author      String
  text        String

  @@map("comments")
}