tradeskill_recipe

Relationships

erDiagram
    tradeskill_recipe {
        int id
        varchar content_flags
        varchar content_flags_disabled
    }
    content_flags {
        varchar flag_name
    }
    tradeskill_recipe_entries {
        int item_id
        int recipe_id
    }
    tradeskill_recipe ||--o{ content_flags : "One-to-One"
    tradeskill_recipe ||--o{ content_flags : "One-to-One"
    tradeskill_recipe ||--o{ tradeskill_recipe_entries : "Has-Many"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	content_flags	content_flags	flag_name
One-to-One	content_flags_disabled	content_flags	flag_name
Has-Many	id	tradeskill_recipe_entries	recipe_id

Schema

Column	Data Type	Description
id	int	Unique Tradeskill Recipe Identifier
name	varchar	Recipe Name
tradeskill	smallint	Tradeskill
skillneeded	smallint	Skill Level Needed
trivial	smallint	Trivial Skill Level
nofail	tinyint	No Fail: 0 = False, 1 = True
replace_container	tinyint	Replace Container: 0 = False, 1 = True
notes	tinytext	Notes
must_learn	tinyint	Must Learn: 0 = False, 1 = True
learned_by_item_id	int
quest	tinyint	Quest Controlled: 0 = False, 1 = True
enabled	tinyint	Enabled: 0 = False, 1 = True
min_expansion	tinyint	Minimum Expansion
max_expansion	tinyint	Maximum Expansion
content_flags	varchar	Content Flags Required to be Enabled
content_flags_disabled	varchar	Content Flags Required to be Disabled