Skip to content



    tradeskill_recipe_entries {
        int item_id
        int recipe_id
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    tradeskill_recipe {
        int id
        varchar content_flags
        varchar content_flags_disabled
    tradeskill_recipe_entries ||--o{ items : "One-to-One"
    tradeskill_recipe_entries ||--o{ tradeskill_recipe : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One item_id items id
One-to-One recipe_id tradeskill_recipe id


Column Data Type Description
id int Unique Tradeskill Recipe Entry Identifier
recipe_id int Unique Tradeskill Recipe Identifier
item_id int Item Identifier
successcount tinyint Success Count
failcount tinyint Fail Count
componentcount tinyint Component Count
salvagecount tinyint Salvage Count
iscontainer tinyint Is Container: 0 = False, 1 = True