ssauke
Tables (13)
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
- effect_type — ENUM( 'TEMPO_UP', 'KEY_UP', 'ATTACKER_MIC_ENABLE', 'LYRICS_HIDE' ) — NOT NULL
- status — ENUM('ASSIGNED', 'ACTIVE', 'USED', 'EXPIRED') — NOT NULL
- assigned_at — DATETIME — NOT NULL
- activated_at — DATETIME
- expires_at — DATETIME
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 — 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
- response_status — SMALLINT — NOT NULL
- response_body — LONGTEXT
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — 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 — 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
- total_score — DECIMAL(5, 2) — NOT NULL
- strength — TEXT
- improvement — TEXT
- created_at — DATETIME — 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
- status — ENUM('PREPARING', 'PLAYING', 'FINISHED', 'CANCELLED') — NOT NULL
- prepared_at — DATETIME — NOT NULL
- playback_started_at — DATETIME
- playback_finished_at — DATETIME
- cancelled_at — DATETIME
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
- reason — VARCHAR(255)
- banned_at — DATETIME — 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
- joined_at — DATETIME — NOT NULL
- left_at — DATETIME
rooms
- room_id — BIGINT — Primary key — NOT NULL
- invite_code — CHAR(6) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- mode — ENUM('GENERAL', 'BATTLE') — NOT NULL
- status — ENUM('PREPARING', 'PLAYING', 'ENDING', 'FINISHED') — NOT NULL
- created_at — DATETIME — NOT NULL
- finished_at — DATETIME
songs
- song_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- artist — VARCHAR(255) — NOT NULL
- duration_seconds — INT — NOT NULL
- mr_object_key — VARCHAR(512) — NOT NULL
- lyrics_object_key — VARCHAR(512) — NOT NULL
- created_at — DATETIME — NOT NULL
transcription_segments
- segment_id — BIGINT — Primary key — NOT NULL
- transcription_id — BIGINT — Foreign key → transcriptions.transcription_id — NOT NULL
- start_ms — BIGINT — NOT NULL
- end_ms — BIGINT — NOT NULL
- segment_text — TEXT — NOT NULL
transcriptions
- transcription_id — BIGINT — Primary key — NOT NULL
- provider_job_key — VARCHAR(191) — NOT NULL
- requested_by_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- performance_id — BIGINT — Foreign key → performances.performance_id
- language — VARCHAR(20) — NOT NULL
- full_text — LONGTEXT — NOT NULL
- duration_ms — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image_url — VARCHAR(2048)
- signup_completed — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL