Expert guidance becomes a personal calendar.
Turn guidance into a plan someone can use.
Where this work fits
A meal-plan template still needs dates, recipes, and progress before a customer can follow it. People also need to find suitable content, save choices, and turn ingredients into a shopping list.
I built backend workflows connecting expert-created plans with customer schedules. Shared content and personal dates or progress needed separate responsibilities so customers could use a plan without changing its reusable source.
Turn a plan into a usable calendar
A balanced week.
Meals + timing
Nutritional totals
Premium access check
Your calendar
Activate a plan to create dated meal slots.
Share the content, keep progress personal.
The original plan and a customer’s copy had different jobs. I modeled personal dates and completion separately, checked membership for premium activation, and handled conflicts such as placing two meals in the same slot. Catalogue filters helped narrow the recipes people could choose from.
The skills behind the work
- Data modeling
- Give different product concepts clear records and relationships so updates have predictable meaning.
- SQL
- Query and update relational data, with clear rules about which records a result represents.
- Access control
- Check which actions and resources an authenticated account is allowed to use.
Membership gave customers a plan they could start and follow, with saved choices and progress. Recipe ingredients could become a reusable shopping checklist.