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