// Prisma schema for SQLite

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

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

model Prompt {
  id         Int              @id @default(autoincrement())
  title      String
  createdAt  DateTime         @default(now())
  updatedAt  DateTime         @updatedAt
  categories PromptCategory[]
}

model PromptCategory {
  promptId   Int
  categoryKey String
  content    String

  prompt     Prompt           @relation(fields: [promptId], references: [id], onDelete: Cascade)

  @@id([promptId, categoryKey])
  @@index([categoryKey])
}