prisma-v7-schema.prisma

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

datasource db {
  provider = "postgresql"
}

enum RecordingAccess {
  FREE
  SUBSCRIBER
}

model User {
  id                     String        @id @default(cuid())
  clerkUserId            String        @unique
  email                  String?       @unique
  name                   String?
  imageUrl               String?
  stripeCustomerId       String?       @unique
  freeTranscriptionCount Int           @default(0)
  createdAt              DateTime      @default(now())
  updatedAt              DateTime      @updatedAt
  subscription           Subscription?
  recordings             Recording[]
  documents              Document[]
}

model Subscription {
  id                   String   @id @default(cuid())
  userId               String   @unique
  user                 User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  stripeCustomerId     String?  @unique
  stripeSubscriptionId String   @unique
  stripePriceId        String?
  status               String
  cancelAtPeriodEnd    Boolean  @default(false)
  currentPeriodEnd     DateTime?
  createdAt            DateTime @default(now())
  updatedAt            DateTime @updatedAt
}

model Recording {
  id               String          @id @default(cuid())
  userId           String
  user             User            @relation(fields: [userId], references: [id], onDelete: Cascade)
  title            String
  transcript       String          @db.Text
  audioUrl         String?
  audioStoragePath String?
  access           RecordingAccess @default(SUBSCRIBER)
  charCount        Int             @default(0)
  wordCount        Int             @default(0)
  createdAt        DateTime        @default(now())
  document         Document?

  @@index([userId, createdAt])
}

model Document {
  id               String          @id @default(cuid())
  userId           String
  user             User            @relation(fields: [userId], references: [id], onDelete: Cascade)
  recordingId      String?         @unique
  recording        Recording?      @relation(fields: [recordingId], references: [id], onDelete: SetNull)
  title            String          
  transcript       String          @db.Text
  twitter          String          @db.Text
  linkedin         String          @db.Text
  summary          String          @db.Text
  tone             String          @default("professional")
  createdAt        DateTime        @default(now())
  updatedAt        DateTime        @updatedAt

  @@index([userId, createdAt])
}