Skip to content



This page was last generated 2023.04.23

Relationship Diagram(s)

Diagram Edit


Relationship Type Local Key Relates to Table Foreign Key
One-to-One bot_id bot_data bot_id
One-to-One item_id items id
One-to-One augment_1 items id
One-to-One augment_2 items id
One-to-One augment_3 items id
One-to-One augment_4 items id
One-to-One augment_5 items id
One-to-One augment_6 items id


Column Data Type Description
inventories_index int Unique Bot Inventory Identifier
bot_id int Bot Identifier
slot_id mediumint Slot Identifier
item_id int Item Identifier
inst_charges smallint Charges
inst_color int Color
inst_no_drop tinyint No Drop: 0 = False, 1= True
inst_custom_data text Custom Data
ornament_icon int Ornamentation Icon
ornament_id_file int Ornamentation Item Texture
ornament_hero_model int Ornamentation Hero's Forge Model
augment_1 mediumint Augment Slot 1
augment_2 mediumint Augment Slot 2
augment_3 mediumint Augment Slot 3
augment_4 mediumint Augment Slot 4
augment_5 mediumint Augment Slot 5
augment_6 mediumint Augment Slot 6