SUDA

Tables (11)

child_profiles

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE — NOT NULL
  • avatar_key — VARCHAR(50) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

communication_messages

  • id — BIGSERIAL
  • session_id — BIGINT — Foreign key → communication_sessions.id — NOT NULL
  • speaker_role — VARCHAR(20) — NOT NULL
  • direction — VARCHAR(50) — NOT NULL
  • source_type — VARCHAR(30) — NOT NULL
  • original_words — TEXT
  • recognized_text — TEXT
  • final_text — TEXT — NOT NULL
  • audio_mime_type — VARCHAR(100)
  • tts_speaker — VARCHAR(50)
  • locale — VARCHAR(20) — NOT NULL
  • message_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

communication_session_analysis

  • id — BIGSERIAL
  • session_id — BIGINT — Foreign key → communication_sessions.id — NOT NULL
  • analysis_status — VARCHAR(20) — NOT NULL
  • summary_json — TEXT
  • analyzed_at — TIMESTAMP
  • analysis_version — VARCHAR(30) — NOT NULL
  • model_name — VARCHAR(100)
  • prompt_version — VARCHAR(30) — NOT NULL
  • analysis_error_code — VARCHAR(100)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

communication_sessions

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • child_profile_id — BIGINT — Foreign key → child_profiles.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP
  • message_count — INTEGER — NOT NULL
  • summary_text — TEXT
  • expires_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

learn

  • id — BIGSERIAL
  • category_id — BIGINT — Foreign key → learn_categories.id — NOT NULL
  • difficulty — VARCHAR(20) — NOT NULL
  • word — VARCHAR(100) — NOT NULL
  • display_text — VARCHAR(100) — NOT NULL
  • pronunciation_text — VARCHAR(100)
  • image_url — VARCHAR(500)
  • audio_url — VARCHAR(500)
  • active — BOOLEAN — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

learn_categories

  • id — BIGSERIAL
  • name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(255)
  • thumbnail_url — VARCHAR(500)
  • active — BOOLEAN — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

quiz_answers

  • id — BIGSERIAL
  • session_id — BIGINT — Foreign key → quiz_sessions.id — NOT NULL
  • question_id — BIGINT — Foreign key → quiz_questions.id — NOT NULL
  • word_id — BIGINT — Foreign key → learn.id — NOT NULL
  • target_text — VARCHAR(100) — NOT NULL
  • recognized_text — VARCHAR(100)
  • is_correct — BOOLEAN — NOT NULL
  • star — INTEGER — NOT NULL
  • feedback — VARCHAR(255)
  • grading_reason — VARCHAR(500)
  • confidence — DOUBLE
  • answered_at — TIMESTAMP — NOT NULL

quiz_questions

  • id — BIGSERIAL
  • session_id — BIGINT — Foreign key → quiz_sessions.id — NOT NULL
  • word_id — BIGINT — Foreign key → learn.id — NOT NULL
  • question_number — INTEGER — NOT NULL
  • answered — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

quiz_sessions

  • id — BIGSERIAL
  • child_profile_id — BIGINT — Foreign key → child_profiles.id — NOT NULL
  • category_id — BIGINT — Foreign key → learn_categories.id — NOT NULL
  • difficulty — VARCHAR(50) — NOT NULL
  • total_question_count — INTEGER — NOT NULL
  • correct_count — INTEGER — NOT NULL
  • total_star — INTEGER — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • ended_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

social_accounts

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • provider — VARCHAR(30) — NOT NULL
  • provider_user_id — VARCHAR(255) — NOT NULL
  • provider_email — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • password_login_enabled — BOOLEAN — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • active — BOOLEAN — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • tts_speaker — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL