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