schema.prisma

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

// Get a free hosted Postgres database in seconds: `npx create-db`

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

datasource db {
  provider = "postgresql"
}

// Shareable app state models
model SharedLink {
  id           String    @id @default(cuid())
  userId       String?   // Optional - null for anonymous shares
  pageName     String // 'text', 'json', 'base64'
  tabName      String // 'diff', 'format', etc.
  title        String // User-provided title
  comment      String? // Optional user-provided comment
  expiresAt    DateTime? // Null = never expires
  passwordHash String? // Null = public access
  viewCount    Int       @default(0)
  updatedAt    DateTime  @updatedAt
  createdAt    DateTime  @default(now())

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

  @@index([pageName])
  @@index([createdAt])
  @@index([expiresAt])
  @@index([userId])
}

model SharedContent {
  id     String     @id @default(cuid())
  linkId String     @unique
  state  Json // Page-specific state as JSON
  link   SharedLink @relation(fields: [linkId], references: [id], onDelete: Cascade)

  @@index([linkId])
}

// Saved items model for user bookmarks/saved content
model SavedItem {
  id        String   @id @default(cuid())
  userId    String?  // Optional - null for anonymous saves
  pageName  String   // 'text', 'json', 'base64'
  tabName   String   // 'diff', 'format', etc.
  name      String   // User-provided name
  content   Json     // Page-specific content as JSON
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

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

  @@index([pageName])
  @@index([createdAt])
  @@index([userId])
}

model ShortenedUrl {
  id        String   @id @default(cuid())
  shortCode String   @unique
  originalUrl String
  clicks    Int      @default(0)
  userId    String?
  createdAt DateTime @default(now())

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

  @@index([shortCode])
  @@index([userId])
  @@index([createdAt])
}

// ─── Authentication ──────────────────────────────────────────────────────

model User {
  id             String    @id @default(uuid())
  email          String    @unique
  name           String
  emailVerified  Boolean   @default(false)
  image          String?
  createdAt      DateTime  @default(now())
  updatedAt      DateTime  @updatedAt
  shares         SharedLink[]
  savedItems     SavedItem[]
  shortenedUrls  ShortenedUrl[]
  sessions       Session[]
  accounts       Account[]
}

model Session {
  id        String   @id
  expiresAt DateTime
  token     String   @unique
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  ipAddress String?
  userAgent String?
  userId    String
  user      User     @relation(fields: [userId], references: [id], onDelete: Cascade)
}

model Account {
  id                    String    @id
  accountId             String
  providerId            String
  userId                String
  user                  User      @relation(fields: [userId], references: [id], onDelete: Cascade)
  accessToken           String?
  refreshToken          String?
  idToken               String?
  accessTokenExpiresAt  DateTime?
  refreshTokenExpiresAt DateTime?
  scope                 String?
  password              String?
  createdAt             DateTime  @default(now())
  updatedAt             DateTime  @updatedAt
}

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