guild_bank
Relationships
erDiagram
guild_bank {
varchar donator
intunsigned guildid
intunsigned itemid
}
character_data {
intunsigned id
varchar name
varchar nane
intunsigned zone_instance
intunsigned zone_id
}
guilds {
int id
int leader
varchar motd_setter
}
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
guild_bank ||--o{ character_data : "One-to-One"
guild_bank ||--o{ guilds : "One-to-One"
guild_bank ||--o{ items : "One-to-One"
| Relationship Type |
Local Key |
Relates to Table |
Foreign Key |
| One-to-One |
donator |
character_data |
name |
| One-to-One |
guildid |
guilds |
id |
| One-to-One |
itemid |
items |
id |
Schema