Loading...   

Field Name Field Description Field Type Field Default Value
id The ID of the character. int(11) Auto Increment
account_id The account ID of the character. int(11) 0
name The name of the character. varchar(64) Empty String
profile The profile blob of the character. blob(0) NULL
timelaston The last time the character was online. int(11) 0
x The X position of the character. float(0) 0
y The Y position of the character. float(0) 0
z The Z position of the character. float(0) 0
zonename The name of the zone the character is in. varchar(30) Empty String
alt_adv The alternate advancement blob of the character. blob(0) NULL
zoneid The zone ID of the zone the character is in. smallint(6) 0
instanceid The instance ID of the zone the character is in. smallint(5) 0
pktime The PK time of the character. int(8) 0
inventory The inventory blob of the character. blob(0)

NULL

groupid The group ID of the character. int(10) 0
extprofile The exterior profile blob of the character. blob(0) NULL
class The class ID of the character. tinyint(4) 0
level The level of the character. mediumint(8) 0
lfp Determines whether or not the character is looking for a party. 0 = No, 1 = Yes tinyint(1) 0
lfg Determines whether or not the character is looking for a guild. 0 = No, 1 = Yes tinyint(1) 0
mailkey The mail key of the character. char(16) 0
xtargets The number of XTargets the character has. tinyint(3) 5
firstlogon The first time the character was ever online. tinyint(3) 0
inspectmessage The inspect message of the character. varchar(256) Empty String