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 8 months ago