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