schema.prisma

generator client {
  provider      = "prisma-client-js"
  binaryTargets = ["native", "linux-musl-arm64-openssl-3.0.x"]
}

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

model Course {
  id             Int             @id @default(autoincrement())
  appxCourseId   Int
  discordRoleId  String
  title          String
  imageUrl       String
  description    String
  openToEveryone Boolean         @default(false)
  slug           String
  content        CourseContent[]
  purchasedBy    UserPurchases[]
  certificate    Certificate[]
  certIssued     Boolean        @default(false)
}

model UserPurchases {
  user       User     @relation(fields: [userId], references: [id])
  userId     String
  course     Course   @relation(fields: [courseId], references: [id])
  courseId   Int
  assignedAt DateTime @default(now())

  @@id([userId, courseId])
}

model Content {
  id               Int             @id @default(autoincrement())
  type             String          @default("folder")
  title            String
  hidden           Boolean         @default(false)
  description      String?
  thumbnail        String?
  parentId         Int?
  parent           Content?        @relation("ContentToContent", fields: [parentId], references: [id])
  videoProgress    VideoProgress[]
  children         Content[]       @relation("ContentToContent")
  courses          CourseContent[]
  createdAt        DateTime        @default(now())
  VideoMetadata    VideoMetadata?
  NotionMetadata   NotionMetadata?
  notionMetadataId Int?
  comments         Comment[]
  commentsCount    Int             @default(0)
  bookmark         Bookmark[]
}

model CourseContent {
  course    Course  @relation(fields: [courseId], references: [id])
  courseId  Int
  content   Content @relation(fields: [contentId], references: [id])
  contentId Int

  @@id([courseId, contentId])
}

model Certificate {
  id                String    @id @default(cuid())
  slug              String    @default("certId")
  user              User      @relation(fields: [userId], references: [id])
  userId            String
  course            Course    @relation(fields: [courseId], references: [id])
  courseId          Int

  @@unique([userId, courseId])
}

model NotionMetadata {
  id        Int     @id @default(autoincrement())
  contentId Int
  content   Content @relation(fields: [contentId], references: [id])
  notionId  String

  @@unique([contentId])
}

model VideoMetadata {
  id                   Int     @id @default(autoincrement())
  contentId            Int
  video_1080p_mp4_1    String? // Link to 1080p mp4 quality video variant 1
  video_1080p_mp4_2    String? // Link to 1080p mp4 quality video variant 2
  video_1080p_mp4_3    String? // Link to 1080p mp4 quality video variant 3
  video_1080p_mp4_4    String? // Link to 1080p mp4 quality video variant 4
  video_1080p_1        String? // Link to 1080p quality video variant 1
  video_1080p_2        String? // Link to 1080p quality video variant 2
  video_1080p_3        String? // Link to 1080p quality video variant 3
  video_1080p_4        String? // Link to 1080p quality video variant 4
  video_720p_mp4_1     String? // Link to 720p mp4 quality video variant 1
  video_720p_mp4_2     String? // Link to 720p mp4 quality video variant 2
  video_720p_mp4_3     String? // Link to 720p mp4 quality video variant 3
  video_720p_mp4_4     String? // Link to 720p mp4 quality video variant 4
  video_720p_1         String? // Link to 720p quality video variant 1
  video_720p_2         String? // Link to 720p quality video variant 2
  video_720p_3         String? // Link to 720p quality video variant 3
  video_720p_4         String? // Link to 720p quality video variant 4
  video_360p_mp4_1     String? // Link to 360p mp4 quality video variant 1
  video_360p_mp4_2     String? // Link to 360p mp4 quality video variant 2
  video_360p_mp4_3     String? // Link to 360p mp4 quality video variant 3
  video_360p_mp4_4     String? // Link to 360p mp4 quality video variant 4
  video_360p_1         String? // Link to 360p quality video variant 1
  video_360p_2         String? // Link to 360p quality video variant 2
  video_360p_3         String? // Link to 360p quality video variant 3
  video_360p_4         String? // Link to 360p quality video variant 4
  subtitles            String? // Link to subtitles file
  segments             Json?
  content              Content @relation(fields: [contentId], references: [id])
  slides               String? // link to slides
  thumbnail_mosiac_url String?
  duration             Int?

  @@unique([contentId])
}

model Session {
  id           String   @id @default(cuid())
  sessionToken String   @unique
  userId       String
  expires      DateTime
  user         User     @relation(fields: [userId], references: [id], onDelete: Cascade)
}

model User {
  id             String          @id @default(cuid())
  name           String?
  email          String?         @unique
  token          String?
  sessions       Session[]
  purchases      UserPurchases[]
  videoProgress  VideoProgress[]
  comments       Comment[]
  votes          Vote[]
  discordConnect DiscordConnect?
  disableDrm     Boolean         @default(false)
  bookmarks      Bookmark[]
  password       String?
  appxUserId     String?
  appxUsername   String?
  questions      Question[]
  answers        Answer[]
  certificate    Certificate[]
}

model DiscordConnect {
  id        String @id @default(cuid())
  username  String
  discordId String @unique
  userId    String @unique
  user      User   @relation(fields: [userId], references: [id], onDelete: Cascade)
}

model DiscordConnectBulk {
  id        String @id @default(cuid())
  username  String
  discordId String
  userId    String
}

model VideoProgress {
  id               Int      @id @default(autoincrement())
  userId           String
  contentId        Int
  currentTimestamp Int
  user             User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  content          Content  @relation(fields: [contentId], references: [id], onDelete: Cascade)
  markAsCompleted  Boolean  @default(false)
  updatedAt        DateTime @default(now()) @updatedAt

  @@unique([contentId, userId])
}

model Bookmark {
  id        Int      @id @default(autoincrement())
  userId    String
  contentId Int
  user      User     @relation(fields: [userId], references: [id], onDelete: Cascade)
  content   Content  @relation(fields: [contentId], references: [id])
  createdAt DateTime @default(now())
}

model Comment {
  id           Int         @id @default(autoincrement())
  content      String
  commentType  CommentType @default(DEFAULT)
  approved     Boolean     @default(false)
  contentId    Int
  commentedOn  Content     @relation(fields: [contentId], references: [id])
  parentId     Int?
  parent       Comment?    @relation("ParentComment", fields: [parentId], references: [id])
  children     Comment[]   @relation("ParentComment")
  userId       String
  user         User        @relation(fields: [userId], references: [id])
  upvotes      Int         @default(0)
  downvotes    Int         @default(0)
  repliesCount Int         @default(0)
  createdAt    DateTime    @default(now())
  updatedAt    DateTime    @updatedAt
  votes        Vote[]
  isPinned     Boolean     @default(false)
}
model Question {
  id          Int       @id @default(autoincrement())
  title       String
  content     String
  slug        String    @unique
  createdAt   DateTime  @default(now())
  author      User      @relation(fields: [authorId], references: [id])
  authorId    String
  upvotes     Int       @default(0)
  downvotes   Int       @default(0)
  totalanswers Int      @default(0)
  answers     Answer[]
  votes       Vote[]
  tags        String[]
  updatedAt   DateTime  @updatedAt

  @@index([authorId])
}

model Answer {
  id          Int       @id @default(autoincrement())
  content     String
  createdAt   DateTime  @default(now())
  question    Question  @relation(fields: [questionId], references: [id])
  questionId  Int
  author      User      @relation(fields: [authorId], references: [id])
  authorId    String
  votes       Vote[]
  upvotes     Int       @default(0)
  downvotes   Int       @default(0)
  totalanswers  Int     @default(0)
  parentId    Int?      
  responses   Answer[]  @relation("AnswerToAnswer")
  parent      Answer?   @relation("AnswerToAnswer", fields: [parentId], references: [id])
  updatedAt   DateTime  @updatedAt

  @@index([questionId])
  @@index([authorId])
  @@index([parentId])
}


model Vote {
  id        Int      @id @default(autoincrement())
  questionId Int?    
  question  Question? @relation(fields: [questionId], references: [id])
  answerId  Int?     
  answer    Answer?  @relation(fields: [answerId], references: [id])
  commentId Int?     
  comment   Comment? @relation(fields: [commentId], references: [id])
  userId    String
  user      User     @relation(fields: [userId], references: [id])
  voteType  VoteType 
  createdAt DateTime @default(now())

  @@unique([questionId, userId])  
  @@unique([answerId, userId])    
  @@unique([commentId, userId])  
}

enum VoteType {
  UPVOTE
  DOWNVOTE
}
enum PostType {
  QUESTION
  ANSWER
}
enum CommentType {
  INTRO
  DEFAULT
}