Skip to content

character_spells

Relationships

erDiagram
    character_spells {
        intunsigned id
        smallintunsigned spell_id
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    spells_new {
        int id
        int descnum
        int effectdescnum
        int effectdescnum2
        int typedescnum
        varchar teleport_zone
    }
    character_spells ||--o{ character_data : "One-to-One"
    character_spells ||--o{ spells_new : "One-to-One"
Relationship Type Local Key Relates to Table Foreign Key
One-to-One id character_data id
One-to-One spell_id spells_new id

Schema

Column Data Type Description
id int Character Identifier
slot_id smallint Slot Identifier
spell_id smallint Spell Identifier