schema.prisma

datasource db {
  provider     = "mysql"
  url          = env("DATABASE_URL")
  relationMode = "prisma"
}

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

// Metadata
model Topic {
  id   Int    @id @default(autoincrement())
  name String @db.VarChar(255)

  articles            Article[]
  books               Book[]
  podcasts            Podcast[]
  podcastEpisodes     PodcastEpisode[]
  directories         Directory[]
  videos              Video[]
  tools               Tool[]
  communities         Community[]
  courses             Course[]
  examples            Example[]
  agencies            Agency[]
  slides              Slide[]
  magazines           Magazine[]
  newsletters         Newsletter[]
  papers              Paper[]
  socialMediaProfiles SocialMediaProfile[]
  thoughtleaders      Thoughtleader[]
  reports             Report[]
}

model Category {
  id   Int    @id @default(autoincrement())
  name String @db.VarChar(255)

  articles            Article[]
  books               Book[]
  podcasts            Podcast[]
  podcastEpisodes     PodcastEpisode[]
  directories         Directory[]
  videos              Video[]
  tools               Tool[]
  communities         Community[]
  courses             Course[]
  examples            Example[]
  agencies            Agency[]
  slide               Slide[]
  magazines           Magazine[]
  newsletters         Newsletter[]
  thoughtleaders      Thoughtleader[]
  papers              Paper[]
  socialMediaProfiles SocialMediaProfile[]
  reports             Report[]
}

enum Type {
  thoughtleader
  article
  book
  podcast
  podcastEpisode
  directory
  video
  tool
  community
  course
  example
  agency
  slide
  magazine
  newsletter
  paper
  socialMediaProfile
  report
}

model Like {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())

  userId     String @db.VarChar(255)
  type       Type
  resourceId Int

  @@unique([userId, type, resourceId])
  @@index([userId])
  @@index([type])
  @@index([resourceId])
}

model Comment {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  userId     String @db.VarChar(255)
  type       Type
  resourceId Int
  text       String @db.Text

  @@index([userId])
  @@index([type])
  @@index([resourceId])
}

// Resources
model Thoughtleader {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(thoughtleader)
  name       String   @db.VarChar(255)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  link           String? @db.VarChar(255)
  jobDescription String? @db.VarChar(255)
  note           String? @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  articles        Article[]
  books           Book[]
  podcasts        Podcast[]
  podcastEpisodes PodcastEpisode[]
  videos          Video[]
  slides          Slide[]
  newsletters     Newsletter[]
  papers          Paper[]
  report          Report[]

  @@index([categoryId])
}

model Article {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(article)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  title        String          @db.VarChar(255)
  authors      Thoughtleader[]
  authorsPlain String?         @db.VarChar(255)
  date         DateTime?
  datePlain    String?         @db.VarChar(255)
  duration     String?         @db.VarChar(255)
  link         String?         @db.VarChar(255)
  note         String?         @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model Book {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(book)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  title String @db.VarChar(255)

  authors        Thoughtleader[]
  authorsPlain   String?         @db.VarChar(255)
  publishingDate DateTime?
  publisher      String?         @db.VarChar(255)
  isbn           String?         @db.VarChar(255)
  link           String?         @db.VarChar(255)
  note           String?         @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model Podcast {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(podcast)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  title      String          @db.VarChar(255)
  hosts      Thoughtleader[]
  hostsPlain String?         @db.VarChar(255)
  link       String?         @db.VarChar(255)
  note       String?         @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  podcastEpisodes PodcastEpisode[]

  @@index([categoryId])
}

model PodcastEpisode {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(podcastEpisode)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  title        String          @db.VarChar(255)
  podcastId    Int?
  podcast      Podcast?        @relation(fields: [podcastId], references: [id])
  podcastPlain String?         @db.VarChar(255)
  guests       Thoughtleader[]
  date         DateTime?
  duration     String?
  link         String?         @db.VarChar(255)
  note         String?         @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([podcastId])
  @@index([categoryId])
}

model Directory {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(directory)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  name        String  @db.VarChar(255)
  description String? @db.VarChar(255)
  link        String? @db.VarChar(255)
  note        String? @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model Video {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(video)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  title         String          @db.VarChar(255)
  creators      Thoughtleader[]
  creatorsPlain String?         @db.VarChar(255)
  date          DateTime?
  duration      String?
  link          String?         @db.VarChar(255)
  note          String?         @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model Tool {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(tool)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  name        String  @db.VarChar(255)
  description String? @db.VarChar(255)
  link        String? @db.VarChar(255)
  note        String? @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model Community {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(community)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  name        String  @db.VarChar(255)
  description String? @db.VarChar(255)
  link        String? @db.VarChar(255)
  note        String? @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model Course {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(course)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  name        String  @db.VarChar(255)
  description String? @db.VarChar(255)
  link        String? @db.VarChar(255)
  note        String? @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model Example {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(example)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  name        String  @db.VarChar(255)
  description String? @db.VarChar(255)
  link        String? @db.VarChar(255)
  note        String? @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model Agency {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(agency)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  name        String  @db.VarChar(255)
  description String? @db.VarChar(255)
  link        String? @db.VarChar(255)
  note        String? @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model Slide {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(slide)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  title        String          @db.VarChar(255)
  authors      Thoughtleader[]
  authorsPlain String?         @db.VarChar(255)
  date         DateTime?
  datePlain    String?         @db.VarChar(255)
  link         String?         @db.VarChar(255)
  note         String?         @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model Magazine {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(magazine)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  name        String  @db.VarChar(255)
  description String? @db.VarChar(255)
  link        String? @db.VarChar(255)
  note        String? @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model Newsletter {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(newsletter)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  name         String          @db.VarChar(255)
  authors      Thoughtleader[]
  authorsPlain String?         @db.VarChar(255)
  description  String?         @db.VarChar(255)
  frequency    String?         @db.VarChar(255)
  link         String?         @db.VarChar(255)
  note         String?         @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model Paper {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(paper)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  title        String          @db.VarChar(255)
  authors      Thoughtleader[]
  authorsPlain String?         @db.VarChar(255)
  date         DateTime?
  datePlain    String?         @db.VarChar(255)
  journal      String?         @db.VarChar(255)
  link         String?         @db.VarChar(255)
  note         String?         @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model SocialMediaProfile {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(socialMediaProfile)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  name        String  @db.VarChar(255)
  handle      String? @db.VarChar(255)
  description String? @db.VarChar(255)
  link        String? @db.VarChar(255)
  note        String? @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

model Report {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  type       Type     @default(report)
  likes      Int      @default(0)
  suggestion Boolean  @default(false)

  title        String          @db.VarChar(255)
  authors      Thoughtleader[]
  authorsPlain String?         @db.VarChar(255)
  date         DateTime?
  datePlain    String?         @db.VarChar(255)
  description  String?         @db.VarChar(255)
  link         String?         @db.VarChar(255)
  note         String?         @db.Text

  categoryId Int?
  category   Category? @relation(fields: [categoryId], references: [id])
  topics     Topic[]

  @@index([categoryId])
}

// Collections

model Collection {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  userId      String @db.VarChar(255)
  title       String @db.VarChar(255)
  description String @db.Text

  collectionItem    CollectionItem[]
  collectionComment CollectionComment[]
  collectionLikes   CollectionLikes[]
}

model CollectionItem {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  collectionId Int
  collection   Collection @relation(fields: [collectionId], references: [id])

  resourceId   Int
  resourceType Type

  @@unique([collectionId, resourceId, resourceType])
  @@index([collectionId])
}

model CollectionLikes {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  userId String @db.VarChar(255)

  collectionId Int
  collection   Collection @relation(fields: [collectionId], references: [id])

  @@unique([userId, collectionId])
  @@index([collectionId])
}

model CollectionComment {
  id        Int      @id @default(autoincrement())
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  userId String @db.VarChar(255)
  text   String @db.Text

  collectionId Int
  collection   Collection @relation(fields: [collectionId], references: [id])

  @@index([userId])
  @@index([collectionId])
}