SUDA

Tables (18)

answer_attempts

  • answer_attempt_id — BIGINT — Primary key — NOT NULL
  • session_question_id — BIGINT — Foreign key → session_questions.session_question_id — NOT NULL
  • attempt_no — INT — NOT NULL
  • recognition_status — VARCHAR(20) — NOT NULL
  • recognized_text — VARCHAR(255)
  • judgement_result — VARCHAR(20) — NOT NULL
  • attempted_at — DATETIME — NOT NULL

child_profiles

  • child_profile_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • birth_date — DATE — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

comm_feedback_reports

  • comm_feedback_report_id — BIGINT — Primary key — NOT NULL
  • comm_session_id — BIGINT — Foreign key → comm_sessions.comm_session_id — NOT NULL
  • comm_message_id — BIGINT — Foreign key → comm_messages.comm_message_id
  • reporter_member_id — BIGINT — Foreign key → members.member_id
  • reason_code — VARCHAR(30) — NOT NULL
  • reason_detail — VARCHAR(500)
  • delivery_status — VARCHAR(20) — NOT NULL
  • retry_count — INT — NOT NULL
  • next_retry_at — DATETIME
  • last_error — VARCHAR(500)
  • created_at — DATETIME — NOT NULL

comm_messages

  • comm_message_id — BIGINT — Primary key — NOT NULL
  • comm_session_id — BIGINT — Foreign key → comm_sessions.comm_session_id — NOT NULL
  • message_no — INT — NOT NULL
  • speaker_type — VARCHAR(20) — NOT NULL
  • source_type — VARCHAR(20) — NOT NULL
  • original_text — VARCHAR(1000)
  • translated_text — VARCHAR(1000)
  • comm_translation_result_id — BIGINT — Foreign key → comm_translation_results.comm_translation_result_id
  • rendered_at — DATETIME — NOT NULL

comm_sessions

  • comm_session_id — BIGINT — Primary key — NOT NULL
  • user_mode — VARCHAR(20) — NOT NULL
  • guest_id — VARCHAR(120)
  • started_by_member_id — BIGINT — Foreign key → members.member_id
  • child_profile_id — BIGINT — Foreign key → child_profiles.child_profile_id
  • permission_camera_granted — TINYINT(1) — NOT NULL
  • permission_mic_granted — TINYINT(1) — NOT NULL
  • session_status — VARCHAR(20) — NOT NULL
  • started_at — DATETIME — NOT NULL
  • ended_at — DATETIME

comm_translation_results

  • comm_translation_result_id — BIGINT — Primary key — NOT NULL
  • comm_session_id — BIGINT — Foreign key → comm_sessions.comm_session_id — NOT NULL
  • lstm_gloss — VARCHAR(255)
  • lstm_confidence — DECIMAL(5,4)
  • llm_output_text — VARCHAR(1000)
  • fallback_used — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

learning_categories

  • category_id — BIGINT — Primary key — NOT NULL
  • category_code — VARCHAR(50) — NOT NULL
  • category_name — VARCHAR(100) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL

learning_sessions

  • learning_session_id — BIGINT — Primary key — NOT NULL
  • child_profile_id — BIGINT — Foreign key → child_profiles.child_profile_id — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • category_id — BIGINT — Foreign key → learning_categories.category_id
  • difficulty_level — VARCHAR(20)
  • session_status — VARCHAR(20) — NOT NULL
  • started_at — DATETIME — NOT NULL
  • ended_at — DATETIME

learning_words

  • word_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → learning_categories.category_id — NOT NULL
  • word_text — VARCHAR(100) — NOT NULL
  • image_url — VARCHAR(1000)
  • audio_url — VARCHAR(1000)
  • default_difficulty — VARCHAR(20) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL

member_social_accounts

  • social_account_id — BIGINT — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(128) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • linked_at — DATETIME — NOT NULL

members

  • member_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(320) — NOT NULL
  • password_hash — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

redis_access_token_blacklist

  • access_jti — VARCHAR(128) — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id
  • expires_at — DATETIME — NOT NULL

redis_ai_inference_queue

  • queue_item_id — VARCHAR(128) — Primary key — NOT NULL
  • comm_session_id — BIGINT — Foreign key → comm_sessions.comm_session_id
  • learning_session_id — BIGINT — Foreign key → learning_sessions.learning_session_id
  • session_question_id — BIGINT — Foreign key → session_questions.session_question_id
  • job_type — VARCHAR(30) — NOT NULL
  • job_status — VARCHAR(20) — NOT NULL
  • payload_text — LONGTEXT — NOT NULL
  • available_at — DATETIME — NOT NULL
  • retry_count — INT — NOT NULL
  • max_retry_count — INT — NOT NULL

redis_comm_frame_buffers

  • frame_buffer_key — VARCHAR(120) — Primary key — NOT NULL
  • comm_session_id — BIGINT — Foreign key → comm_sessions.comm_session_id — NOT NULL
  • max_frames — INT — NOT NULL
  • current_frames — INT — NOT NULL
  • expires_at — DATETIME — NOT NULL

redis_password_reset_tokens

  • reset_token_key — VARCHAR(128) — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id
  • email — VARCHAR(320) — NOT NULL
  • verification_value_hash — VARCHAR(255) — NOT NULL
  • is_verified — TINYINT(1) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • requested_at — DATETIME — NOT NULL

redis_refresh_tokens

  • refresh_token_key — VARCHAR(128) — Primary key — NOT NULL
  • member_id — BIGINT — Foreign key → members.member_id — NOT NULL
  • token_status — VARCHAR(20) — NOT NULL
  • expires_at — DATETIME — NOT NULL

session_question_results

  • session_question_result_id — BIGINT — Primary key — NOT NULL
  • session_question_id — BIGINT — Foreign key → session_questions.session_question_id — NOT NULL
  • final_attempt_id — BIGINT — Foreign key → answer_attempts.answer_attempt_id
  • final_result — VARCHAR(20) — NOT NULL
  • attempts_count — INT — NOT NULL
  • emotion_label — VARCHAR(30)
  • emotion_score — DECIMAL(5,4)
  • tone_label — VARCHAR(30)
  • tone_score — DECIMAL(5,4)
  • analyzed_at — DATETIME
  • finalized_at — DATETIME — NOT NULL

session_questions

  • session_question_id — BIGINT — Primary key — NOT NULL
  • learning_session_id — BIGINT — Foreign key → learning_sessions.learning_session_id — NOT NULL
  • question_no — INT — NOT NULL
  • word_id — BIGINT — Foreign key → learning_words.word_id — NOT NULL
  • question_status — VARCHAR(20) — NOT NULL
  • presented_at — DATETIME
  • answered_at — DATETIME