Skip to content



This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit


Relationship Type Local Key Relates to Table Foreign Key
One-to-One charid character_data id
One-to-One itemid items id
One-to-One augslot1 items id
One-to-One augslot2 items id
One-to-One augslot3 items id
One-to-One augslot4 items id
One-to-One augslot5 items id
One-to-One augslot6 items id


Column Data Type Description
charid int Character Identifier
slotid mediumint Slot Identifier
itemid int Item Identifier
charges smallint Charges
color int Color
augslot1 mediumint Augment Slot 1
augslot2 mediumint Augment Slot 2
augslot3 mediumint Augment Slot 3
augslot4 mediumint Augment Slot 4
augslot5 mediumint Augment Slot 5
augslot6 mediumint Augment Slot 6
instnodrop tinyint No Drop: 0 = True, 1 = False
custom_data text Custom Data
ornamenticon int Ornamentation Icon
ornamentidfile int Ornamentation Texture
ornament_hero_model int Ornamentation Hero's Forge Model