schema.prisma

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

datasource db {
  provider = "mongodb"
  url      = env("MONGO_CONNECTION_STRING")
}

model User {
  id        String   @id @default(auto()) @map("_id") @db.ObjectId
  email     String   @unique
  password  String
  fullName  String?
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  
  sessions  Session[]
  streaks   Int      @default(0)
  xp        Int      @default(0)
  aiWordCount Int      @default(0)
}

model Session {
  id          String   @id @default(auto()) @map("_id") @db.ObjectId
  userId      String   @db.ObjectId
  user        User     @relation(fields: [userId], references: [id])
  mode        String   // interview, learning, shark, zen_master
  createdAt   DateTime @default(now())
  duration    Int?     // in seconds
  
  // Analytics
  wpm         Float?
  fillerWords Int?
  confidence  Float? // Average confidence
  confidenceScores Float[] // Array of confidence scores over time for the graph
  
  // Transcripts & Analysis
  transcript     String? // Plain text
  transcriptJson Json?   // Structured data (speaker, timestamp, analysis)
  feedback       String? // General feedback
  
  feedbacks   Feedback[]
}

model Feedback {
  id        String   @id @default(auto()) @map("_id") @db.ObjectId
  sessionId String   @db.ObjectId
  session   Session  @relation(fields: [sessionId], references: [id])
  type      String   // weakness, strength, tip
  content   String
}