I am looking for some guidance on how to design mongo Schema for supply chain management.
I have a fair enough idea about creating the setup in RDBMS but struggling to see how it needs to be done using mongo schema.
In a nut shell, I have a list of products with their own attributes. The product schema is straight forward.
I have another table which is the demand for product. Should I embed this data in the product schema as an attribute?
The most data intensive table is the transactions table which is a time log of products going in and out of plants. This is a huge table similar to server log or historical data. How do i store the data ? with the timeline ? below is a sample data
