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