📊 Database Schema

{
  clerkId: String,          // Clerk user ID
  email: String,
  name: String,
  imageUrl: String,
  credits: Number,          // Available credits
  role: String,             // 'user' | 'admin'
  settings: {
    theme: String,
    notifications: Boolean
  },
  createdAt: Date,
  updatedAt: Date
}

{
  userId: ObjectId,
  title: String,
  description: String,
  questions: [{
    question: String,
    type: String,           // 'multiple_choice' | 'true_false' | 'short_answer'
    options: [String],
    correctAnswer: String | Number,
    explanation: String
  }],
  settings: {
    difficulty: String,
    questionCount: Number,
    timer: Number
  },
  sourceFile: String,
  collectionId: ObjectId,
  createdAt: Date
}

{
  userId: ObjectId,
  toolId: String,           // Tool identifier
  toolName: String,
  input: Object,            // Tool input parameters
  output: String,           // Generated content
  creditsUsed: Number,
  createdAt: Date
}

{
  userId: ObjectId,         // Creator
  name: String,
  description: String,
  code: String,             // Join code
  tools: [String],          // Assigned tool IDs
  students: [{
    name: String,
    email: String,
    joinedAt: Date
  }],
  isActive: Boolean,
  createdAt: Date
}

{
  siteName: String,
  siteDescription: String,
  logo: String,
  favicon: String,
  primaryColor: String,
  freeCredits: Number,      // Credits for new users
  footerText: String,
  socialLinks: Object,
  updatedAt: Date
}

{
  name: String,
  credits: Number,
  price: Number,
  currency: String,
  features: [String],
  isPopular: Boolean,
  isActive: Boolean,
  stripePriceId: String,
  createdAt: Date
}

db.users.createIndex({ clerkId: 1 }, { unique: true })
db.users.createIndex({ email: 1 })
db.quizzes.createIndex({ userId: 1 })
db.quizzes.createIndex({ collectionId: 1 })
db.generations.createIndex({ userId: 1, createdAt: -1 })
db.rooms.createIndex({ code: 1 }, { unique: true })