|
Back to the Data Model
Subject: Database for Workout Programme
Hi,
I came across your site on a Google search and have found it incredibly useful so far.
I am looking to design an application which enables Workout Programme Design (i.e. planning in advance) as well as Tracking.
It should contain planned workout stats (including exercises, sets, reps, weight) and additionally actual workout stats.
E.g. the planned data could be:-
Exercise Set Number Reps Weight
Bench Press Set 10 100kg
but the actual data could be:-
Exercise Set Number Reps Weight
Bench Press Set 10 90kg
I want to record the difference to plot performance deviations.
Is a simple "Isplanned?" flag in the "WorkoutSets" table sufficient or can you suggest an alternative?
Also, a Programme contains many Phases (e.g. 3) with a title.
A Phase contains many (Planned) Workouts.
A Workout contains many Exercises/Sets.
A Programme could ultimately become a template for use with another User.
I have scoured the database models on the site and can't seem to find a suitable template to structure my data model on.
Any help would be greatly appreciated.
Thanks in advance,
Andy
© DataBase Answers Ltd. 2013
|
|