Hey All, apologies in advance as my SQL knowlege is thin and this is going to likely get a bit intertwined. I run a small business making bags and offer custom colors on all products through my website. I have wanted a lightweight MRP system for a while as a way to track cut jobs, track inventory, and learn a little bit more about database admin and programming. I have created a PostgreSQL database and plan to make a tidy little dashboard in Django to do CRUD operations but am struggling in how to best handle BOMs and inventory with the high amount of enumerated options I have. My plan going in was to have a table of components with a boolean called 'variable'. When variable=true that means this component could be made of any of a list of materials (this is handled via a combination of the 'usage', 'web_attributes' and 'mat_usage' tables).…