inventory_snapshots¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
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 |