schema.prisma

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

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

model User {
  id                  Int           @id @default(sequence())
  email               String        @unique
  name                String?
  verified            Boolean       @default(false)
  about               String?
  website             String?
  other               String?
  avatar              String?
  cover               String?
  role                String?       @default("user")
  hashedPassword      String
  salt                String
  resetToken          String?
  resetTokenExpiresAt DateTime?
  Video               Video[]
  createdAt           DateTime      @default(now())
  updatedAt           DateTime      @updatedAt
  Comment             Comment[]
  Subscribers         Subscribers[]
  Cmmt                Cmmt[]
}

model Comment {
  id        Int      @id @default(sequence())
  author    User     @relation(fields: [authorId], references: [id])
  authorId  Int
  content   String
  videoId   Int
  rating    Int?
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model Video {
  id          Int      @id @default(sequence())
  title       String
  description String
  author      User?    @relation(fields: [authorId], references: [id])
  authorId    Int
  url         String
  thumbnail   String?
  tags        String
  published   String
  views       Int?     @default(0)
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
}

model Subscribers {
  id        Int      @id @default(sequence())
  author    User?    @relation(fields: [authorId], references: [id])
  authorId  Int
  channel   Int
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model Cmmt {
  id        Int      @id @default(sequence())
  content   String
  author    User?    @relation(fields: [authorId], references: [id])
  authorId  Int
  parentId  Int
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}