test
Tables (14)
attendance_logs
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- visit_date — DATE — NOT NULL
bookmarks
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- session_id — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
daily_best_records
- level — INTEGER — Primary key — NOT NULL
- record_date — DATE — Primary key — NOT NULL
- user_id — BIGINT — Foreign key — NOT NULL
- game_record_id — BIGINT
- best_final_score — NUMERIC(10, 2) — NOT NULL
daily_game_sentences
- id — BIGSERIAL
- level — INTEGER — NOT NULL
- game_sentence_id — BIGINT — NOT NULL
- assigned_date — DATE — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
evaluations
- id — BIGSERIAL
- session_id — BIGINT — NOT NULL
- sentence_id — BIGINT — NOT NULL
- step — INTEGER — NOT NULL
- user_transcription — TEXT — NOT NULL
- word_level_feedback — JSON — NOT NULL
- boundary_tone_feedback — JSON — NOT NULL
- dynamic_stress_feedback — JSON — NOT NULL
- total_score — NUMERIC(5, 2) — NOT NULL
- word_accuracy — NUMERIC(5, 2) — NOT NULL
- prosody_and_stress — NUMERIC(5, 2) — NOT NULL
- word_rhythm_score — NUMERIC(5, 2) — NOT NULL
- boundary_tone_score — NUMERIC(5, 2) — NOT NULL
- dynamic_stress_score — NUMERIC(5, 2) — NOT NULL
- speed_similarity — NUMERIC(5, 2) — NOT NULL
- pause_similarity — NUMERIC(5, 2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- id (id2) — BIGSERIAL — Foreign key → sentences.id
game_records
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- level — INTEGER — NOT NULL
- played_date — DATE — NOT NULL
- hearts — INTEGER — NOT NULL
- avg_total_score — NUMERIC(10, 2) — NOT NULL
- avg_word_rhythm_score — NUMERIC(10, 2) — NOT NULL
- avg_dynamic_stress_score — NUMERIC(10, 2) — NOT NULL
- avg_word_accuracy — NUMERIC(10, 2) — NOT NULL
- final_score — NUMERIC(10, 2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
game_sentences
- id — BIGSERIAL
- level — INTEGER — NOT NULL
- content — TEXT — NOT NULL
- masked_content — TEXT
- word_timestamps — TEXT
- features_url — VARCHAR(255)
- metadata_url — VARCHAR(255)
- reference_audio_url — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
reports
- id — BIGSERIAL
- session_id — BIGINT — NOT NULL
- cycle_number — INTEGER — NOT NULL
- total_score — NUMERIC(5, 2) — NOT NULL
- word_accuracy — NUMERIC(5, 2) — NOT NULL
- prosody_and_stress — NUMERIC(5, 2) — NOT NULL
- word_rhythm_score — NUMERIC(5, 2) — NOT NULL
- boundary_tone_score — NUMERIC(5, 2) — NOT NULL
- dynamic_stress_score — NUMERIC(5, 2) — NOT NULL
- speed_similarity — NUMERIC(5, 2) — NOT NULL
- pause_similarity — NUMERIC(5, 2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
sentences
- id — BIGSERIAL — Primary key
- session_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- start_sec — DOUBLE — NOT NULL
- end_sec — DOUBLE — NOT NULL
- duration_sec — DOUBLE — NOT NULL
- word_timestamps — JSON
- features_url — VARCHAR(255)
- sentence_ko — TEXT
- difficulty — VARCHAR(20)
- difficulty_score — DOUBLE
- key_expressions — JSON
- vocabulary_json — JSON
- study_count — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
study_sessions
- id — BIGSERIAL
- user_id — BIGINT — NOT NULL
- video_id — VARCHAR(50) — NOT NULL
- parent_session_id — BIGINT
- start_sec — DOUBLE — NOT NULL
- end_sec — DOUBLE — NOT NULL
- status — VARCHAR(20) — NOT NULL
- cycle_count — INTEGER — NOT NULL
- is_reviewing — BOOLEAN — NOT NULL
- name — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
user_game_profiles
- user_id — BIGINT
- tier — VARCHAR(20) — NOT NULL
- weekly_score — NUMERIC(10, 2) — NOT NULL
- consecutive_no_play_weeks — INTEGER — NOT NULL
- frozen — BOOLEAN — NOT NULL
- last_played_week — DATE
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
users
- id — BIGSERIAL
- email — VARCHAR(50)
- nickname — VARCHAR(20) — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(50) — NOT NULL
- visited_count — INTEGER — NOT NULL
- last_visited_date — DATE
- deleted_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
videos
- video_id — VARCHAR(50)
- title — VARCHAR(255) — NOT NULL
- embed_url — VARCHAR(255) — NOT NULL
- thumbnail_url — VARCHAR(255)
- duration — INTEGER — NOT NULL
- channel_title — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
week_sentences
- id — BIGSERIAL
- report_id — BIGINT — NOT NULL
- sentence_id — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- id (id2) — BIGSERIAL — Foreign key → sentences.id