Database Answers Golds Gym, Santa Monica, California (Click for Web Site)

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for Workout Programmes 
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
About Us Contact Us