char_recipe_list¶
Relationships¶
erDiagram
char_recipe_list {
int char_id
int recipe_id
}
character_data {
intunsigned id
varchar name
varchar nane
intunsigned zone_instance
intunsigned zone_id
}
tradeskill_recipe {
int id
varchar content_flags
varchar content_flags_disabled
}
char_recipe_list ||--o{ character_data : "One-to-One"
char_recipe_list ||--o{ tradeskill_recipe : "One-to-One"
Relationship Type | Local Key | Relates to Table | Foreign Key |
---|---|---|---|
One-to-One | char_id | character_data | id |
One-to-One | recipe_id | tradeskill_recipe | id |
Schema¶
Column | Data Type | Description |
---|---|---|
char_id | int | Character Identifier |
recipe_id | int | Recipe Identifier |
madecount | int | Made Count |