Database structure - food-fox/foody GitHub Wiki

recipe

• id
• name
• time
• difficulty

ingredient

• id
• name
• season_start
• season_end
• basic

recipe_ingredient

• recipe_id
• ingredient_id
• quantity
• unit

product

• id
• name
• ean
• quantity
• unit
• price
• currency_id

inventory

• product_id
• quantity
• unit
• expiry_date

ingredient_product

• ingredient_id
• product_id