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