Hi, I am building an Order Management System for a Printing Company using MEAN. This is how it flows -
Order Received - Sent to Design / Preprepress - Orders Clubbed to create a new Job and sent to Production - Production will process the job - Send to Packaging - Despatch
This is just a brief idea. Now, I am planning to make one table for Orders, One for Jobs . Each Job (record) in the jobs table will have Orders field which will contain one or multiple orders (Id) . The Orders Table inturn will have Production Status field which will get its values from the jobs table. How do I structure this database. Can someone help?