auras

Relationships

erDiagram
    auras {
        int npc_type
        int spell_id
    }
    npc_types {
        intunsigned alt_currency_id
        int id
        int npc_faction_id
        text name
        intunsigned loottable_id
        intunsigned merchant_id
        intunsigned emoteid
        intunsigned adventure_template_id
        intunsigned armortint_id
        intunsigned npc_spells_id
        intunsigned npc_spells_effects_id
        intunsigned trap_template
    }
    spells_new {
        int id
        int descnum
        int effectdescnum
        int effectdescnum2
        int typedescnum
        varchar teleport_zone
    }
    auras ||--o{ npc_types : "One-to-One"
    auras ||--o{ spells_new : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	npc_type	npc_types	id
One-to-One	spell_id	spells_new	id

Schema

Column	Data Type	Description
type	int	Unique Aura Identifier
npc_type	int	NPC Type Identifier
name	varchar	Name
spell_id	int	Spell Identifier
distance	int	Distance
aura_type	int	Aura Type
spawn_type	int	Aura Spawn Type
movement	int	Aura Movement Type
duration	int	Duration
icon	int	Icon
cast_time	int	Cast Time