nerd-math
Tables (20)
activity_log
- logId — ObjectId — Primary key — NOT NULL
- date — Date
- todaySolved — Number
- studyDuration — Number
- totalProblems — Number
- totalStudyMinutes — Number
- attendanceCount — Number
- userId — INT — Foreign key → user.userId — NOT NULL
concept
- conceptId — INT — Primary key — NOT NULL
- realExample — Object
- realImageUrl — String
- relation — Object
- explanation — Object
- simpleProblem — Object
- createdAt — Date
- unitId — ObjectId — Foreign key → unit.unitId — NOT NULL
diagnostic_analysis
- analysisId — ObjectId — Primary key — NOT NULL
- aiComment — String
- recommendedPath — Array<ObjectId>
- generatedAt — Date
- testId — ObjectId — Foreign key → diagnostic_test.testId — NOT NULL
diagnostic_problem
- problemId — ObjectId — Primary key — NOT NULL
- grade — Number
- difficulty — String
- questionText — Object
- type — String
- choices — Array<String>
- answer — Object
- unitId — ObjectId — Foreign key → unit.unitId — NOT NULL
- level — String
- tags — Array<String>
- source — String
diagnostic_score
- scoreId — ObjectId — Primary key — NOT NULL
- userAnswer — Object
- isCorrect — Boolean
- testId — ObjectId — Foreign key → diagnostic_test.testId — NOT NULL
- problemId — ObjectId — Foreign key → diagnostic_problem.problemId — NOT NULL
diagnostic_test
- testId — ObjectId — Primary key — NOT NULL
- gradeRange — Number
- startedAt — Date
- endedAt — Date
- duration — Number
- completed — Boolean
- userId — INT — Foreign key → user.userId — NOT NULL
email_verification
- verificationId — INT — Primary key — NOT NULL
- email — VARCHAR(30)
- code — INT
- expiresAt — DateTime
- verified — Boolean
- createdAt — DateTime
- userId (userId2) — INT — Foreign key → user.userId — NOT NULL
gamification
- gamifiId — ObjectId — Primary key — NOT NULL
- xp — Number
- level — Number
- updatedAt — Date
- userId — INT — Foreign key → user.userId — NOT NULL
- xpLog — Array<Number>
- nextLevelXp — Number
guardian_info
- guardianId — INT — Primary key — NOT NULL
- name — VARCHAR(20)
- phoneNumber — VARCHAR(30)
- consent — Boolean
- userId — INT — Foreign key → user.userId — NOT NULL
learning_time_log
- learningTimeId — ObjectId — Primary key — NOT NULL
- activityType — String
- contentId — ObjectId
- startedAt — Date
- endedAt — Date
- durationSeconds — Number
- createdAt — Date
- userId — INT — Foreign key → user.userId — NOT NULL
password_reset
- resetId — INT — Primary key — NOT NULL
- code — INT
- expiresAt — DateTime
- used — Boolean
- createdAt — DateTime
- userId — INT — Foreign key → user.userId — NOT NULL
problem
- problemId — ObjectId — Primary key — NOT NULL
- difficulty — String
- questionText — Object
- type — String
- choices — Array<String> — NOT NULL
- answer — Object
- explanation — Object
- imageUrl — String — NOT NULL
- createdAt — Date
- setId — ObjectId — Foreign key → problem_set.setId — NOT NULL
- level — String
- tags — Array<String>
- source — String
problem_set
- setId — ObjectId — Primary key — NOT NULL
- createdAt — Date
- unitId — ObjectId — Foreign key → unit.unitId — NOT NULL
progress
- progressId — ObjectId — Primary key — NOT NULL
- conceptProgress — Number
- problemProgress — Number
- lastUpdated — Date
- userId — INT — Foreign key → user.userId — NOT NULL
- unitId — ObjectId — Foreign key → unit.unitId — NOT NULL
unit
- unitId — ObjectId — Primary key — NOT NULL
- title — String
- grade — Number
- chapter — Number
- orderInGrade — Number
- description — String — NOT NULL
- createdAt — Date
user
- userId — INT — Primary key — NOT NULL
- email — VARCHAR(30)
- password — VARCHAR(30)
- name — VARCHAR(20)
- birthDate — Date
- phoneNumber — VARCHAR(30)
- nickname — VARCHAR(30)
- createdAt — DateTime
- isActive — Boolean
- agreeTerms — Boolean
- agreePrivacy — Boolean
- agreeMarketing — Boolean — NOT NULL
user_answer
- answerId — ObjectId — Primary key — NOT NULL
- userAnswer — Object
- isCorrect — Boolean
- solvedAt — Date
- memo — Object — NOT NULL
- bookmarked — Boolean
- userId — INT — Foreign key → user.userId — NOT NULL
- problemId — ObjectId — Foreign key → problem.problemId — NOT NULL
user_auth
- authId — INT — Primary key — NOT NULL
- acessToken — Text
- acessTokenExpireAt — DateTime
- refreshToken — Text
- refreshTokenExprireAt — DateTime
- issuedAt — DateTime
- isRevoked — Boolean
- revokedAt — DateTime
- userId — INT — Foreign key → user.userId — NOT NULL
user_withdrawal
- withdrawalId — INT — Primary key — NOT NULL
- reason — VARCHAR(255)
- withdrawnAt — DateTime
- userId — INT — Foreign key → user.userId — NOT NULL
vocabulary
- vocaId — ObjectId — Primary key — NOT NULL
- type — String
- imageUrl — String — NOT NULL
- word — Object
- meaning — Object
- etymology — Object
- createdAt — Date
- unitId — ObjectId — Foreign key → unit.unitId — NOT NULL