merchantlist_temp
Relationships
erDiagram
merchantlist_temp {
intunsigned itemid
intunsigned npcid
}
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
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
}
merchantlist_temp ||--o{ items : "One-to-One"
merchantlist_temp ||--o{ npc_types : "One-to-One"
| Relationship Type |
Local Key |
Relates to Table |
Foreign Key |
| One-to-One |
itemid |
items |
id |
| One-to-One |
npcid |
npc_types |
id |
Schema