// 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"
}

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

model User {
  id        String   @id @default(cuid())
  name      String
  email     String   @unique
  password  String
  role      String   @default("user")
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt

  Enrollment Enrollment[]
}

model Company {
  id        String   @id @default(cuid())
  name      String
  logo      String
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model Partner {
  id        String   @id @default(cuid())
  name      String
  logo      String
  website   String
  createdAt DateTime @default(now())
  updateAt  DateTime @updatedAt
}

model Clients {
  id        String   @id @default(cuid())
  name      String
  logo      String
  createdAt DateTime @default(now())
  updateAt  DateTime @updatedAt
}

model Testimonials {
  id          String   @id @default(cuid())
  name        String
  designation String
  message     String
  rating      Int
  createdAt   DateTime @default(now())
  updatedAt   DateTime @updatedAt
}

model Courses {
  id          String    @id @default(cuid())
  name        String
  description String?
  price       Int       @default(0)
  duration    Int       @default(0)
  level       String    @default("Beginner")
  banner      String?
  categoryId  String?
  category    Category? @relation(fields: [categoryId], references: [id]) // Optional Category
  createdAt   DateTime  @default(now())
  updatedAt   DateTime  @updatedAt

  Section Section[]

  Enrollment Enrollment[]
}

model Category {
  id        String    @id @default(uuid()) // Unique identifier
  name      String    @unique
  icon      String
  courses   Courses[] // One-to-Many relationship (Category → Courses)
  createdAt DateTime  @default(now())
  updatedAt DateTime  @updatedAt

  // Table name in database
}

model Section {
  id        String   @id @default(cuid())
  title     String
  lesson    Lesson[]
  courseId  String
  course    Courses  @relation(fields: [courseId], references: [id], onDelete: Cascade)
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model Lesson {
  id        String   @id @default(cuid())
  title     String
  content   String // Could be text, markdown, or video URL
  videoUrl  String?
  sectionId String
  section   Section  @relation(fields: [sectionId], references: [id], onDelete: Cascade)
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}

model Enrollment {
  id         String   @id @default(uuid())
  userId     String
  courseId   String
  enrolledAt DateTime @default(now())

  // Relations
  user   User    @relation(fields: [userId], references: [id])
  course Courses @relation(fields: [courseId], references: [id])

  // Table name in database
}

model Gallery{
  id String @id @default(cuid())
  title String
  category String
  images   String
  createdAt DateTime @default(now())
  updateAt DateTime @updatedAt
}