Game DB Tables

Here we document the structures of the database tables. These tables will come mostly from the character database, but sometimes from the world database. The goal is to have a documentation where we can see which columns of which table appears in which packets. And maybe finding new columns based on the packets.

---

Table groups
Character database tables

---

Character database Tables

Table
Account

---

Account

This table stores the account-wide information. It doesn't store authentication data, the auth database's account table stores that, but this is separated

Field	Type	Description
id	INT(11) UNSIGNED	Unique id.
email	VARCHAR(255)	The email address.
name	VARCHAR(64)	The username.
level	TINYINT(3) UNSIGNED	The user level. (none, vip, admin, etc...)
family_name	VARCHAR(64)	The account's family name.
selected_slot	TINYINT(3) UNSIGNED	The last selected slot int he character selection.
can_skip_bootcamp	BIT(1)	Can skip bootcamp flag.
last_ip	VARCHAR(15)	The IP address of the last login.
last_login	DATETIME	The date of the last login.
created_at	TIMESTAMP	Technical, the creation time of this database row.

---

DEV copiable empty table for database

Table name

DEV table description

Field	Type	Description