Skip to content

inventory_snapshots

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
time_index int Inventory Snapshot Time Identifier
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 = False, 1 = True
custom_data text Custom Data
ornamenticon int Ornamentation Icon
ornamentidfile int Ornamentation Texture
ornament_hero_model int Ornamentation Hero's Forge Model