Recipe: Mock Database - Githubissues

ubclaunchpad / food-doods

Dabbing out food waste and over-spending on groceries

MIT License

5 stars 4 forks source link

Recipe: Mock Database #34

Open DConnorFong opened 4 years ago

DConnorFong commented 4 years ago

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

no-or commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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.