Yorr_최종

테이블 (4)

match_participants

  • id — BIGINT — 기본 키 — NOT NULL
  • match_id — BIGINT — 외래 키 → matches.id — NOT NULL
  • user_id — VARCHAR(36) — 외래 키 → users.id
  • player_id — VARCHAR(64) — NOT NULL
  • display_nickname — VARCHAR(20) — NOT NULL
  • total_score — INT — NOT NULL
  • ranking — INT — NOT NULL

matches

  • id — BIGINT — 기본 키 — NOT NULL
  • game_id — VARCHAR(64) — NOT NULL
  • game_code — VARCHAR(32) — NOT NULL
  • room_code — VARCHAR(12) — NOT NULL
  • player_count — INT — NOT NULL
  • finished_at — DATETIME(6) — NOT NULL

social_accounts

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — VARCHAR(36) — 외래 키 → users.id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_user_id — VARCHAR(64) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

users

  • id — VARCHAR(36) — 기본 키 — NOT NULL
  • nickname — VARCHAR(20) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL