schema.prisma

generator client {
  provider               = "prisma-client-py"
  partial_type_generator = "core/models/partials.py"
  recursive_type_depth   = 5
}

datasource db {
  provider = "sqlite"
  url      = "file:data/server.db"
}

// User accounts
model User {
  id        String        @id @default(uuid())
  username  String        @unique
  password  String // Hashed password
  createdAt DateTime      @default(now())
  status    String        @default("OFFLINE") // ONLINE, OFFLINE, IN_GAME
  matches   MatchPlayer[]
}

model Match {
  id           String        @id @default(uuid())
  startedAt    DateTime      @default(now())
  endedAt      DateTime?
  winnerUserId String?
  players      MatchPlayer[]
}

model MatchPlayer {
  id            String  @id @default(uuid())
  matchId       String
  userId        String
  match         Match   @relation(fields: [matchId], references: [id], onDelete: Cascade)
  user          User    @relation(fields: [userId], references: [id], onDelete: Cascade)
  isWinner      Boolean @default(false)
  bombsPlaced   Int     @default(0)
  playersKilled Int     @default(0) // pra um futuro com mais players.

  @@unique([matchId, userId])
}