character_corpse_items

Relationships

erDiagram
    character_corpse_items {
        intunsigned corpse_id
        intunsigned item_id
        intunsigned aug_1
        intunsigned aug_2
        intunsigned aug_3
        intunsigned aug_4
        intunsigned aug_5
        int aug_6
    }
    character_corpses {
        intunsigned id
        intunsigned charid
        varchar charname
        smallintunsigned instance_id
        smallint 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
    }
    character_corpse_items ||--o{ character_corpses : "One-to-One"
    character_corpse_items ||--o{ items : "One-to-One"
    character_corpse_items ||--o{ items : "One-to-One"
    character_corpse_items ||--o{ items : "One-to-One"
    character_corpse_items ||--o{ items : "One-to-One"
    character_corpse_items ||--o{ items : "One-to-One"
    character_corpse_items ||--o{ items : "One-to-One"
    character_corpse_items ||--o{ items : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	corpse_id	character_corpses	id
One-to-One	item_id	items	id
One-to-One	aug_1	items	id
One-to-One	aug_2	items	id
One-to-One	aug_3	items	id
One-to-One	aug_4	items	id
One-to-One	aug_5	items	id
One-to-One	aug_6	items	id

Schema

Column	Data Type	Description
corpse_id	int	Corpse Identifier
equip_slot	int	Equipment Slot
item_id	int	Item Identifier
charges	int	Item Charges
aug_1	int	Item Augment Slot 1
aug_2	int	Item Augment Slot 2
aug_3	int	Item Augment Slot 3
aug_4	int	Item Augment Slot 4
aug_5	int	Item Augment Slot 5
aug_6	int	Item Augment Slot 6
attuned	smallint	Item Attuned: 0 = False, 1 = True
custom_data	text	Custom Data
ornamenticon	int	Ornamentation Icon
ornamentidfile	int	Ornamentation IDFile
ornament_hero_model	int	Ornamentation Hero's Forge Model