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