Prisma Schema Visualizer & Documentation Generator

// Blog Platform Schema
datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

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

/// Represents a user who can write posts and comments
model User {
  /// Unique identifier for the user
  id        String   @id @default(cuid())
  /// User's email address, must be unique
  email     String   @unique
  /// Display name for the user (optional)
  name      String?
  /// All posts written by this user
  posts     Post[]
  /// All comments made by this user
  comments  Comment[]
  /// Account creation timestamp
  createdAt DateTime @default(now())
  /// Last update timestamp
  updatedAt DateTime @updatedAt
}

/// Blog post containing content and metadata
model Post {
  /// Unique identifier for the post
  id        String    @id @default(cuid())
  /// Post title
  title     String
  /// Post content in markdown or HTML
  content   String?
  /// Whether the post is published or draft
  published Boolean   @default(false)
  /// Post author
  author    User      @relation(fields: [authorId], references: [id])
  authorId  String
  /// Comments on this post
  comments  Comment[]
  /// Tags categorizing this post
  tags      Tag[]
  /// Post creation timestamp
  createdAt DateTime  @default(now())
  /// Last modification timestamp
  updatedAt DateTime  @updatedAt
}

/// User comment on a blog post
model Comment {
  /// Unique identifier for the comment
  id        String   @id @default(cuid())
  /// Comment text content
  content   String
  /// Post this comment belongs to
  post      Post     @relation(fields: [postId], references: [id])
  postId    String
  /// User who wrote the comment
  author    User     @relation(fields: [authorId], references: [id])
  authorId  String
  /// Comment creation timestamp
  createdAt DateTime @default(now())
}

/// Tag for categorizing posts
model Tag {
  /// Unique identifier for the tag
  id    String @id @default(cuid())
  /// Tag name (e.g., "Technology", "Tutorial")
  name  String @unique
  /// Posts with this tag
  posts Post[]
}