schema.prisma

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

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

model Achievement {
  @@map("achievements")
  id           String    @id @default(cuid())
  name         String
  description  String
  image        String
  isObtainable Boolean   @default(true)
  createdAt    DateTime  @default(now())

  category     Category   @relation(fields: [categoryId], references: [id])
  categoryId   String

  userAchievements UserAchievement[]
}

model User {
  @@map("users")
  id           String    @id @default(cuid())
  cid          String    @unique
  createdAt    DateTime  @default(now())

  achievements UserAchievement[]
}

model UserAchievement {
  @@map("userAchievements")
  createdAt     DateTime    @default(now())

  user          User        @relation(fields: [cid], references: [cid])
  cid           String
  achievement   Achievement @relation(fields: [achievementId], references: [id])
  achievementId String

  @@id([cid, achievementId])
}

model Category {
  @@map("categories")
  id        String      @id @default(cuid())
  name      String      @unique

  // Maybe add an image for the category?

  achievements Achievement[]
}

model AuthorizeToken {
  @@map("authorizeTokens")
  token     String      @id @default(cuid())
  tokenName String      @unique
  createdAt DateTime    @default(now())
  expiresAt DateTime?
}