MICONv2
Tables (42)
artist_portrait
- normalized_name — VARCHAR(100) — Primary key — NOT NULL
- display_name — VARCHAR(100) — NOT NULL
- image_url — VARCHAR(2048) — NOT NULL
embedding_catalog_active
- channel — VARCHAR(32) — Primary key — NOT NULL
- batch_id — VARCHAR(64) — Foreign key → embedding_catalog_batch.batch_id
- revision — BIGINT — NOT NULL
embedding_catalog_batch
- batch_id — VARCHAR(64) — Primary key — NOT NULL
- bucket — VARCHAR(63) — NOT NULL — Private S3 bucket
- region — VARCHAR(32) — NOT NULL
- object_prefix — VARCHAR(512) — NOT NULL
- manifest_key — VARCHAR(1024) — NOT NULL — S3 manifest object key
- manifest_sha256 — CHAR(64) — NOT NULL
- manifest_bytes — INT — NOT NULL
- models_json — JSON — NOT NULL
- track_count — INT — NOT NULL
embedding_catalog_event
- event_id — BIGINT — Primary key — NOT NULL
- channel — VARCHAR(32) — NOT NULL
- batch_id — VARCHAR(64) — Foreign key → embedding_catalog_batch.batch_id — NOT NULL
- previous_batch_id — VARCHAR(64) — Foreign key → embedding_catalog_batch.batch_id
- revision — BIGINT — NOT NULL
favorite_song
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- song_id — VARCHAR(64) — Foreign key → song.song_id — NOT NULL
- preferred_key — SMALLINT
genre
- genre_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- normalized_name — VARCHAR(100) — NOT NULL
- category — VARCHAR(20) — NOT NULL
- preference_label — VARCHAR(100)
- preference_order — SMALLINT
password_reset_request
- password_reset_request_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- request_id — VARCHAR(36) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
practice_result
- practice_result_id — BIGINT — Primary key — NOT NULL
- practice_id — BIGINT — Foreign key → practice_session.practice_id — NOT NULL
- status — VARCHAR(30) — NOT NULL
practice_session
- practice_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- song_id — VARCHAR(64) — Foreign key → song.song_id — NOT NULL
- section_id — BIGINT — Foreign key → song_section.section_id
- recording_id — BIGINT — Foreign key → voice_recording.recording_id
- status — VARCHAR(30) — NOT NULL
recommendation
- recommendation_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- profile_id — BIGINT — Foreign key → user_voice_profile.profile_id
- profile_version — BIGINT
- preference_version — BIGINT
- mode — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
recommendation_shelf
- recommendation_shelf_id — BIGINT — Primary key — NOT NULL
- recommendation_id — BIGINT — Foreign key → recommendation.recommendation_id — NOT NULL
- shelf_key — VARCHAR(50) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- metric — VARCHAR(255)
- shelf_order — SMALLINT — NOT NULL
recommendation_song
- recommendation_id — BIGINT — Foreign key → recommendation_shelf.recommendation_id — NOT NULL
- song_id — VARCHAR(64) — Foreign key → song.song_id — NOT NULL
- recommendation_shelf_id — BIGINT — Foreign key → recommendation_shelf.recommendation_shelf_id — NOT NULL
- overall_rank — SMALLINT — NOT NULL
- shelf_position — SMALLINT — NOT NULL
refresh_token
- refresh_token_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- session_id — VARCHAR(36) — NOT NULL
- token_hash — VARCHAR(255) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
setlist
- setlist_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
setlist_item
- setlist_item_id — BIGINT — Primary key — NOT NULL
- setlist_id — BIGINT — Foreign key → setlist.setlist_id — NOT NULL
- song_id — VARCHAR(64) — Foreign key → song.song_id — NOT NULL
- position_no — INT — NOT NULL
similar_artist_result
- similar_artist_result_id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → voice_analysis_component_job.session_id — NOT NULL
- component_job_id — BIGINT — Foreign key → voice_analysis_component_job.component_job_id — NOT NULL
- singer_id — BIGINT — Foreign key → singer.singer_id — NOT NULL
- catalog_batch_id — VARCHAR(64) — Foreign key → embedding_catalog_batch.batch_id — NOT NULL
singer
- singer_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- normalized_name — VARCHAR(100) — NOT NULL
social_identity
- social_identity_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_subject — VARCHAR(255) — NOT NULL
social_login
- social_login_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
song
- song_id — VARCHAR(64) — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- title_normalized — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- practice_ready — BOOLEAN — NOT NULL
song_analysis
- analysis_id — BIGINT — Primary key — NOT NULL
- song_id — VARCHAR(64) — Foreign key → song.song_id — NOT NULL
- analysis_version — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
song_embedding
- model_key — VARCHAR(32) — Primary key — NOT NULL
- batch_id — VARCHAR(64) — Foreign key → embedding_catalog_batch.batch_id — NOT NULL
- song_id — VARCHAR(64) — Foreign key → song.song_id — NOT NULL
- catalog_track_id — VARCHAR(100) — NOT NULL
- object_key — VARCHAR(1024) — NOT NULL — Private S3 vector object key
- sha256 — CHAR(64) — NOT NULL
- file_bytes — INT — NOT NULL
- segment_count — SMALLINT — NOT NULL
- dimension — SMALLINT — NOT NULL
song_genre
- song_id — VARCHAR(64) — Foreign key → song.song_id — NOT NULL
- genre_id — BIGINT — Foreign key → genre.genre_id — NOT NULL
- is_primary — BOOLEAN — NOT NULL
song_media
- media_id — BIGINT — Primary key — NOT NULL
- song_id — VARCHAR(64) — Foreign key → song.song_id — NOT NULL
- kind — VARCHAR(40) — NOT NULL
- semitones — SMALLINT — NOT NULL
- file_path — VARCHAR(1024) — NOT NULL — S3 object key: source/instrumental/MIDI asset
song_metadata
- song_id — VARCHAR(64) — Foreign key → song.song_id — NOT NULL
- track_id — VARCHAR(100)
- catalog_track_id — VARCHAR(100)
song_note
- song_note_id — BIGINT — Primary key — NOT NULL
- analysis_id — BIGINT — Foreign key → song_analysis.analysis_id — NOT NULL
- karaoke_notes — JSON — NOT NULL
song_section
- section_id — BIGINT — Primary key — NOT NULL
- song_id — VARCHAR(64) — Foreign key → song.song_id — NOT NULL
- analysis_id — BIGINT — Foreign key → song_analysis.analysis_id
- section_type — VARCHAR(30) — NOT NULL
- sequence_no — SMALLINT — NOT NULL
song_singer
- song_id — VARCHAR(64) — Foreign key → song.song_id — NOT NULL
- singer_id — BIGINT — Foreign key → singer.singer_id — NOT NULL
- role — VARCHAR(20) — NOT NULL
user_genre_preference
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- genre_id — BIGINT — Foreign key → genre.genre_id — NOT NULL
user_singer_preference
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- singer_id — BIGINT — Foreign key → singer.singer_id — NOT NULL
user_voice_profile
- profile_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → voice_analysis_session.user_id — NOT NULL
- session_id — BIGINT — Foreign key → voice_analysis_session.session_id — NOT NULL
- profile_version — BIGINT — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(64)
- auth_type — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
voice_analysis_component_job
- component_job_id — BIGINT — Primary key — NOT NULL
- analysis_job_id — BIGINT — Foreign key → voice_analysis_job.analysis_job_id
- session_id — BIGINT — Foreign key → voice_analysis_session.session_id — NOT NULL
- recording_id — BIGINT — Foreign key → voice_recording.recording_id
- component_type — VARCHAR(30) — NOT NULL
- attempt_no — INT — NOT NULL
- status — VARCHAR(30) — NOT NULL
voice_analysis_job
- analysis_job_id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → voice_analysis_session.session_id — NOT NULL
- recording_id — BIGINT — Foreign key → voice_recording.recording_id
- request_id — VARCHAR(100) — NOT NULL
- analysis_type — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
voice_analysis_session
- session_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- song_id — VARCHAR(64) — Foreign key → song.song_id
- status — VARCHAR(30) — NOT NULL
voice_model_result
- model_result_id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → voice_analysis_component_job.session_id — NOT NULL
- component_job_id — BIGINT — Foreign key → voice_analysis_component_job.component_job_id — NOT NULL
- model_key — VARCHAR(30) — NOT NULL
- vector_object_key — VARCHAR(1024) — Private S3 model-vector object key; null when vector_json is stored
- vector_sha256 — CHAR(64) — NOT NULL
- vector_json — JSON
voice_profile_save_job
- save_job_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → voice_analysis_session.user_id — NOT NULL
- session_id — BIGINT — Foreign key → voice_analysis_session.session_id — NOT NULL
- profile_id — BIGINT — Foreign key → user_voice_profile.profile_id
- public_id — VARCHAR(100) — NOT NULL
- status — VARCHAR(30) — NOT NULL
voice_range_measurement
- range_measurement_id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → voice_analysis_session.session_id — NOT NULL
- measurement_uid — VARCHAR(100) — NOT NULL
voice_recording
- recording_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- session_id — BIGINT — Foreign key → voice_analysis_session.session_id
- purpose — VARCHAR(30) — NOT NULL
- storage_mode — VARCHAR(20) — NOT NULL
- storage_path — VARCHAR(1024) — S3 object key when storage_mode is STORED
voice_recording_context
- recording_id — BIGINT — Foreign key → voice_recording.recording_id — NOT NULL
- session_id — BIGINT — Foreign key → voice_analysis_session.session_id — NOT NULL
- song_id — VARCHAR(64) — Foreign key → song.song_id — NOT NULL
voice_recording_deletion_job
- deletion_job_id — BIGINT — Primary key — NOT NULL
- recording_id — BIGINT — Foreign key → voice_recording.recording_id — NOT NULL
- status — VARCHAR(30) — NOT NULL
voice_recording_segment
- recording_segment_id — BIGINT — Primary key — NOT NULL
- recording_id — BIGINT — Foreign key → voice_recording.recording_id — NOT NULL
- sequence_no — SMALLINT — NOT NULL