Recipe Platform

Overview

Recipe sharing and meal planning platform schema. Users can browse recipes, plan weekly meals, auto-generate shopping lists, and track nutritional intake.

Key Design Decisions

• Ingredient Normalization: Canonical ingredient table with unit conversion support
• Nutritional Data: Per-ingredient nutrition for automatic recipe calorie calculation
• Meal Planning: Weekly meal plan with day/meal-slot structure
• Shopping Lists: Auto-generated from meal plans with manual additions

Tables

10-14 tables covering users, recipes, ingredients, recipe ingredients, nutritional info, meal plans, meal plan items, shopping lists, shopping list items, collections, ratings, and recipe tags.