Select all columns from the character
table. Each character has its own unique id
, and is associated with the ID of the player who created it (the player_id
column). All characters have reached a certain level
, belong to a certain class
(e.g., 'wizard'
or 'warrior'
), and have some money (account_balance
).
There are also stats like hp
(health points), mp
(mana points), strength
, and wisdom
. Due to various curses and blessings, characters' statistics can be affected by the stat_modifier
attribute, which can be positive or negative.
Finally, there's the height
and weight
of each character, expressed in meters and kilograms, respectively.