yinsh_v2
Tables (13)
Arena
- ArenaID — CHAR(36)
- Name — VARCHAR(255) — NOT NULL
- MinTrophies — INT — NOT NULL
- MaxTrophies — INT — NOT NULL
- Status — ENUM('active', 'inactive', 'upcoming') — NOT NULL
- StartDate — DATETIME — NOT NULL
- EndDate — DATETIME — NOT NULL
Effect
- id — INT — Primary key — NOT NULL
- EffectID — CHAR(36)
- Name — VARCHAR(255) — NOT NULL
- Description — TEXT
- ImageURL — VARCHAR(255)
Friendship
- FriendshipID — CHAR(36)
- PlayerID1 — CHAR(36) — NOT NULL
- PlayerID2 — CHAR(36) — NOT NULL
- Status — ENUM('pending', 'accepted', 'rejected', 'blocked') — NOT NULL
- CreatedDate — DATETIME — NOT NULL
Game
- id — INT — Primary key — NOT NULL
- 시작타이머 (start_timer) — JSON — NOT NULL — 초 단위
- 시간증가 (time_per_turn) — JSON — NOT NULL
- 상태 (status) — ENUM('waiting','playing','finished') — NOT NULL
- 시작시간 (start_time) — DATETIME
- 종료시간 (end_time) — DATETIME
- 턴 (turn_state)
Item
- ItemID — CHAR(36)
- Name — VARCHAR(255) — NOT NULL
- Type — ENUM('consumable', 'permanent', 'boost') — NOT NULL
- Price — INT — NOT NULL
- IsPremium — BOOLEAN — NOT NULL
- CreatedDate — DATETIME — NOT NULL
ItemOwnership
- OwnershipID — CHAR(36)
- PlayerID — CHAR(36) — NOT NULL
- ItemID — CHAR(36) — NOT NULL
- AcquiredDate — DATETIME — NOT NULL
Leaderboard
- LeaderboardID — CHAR(36)
- ArenaID — CHAR(36) — NOT NULL
- PlayerID — CHAR(36) — NOT NULL
- Rank — INT — NOT NULL
- Points — INT — NOT NULL
- Trophies — INT — NOT NULL
Marker
- id — INT — Primary key — NOT NULL
- id (game_id) — INT — Foreign key → Game.id — NOT NULL
- Position — VARCHAR(255) — NOT NULL
- Field (color) — INT
Player
- id — INT — Primary key — NOT NULL
- id (game_id) — INT — Foreign key → Game.id — NOT NULL
- CurrentTimer — INT — NOT NULL
- IsTurn — BOOLEAN — NOT NULL
- Status — ENUM('not_ready', 'ready', 'playing', 'left', 'surrender') — NOT NULL
- removed_marker_set — INT — NOT NULL
- removed_rings — INT
- 유저아이디 (user_id) — INT — Foreign key → User.id — NOT NULL — id PK
PrivateUser
- id — Primary key — NOT NULL
- 이메일 (email) — VARCHAR(255) — NOT NULL
- 비밀번호 (password_hash) — VARCHAR(255) — NOT NULL
- 성별 (gender) — DATETIME — NOT NULL
- 생일 (birthdate) — DATETIME — NOT NULL
Ring
- id — INT — Primary key — NOT NULL
- id (game_id) — INT — Foreign key → Game.id — NOT NULL
- Position — VARCHAR(255) — NOT NULL
- Field (color) — INT
Shop
- ShopID — CHAR(36)
- ItemID — CHAR(36) — NOT NULL
- StockCount — INT — NOT NULL
- StartDate — DATETIME — NOT NULL
- EndDate — DATETIME — NOT NULL
User
- id — INT — Primary key — NOT NULL — id PK
- id (private_data_id) — Foreign key → PrivateUser.id — NOT NULL
- 유저이름 (username) — VARCHAR(255) — NOT NULL
- 프로필이미지 (profile_image) — VARCHAR(255)
- 참여날짜 (join_date) — DATETIME — NOT NULL
- 최근접속 (last_login) — DATETIME — NOT NULL
- 트로피 (trophies) — INT — NOT NULL
- 코인 (coins) — INT — NOT NULL
- 타입 (type) — enum(user,guest,withdraw) — NOT NULL