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