Momen
Tables (16)
assignment_materials
- material_id — BIGINT — Primary key — NOT NULL
- todo_id — BIGINT — Foreign key → todos.todo_id — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
assignment_submissions
- submission_id — BIGINT — Primary key — NOT NULL
- todo_id — BIGINT — Foreign key → todos.todo_id — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- submitted_at — DATETIME
- ai_analysis_status — VARCHAR(20)
- study_density_score — INT
- ai_check_comment — TEXT — EX
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
chat_logs
- chat_id — BIGINT — Primary key — NOT NULL
- mentee_id — BIGINT — Foreign key → mentees.mentee_id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- message_content — TEXT — NOT NULL
- related_todo_id — BIGINT — Foreign key → todos.todo_id
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
feedbacks
- feedback_id — BIGINT — Primary key — NOT NULL
- planner_id — BIGINT — Foreign key → planners.planner_id — NOT NULL
- mentor_id — BIGINT — Foreign key → mentors.mentor_id — NOT NULL
- ai_generated_draft — TEXT
- is_ai_adopted — TINYINT(1)
- korean_summary — TEXT
- math_summary — TEXT
- english_summary — TEXT
- total_review — TEXT
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
focus_sessions
- session_id — BIGINT — Primary key — NOT NULL
- mentee_id — BIGINT — Foreign key → mentees.mentee_id — NOT NULL
- start_time — DATETIME
- end_time — DATETIME
- drowsiness_count — INT
- phone_use_count — INT
- focus_score — INT
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
mentees
- mentee_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.USER_ID — NOT NULL
- mentor_id — BIGINT — Foreign key → mentors.mentor_id
- grade — VARCHAR(20)
- target_university — VARCHAR(100)
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
mentors
- mentor_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → tbl_user.USER_ID — NOT NULL
- intro — TEXT
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
mistake_notes
- note_id — BIGINT — Primary key — NOT NULL
- mentee_id — BIGINT — Foreign key → mentees.mentee_id — NOT NULL
- todo_id — BIGINT — Foreign key → todos.todo_id
- question_image_url — VARCHAR(500)
- ai_generated_question — TEXT
- is_solved — TINYINT(1)
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
oral_tests
- test_id — BIGINT — Primary key — NOT NULL
- mentee_id — BIGINT — Foreign key → mentees.mentee_id — NOT NULL
- topic — VARCHAR(255) — NOT NULL
- audio_url — VARCHAR(500)
- transcription — TEXT
- ai_accuracy_score — INT
- ai_feedback_comment — TEXT — EX
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
planners
- planner_id — BIGINT — Primary key — NOT NULL
- mentee_id — BIGINT — Foreign key → mentees.mentee_id — NOT NULL
- planner_date — DATE — NOT NULL
- student_comment — TEXT — EX
- sentiment_score — DOUBLE
- mood_emoji — VARCHAR(10)
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
tbl_dalle_generation_log
- DALLE_LOG_ID — BIGINT — Primary key — NOT NULL
- JOB_ID — VARCHAR(36) — NOT NULL
- USER_ID — BIGINT — Foreign key → tbl_user.USER_ID
- MODEL — VARCHAR(50) — NOT NULL
- PROMPT — TEXT — NOT NULL
- REVISED_PROMPT — TEXT
- SIZE — VARCHAR(20)
- QUALITY — VARCHAR(20)
- STYLE — VARCHAR(20)
- SEED — BIGINT
- IMAGE_URL — VARCHAR(1000)
- B64_JSON — TEXT
- STATUS — VARCHAR(20) — NOT NULL
- ERROR_MESSAGE — TEXT
- ERROR_CODE — VARCHAR(50)
- COPYRIGHT_FLAG — TINYINT(1)
- SAFETY_FILTER_TRIGGERED — TINYINT(1)
- METADATA — JSON
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
tbl_email_verification
- VERIFICATION_ID — BIGINT — Primary key — NOT NULL
- EMAIL — VARCHAR(100) — NOT NULL
- CODE — VARCHAR(6) — NOT NULL
- EXPIRES_AT — DATETIME — NOT NULL
- VERIFIED — TINYINT(1) — NOT NULL
- VERIFIED_AT — DATETIME
- ATTEMPT_COUNT — INT — NOT NULL
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
tbl_openai_chat_log
- CHAT_LOG_ID — BIGINT — Primary key — NOT NULL
- JOB_ID — VARCHAR(36) — NOT NULL
- USER_ID — BIGINT — Foreign key → tbl_user.USER_ID
- MODEL — VARCHAR(50) — NOT NULL
- SYSTEM_PROMPT — TEXT
- USER_PROMPT — TEXT — NOT NULL
- ASSISTANT_RESPONSE — TEXT
- TEMPERATURE — DECIMAL(3,2)
- MAX_TOKENS — INT
- TOKENS_USED — INT
- PROMPT_TOKENS — INT
- COMPLETION_TOKENS — INT
- STATUS — VARCHAR(20) — NOT NULL
- ERROR_MESSAGE — TEXT
- ERROR_CODE — VARCHAR(50)
- METADATA — JSON
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
tbl_refresh_token
- REFRESH_TOKEN_ID — BIGINT — Primary key — NOT NULL
- USER_ID — BIGINT — Foreign key → tbl_user.USER_ID
- TOKEN — VARCHAR(512)
- EXPIRES_AT — DATETIME
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
tbl_user
- USER_ID — BIGINT — Primary key — NOT NULL
- EMAIL — VARCHAR(255)
- PASSWORD_HASH — VARCHAR(255)
- NAME — VARCHAR(255)
- IS_ACTIVE — TINYINT(1) — NOT NULL
- PHONE — VARCHAR(20)
- ROLE — VARCHAR(20) — NOT NULL
- EMAIL_VERIFIED — TINYINT(1) — NOT NULL
- EMAIL_VERIFIED_AT — DATETIME
- TERMS_AGREED_AT — DATETIME
- PROFILE_IMAGE_URL — VARCHAR(500)
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL
todos
- todo_id — BIGINT — Primary key — NOT NULL
- planner_id — BIGINT — Foreign key → planners.planner_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- subject — VARCHAR(20) — NOT NULL
- goal_description — TEXT
- study_time — INT
- is_completed — TINYINT(1)
- is_fixed — TINYINT(1)
- created_by — BIGINT — NOT NULL
- CREATE_DT — DATETIME — NOT NULL
- UPDATE_DT — DATETIME — NOT NULL