| SchemaSpy Analysis of characters UnifiedDB Character Database | Generated by SchemaSpy |
| Generated by SchemaSpy on Fri Feb 11 23:13 MST 2011 | |
| Database Type: MySQL - 5.5.9 |
|
XML Representation Insertion Order Deletion Order |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| account_data | 1 | 4 | 0 | ||
| arena_team | 2 | 1 | 9 | 0 | |
| arena_team_member | 2 | 7 | 0 | ||
| arena_team_stats | 1 | 7 | 0 | ||
| auctionhouse | 5 | 11 | 0 | ||
| bugreport | 3 | 0 | Debug System | ||
| character_achievement | 1 | 3 | 0 | ||
| character_achievement_progress | 1 | 4 | 0 | ||
| character_action | 1 | 5 | 0 | Player System | |
| character_aura | 3 | 9 | 0 | Player System | |
| character_db_version | 1 | 1 | Last applied sql update to DB | ||
| character_declinedname | 1 | 6 | 0 | ||
| character_gifts | 3 | 4 | 0 | ||
| character_homebind | 1 | 6 | 0 | Player System | |
| character_instance | 2 | 3 | 0 | ||
| character_inventory | 4 | 5 | 0 | Player System | |
| character_pet | 2 | 2 | 21 | 0 | Pet System |
| character_pet_declinedname | 1 | 7 | 0 | ||
| character_queststatus | 2 | 14 | 0 | Player System | |
| character_queststatus_daily | 2 | 3 | 0 | Player System | |
| character_reputation | 1 | 4 | 0 | Player System | |
| character_social | 2 | 4 | 0 | Player System | |
| character_spell | 2 | 4 | 0 | Player System | |
| character_spell_cooldown | 3 | 4 | 0 | ||
| character_ticket | 1 | 4 | 0 | Player System | |
| character_tutorial | 3 | 11 | 0 | Player System | |
| characters | 45 | 1 | 41 | 0 | Player System |
| corpse | 1 | 13 | 0 | Death System | |
| group_instance | 2 | 3 | 0 | ||
| group_member | 2 | 4 | 0 | Groups | |
| groups | 2 | 4 | 16 | 0 | Groups |
| guild | 7 | 1 | 12 | 0 | Guild System |
| guild_bank_eventlog | 3 | 9 | 0 | ||
| guild_bank_item | 4 | 5 | 0 | ||
| guild_bank_right | 3 | 5 | 0 | ||
| guild_bank_tab | 4 | 2 | 5 | 0 | |
| guild_eventlog | 4 | 7 | 0 | Guild Eventlog | |
| guild_member | 3 | 19 | 0 | Guild System | |
| guild_rank | 3 | 1 | 5 | 0 | Guild System |
| instance | 2 | 5 | 0 | ||
| instance_reset | 2 | 0 | |||
| item_instance | 8 | 1 | 3 | 0 | Item System |
| item_text | 2 | 0 | Item System | ||
| 1 | 2 | 14 | 0 | Mail System | |
| mail_items | 4 | 4 | 0 | ||
| pet_aura | 3 | 9 | 0 | Pet System | |
| pet_spell | 2 | 3 | 0 | Pet System | |
| pet_spell_cooldown | 2 | 3 | 0 | ||
| petition | 2 | 4 | 0 | Guild System | |
| petition_sign | 4 | 5 | 0 | Guild System | |
| saved_variables | 1 | 0 | Variable Saves | ||
| 51 Tables | 362 | 1 | |||
| 0 Views | 0 |
Related tables in other schemas
| Table | In this schema | Comments | |
|---|---|---|---|
| Children | Parents | ||
| mangos.creature | 1 | ||
| mangos.creature_template | 1 | ||
| mangos.item_template | 6 | ||
| mangos.quest_template | 2 | ||
| mangos.spell_dbc | 6 | ||
| realmd.account | 4 | ||
| realmd.realmlist | 1 | ||