erDiagram
alternate_currency {
int id
int item_id
}
character_alt_currency {
intunsigned currency_id
intunsigned char_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
}
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
alternate_currency ||--o{ character_alt_currency : "Has-Many"
alternate_currency ||--o{ npc_types : "Has-Many"
alternate_currency ||--o{ items : "Has-Many"