schema.prisma

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

datasource db {
  provider  = "postgresql"
  url       = env("POSTGRES_PRISMA_URL")
  directUrl = env("POSTGRES_URL_NON_POOLING")
}

model User {
  hash               String               @id @unique
  createdAt          DateTime             @default(now()) @map(name: "created_at")
  ContentInteraction ContentInteraction[]

  @@map(name: "users")
}

model Content {
  slug               String               @id @unique
  createdAt          DateTime             @default(now()) @map(name: "created_at")
  ContentInteraction ContentInteraction[]

  @@map(name: "contents")
}

model ContentInteraction {
  createdAt DateTime @default(now()) @map(name: "created_at")
  updatedAt DateTime @updatedAt @map(name: "updated_at")
  seen      Boolean  @default(false)
  likes     Int      @default(0) @db.SmallInt()

  User     User   @relation(fields: [userHash], references: [hash])
  userHash String @map(name: "user_hash")

  Content     Content @relation(fields: [contentSlug], references: [slug])
  contentSlug String  @map(name: "content_slug")

  @@id(name: "interactionRelation", [userHash, contentSlug])
  @@map(name: "content_interactions")
}