Hello everyone. Need an advise from MongoDB gurus.
I have a collection ‘companies’ which is the list of legal entities. Each entity is unique: all of them have their own official legal name, registration number, and other unique identifiers. And yet, some of them can have parent-child relationship between each other from the point of view ownership: one company can be a shareholder in another one and thus considered as parent. Since all the companies are quite unique I don’t think that imbedding child companies as an array of documents into the document of parent company would be a good idea. It’s not kind of “product-review” or “author-publisher” relationship which you can find in a lot of documentations and examples on this topic.
So, could you please share the best practices of handling such kind of relationships in MongoDB?
Thanks in advance,