tradeskill_recipe¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
Relationships¶
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 |
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 |