yinsh
Tables (15)
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
- EffectID — CHAR(36)
- Name — VARCHAR(255) — NOT NULL
- Description — TEXT
- ImageURL — VARCHAR(255)
Friendship
- FriendshipID — UUID — Primary key — NOT NULL
- PlayerID1 — UUID — NOT NULL
- PlayerID2 — UUID — NOT NULL
- Status — ENUM('pending', 'accepted', 'rejected') — NOT NULL
- CreatedDate — DATETIME — NOT NULL
Game
- GameID — CHAR(36)
- Name — VARCHAR(255) — NOT NULL
- TimerSettings — JSON — NOT NULL
- MaxPlayers — INT — NOT NULL
- Rules — JSON — NOT NULL
- CreatedDate — DATETIME — NOT NULL
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
- MarkerID — CHAR(36)
- MatchID — CHAR(36) — NOT NULL
- Position — VARCHAR(255) — NOT NULL
- PlayerID — CHAR(36) — NOT NULL
- CreatedAt — DATETIME — NOT NULL
- RemovedAt — DATETIME
- EffectID — CHAR(36)
Match
- MatchID — CHAR(36)
- GameID — CHAR(36) — NOT NULL
- Player1ID — CHAR(36) — NOT NULL
- Player2ID — CHAR(36) — NOT NULL
- WinnerID — CHAR(36)
- StartTime — DATETIME — NOT NULL
- EndTime — DATETIME
- TurnOrder — JSON — NOT NULL
- BoardState — JSON — NOT NULL
Move
- MoveID — CHAR(36)
- MatchID — CHAR(36) — NOT NULL
- PlayerID — CHAR(36) — NOT NULL
- RingID — CHAR(36)
- StartPosition — VARCHAR(255) — NOT NULL
- EndPosition — VARCHAR(255) — NOT NULL
- MoveType — ENUM('place', 'move', 'remove') — NOT NULL
- Timestamp — DATETIME — NOT NULL
Player
- PlayerID — CHAR(36)
- UserID — CHAR(36) — NOT NULL
- MatchID — CHAR(36) — NOT NULL
- CurrentTimer — INT — NOT NULL
- IsTurn — BOOLEAN — NOT NULL
- Status — ENUM('not_ready', 'ready', 'playing', 'left', 'resigned') — NOT NULL
- Score — INT — NOT NULL
PrivateUser
- id — Primary key — NOT NULL
- user_id — CHAR(36) — NOT NULL
- Email — VARCHAR(255) — NOT NULL
- PasswordHash — VARCHAR(255) — NOT NULL
Ring
- RingID — CHAR(36)
- MatchID — CHAR(36) — NOT NULL
- PlayerID — CHAR(36) — NOT NULL
- Position — VARCHAR(255) — NOT NULL
- IsRemoved — BOOLEAN — NOT NULL
- CreatedAt — DATETIME — NOT NULL
- RemovedAt — DATETIME
- EffectID — CHAR(36)
Shop
- ShopID — CHAR(36)
- ItemID — CHAR(36) — NOT NULL
- StockCount — INT — NOT NULL
- StartDate — DATETIME — NOT NULL
- EndDate — DATETIME — NOT NULL
User
- id — Primary key — NOT NULL
- id (id2) — Foreign key → PrivateUser.id — NOT NULL
- Username — VARCHAR(255) — NOT NULL
- JoinDate — DATETIME — NOT NULL
- LastLogin (Field) — DATETIME
- PrivateUserID — CHAR(36)
- Trophies (Field2) — INT
- Coins (Field3) — INT