Details
-
Question
-
Resolution: Done
-
Major - P3
-
None
-
None
-
None
-
Server Triage
Description
I have the following data set in MongoDB:
{
|
"_id" : ObjectId("5c73cc96c2fb92219aeb476a"), |
"menus" : { |
"name" : "Menu", |
"sections" : [ |
{
|
"name" : "Small Plates", |
"items" : [ |
{
|
"name" : "Savory Pancakes", |
"description" : "Choice of vegetarian of seafood options.", |
"price" : null |
},
|
{
|
"name" : "Kimbop", |
"description" : "Wrapped in seaweed paper with assorted vegetables. BBQ Beef, Spicy Pork, Chicken, Spicy Fish Cake, Spam (Gluten Free), Spicy Kimchi (Gluten Free), Vegetable (Gluten Free).", |
"price" : "8.0" |
},
|
{
|
"name" : "Bacon Roll", |
"description" : "4 pieces. Seasoned rice rolled in bacon strip.", |
"price" : "8.0" |
},
|
{
|
"name" : "Fried Potstickers", |
"description" : "8 pieces.", |
"price" : "8.0" |
}
|
]
|
},
|
{
|
"name" : "Noodles & Soup", |
"items" : [ |
{
|
"name" : "Fish Cake Soup (Lunch)", |
"description" : "Fish cake with radish, glass noodles, and scallions.", |
"price" : null |
},
|
{
|
"name" : "Beef Short Rib Stew (Lunch)", |
"description" : "With radish, glass noodles, scallions, and eggs.", |
"price" : null |
},
|
{
|
"name" : "Korean Gnocchi Soup (Lunch)", |
"description" : "Korean potato pasta with bean sprouts, squash with eggs, and scallions.", |
"price" : null |
}
|
]
|
},
|
{
|
"name" : "Rice Dishes", |
"items" : [ |
{
|
"name" : "Bibimbop", |
"description" : "Build your own rice bowl. A bed of rice with spinach, mushroom, radish, julienned carrots, bean sprouts, quinoa and assorted vegetables on top. Topped with your choice of protein and fried egg. Served warm.", |
"price" : null |
},
|
{
|
"name" : "Kimchi Fried Rice (Lunch)", |
"description" : "With sunny side up fried egg.", |
"price" : null |
},
|
{
|
"name" : "Jhap Chae Fried Rice (Lunch)", |
"description" : "With vegetarian jhap chae and sunny side up fried egg.", |
"price" : null |
}
|
]
|
}
|
]
|
}
|
}
|
Now my question is: Should I split the above data set and create separate collections for menus, sections & items or should not split.
There is an another feature in my application, in which users can mark the items as favourite, so in that case I will need to save the information in another collection whose columns will be "user_id" & "item_id", but if we not split the data set how can I get item id as primary key.