Skip to content

character_potionbelt

Relationships

erDiagram
    character_potionbelt {
        intunsigned id
        intunsigned icon
        intunsigned item_id
    }
    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
    }
    character_potionbelt ||--o{ character_data : "One-to-One"
    character_potionbelt ||--o{ items : "One-to-One"
    character_potionbelt ||--o{ items : "One-to-One"
Relationship Type Local Key Relates to Table Foreign Key
One-to-One id character_data id
One-to-One icon items icon
One-to-One item_id items id

Schema

Column Data Type Description
id int Character Identifier
potion_id tinyint Potion Identifier
item_id int Item Identifier
icon int Icon