Detailed Collection Schemas

1. User

{
  "_id": "ObjectId",
  "name": "string",
  "email": "string (unique)",
  "password": "string (hashed)",
  "phoneNumber": "string",
  "address": "string",
  "role": "string (user | instructor | admin)",
  "createdAt": "Date",
  "updatedAt": "Date"
}

2. Course

{
  "_id": "ObjectId",
  "title": "string",
  "description": "string",
  "instructorId": "ObjectId (User)",
  "category": "string",
  "price": "number",
  "createdAt": "Date",
  "updatedAt": "Date"
}

3. Lesson

{
  "_id": "ObjectId",
  "courseId": "ObjectId (Course)",
  "title": "string",
  "order": "number",
  "createdAt": "Date",
  "updatedAt": "Date"
}

4. Modules

{
  "_id": "ObjectId",
  "lessonId": "ObjectId (Lesson)",
  "type": "string (video | pdf)",
  "url": "string (Cloudinary URL)",
  "title": "string",
  "createdAt": "Date",
  "updatedAt": "Date"
}

5. Transaction

{
  "_id": "ObjectId",
  "userId": "ObjectId (User)",
  "courseId": "ObjectId (Course)",
  "status": "string (pending | completed | cancelled)",
  "paymentMethod": "string",
  "amount": "number",
  "createdAt": "Date",
  "updatedAt": "Date"
}

6. Certificate

{
  "_id": "ObjectId",
  "userId": "ObjectId (User)",
  "courseId": "ObjectId (Course)",
  "certificateUrl": "string",
  "issuedDate": "Date",
  "createdAt": "Date",
  "updatedAt": "Date"
}

7. Review

{
  "_id": "ObjectId",
  "userId": "ObjectId (User)",
  "courseId": "ObjectId (Course)",
  "rating": "number (1-5)",
  "comment": "string",
  "createdAt": "Date",
  "updatedAt": "Date"
}