tradeskill_recipe_entries

Relationships

erDiagram
    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

Schema

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