schema.prisma

// This is your Prisma schema file, learn more about it in the docs: https://pris.ly/d/prisma-schema

generator client {
  provider      = "prisma-client-js"
  binaryTargets = ["native", "linux-musl", "debian-openssl-1.1.x", "darwin-arm64"]
  previewFeatures = ["tracing"]
}

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

enum ClusterType {
  normal
  collection
  screenshots
  stories
  withName
}

model Clusters {
  id   Int         @id @default(autoincrement())
  name String      @unique
  icon String
  type ClusterType

  sortOrder Int @default(0) // TODO: why?

  stories Story[]
  Media   Media[]

  credentials Credentials[]
  Tags        Tags[]

  @@index([name])
}

model Tags {
  id        Int     @id @default(autoincrement())
  tag       String
  icon      String?
  collapsed Boolean @default(false)

  parentId Int?
  parent   Tags?      @relation("ParentChildTags", fields: [parentId], references: [id])
  children Tags[]     @relation("ParentChildTags")
  clusters Clusters[]
  media    Media[]
}

model Media {
  id          String   @id @default(uuid())
  type        String
  name        String
  date        DateTime @default(now())
  createdDate DateTime @default(now())

  height       Int
  width        Int
  tags_old     String[]
  source       String? // TODO
  content_hash String?

  favourited             Boolean @default(false)
  specialFilterAttribute String?

  // Link to cluster
  cluster    Clusters? @relation(fields: [clustersId], references: [id])
  clustersId Int

  // Grouped with other media
  groupedInto        GroupedIntoNames? @relation(fields: [groupedIntoNamesId], references: [id])
  groupedIntoNamesId Int?

  tags Tags[]

  @@index([id, clustersId, tags_old])
}

model GroupedIntoNames {
  id    Int     @id @default(autoincrement())
  name  String
  Media Media[]
}

model Story {
  id      String   @id @default(uuid())
  cluster Clusters @relation(fields: [clusterId], references: [id])
  date    DateTime @default(now())

  title   String
  content String
  source  String @default("Unknown")

  clusterId Int
}

model Credentials {
  id                Int        @id @default(autoincrement())
  username          String     @unique
  hash              String
  salt              String
  permittedClusters Clusters[]
  Session           Session[]
}

model Session {
  id            Int         @id @default(autoincrement())
  token         String
  createdAt     DateTime    @default(now())
  expiresAt     DateTime
  credential    Credentials @relation(fields: [credentialsId], references: [id])
  credentialsId Int
}

enum JobStatus {
  created
  running
  completed
  failed
  invalid
}

model Job {
  id                   Int       @id @default(autoincrement())
  name                 String
  status               JobStatus @default(created)
  data                 String    @default("{}")
  completionPercentage Int?
  createdAt            DateTime  @default(now())
  priority             Int       @default(0)
  debugMessages        String[]
}