To my knowledge all dropped items can be crafted (maybe an exception here and there). Currently we adding weapons and armors under crafts and under dropped items. Thus on 2 different places. Can't we have all weapons and armor under crafts, and link the crafted items to the drops ? Saves double entries in the database and makes sure the crafted list stays up to date.

Crafted items have some additions to dropped items but i am pretty sure we can work that in some how in the craft overview.

Yes i know that, but the craft section is not items, its recepies.

Its in that mind i created the database structure.

I whas planning to add a link to the items to say what craft can make this item.

There are hundreds of exceptions, black knight armor, khamset armor, severii armor, ancient armor..... recipes are still being added, like the scale boots and gloves.

Having the crafted list seperate makes it easier to keep that up to date as you are only going through recipes that are actually avaliable to each craft, there is also the possiblity that recipes may be removed/modified, unlikely but still possible, you would then have to seperate the recipe from the old/original crafted result again in the database

Two seperate sections allows for more flexibility and its easier to amend if needs be

Related discussion - I fail at post titles
http://www.dfo-db.com/forum/about-dfodb/0_39

I have now linked items to crafts and vice versa.
(all forms have been updated)