Engineering BOM & PDM
Currently I have setup a MySQL DB with 2 tables: item & parentchild
- PN (part number)
- DESC (description)
- parent (parent part number)
- child (child part number)
With a BOM hierarchy established, one can input a parent PN, and generate a fully exploded sub-BOM. I will build this wiki and project status as I continue to work on this.
It's late now, however! :)
Will need some input on how/where to store the DB. I am willing to host long term if this thing works out!