The scenario
A gym chain needs a database to track member personal training sessions, nutrition plans, daily meal logs, workout regimens, assigned trainers, and periodic body composition progress logs.
What is in this drawing
Read the decisions behind it.
01
Separate Nutrition and Workout plans for modular tracking
02
Junction table MemberTrainer for many-to-many member-trainer assignments
03
MealEntry and Exercise tables for detailed logging
04
ProgressLog for body metrics over time
When designing a backend for a fitness app that integrates training and nutrition coaching, tracking individual member progress and program adherence.
More like this