schema.prisma

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

datasource db {
  provider = "sqlite"
  url      = env("DATABASE_URL")
}

model QueryCount {
  id            Int    @id @default(1)
  total_queries BigInt
}

enum PaymentStatus {
  created
  authorized
  captured
  refunded
  failed
}

enum SubscriptionStatus {
  created
  authenticated
  active
  pending
  halted
  cancelled
  completed
  expired
}

model User {
  id             String         @id @default(cuid())
  email          String         @unique
  firstName      String
  authMethod     String
  createdAt      DateTime       @default(now())
  lastLogin      DateTime       @updatedAt
  completedSteps Json?
  accounts       Account[]
  payments       Payment[]
  subscriptions  Subscription[]
  testimonial    Testimonial?
}

model Testimonial {
  id         String   @id @default(cuid())
  userId     String   @unique
  content    String
  name       String
  avatar     String
  socialLink String?
  createdAt  DateTime @default(now())
  updatedAt  DateTime @updatedAt
  user       User     @relation(fields: [userId], references: [id], onDelete: Cascade)
}

model Account {
  id                String  @id @default(cuid())
  userId            String
  type              String
  provider          String
  providerAccountId String
  refresh_token     String?
  access_token      String?
  expires_at        Int?
  token_type        String?
  scope             String?
  id_token          String?
  session_state     String?
  user              User    @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@unique([provider, providerAccountId])
}

model Payment {
  id                String        @id @default(cuid())
  userId            String
  subscriptionId    String?
  razorpayPaymentId String        @unique
  razorpayOrderId   String
  amount            Int           // Amount in paise (smallest currency unit)
  currency          String        @default("INR")
  status            PaymentStatus
  createdAt         DateTime      @default(now())
  updatedAt         DateTime      @updatedAt
  subscription      Subscription? @relation(fields: [subscriptionId], references: [id])
  user              User          @relation(fields: [userId], references: [id], onDelete: Cascade)
}

model Subscription {
  id        String    @id @default(cuid())
  userId    String
  planId    String
  status    SubscriptionStatus
  startDate DateTime  @default(now())
  endDate   DateTime?
  autoRenew Boolean   @default(true)
  payments  Payment[]
  plan      Plan      @relation(fields: [planId], references: [id], onDelete: Cascade)
  user      User      @relation(fields: [userId], references: [id], onDelete: Cascade)

  @@index([userId])
}

model Plan {
  id            String         @id @default(cuid())
  name          String
  interval      String
  price         Int
  currency      String         @default("INR")
  createdAt     DateTime       @default(now())
  updatedAt     DateTime       @updatedAt
  subscriptions Subscription[]
}

model WeeklySession {
  id          String        @id @default(cuid())
  title       String
  description String?
  youtubeUrl  String
  sessionDate DateTime
  createdAt   DateTime      @default(now())
  updatedAt   DateTime      @updatedAt
  topics      SessionTopic[]

  @@index([sessionDate])
  @@index([createdAt])
}

model SessionTopic {
  id        String         @id @default(cuid())
  sessionId String
  timestamp String
  topic     String
  order     Int
  session   WeeklySession  @relation(fields: [sessionId], references: [id], onDelete: Cascade)

  @@index([sessionId, order])
}