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