prisma/schema.prisma

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

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

model Prompt {
  id           String        @id @default(uuid())
  prompt_image PromptImage[]
}

model PromptImage {
  id         String   @id @default(uuid())
  file_name  String
  text       String
  created_at DateTime @default(now())
  Prompt     Prompt?  @relation(fields: [promptId], references: [id])
  promptId   String?
}

model Quest {
  id                String   @id @default(uuid())
  prompt_id_correct String
  created_at        DateTime @default(now())
}