-
Type:
Question
-
Resolution: Done
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
Server Triage
-
None
-
None
-
None
-
None
-
None
-
None
-
None
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.