inventory
Relationships
erDiagram
inventory {
intunsigned charid
intunsigned itemid
mediumintunsigned augslot1
mediumintunsigned augslot2
mediumintunsigned augslot3
mediumintunsigned augslot4
mediumintunsigned augslot5
mediumint augslot6
}
character_data {
intunsigned id
varchar name
varchar nane
intunsigned zone_instance
intunsigned zone_id
}
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
inventory ||--o{ character_data : "One-to-One"
inventory ||--o{ items : "One-to-One"
inventory ||--o{ items : "One-to-One"
inventory ||--o{ items : "One-to-One"
inventory ||--o{ items : "One-to-One"
inventory ||--o{ items : "One-to-One"
inventory ||--o{ items : "One-to-One"
inventory ||--o{ items : "One-to-One"
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 |