seoul test

Tables (66)

ad

  • id — CHAR(24) — Primary key — NOT NULL
  • wala_code — VARCHAR(100)
  • is_show — TINYINT
  • views — INT
  • payload_json — LONGTEXT — Inactive ad integration

ai_cover

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • ai_model_id — CHAR(26) — Foreign key → ai_cover_model.ai_model_id — NOT NULL
  • video_id — VARCHAR(20) — NOT NULL — YouTube ID; lyrics document not required
  • ai_cover_name — TEXT
  • ai_cover_status — VARCHAR(30)
  • ai_cover_link — TEXT
  • ai_cover_streaming_link — TEXT
  • thumbnail — TEXT
  • likes — INT
  • reports — INT
  • hit_counter — INT
  • is_deleted — TINYINT
  • created_timestamp — VARCHAR(30)
  • created_at — BIGINT
  • created_date — BIGINT

ai_cover_action

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL — Actor
  • user_sub_author — VARCHAR(255)
  • ai_model_id — CHAR(26) — Foreign key → ai_cover.ai_model_id — NOT NULL
  • video_id — VARCHAR(20) — Foreign key → ai_cover.video_id — NOT NULL
  • action_type — VARCHAR(20) — NOT NULL — like or report
  • thumbnail — TEXT
  • created_at — BIGINT

ai_cover_model

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • ai_model_id — CHAR(26) — NOT NULL — Logical ULID
  • ai_model_status — VARCHAR(30) — init, uploaded, complete, error, removed
  • created_timestamp — VARCHAR(30)
  • created_at — BIGINT
  • is_deleted — TINYINT
  • error_status — VARCHAR(100)

ai_cover_playback

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • ai_model_id — CHAR(26) — Foreign key → ai_cover.ai_model_id — NOT NULL
  • video_id — VARCHAR(20) — Foreign key → ai_cover.video_id — NOT NULL
  • created_at — BIGINT

archive_file_sing

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub
  • video_id — VARCHAR(20) — YouTube ID; no required lyrics document
  • link — TEXT
  • file_size_mb — DECIMAL(10, 2)
  • created_timestamp — VARCHAR(30)
  • created_at — BIGINT

artists

  • id — CHAR(24) — Primary key — NOT NULL
  • artist_id — CHAR(26) — NOT NULL — Logical ULID; unique here for diagram references
  • artist — VARCHAR(255) — NOT NULL
  • artist_image_link — TEXT
  • artist_image_link_thumbnail — TEXT
  • keywords_json — LONGTEXT — MongoDB keywords array
  • favorite_count — INT
  • sort_order — INT
  • created_at — BIGINT

comments

  • id — CHAR(24) — Primary key — NOT NULL
  • comment_id — CHAR(26) — NOT NULL — Logical ULID
  • parent_id — VARCHAR(512) — NOT NULL — lyrics.video_id or redis_key, posts.post_id, comments.comment_id
  • parent_type — VARCHAR(20) — NOT NULL — lyrics, posts, comments
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • user_sub_author — VARCHAR(255) — Copied parent author
  • body — TEXT
  • translations_json — LONGTEXT — body_translated_* fields
  • likes — INT
  • reports — INT
  • is_deleted — TINYINT
  • timestamp_at_deleted — BIGINT
  • created_at — BIGINT

comments_action

  • id — CHAR(24) — Primary key — NOT NULL
  • comment_id — CHAR(26) — Foreign key → comments.comment_id — NOT NULL
  • parent_id — VARCHAR(512) — Copied polymorphic parent ID
  • parent_type — VARCHAR(20)
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL — Actor
  • user_sub_author — VARCHAR(255)
  • action_type — VARCHAR(20) — NOT NULL — like or report
  • report_comment — TEXT
  • created_at — BIGINT

dictionary

  • id — CHAR(24) — Primary key — NOT NULL
  • original_word — TEXT
  • translations_json — LONGTEXT — Dynamic language-code keys

dubbing_meta

  • id — CHAR(24) — Primary key — NOT NULL
  • status — VARCHAR(30)
  • dubbing_id — VARCHAR(100) — Embedded params.dubbing_id
  • params_json — LONGTEXT
  • result_json — LONGTEXT
  • error_message — TEXT
  • created_at — BIGINT

home_api_order

  • id — CHAR(24) — Primary key — NOT NULL
  • order — INT
  • fe_enum — VARCHAR(100)
  • api — VARCHAR(255)
  • playlist_name — VARCHAR(100) — Name may resolve to lyrics or lesson playlist
  • name — VARCHAR(255)

lesson

  • id — CHAR(24) — Primary key — NOT NULL
  • redis_key — VARCHAR(512) — NOT NULL
  • music_artist — VARCHAR(255) — Embedded metadata.artist
  • music_title — VARCHAR(255) — Embedded metadata.title
  • music_album — VARCHAR(255)
  • difficulty — VARCHAR(100)
  • description — TEXT
  • cover_image — TEXT
  • instructor_snapshot_json — LONGTEXT — Embedded metadata.instructor
  • metadata_json — LONGTEXT — Other embedded metadata fields

lesson_instructor

  • id — CHAR(24) — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • profile_image — TEXT

lesson_instructor_v3

  • id — CHAR(24) — Primary key — NOT NULL
  • instructor_id — CHAR(26) — NOT NULL — Logical ULID
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • biography — TEXT
  • profile_image — TEXT
  • created_at — BIGINT

lesson_learn

  • id — CHAR(24) — Primary key — NOT NULL
  • redis_key — VARCHAR(512) — NOT NULL
  • artist — VARCHAR(255)
  • title — VARCHAR(255)
  • video — TEXT
  • thumbnail — TEXT
  • flows_wordbyword_json — LONGTEXT
  • flows_sentence_json — LONGTEXT
  • sort_order — INT
  • created_at — BIGINT

lesson_playback

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub
  • redis_key — VARCHAR(512) — Foreign key → lesson.redis_key
  • artist — VARCHAR(255)
  • title — VARCHAR(255)
  • learn_title — VARCHAR(255)
  • created_at — BIGINT

lesson_playlist

  • id — CHAR(24) — Primary key — NOT NULL
  • playlist_name — VARCHAR(100) — NOT NULL
  • sort_order — INT

lesson_playlist_v2_item

  • item_index — INT — Primary key — NOT NULL
  • playlist_id — CHAR(24) — Foreign key → lesson_playlist.id — NOT NULL
  • lesson_redis_key — VARCHAR(512) — Foreign key → lesson.redis_key — NOT NULL — MongoDB video_ids array

lesson_playlist_v3_item

  • item_index — INT — Primary key — NOT NULL
  • playlist_id — CHAR(24) — Foreign key → lesson_playlist.id — NOT NULL
  • lesson_id — CHAR(26) — Foreign key → lesson_v3.lesson_id — NOT NULL — MongoDB lesson_ids array

lesson_rating

  • id — CHAR(24) — Primary key — NOT NULL
  • redis_key — VARCHAR(512) — KEY.LESSON_RATING; differs from lesson.redis_key
  • counts — INT
  • sum — INT

lesson_rating_raw

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub
  • redis_key — VARCHAR(512) — Foreign key → lesson.redis_key
  • rating — INT
  • created_at — VARCHAR(30) — Formatted timestamp text

lesson_rating_raw_v3

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub
  • lesson_id — CHAR(26) — Foreign key → lesson_v3.lesson_id
  • rating — INT
  • comment — TEXT
  • created_at — VARCHAR(30) — Formatted timestamp text

lesson_rating_v3

  • id — CHAR(24) — Primary key — NOT NULL
  • lesson_id — CHAR(26) — Foreign key → lesson_v3.lesson_id — NOT NULL
  • counts — INT
  • sum — INT

lesson_unit_v3

  • id — CHAR(24) — Primary key — NOT NULL
  • unit_id — CHAR(26) — NOT NULL — Logical ULID
  • link_video — TEXT
  • link_thumbnail — TEXT
  • created_at — BIGINT

lesson_unit_v3_section

  • section_id — CHAR(26) — Primary key — NOT NULL
  • unit_id — CHAR(26) — Foreign key → lesson_unit_v3.unit_id — NOT NULL
  • section_type — VARCHAR(100)
  • section_number — VARCHAR(30)
  • section_name — VARCHAR(255)
  • timestamp_start — VARCHAR(30)
  • timestamp_end — VARCHAR(30)

lesson_v2_item

  • item_index — INT — Primary key — NOT NULL
  • lesson_id — CHAR(24) — Foreign key → lesson.id — NOT NULL
  • learn_redis_key — VARCHAR(512) — Foreign key → lesson_learn.redis_key — Source learn document is copied into lesson
  • learn_title — VARCHAR(255)
  • learn_description — TEXT
  • learn_length — VARCHAR(30)
  • is_free — TINYINT
  • learn_price — INT
  • learn_snapshot_json — LONGTEXT

lesson_v3

  • id — CHAR(24) — Primary key — NOT NULL
  • lesson_id — CHAR(26) — NOT NULL — Logical ULID
  • instructor_id — CHAR(26) — Foreign key → lesson_instructor_v3.instructor_id — Copied into metadata.instructor
  • music_artist — VARCHAR(255)
  • music_title — VARCHAR(255)
  • music_album — VARCHAR(255)
  • difficulty — VARCHAR(100)
  • description — TEXT
  • link_thumbnail — TEXT
  • preview_video — TEXT
  • hit_counter — INT — metadata.hit_counter
  • metadata_snapshot_json — LONGTEXT — Other embedded metadata fields
  • created_at — BIGINT

lesson_v3_playback

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub
  • lesson_id — CHAR(26) — Foreign key → lesson_v3.lesson_id
  • unit_id — CHAR(26) — Foreign key → lesson_unit_v3.unit_id
  • created_at — BIGINT

lesson_v3_unit

  • item_index — INT — Primary key — NOT NULL
  • lesson_id — CHAR(26) — Foreign key → lesson_v3.lesson_id — NOT NULL
  • unit_id — CHAR(26) — Foreign key → lesson_unit_v3.unit_id — NOT NULL
  • unit_title — VARCHAR(255)
  • unit_description — TEXT
  • is_free — TINYINT
  • unit_snapshot_json — LONGTEXT — Embedded units snapshot including sections

lyrics

  • id — CHAR(24) — Primary key — NOT NULL
  • video_id — VARCHAR(20) — NOT NULL — YouTube video ID; unique MongoDB index
  • redis_key — VARCHAR(512) — Legacy lyrics key
  • user_sub — VARCHAR(255) — Foreign key → users.sub
  • artist_id — CHAR(26) — Foreign key → artists.artist_id
  • video_title — TEXT
  • video_thumbnail — TEXT
  • video_id_karaoke — VARCHAR(20)
  • music_artist — VARCHAR(255)
  • music_album — VARCHAR(255)
  • music_title — VARCHAR(255)
  • status — VARCHAR(30) — ready, processing, complete, error
  • hit_counter — INT
  • has_music_meta — TINYINT
  • attempts_to_get_music_meta — INT
  • is_without_lyrics — TINYINT
  • is_translated_by_chatgpt — TINYINT
  • is_deleted — TINYINT
  • created_at — BIGINT
  • complete_at — BIGINT
  • music_meta_updated_at — BIGINT
  • meta_youtube_json — LONGTEXT — Embedded YouTube snippet
  • lyrics_metadata_json — LONGTEXT — Embedded lyrics.metadata

lyrics_cover_image

  • id — CHAR(24) — Primary key — NOT NULL
  • music_artist — VARCHAR(255)
  • music_album — VARCHAR(255)
  • cover_image_link — TEXT
  • cover_image_link_thumbnail — TEXT

lyrics_line

  • line_no — INT — Primary key — NOT NULL
  • lyrics_id — CHAR(24) — Foreign key → lyrics.id — NOT NULL
  • time — VARCHAR(30)
  • original — TEXT
  • romanized — TEXT
  • katakana — TEXT
  • translations_json — LONGTEXT — translated_* fields from embedded lyrics.lyrics

lyrics_playback

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub
  • video_id — VARCHAR(20) — Foreign key → lyrics.video_id
  • created_at — BIGINT

lyrics_playlist

  • id — CHAR(24) — Primary key — NOT NULL
  • playlist_name — VARCHAR(100) — NOT NULL
  • order — INT

lyrics_playlist_video_item

  • item_index — INT — Primary key — NOT NULL
  • playlist_id — CHAR(24) — Foreign key → lyrics_playlist.id — NOT NULL
  • video_id — VARCHAR(20) — Foreign key → lyrics.video_id — NOT NULL — MongoDB video_ids array

lyrics_report

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub
  • video_id — VARCHAR(20) — Foreign key → lyrics.video_id
  • action_type — VARCHAR(20)
  • title — VARCHAR(255)
  • report_comment — TEXT
  • user_name — VARCHAR(100)
  • created_at — VARCHAR(30) — This path stores formatted timestamp text

lyrics_request_karaoke

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub
  • video_id — VARCHAR(20) — Foreign key → lyrics.video_id
  • status — VARCHAR(30)
  • created_at — BIGINT

lyricsync

  • id — CHAR(24) — Primary key — NOT NULL
  • video_id — VARCHAR(20)
  • user_sub — VARCHAR(255)
  • status — VARCHAR(30)
  • created_at — BIGINT
  • payload_json — LONGTEXT — Legacy lyricsync worker document

posts

  • id — CHAR(24) — Primary key — NOT NULL
  • post_id — CHAR(26) — NOT NULL — Logical ULID
  • parent_id — CHAR(26) — Foreign key → artists.artist_id — artists.artist_id
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • body — LONGTEXT
  • translated_json — LONGTEXT — Embedded translations object
  • image_links_json — LONGTEXT — Embedded image_links array
  • likes — INT
  • reports — INT
  • is_deleted — TINYINT
  • created_at — BIGINT

posts_action

  • id — CHAR(24) — Primary key — NOT NULL
  • post_id — CHAR(26) — Foreign key → posts.post_id — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL — Actor
  • user_sub_author — VARCHAR(255) — Copied post author for notification
  • parent_id — CHAR(26) — Copied artist ID
  • action_type — VARCHAR(20) — NOT NULL — like or report
  • report_comment — TEXT
  • image_links_json — LONGTEXT
  • created_at — BIGINT

posts_images

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • image_link — TEXT
  • created_at — BIGINT

promotion_codes

  • id — CHAR(24) — Primary key — NOT NULL
  • code — VARCHAR(100) — NOT NULL
  • promotion_type — VARCHAR(100)
  • user_sub — VARCHAR(255) — Foreign key → users.sub — Redeeming user; absent before use
  • is_used — TINYINT
  • used_at — BIGINT

promotion_entries

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • promotion_type — VARCHAR(100) — NOT NULL
  • used_at — BIGINT

short_url

  • id — CHAR(24) — Primary key — NOT NULL
  • short_key — VARCHAR(20)
  • short_url — TEXT
  • url — TEXT
  • created_at — BIGINT

system

  • id — CHAR(24) — Primary key — NOT NULL
  • data_type — VARCHAR(100) — banners, binaries, gpu_indicator, admin_keys, etc.
  • type — VARCHAR(100) — Banner type or legacy indicator type
  • image_link — TEXT
  • link — TEXT
  • title — VARCHAR(255)
  • message — TEXT
  • is_show — TINYINT
  • order — INT
  • updated_at — BIGINT
  • payload_json — LONGTEXT — All other dynamic settings and nested fields

system_admin_key

  • key_id — VARCHAR(20) — Primary key — NOT NULL
  • system_id — CHAR(24) — Foreign key → system.id — NOT NULL — system.data_type = admin_keys
  • key_value — VARCHAR(255) — MongoDB keys.key; never include actual values in ERD
  • role — VARCHAR(20) — dev or editor
  • label — VARCHAR(100)
  • created_at — BIGINT

system_allowed_ip

  • ip_prefix — VARCHAR(100) — Primary key — NOT NULL
  • system_id — CHAR(24) — Foreign key → system.id — NOT NULL — system.data_type = admin_allowed_ips

system_upload_url

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • upload_url — TEXT
  • created_at — BIGINT

toasts

  • id — CHAR(24) — Primary key — NOT NULL
  • message — TEXT
  • is_show — TINYINT
  • created_at — BIGINT

tokens_fcm

  • id — CHAR(24) — Primary key — NOT NULL
  • token — VARCHAR(512) — NOT NULL — May be registered anonymously

trending

  • id — CHAR(24) — Primary key — NOT NULL
  • video_id — VARCHAR(20)
  • lyricsync_status — VARCHAR(30)
  • created_timestamp — VARCHAR(30)
  • youtube_payload_json — LONGTEXT — Legacy trending worker document

users

  • id — CHAR(24) — Primary key — NOT NULL
  • sub — VARCHAR(255) — NOT NULL — OAuth subject; unique MongoDB index
  • email — VARCHAR(255)
  • user_name — VARCHAR(100)
  • marketing_agreement — TINYINT
  • profile_image — TEXT
  • badge_image — TEXT
  • badge — VARCHAR(100)
  • platform — VARCHAR(20)
  • country_code — VARCHAR(10)
  • birth_date — VARCHAR(20)
  • promotion — VARCHAR(100)
  • fcm_token — VARCHAR(255)
  • egg_counts — INT
  • subs_status — VARCHAR(20)
  • subs_start — BIGINT — Unix epoch milliseconds
  • subs_expiry — BIGINT — Unix epoch milliseconds
  • subs_type — VARCHAR(100)
  • personalized_playlist_expiry — BIGINT
  • is_answered_survey_2023_10 — TINYINT
  • is_answered_survey_2024_03 — TINYINT
  • last_notification_checked_at — BIGINT
  • is_deleted — TINYINT — 0 active, 1 withdrawn
  • created_at — BIGINT — Unix epoch milliseconds

users_blacklist

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL

users_favorite_artist

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • music_artists_json — LONGTEXT — Legacy artist-name array

users_favorite_artist_item

  • favorite_id — CHAR(24) — Foreign key → users_favorite_artist.id — NOT NULL
  • artist_id — CHAR(26) — Foreign key → artists.artist_id — NOT NULL

users_feedbacks

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — Absent for anonymous NPS and song requests
  • feedback_type — VARCHAR(100)
  • message — TEXT
  • answer — INT
  • recommend_point — INT
  • request — TEXT
  • created_at — BIGINT

users_log_eggs

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • where — VARCHAR(512) — Reward or consumption source
  • egg_counts — INT — Positive for credit, negative for debit
  • created_at — BIGINT

users_log_watch_ads

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • where — VARCHAR(512) — Learn key
  • stamp_count — INT

users_playlist

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • playlist_name — VARCHAR(100) — NOT NULL — saved_songs, saved_lessons, saved_lessons_v3, etc.

users_playlist_lesson_item

  • item_index — INT — Primary key — NOT NULL
  • playlist_id — CHAR(24) — Foreign key → users_playlist.id — NOT NULL
  • lesson_id — CHAR(26) — Foreign key → lesson_v3.lesson_id — NOT NULL — MongoDB lesson_ids array

users_playlist_video_item

  • item_index — INT — Primary key — NOT NULL
  • playlist_id — CHAR(24) — Foreign key → users_playlist.id — NOT NULL
  • video_id_or_redis_key — VARCHAR(512) — NOT NULL — Polymorphic video_ids array: lyrics.video_id or lesson.redis_key

users_purchase

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • purchase_type — VARCHAR(30) — NOT NULL — learn, lesson, karaoke

users_purchase_key

  • item_index — INT — Primary key — NOT NULL
  • purchase_id — CHAR(24) — Foreign key → users_purchase.id — NOT NULL
  • purchase_key — VARCHAR(512) — NOT NULL — Polymorphic key; target depends on purchase_type

users_receipt

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • product_id — VARCHAR(255)
  • receipt — LONGTEXT
  • platform — VARCHAR(20)
  • created_at — BIGINT

users_receipt_subs

  • id — CHAR(24) — Primary key — NOT NULL
  • user_sub — VARCHAR(255) — Foreign key → users.sub — NOT NULL
  • product_id — VARCHAR(255)
  • transaction_id — VARCHAR(255)
  • receipt — LONGTEXT
  • timestamp_start — BIGINT
  • timestamp_expiry — BIGINT
  • verify_result — TINYINT
  • created_at — BIGINT