1
Tables (7)
Achievement
- id — UUID — Primary key — NOT NULL
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT — NOT NULL
- iconUrl — VARCHAR(255)
ChatMessage
- id — UUID — Primary key — NOT NULL
- senderId — UUID — Foreign key — NOT NULL
- roomId — VARCHAR(100) — NOT NULL
- message — TEXT — NOT NULL
- sentAt — TIMESTAMP — NOT NULL
Friend
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key — NOT NULL
- friendId — UUID — Foreign key — NOT NULL
- status — VARCHAR(20) — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
GameHistory
- id — UUID — Primary key — NOT NULL
- gameType — VARCHAR(50) — NOT NULL
- player1Id — UUID — Foreign key — NOT NULL
- player2Id — UUID — Foreign key — NOT NULL
- player1Score — INTEGER — NOT NULL
- player2Score — INTEGER — NOT NULL
- winnerId — UUID — Foreign key
- playedAt — TIMESTAMP — NOT NULL
Room
- id — UUID — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- hostNickname — VARCHAR(50) — NOT NULL
- password — VARCHAR(255)
- isPublic — BOOLEAN — NOT NULL
- currentPlayers — INTEGER — NOT NULL
- maxPlayers — INTEGER — NOT NULL
- isGameStart — BOOLEAN — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
- slot1Ready — BOOLEAN — NOT NULL
- slot2Open — BOOLEAN — NOT NULL
- slot2IsAi — BOOLEAN — NOT NULL
- slot2Nick — VARCHAR(50)
- slot2Ready — BOOLEAN — NOT NULL
- slot3Open — BOOLEAN — NOT NULL
- slot3IsAi — BOOLEAN — NOT NULL
- slot3Nick — VARCHAR(50)
- slot3Ready — BOOLEAN — NOT NULL
- slot4Open — BOOLEAN — NOT NULL
- slot4IsAi — BOOLEAN — NOT NULL
- slot4Nick — VARCHAR(50)
- slot4Ready — BOOLEAN — NOT NULL
User
- id — UUID — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- avatar — VARCHAR(255)
- title — VARCHAR(100)
- equippedTitle — VARCHAR(100)
- isTitleSeen — BOOLEAN — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
- updatedAt — TIMESTAMP — NOT NULL
UserAchievement
- id — UUID — Primary key — NOT NULL
- userId — UUID — Foreign key — NOT NULL
- achievementId — UUID — Foreign key → Achievement.id — NOT NULL
- unlockedAt — TIMESTAMP — NOT NULL