note

Tables (12)

AIAnalysis

  • student_number — VARCHAR(30) — Foreign key → WrongNote.student_number — NOT NULL
  • analysis_id — VARCHAR(36)
  • answer_id — VARCHAR(36)
  • extracted_steps — TEXT
  • matched_steps — TEXT
  • error_type — VARCHAR(100)
  • ai_hint — TEXT
  • ai_feedback — TEXT
  • guide_type — VARCHAR(50)
  • is_understood — TINYINT(1)

Chat

  • student_number — VARCHAR(30) — Foreign key → Student.student_number — NOT NULL
  • teacher_number — VARCHAR(30) — Foreign key → Teacher.teacher_number — NOT NULL
  • chat_id — VARCHAR(36)
  • message — TEXT
  • sender_role — VARCHAR(20)
  • created_at — DATETIME

Exam

  • exam_id — VARCHAR(36) — Primary key — NOT NULL
  • student_number — VARCHAR(30) — Foreign key → Student.student_number — NOT NULL
  • title — VARCHAR(255)
  • year — INT
  • is_uploaded_by_student — TINYINT(1)
  • created_by_user_id — VARCHAR(36)
  • created_at — DATETIME

ExamQuestion

  • question_id — VARCHAR(36)
  • question_number — INT
  • question_text — TEXT
  • subject — VARCHAR(50)
  • difficulty — INT
  • uploaded_image_url — TEXT
  • exam_id — VARCHAR(36) — Foreign key → Exam.exam_id — NOT NULL
  • student_number — VARCHAR(30) — Foreign key → Exam.student_number — NOT NULL

Feedback

  • student_number — VARCHAR(30) — Foreign key → WrongNote.student_number — NOT NULL
  • feedback_id — VARCHAR(36)
  • teacher_id — VARCHAR(36)
  • answer_id — VARCHAR(36)
  • feedback_text — TEXT
  • created_at — DATETIME

Notification

  • noti_id — VARCHAR(36)
  • user_id — VARCHAR(36)
  • message — TEXT
  • is_read — TINYINT(1)
  • created_at — DATETIME
  • student_number — VARCHAR(30) — Foreign key → Chat.student_number — NOT NULL
  • teacher_number — VARCHAR(30) — Foreign key → Chat.teacher_number — NOT NULL

Student

  • student_number — VARCHAR(30) — Primary key — NOT NULL
  • teacher_number — VARCHAR(30) — Foreign key → Teacher.teacher_number — NOT NULL
  • grade — INT

StudentAnswer

  • answer_id — VARCHAR(36)
  • student_id — VARCHAR(36)
  • question_id — VARCHAR(36)
  • answer_text — TEXT
  • answer_image_url — TEXT
  • is_correct — TINYINT(1)
  • created_at — DATETIME
  • exam_id — VARCHAR(36) — Foreign key → Exam.exam_id — NOT NULL
  • student_number — VARCHAR(30) — Foreign key → Exam.student_number — NOT NULL

StudentStats

  • student_number — VARCHAR(30) — Foreign key → Student.student_number — NOT NULL
  • teacher_number — VARCHAR(30) — Foreign key → Student.teacher_number — NOT NULL
  • student_id — VARCHAR(36)
  • total_exams — INT
  • avg_score — FLOAT
  • recent_wrong_ratio — FLOAT
  • most_wrong_subject — VARCHAR(50)

Teacher

  • teacher_number — VARCHAR(30) — Primary key — NOT NULL
  • user_id — VARCHAR(36) — Foreign key → USER.user_id — NOT NULL
  • department — VARCHAR(50)

USER (User)

  • user_id — VARCHAR(36) — Primary key — NOT NULL
  • email — VARCHAR(100)
  • password — VARCHAR(100)
  • roler (role) — VARCHAR(20)
  • created_at — DATETIME
  • Field

WrongNote

  • student_number — VARCHAR(30) — Foreign key → Student.student_number — NOT NULL
  • note_id — VARCHAR(36)
  • student_id — VARCHAR(36)
  • question_id — VARCHAR(36)
  • answer_id — VARCHAR(36)
  • feedback_text — TEXT
  • is_fixed — TINYINT(1)
  • created_at — DATETIME