πŸ—ƒοΈ Database Schema

TECHTONIC uses a NoSQL schema for flexibility, supporting both MongoDB and Firebase Firestore.

Core Collections/Tables:

  • Users

    • ID, email, name, passwordHash, role, enrolledCourses, points, certificates

  • Courses

    • ID, title, level, track, description, lessons[]

  • Lessons

    • ID, title, type (video, PDF, quiz), contentURL, courseId

  • Progress

    • userId, courseId, currentLessonId, completionRate

  • Certificates

    • userId, courseId, dateIssued, certificateURL

Last updated