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