schema.prisma

generator client {
  provider = "prisma-client"
  output   = "../src/lib/prisma"
}

datasource db {
  provider = "postgresql"
}

model User {
  id            String    @id @default(cuid())
  name          String
  email         String    @unique
  emailVerified Boolean   @default(false)
  image         String?
  createdAt     DateTime  @default(now())
  updatedAt     DateTime  @updatedAt

  accounts      Account[]
  sessions      Session[]
  profile       UserProfile?
  apiKeys       ApiKey[]
  posts         Post[]
}

model Session {
  id        String   @id @default(cuid())
  token     String   @unique
  userId    String
  expiresAt DateTime
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  ipAddress String?
  userAgent String?

  user User @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@index([userId])
}

model Account {
  id                String  @id @default(cuid())
  userId            String
  providerId        String
  accountId         String
  accessToken       String?
  refreshToken      String?
  idToken           String?
  accessTokenExpiresAt DateTime?
  refreshTokenExpiresAt DateTime?
  scope             String?
  password          String?
  createdAt       DateTime  @default(now())
  updatedAt       DateTime  @updatedAt

  user User @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@index([userId])
}

model Verification {
  id         String   @id @default(cuid())
  identifier String
  value      String
  expiresAt  DateTime
  createdAt  DateTime @default(now())
  updatedAt  DateTime @updatedAt

  @@index([identifier])
}

model UserProfile {
  id        String   @id @default(cuid())
  role      Role     @default(AGENT)
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  userId    String   @unique

  user User @relation(fields: [userId], references: [id], onDelete: Cascade)
}

enum Role {
  ADMIN
  AUTHOR
  AGENT
  GUEST
}

model ApiKey {
  id        String    @id @default(cuid())
  key       String    @unique
  name      String
  userId    String
  createdAt DateTime  @default(now())
  expiresAt DateTime?

  user User @relation(fields: [userId], references: [id], onDelete: Cascade)
}

model Post {
  id            String        @id @default(cuid())
  title         String
  slug          String        @unique
  bodyMarkdown  String
  bodyHtml      String
  visibility    Visibility    @default(PUBLIC)
  authorId      String
  publishedAt   DateTime?
  createdAt     DateTime      @default(now())
  updatedAt     DateTime      @updatedAt

  author        User          @relation(fields: [authorId], references: [id], onDelete: Cascade)
  metadata      PostMetadata?
  pageViews     PageView[]

  @@index([title(ops: raw("gin_trgm_ops"))], type: Gin, name: "Post_title_trgm_idx")
  @@index([slug(ops: raw("gin_trgm_ops"))], type: Gin, name: "Post_slug_trgm_idx")
}

enum Visibility {
  PUBLIC
  PRIVATE
  UNLISTED
  DRAFT
}

model PostMetadata {
  id           String   @id @default(cuid())
  seoDescription String?
  coverImage   String?
  tags         String[]
  postId       String   @unique

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

  @@index([tags], type: Gin, name: "PostMetadata_tags_gin_idx")
}

model SiteSettings {
  id    String @id @default(cuid())
  key   String @unique
  value String
}

model PageView {
  id        String   @id @default(cuid())
  path      String
  referrer  String?
  userAgent String?
  ipHash    String?
  postId    String?
  createdAt DateTime @default(now())

  post Post? @relation(fields: [postId], references: [id], onDelete: SetNull)

  @@index([path])
  @@index([postId])
  @@index([createdAt])
}