4 Replies Latest reply on Sep 25, 2014 5:31 AM by themactech.

    Manufacturing ERP Relational Diagram



      Manufacturing ERP Relational Diagram


      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