schema.prisma

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

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

datasource db {
  provider = "postgres"
  url      = env("DB_URL")
}

model User {
  email   String          @id @unique
  classes ClassForDecks[]
}

model ClassForDecks {
  id           String   @id @default(cuid())
  user         User     @relation(fields: [userEmail], references: [email])
  userEmail    String
  name         String
  decks        Deck[]
  creationDate DateTime @default(now())

  @@unique([userEmail, name])
}

model Deck {
  id           String        @id @default(cuid())
  classOfDeck  ClassForDecks @relation(fields: [classId], references: [id], onDelete: Cascade)
  classId      String
  name         String
  cards        Card[]
  creationDate DateTime      @default(now())

  @@unique([classId, name])
}

model Card {
  id String @id @unique @default(cuid())

  question      String
  answer        String
  isDone        Boolean @default(false)
  videoQuestion String?
  videoAnswer   String?
  imageQuestion String?
  imageAnswer   String?

  deck   Deck   @relation(fields: [deckId], references: [id], onDelete: Cascade)
  deckId String

  creationDate DateTime @default(now())

  nextReviewDate DateTime
  level          Int

}