schema.prisma

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

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

model Account {
  id String @id

  user   User   @relation(fields: [userId], references: [id])
  userId String
}

model User {
  id          String @id @default(cuid())
  alias       String @unique @db.Citext
  displayName String
  avatar      String

  accounts Account[]

  createdAt DateTime @default(now())

  henkenFrom Henken[] @relation("henkenFrom")
  henkenTo   Henken[] @relation("henkenTo")

  followFrom Follow[] @relation("followFrom")
  followTo   Follow[] @relation("followTo")
}

model Follow {
  id String @id @default(cuid())

  createdAt DateTime @default(now())

  from   User   @relation("followFrom", fields: [fromId], references: [id])
  fromId String

  to   User   @relation("followTo", fields: [toId], references: [id])
  toId String

  @@unique([fromId, toId])
}

model Henken {
  id String @id @default(cuid())

  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  comment String @default("")

  from   User   @relation("henkenFrom", fields: [fromId], references: [id])
  fromId String

  to   User   @relation("henkenTo", fields: [toId], references: [id])
  toId String

  answer Answer?

  content   Content @relation(fields: [contentId], references: [id])
  contentId String

  @@unique([toId, contentId])
}

model Answer {
  id String @id @default(cuid())

  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  type AnswerType

  comment String @default("")

  henken   Henken @relation(fields: [henkenId], references: [id])
  henkenId String
}

enum AnswerType {
  RIGHT
  WRONG
}

model Content {
  id   String      @id @default(uuid())
  type ContentType

  henkens Henken[]
}

enum ContentType {
  BOOK
  BOOK_SERIES
  AUTHOR
}