| SchemaSpy Analysis of mangos UnifiedDB World Database | Generated by SchemaSpy |
| Generated by SchemaSpy on Fri Feb 11 23:15 MST 2011 | |
| Database Type: MySQL - 5.5.9 |
|
XML Representation Insertion Order Deletion Order |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| achievement_criteria_requirement | 4 | 1,853 | Achievment system | ||
| achievement_reward | 5 | 8 | 93 | Loot System | |
| achievements_dbc | 1 | 1 | Logical representation of the Achievements.dbc file | ||
| areatable_dbc | 7 | 1 | Logical representation of the AreaTable.dbc file | ||
| areatrigger_dbc | 5 | 1 | Logical representation of the AreaTrigger.dbc file | ||
| areatrigger_involvedrelation | 2 | 2 | 51 | Trigger System | |
| areatrigger_tavern | 1 | 2 | 101 | Trigger System | |
| areatrigger_teleport | 4 | 15 | 224 | Trigger System | |
| battleground_events | 1 | 4 | 191 | ||
| battleground_template | 1 | 3 | 7 | 13 | |
| battlemaster_entry | 2 | 2 | 136 | ||
| chartitles_dbc | 2 | 1 | Logical representation of the CharTitles.dbc file | ||
| command | 3 | 301 | Chat System | ||
| creature | 9 | 5 | 18 | 138,708 | Creature System |
| creature_addon | 1 | 7 | 87,099 | ||
| creature_ai_scripts | 23 | 22,077 | EventAI Scripts | ||
| creature_ai_summons | 7 | 10 | EventAI Summoning Locations | ||
| creature_ai_texts | 2 | 15 | 987 | Script Texts | |
| creature_battleground | 3 | 3 | 908 | Creature battleground indexing system | |
| creature_equip_template | 3 | 1 | 4 | 2,289 | Creature System (Equipment) |
| creature_involvedrelation | 2 | 2 | 7,841 | Creature System | |
| creature_loot_template | 1 | 2 | 9 | 258,564 | Loot System |
| creature_model_info | 8 | 3 | 6 | 24,155 | Creature System (Model related info) |
| creature_model_race | 4 | 20 | Model system | ||
| creature_movement | 3 | 12 | 19 | 48,680 | Creature System |
| creature_movement_scripts | 1 | 1 | 17 | 26 | |
| creature_movement_template | 18 | 915 | Creature waypoint system | ||
| creature_onkill_reputation | 3 | 10 | 1,432 | Creature OnKill Reputation gain | |
| creature_questrelation | 2 | 2 | 7,620 | Creature System | |
| creature_respawn | 1 | 1 | |||
| creature_template | 17 | 16 | 82 | 29,920 | Creature System |
| creature_template_addon | 1 | 7 | 4,661 | ||
| creaturedisplayinfo_dbc | 3 | 1 | Logical representation of the CreatureDisplayInfo.dbc file | ||
| db_script_string | 6 | 10 | 399 | ||
| db_version | 4 | 1 | Used DB version notes | ||
| disenchant_loot_template | 1 | 2 | 9 | 123 | Loot System |
| event_scripts | 1 | 17 | 442 | ||
| exploration_basexp | 2 | 71 | Exploration System | ||
| faction_dbc | 9 | 1 | Logical representation of the Faction.dbc file | ||
| factiontemplate_dbc | 3 | 1 | Logical representation of the FactionTemplate.dbc file | ||
| fishing_loot_template | 2 | 9 | 244 | Loot System | |
| game_event | 6 | 7 | 39 | ||
| game_event_creature | 2 | 2 | 3,085 | ||
| game_event_creature_quest | 3 | 3 | 99 | ||
| game_event_gameobject | 2 | 2 | 22,020 | ||
| game_event_model_equip | 4 | 4 | 10 | ||
| game_graveyard_zone | 2 | 3 | 687 | Trigger System | |
| game_tele | 1 | 7 | 1,421 | Tele Command | |
| game_weather | 1 | 13 | 35 | Weather System | |
| gameobject | 4 | 2 | 16 | 90,565 | Gameobject System |
| gameobject_battleground | 3 | 328 | GameObject battleground indexing system | ||
| gameobject_involvedrelation | 2 | 2 | 295 | ||
| gameobject_loot_template | 1 | 9 | 17,889 | Loot System | |
| gameobject_questrelation | 2 | 2 | 367 | ||
| gameobject_respawn | 1 | 1 | |||
| gameobject_scripts | 1 | 17 | 54 | ||
| gameobject_template | 5 | 1 | 43 | 18,898 | Gameobject System |
| gemproperties_dbc | 1 | 1 | Logical representation of the GemProperties.dbc file | ||
| gossip_menu | 1 | 8 | 2,078 | ||
| gossip_menu_option | 1 | 21 | 1,449 | ||
| gossip_scripts | 1 | 17 | 19 | ||
| instance_template | 1 | 5 | 81 | ||
| item_dbc | 2 | 1 | Logical representation of the Item.dbc file | ||
| item_enchantment_template | 3 | 28,607 | Item Random Enchantment System | ||
| item_loot_template | 2 | 9 | 5,054 | Loot System | |
| item_required_target | 1 | 3 | 134 | ||
| item_template | 26 | 14 | 138 | 36,407 | Item System |
| itemset_dbc | 1 | 1 | Logical representation of the ItemSet.dbc file | ||
| languages_dbc | 1 | 1 | Logical representation of the Languages.dbc file | ||
| locales_achievement_reward | 18 | 0 | |||
| locales_creature | 1 | 17 | 0 | ||
| locales_gameobject | 1 | 17 | 0 | ||
| locales_gossip_menu_option | 18 | 0 | |||
| locales_item | 1 | 17 | 0 | ||
| locales_npc_text | 1 | 129 | 0 | ||
| locales_page_text | 1 | 9 | 0 | ||
| locales_points_of_interest | 9 | 0 | |||
| locales_quest | 1 | 89 | 0 | ||
| mail_level_reward | 1 | 4 | 24 | Mail System | |
| mail_loot_template | 1 | 9 | 66 | Loot System | |
| mangos_string | 10 | 756 | |||
| maps_dbc | 11 | 1 | Logical representation of the Maps.dbc file | ||
| milling_loot_template | 2 | 9 | 46 | Loot System | |
| npc_gossip | 2 | 2 | 3,368 | ||
| npc_spellclick_spells | 5 | 6 | 19 | ||
| npc_text | 3 | 81 | 5,779 | ||
| npc_trainer | 2 | 6 | 74,407 | ||
| npc_vendor | 2 | 5 | 35,555 | Npc System | |
| page_text | 3 | 1 | 3 | 1,771 | Item System |
| pet_levelstats | 1 | 10 | 2,480 | Stores pet levels stats. | |
| pet_name_generation | 4 | 313 | |||
| pickpocketing_loot_template | 1 | 2 | 9 | 10,997 | Loot System |
| player_classlevelstats | 4 | 800 | Stores levels stats. | ||
| player_levelstats | 8 | 4,960 | Stores levels stats. | ||
| player_xp_for_level | 2 | 79 | |||
| playercreateinfo | 2 | 8 | 62 | ||
| playercreateinfo_action | 5 | 355 | |||
| playercreateinfo_item | 1 | 4 | 0 | ||
| playercreateinfo_spell | 1 | 4 | 2,851 | ||
| points_of_interest | 1 | 7 | 446 | ||
| pool_creature | 2 | 4 | 774 | ||
| pool_gameobject | 2 | 4 | 27,969 | ||
| pool_pool | 4 | 3,241 | |||
| pool_template | 2 | 3 | 4,176 | ||
| prospecting_loot_template | 2 | 9 | 103 | Loot System | |
| quest_end_scripts | 17 | 310 | |||
| quest_poi | 3 | 8 | 18,459 | ||
| quest_poi_points | 4 | 56,372 | |||
| quest_start_scripts | 17 | 235 | |||
| quest_template | 16 | 140 | 9,063 | Quest System | |
| reference_loot_template | 1 | 2 | 9 | 9,234 | Loot System |
| reputation_reward_rate | 1 | 4 | 14 | ||
| reputation_spillover_template | 5 | 13 | 26 | Reputation spillover reputation gain | |
| reserved_name | 1 | 0 | Player Reserved Names | ||
| scripted_areatrigger | 1 | 2 | 29 | ||
| scripted_event_id | 2 | 4 | Script library scripted events | ||
| skill_discovery_template | 2 | 4 | 348 | Skill Discovery System | |
| skill_extra_item_template | 2 | 4 | 206 | Skill Specialization System | |
| skill_fishing_base_level | 1 | 2 | 88 | Fishing system | |
| skinning_loot_template | 1 | 2 | 9 | 3,362 | Loot System |
| spell_affect | 1 | 1 | |||
| spell_area | 4 | 9 | 123 | ||
| spell_bonus_data | 5 | 123 | |||
| spell_chain | 3 | 5 | 1,605 | Spell Additinal Data | |
| spell_dbc | 41 | 1 | Logical representation of the Spell.dbc file | ||
| spell_elixir | 1 | 2 | 132 | Spell System | |
| spell_learn_spell | 2 | 3 | 18 | Item System | |
| spell_loot_template | 2 | 9 | 161 | Loot System | |
| spell_pet_auras | 1 | 4 | 45 | ||
| spell_proc_event | 1 | 17 | 570 | ||
| spell_proc_item_enchant | 2 | 3 | |||
| spell_script_target | 1 | 3 | 701 | Spell System | |
| spell_scripts | 1 | 17 | 17 | ||
| spell_target_position | 6 | 388 | Spell System | ||
| spell_teleport | 2 | 2 | |||
| spell_threat | 1 | 2 | 120 | ||
| transports | 1 | 3 | 24 | Transports | |
| worldsafelocs_dbc | 3 | 1 | Logical representation of the WorldSafeLocs.dbc file | ||
| 138 Tables | 1,577 | 1,152,953 | |||
| 0 Views | 0 |
Related tables in other schemas