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