schema.prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

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

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

model Post {
  id          String   @id @default(cuid())
  contentHash String   @unique
  title       String?
  content     String
  url         String?
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt

  // Relations
  postPlatforms PostPlatform[]

  @@map("posts")
}

model Platform {
  id          String @id @default(cuid())
  name        String @unique // mastodon, bluesky, reddit, discord
  displayName String
  createdAt   DateTime @default(now())

  // Relations
  postPlatforms PostPlatform[]

  @@map("platforms")
}

model PostPlatform {
  id        String   @id @default(cuid())
  postId    String
  platformId String
  postUrl   String?  // URL of the post on the platform
  postedAt  DateTime @default(now())

  // Relations
  post      Post     @relation(fields: [postId], references: [id], onDelete: Cascade)
  platform  Platform @relation(fields: [platformId], references: [id], onDelete: Cascade)
  analytics PostAnalytics[] // Relation to analytics

  @@unique([postId, platformId])
  @@map("post_platforms")
}

model PostAnalytics {
  id              String   @id @default(cuid())
  postPlatformId  String
  metric          String   // likes, reposts, replies, views, etc.
  value           Int      @default(0)
  recordedAt      DateTime @default(now())

  // Relations
  postPlatform    PostPlatform @relation(fields: [postPlatformId], references: [id], onDelete: Cascade)

  @@unique([postPlatformId, metric])
  @@map("post_analytics")
}

model ScheduledPost {
  id          String   @id @default(cuid())
  contentHash String
  title       String?
  content     String
  url         String?
  tags        String?  // JSON array of tags
  platforms   String   // JSON array of platform names
  scheduledAt DateTime
  status      String   @default("pending") // pending, posted, failed, cancelled
  createdAt   DateTime @default(now())
  postedAt    DateTime?
  error       String?

  @@index([status, scheduledAt])
  @@map("scheduled_posts")
}

model IntentSignal {
  id          String   @id @default(cuid())
  appName     String
  platform    String   // 'reddit' | 'x' | 'linkedin' | 'quora'
  url         String   @unique
  title       String
  excerpt     String
  intentScore Int      @default(0) // 0-100
  status      String   @default("new") // 'new' | 'drafting' | 'replied' | 'ignored'
  createdAt   DateTime @default(now())
  drafts      Draft[]

  @@index([appName, status])
  @@index([intentScore])
  @@map("intent_signals")
}

model Draft {
  id        String        @id @default(cuid())
  appName   String
  platform  String        // 'reddit' | 'hackernews' | 'bluesky' | 'mastodon' | 'telegram' | 'devto'
  content   String
  metadata  String        @default("{}") // JSON: subreddit, title, tags, threadUrl, etc.
  status    String        @default("draft") // 'draft' | 'approved' | 'posted'
  signalId  String?
  signal    IntentSignal? @relation(fields: [signalId], references: [id], onDelete: SetNull)
  createdAt DateTime      @default(now())
  postedAt  DateTime?

  @@index([appName, status])
  @@map("drafts")
}

// Indexes for performance
// Note: Indexes are automatically created for @unique and foreign key fields