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 |