schema.prisma

datasource db {
  // could be postgresql or mysql
  provider = "sqlite"
  url      = "file:./.database/database.db"
}

generator db {
  provider = "go run github.com/steebchen/prisma-client-go"
}

model Word {
  id            String   @id @default(cuid())
  chatId        BigInt
  createdAt     DateTime @default(now())
  updatedAt     DateTime @updatedAt
  word          String
  translate     String
  rememberLevel Int      @default(0)
  nextRemindAt  DateTime
  remindedAt    DateTime @default(now())
  Users         User?    @relation(fields: [usersChatId], references: [chatId])
  usersChatId   BigInt?
}

model User {
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
  chatId    BigInt   @id
  words     Word[]
}