We are trying to build a small stock management web app for a small company. It is the first time that we use NoSQL DB. We designed a system with these collections;
- Users
- Countries (Contains Regions document as Array)
- Regions (Contains Unit document as Array)
- Units (Contains Sales and Stocks Entries as Array)
- Sales
- Stocks
However, because of the high data density in Sales/Stocks, we are trying to find a simple and optimum scheme design. We are keeping all data in one document for now but while the data is entered, probably we could face a chaotic result. We need a better solution. Thanks everybody.