COURSES (Collection)

id: string name: string description: string icon: string hasDetailedTopics: boolean topicNames: string[] topics: object[] ↳ id: string ↳ name: string ↳ order: integer ↳ description: string ↳ subtopics: object[] ↳ id: string ↳ name: string ↳ videoUrl: string ↳ quizQuestions: object[] ↳ question: string ↳ options: string[] ↳ correctAnswerIndex: int createdAt: timestamp

USERS (Central Collection)

uid: string email: string username: string profilePicUrl: string enrolledCourses: string[] (references courses.id) completedSubtopics: map (subtopicId → timestamp) achievements: string[] (references achievements.id) createdAt: timestamp

ACHIEVEMENTS (Collection)

id: string name: string description: string icon: string type: string requirement: string points: integer

SkillOrbitDatabase Schema Diagram

data schema