How to structure my database for multivalued attribute from another table?

How to structure my database for multivalued attribute from another table?
0

#1

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?