Bo

Tables (6)

Account

  • id — int unsigned — Primary key — NOT NULL — Primary Key, auto increment
  • name — varchar(128) — Primary key — NOT NULL — Unique Key
  • password — varchar(256) — Hash password
  • createdAt — DATETIME

Item

  • id (Key) — int unsigned — Primary key — NOT NULL — Primary Key, auto incement
  • name (Key2) — varchar(128) — Primary key — NOT NULL
  • effect (Field) — enum("0", "1", "2", "3") — NOT NULL — 0: HP, 1: MP, 2: ATK, 3: DEF
  • value (Field2) — int — NOT NULL

Party

  • id (Key) — int unsigned — Primary key — NOT NULL — Primary Key, auto increment
  • status (Field) — enum("0", "1") — NOT NULL — 0: Available, 1: Unavailable
  • createdAt (Field2) — DATETIME — NOT NULL

PartyPlayer

  • id (Key) — int unsigned — Primary key — NOT NULL — Primary Key, auto increment
  • player_id (id) — int unsigned — Foreign key → Player.id — NOT NULL
  • party_id (Key2) — int unsigned — Foreign key → Party.id — NOT NULL
  • status (Field) — enum("0","1") — NOT NULL — 0: In, 1: Out
  • createdAt (Field2) — DATETIME — NOT NULL

Player

  • id — int unsigned — Primary key — NOT NULL — Primary Key, auto increment
  • account_id (id2) — int unsigned — Foreign key → Account.id — NOT NULL — Unique Key
  • name (name2) — varchar(128) — Foreign key → Account.name — NOT NULL — Unique Key
  • posX — float — NOT NULL
  • posY (Field) — float — NOT NULL
  • maxHP (Field2) — int unsigned — NOT NULL
  • currentHP (Field3) — int unsigned — NOT NULL
  • createdAt (Field4) — DATETIME

RoomItem

  • id (Key) — int unsigned — Primary key — NOT NULL — Primary Key, auto increment
  • itemId (Key2) — int unsigned — Foreign key → Item.id — NOT NULL — Unique Key
  • roomId (Field) — int unsigned — NOT NULL
  • posX (Field2) — float — NOT NULL
  • posY (Field3) — float — NOT NULL
  • state (Field4) — enum("0","1") — NOT NULL — 0: AVAILABLE, 1: RESPAWN_PENDING