AnsweredAssumed Answered

Manufacturing ERP Relational Diagram

Question asked by themactech. on Sep 23, 2014
Latest reply on Sep 25, 2014 by themactech.

Title

Manufacturing ERP Relational Diagram

Post

Hi everyone

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

ERD_Screenshot.png

Outcomes