SchemaSpy - Table mangos.spell_dbc

Logical representation of the Spell.dbc file

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

int unsigned

0

characters.character_aura.spell	Defined in XML R
characters.character_spell.spell	Defined in XML R
characters.character_spell_cooldown.spell	Defined in XML R
characters.pet_aura.spell	Defined in XML R
characters.pet_spell.spell	Defined in XML R
characters.pet_spell_cooldown.spell	Defined in XML R
creature_movement.spell	Defined in XML R
creature_template.PetSpellDataId	Defined in XML R
creature_template.spell1	Defined in XML R
creature_template.spell2	Defined in XML R
creature_template.spell3	Defined in XML R
creature_template.spell4	Defined in XML R
creature_template.trainer_spell	Defined in XML R
item_template.requiredspell	Defined in XML R
item_template.spellid_1	Defined in XML R
item_template.spellid_2	Defined in XML R
item_template.spellid_3	Defined in XML R
item_template.spellid_4	Defined in XML R
item_template.spellid_5	Defined in XML R
npc_spellclick_spells.spell_id	Defined in XML R
npc_trainer.spell	Defined in XML R
playercreateinfo_spell.Spell	Defined in XML R
skill_discovery_template.reqSpell	Defined in XML R
skill_discovery_template.spellId	Defined in XML R
skill_extra_item_template.requiredSpecialization	Defined in XML R
skill_extra_item_template.spellId	Defined in XML R
spell_affect.entry	Defined in XML R
spell_area.spell	Defined in XML R
spell_chain.first_spell	Defined in XML R
spell_chain.prev_spell	Defined in XML R
spell_chain.spell_id	Defined in XML R
spell_elixir.entry	Defined in XML R
spell_learn_spell.entry	Defined in XML R
spell_learn_spell.SpellID	Defined in XML R
spell_loot_template.entry	Defined in XML R
spell_pet_auras.spell	Defined in XML R
spell_proc_event.entry	Defined in XML R
spell_script_target.entry	Defined in XML R
spell_scripts.id	Defined in XML R
spell_teleport.id	Defined in XML R
spell_threat.entry	Defined in XML R

Analyzed at Fri Feb 11 23:15 MST 2011