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