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