// Architecture blueprint only: this MVP stores workspace data in the browser.
// Supply a PostgreSQL DATABASE_URL and implement authenticated ownership before deployment.
datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

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

model User {
  id            String           @id @default(uuid())
  email         String           @unique
  name          String
  xp            Int              @default(0)
  streak        Int              @default(0)
  sparkCredits  Int              @default(0)
  readingWpm    Int              @default(200)
  avatarConfig  Json
  decks         Deck[]
  schedules     TaskSchedule[]
  codeProjects  CodeProject[]
  stemLabs      StemLabProject[]
  createdRooms  GameRoom[]
  createdAt     DateTime         @default(now())
}

model Deck {
  id            String     @id @default(uuid())
  title         String
  description   String?
  userId        String
  user          User       @relation(fields: [userId], references: [id], onDelete: Cascade)
  cards         Card[]
  tags          String[]
  gameRooms     GameRoom[]
  createdAt     DateTime   @default(now())
  updatedAt     DateTime   @updatedAt
  @@index([userId])
}

model Card {
  id             String   @id @default(uuid())
  deckId         String
  deck           Deck     @relation(fields: [deckId], references: [id], onDelete: Cascade)
  frontTerm      String
  backDefinition String
  diagramUrl     String?
  easeFactor     Float    @default(2.5)
  interval       Int      @default(0)
  repetitions    Int      @default(0)
  dueDate        DateTime @default(now())
  @@index([deckId, dueDate])
}

model TaskSchedule {
  id            String   @id @default(uuid())
  userId        String
  user          User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  title         String
  subject       String   @default("General")
  estHours      Float
  dueDate       DateTime
  allocatedDate DateTime
  blueprintNode Json?
  isFixed       Boolean  @default(false)
  completed     Boolean  @default(false)
  @@index([userId, allocatedDate])
}

model GameRoom {
  id        String   @id @default(uuid())
  code      String   @unique
  hostId    String
  host      User     @relation(fields: [hostId], references: [id], onDelete: Cascade)
  mode      String
  deckId    String
  deck      Deck     @relation(fields: [deckId], references: [id], onDelete: Cascade)
  isActive  Boolean  @default(true)
  createdAt DateTime @default(now())
  @@index([hostId])
}

model CodeProject {
  id            String   @id @default(uuid())
  userId        String
  user          User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  title         String
  sceneData     Json
  blockData     Json
  animationData Json?
  createdAt     DateTime @default(now())
  @@index([userId])
}

model StemLabProject {
  id        String   @id @default(uuid())
  userId    String
  user      User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  labType   String
  stateData Json
  createdAt DateTime @default(now())
  @@index([userId])
}
