Recipe: Mock Database

[DConnorFong]

What are the exact tables you are going to need? Please discuss and add a document.

[no-or]

Hey,
I am thinking NoSQL (MongoDB) with the following collections. Please, let me know if I need to make any adjustments:

userRecipe

• user_id
• recipe_ids []

recipes

• id
• name
• description
• instructions [{number, description}, {number, description}, ….]
• ingredients [{id, qty}, {id, qty}, …..]

[DConnorFong]

I think that using an SQL structure is better, but if you prefer NoSQL, we can try to prototype with it.

This is fine, although thinking about scalability, idk if qty will be enough. There are a lot of different ways to express that (units: a number of apples; weight: mg/Kg; volume: ml/L).

[no-or]

I have not done any project (from scratch) in SQL before. I can give it a try if you want.

And yeah, you are right, we might need to modify qty. I will make the adjustments and comment again for your feedback.