Manufacturing ERP Relational Diagram
I'm starting to develop a "simple" manufacturing ERP system for our small business. (yeah I know.. ERPs are probably the hardest types of databases to develop). At this point in time all they want is a way to track inventory, BOMs, purchasing and orders. (Financial integration is well off into the future).. but for now this where I need to start.
I've created an ERD as a starting point. Attached here. I'd appreciate any advice anyone would want to offer as far as additional tables, relationships, etc that would be useful for my project.
Thanks so much