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