ssasukae

Tables (15)

card_assignments

  • card_assignment_id — BIGINT — Primary key — NOT NULL
  • performance_id — BIGINT — Foreign key → performances.performance_id — NOT NULL
  • owner_participant_id — BIGINT — Foreign key → room_participants.participant_id — NOT NULL
  • target_participant_id — BIGINT — Foreign key → room_participants.participant_id — NOT NULL
  • card_definition_id — BIGINT — Foreign key → card_definitions.card_definition_id — NOT NULL
  • status — ENUM( 'ASSIGNED', 'ACTIVATION_PENDING', 'ACTIVE', 'USED', 'EXPIRED', 'FAILED' ) — NOT NULL
  • effect_snapshot — JSON
  • activation_succeeded — BOOLEAN
  • failure_code — VARCHAR(100)
  • version — BIGINT — NOT NULL
  • assigned_at — DATETIME(6) — NOT NULL
  • assignment_expires_at — DATETIME(6)
  • activation_requested_at — DATETIME(6)
  • activated_at — DATETIME(6)
  • effect_ends_at — DATETIME(6)
  • consumed_at — DATETIME(6)

card_definitions

  • card_definition_id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(1000)
  • effect_config — JSON
  • effect_group — VARCHAR(50) — NOT NULL
  • selection_weight — INT — NOT NULL
  • success_probability — DECIMAL(5, 2) — NOT NULL
  • activation_delay_ms — INT — NOT NULL
  • duration_ms — INT
  • enabled — BOOLEAN — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

favorites

  • favorite_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • song_id — BIGINT — Foreign key → songs.song_id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

idempotency_records

  • idempotency_record_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • endpoint — VARCHAR(255) — NOT NULL
  • idempotency_key — VARCHAR(100) — NOT NULL
  • request_hash — CHAR(64) — NOT NULL
  • status — ENUM( 'IN_PROGRESS', 'COMPLETED', 'FAILED' ) — NOT NULL
  • response_status — SMALLINT
  • response_body — MEDIUMTEXT
  • expires_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

oauth_accounts

  • oauth_account_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • provider — ENUM('GOOGLE', 'KAKAO') — NOT NULL
  • provider_user_key — VARCHAR(191) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

performance_analysis_jobs

  • analysis_job_id — BIGINT — Primary key — NOT NULL
  • performance_id — BIGINT — Foreign key → performances.performance_id — NOT NULL
  • provider_job_key — VARCHAR(191)
  • attempt_no — INT — NOT NULL
  • status — ENUM( 'QUEUED', 'PROCESSING', 'SUCCEEDED', 'FAILED' ) — NOT NULL
  • error_code — VARCHAR(100)
  • error_message — VARCHAR(2000)
  • requested_at — DATETIME(6) — NOT NULL
  • started_at — DATETIME(6)
  • callback_received_at — DATETIME(6)
  • finished_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

performance_results

  • performance_result_id — BIGINT — Primary key — NOT NULL
  • performance_id — BIGINT — Foreign key → performances.performance_id — NOT NULL
  • pitch_score — DECIMAL(5, 2) — NOT NULL
  • rhythm_score — DECIMAL(5, 2) — NOT NULL
  • lyrics_accuracy — DECIMAL(5, 2) — NOT NULL
  • stability_score — DECIMAL(5, 2)
  • analysis_confidence — DECIMAL(5, 2)
  • ai_total_score — DECIMAL(5, 2) — NOT NULL
  • defense_score — DECIMAL(5, 2) — NOT NULL
  • final_score — DECIMAL(5, 2) — NOT NULL
  • grade — VARCHAR(10)
  • strength — TEXT
  • improvement — TEXT
  • scoring_version — VARCHAR(50) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

performance_settings

  • performance_setting_id — BIGINT — Primary key — NOT NULL
  • performance_id — BIGINT — Foreign key → performances.performance_id — NOT NULL
  • key_shift — SMALLINT — NOT NULL
  • tempo_rate — DECIMAL(4, 2) — NOT NULL
  • mr_volume — DECIMAL(4, 3) — NOT NULL
  • mic_volume — DECIMAL(4, 3) — NOT NULL
  • echo_level — TINYINT — NOT NULL
  • reverb_level — TINYINT — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

performances

  • performance_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • performer_participant_id — BIGINT — Foreign key → room_participants.participant_id — NOT NULL
  • song_id — BIGINT — Foreign key → songs.song_id — NOT NULL
  • round_no — INT — NOT NULL
  • status — ENUM( 'PREPARING', 'PLAYING', 'ANALYZING', 'FINISHED', 'ANALYSIS_FAILED', 'CANCELLED' ) — NOT NULL
  • recording_object_key — VARCHAR(512)
  • version — BIGINT — NOT NULL
  • prepared_at — DATETIME(6) — NOT NULL
  • scheduled_start_at — DATETIME(6)
  • playback_started_at — DATETIME(6)
  • expected_end_at — DATETIME(6)
  • playback_finished_at — DATETIME(6)
  • analysis_started_at — DATETIME(6)
  • analysis_finished_at — DATETIME(6)
  • cancelled_at — DATETIME(6)
  • cancel_reason — VARCHAR(255)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

room_bans

  • room_ban_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • banned_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • banned_by_participant_id — BIGINT — Foreign key → room_participants.participant_id — NOT NULL
  • reason — VARCHAR(255)
  • banned_at — DATETIME(6) — NOT NULL

room_participants

  • participant_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • role — ENUM('HOST', 'PARTICIPANT') — NOT NULL
  • connection_status — ENUM( 'ONLINE', 'DISCONNECTED', 'LEFT', 'KICKED' ) — NOT NULL
  • mic_enabled — BOOLEAN — NOT NULL
  • camera_enabled — BOOLEAN — NOT NULL
  • version — BIGINT — NOT NULL
  • joined_at — DATETIME(6) — NOT NULL
  • last_seen_at — DATETIME(6) — NOT NULL
  • disconnected_at — DATETIME(6)
  • left_at — DATETIME(6)

rooms

  • room_id — BIGINT — Primary key — NOT NULL
  • created_by_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • invite_code — CHAR(6) — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • mode — ENUM('GENERAL', 'BATTLE') — NOT NULL
  • status — ENUM( 'PREPARING', 'PLAYING', 'ENDING', 'FINISHED' ) — NOT NULL
  • max_participants — TINYINT — NOT NULL
  • openvidu_session_id — VARCHAR(255) — NOT NULL
  • version — BIGINT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • last_activity_at — DATETIME(6) — NOT NULL
  • finished_at — DATETIME(6)

song_preprocessing_jobs

  • song_preprocessing_job_id — BIGINT — Primary key — NOT NULL
  • song_id — BIGINT — Foreign key → songs.song_id — NOT NULL
  • provider_job_key — VARCHAR(191)
  • attempt_no — INT — NOT NULL
  • status — ENUM( 'QUEUED', 'RUNNING', 'SUCCEEDED', 'FAILED', 'CANCELLED' ) — NOT NULL
  • stage — ENUM( 'QUEUED', 'VALIDATING', 'SEPARATING', 'PITCH_EXTRACTING', 'ALIGNING_LYRICS', 'UPLOADING', 'COMPLETED' ) — NOT NULL
  • progress_percent — TINYINT — NOT NULL
  • error_code — VARCHAR(100)
  • error_message — VARCHAR(2000)
  • requested_at — DATETIME(6) — NOT NULL
  • started_at — DATETIME(6)
  • finished_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

songs

  • song_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • artist — VARCHAR(255) — NOT NULL
  • difficulty_level — TINYINT
  • thumbnail_object_key — VARCHAR(2048)
  • mr_object_key — VARCHAR(512)
  • midi_object_key — VARCHAR(512)
  • lyrics_object_key — VARCHAR(512)
  • created_at — DATETIME(6) — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(320)
  • nickname — VARCHAR(12)
  • normalized_nickname — VARCHAR(12)
  • profile_image_url — VARCHAR(2048)
  • signup_completed — BOOLEAN — NOT NULL
  • status — ENUM('ACTIVE', 'DELETED') — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL