inventory¶
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 |
|---|---|---|
| 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 |