The database - evandadure/Fridge_App GitHub Wiki

You can find the script for the database on this gitHub : "fridgee_database_script.sql"

(https://github.com/evandadure/fridgeapp/blob/master/fridgee_database_script.sql)

Here is a Conceptual Data Model of our database :

And a Physical Data Model :

The database itself is really easy to understand : a User(ID, Username, Name and Password) possesses ingredients, called Food(ID, Name of ingredient, Type of ingredient). These ingredients are used in Recipes(ID, Recipe name, Recipe description, Recipe type, Recipe preparation time and Recipe cooking time).