logo
ExamplesEditorPricingDocs
37.1kSign in

Recipe and meal planning app database schema

A local-first SQLite schema for a cooking app: recipes with quantified ingredients, units and ingredient-specific conversions, timed steps, meal plans by day, shopping lists that merge quantities across recipes, pantry stock and favourites.

Recipe App ER diagram

Recipe and meal planning app database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 11 recipes idINTEGER remote_idVARCHAR titleVARCHAR summaryTEXT source_urlTEXT servingsINTEGER prep_minutesINTEGER cook_minutesINTEGER difficultyVARCHAR image_blobBLOB created_atTIMESTAMP updated_atTIMESTAMP is_dirtyBOOLEAN deleted_atTIMESTAMP ingredients idINTEGER nameVARCHAR normalized_nameVARCHAR aisleVARCHAR default_unit_idINTEGER density_g_per_mlREAL is_pantry_stapleBOOLEAN units idINTEGER nameVARCHAR abbreviationVARCHAR kindVARCHAR systemVARCHAR base_unit_idINTEGER to_base_factorREAL unit_conversions idINTEGER ingredient_idINTEGER from_unit_idINTEGER to_unit_idINTEGER factorREAL sourceVARCHAR recipe_ingredients idINTEGER recipe_idINTEGER ingredient_idINTEGER unit_idINTEGER quantityNUMERIC quantity_maxNUMERIC preparationVARCHAR group_labelVARCHAR is_optionalBOOLEAN positionINTEGER raw_textVARCHAR recipe_steps idINTEGER recipe_idINTEGER positionINTEGER instructionTEXT timer_secondsINTEGER timer_labelVARCHAR is_passiveBOOLEAN image_blobBLOB meal_plans idINTEGER nameVARCHAR start_dateDATE end_dateDATE household_sizeINTEGER created_atTIMESTAMP is_dirtyBOOLEAN meal_plan_entries idINTEGER meal_plan_idINTEGER recipe_idINTEGER plan_dateDATE meal_slotVARCHAR servingsINTEGER noteVARCHAR positionINTEGER shopping_lists idINTEGER meal_plan_idINTEGER nameVARCHAR generated_atTIMESTAMP statusVARCHAR deduct_pantryBOOLEAN shopping_list_items idINTEGER shopping_list_idINTEGER ingredient_idINTEGER unit_idINTEGER quantityNUMERIC manual_textVARCHAR source_countINTEGER pantry_deductedNUMERIC aisleVARCHAR is_checkedBOOLEAN positionINTEGER pantry_items idINTEGER ingredient_idINTEGER unit_idINTEGER quantityNUMERIC locationVARCHAR expires_onDATE opened_onDATE updated_atTIMESTAMP favorites recipe_idINTEGER collectionVARCHAR positionINTEGER favorited_atTIMESTAMP

Related database schemas

PostgreSQL
Food & drink

DoorDash food delivery database schema

How a food delivery marketplace models its data: restaurant menus built from reusable modifier groups, orders that snapshot every chosen option, courier dispatch offers, live location tracking, and the fee split between restaurant, courier and platform.

SQLite
Fintech

Expense tracker & personal finance database schema

A local-first SQLite personal finance database: accounts, transactions in integer minor units, a nested category tree, per-period budgets with rollover, recurring rules, statement imports with auto-categorisation, receipts, and transfers modelled as a linked pair of legs.

PostgreSQL
Food & drink

Online grocery delivery database schema

How an online supermarket models its data: per-store catalogue and pricing, weight-priced items billed on what was actually picked, baskets, substitution preferences and real substitutions, picking tasks, capacity-limited delivery windows and inventory counts.

SQLite
Productivity

Habit tracker app database schema

A small local-first SQLite schema for habit tracking: habits with date-versioned schedules, one row per completion, pauses that skip a streak instead of breaking it, reminders, and streaks derived from check-ins rather than stored as a counter.