해커톤
테이블 (3)
GameResult (UserRanking)
- gameResultId — BIGINT — 기본 키 — NOT NULL — PK, AUTO_INCREMENT
- userId — BIGINT — 외래 키 → User.userId — NOT NULL — PK, AUTO_INCREMENT
- score — BIGINT — NOT NULL
- createdAt — NOT NULL
- updatedAt
RefreshToken
- refreshTokenId — BIGINT — 기본 키 — NOT NULL — PK, AUTO_INCREMENT
- userId — BIGINT — 외래 키 → User.userId — NOT NULL — PK, AUTO_INCREMENT
- token — NOT NULL — UNIQUE, 길이 1000
- expiredAt — NOT NULL
- createdAt — NOT NULL
- updatedAt
User
- userId — BIGINT — 기본 키 — NOT NULL — PK, AUTO_INCREMENT
- loginId — NOT NULL — UNIQUE
- password — NOT NULL — Hash
- role — NOT NULL — DEFAULT 'USER' / USER, ADMIN
- provider — NOT NULL
- createdAt — NOT NULL
- updatedAt
- lastLoginAt