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