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