box-nestjs-monorepo/prisma/mongo/schema/channel.prisma

model Channel {
  id            String    @id @map("_id") @default(auto()) @db.ObjectId
  channelId     String    @unique
  name          String                          // 渠道名称
  landingUrl    String                          // 最新网址
  videoCdn      String?                         // 视频CDN
  coverCdn      String?                         // 封面CDN
  clientName    String?                         // 客户端名称
  clientNotice  String?                         // 客户端公告
  remark        String?                         // 备注

  // epoch (recommended: ms) stored as BigInt
  createAt      BigInt     @default(0)          // 创建时间
  updateAt      BigInt     @default(0)          // 更新时间

  // Relations - storing category references as objects (id + name)
  categories    Json?                           // Array of { id, name }
  
  // Relations - storing tag references as objects (id + name)
  tags          Json?                           // Array of { id, name }
  
  // Tag names only for search optimization
  tagNames      String[]                        // Array of tag names

  @@map("channel")
}