erDiagram
trader {
intunsigned char_id
intunsigned item_id
}
character_data {
intunsigned id
varchar name
varchar nane
intunsigned zone_instance
intunsigned zone_id
}
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
trader ||--o{ character_data : "One-to-One"
trader ||--o{ items : "One-to-One"