bot_inventories¶
Info
This page was last generated 2023.04.23
Relationship Diagram(s)¶
Relationships¶
| 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 |
Schema¶
| 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 |