Skip to content

inventory

Info

This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit

Relationships

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

Schema

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