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